谁知道AR.RA_INTERFACE_LINES_ALL的列都是代表什么意思？

zhang088juan · 发表于 2011-8-23 11:38

原帖由 amwlq 于 2005-8-4 20:19 发表
看应收的User Guide 没错，另附件一份前辈给的中文文档片断，使用时注意字段有些截断，仔细对照英文原版阅读。

學習了。謝謝！

sharpidd · 发表于 2011-9-28 12:03

不错，很有用的文档！

anrry258 · 发表于 2012-3-26 12:28

謝謝共享！！！O(∩_∩)O~

dweiwei108 · 发表于 2012-3-26 13:58

insert into ra_interface_lines_all
                  ( VAT_TAX_ID,
                  TAX_CODE,
                  TAX_EXEMPT_FLAG,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATED_BY,
                  LAST_UPDATE_DATE,
                  ORIG_SYSTEM_SHIP_ADDRESS_ID,
                  ORIG_SYSTEM_SOLD_CUSTOMER_ID,
                  CONVERSION_TYPE,
                  CONVERSION_DATE,
                  CONVERSION_RATE,
                  TRX_NUMBER,
                  QUANTITY,
                  QUANTITY_ORDERED,
                  UNIT_SELLING_PRICE,
                  UNIT_STANDARD_PRICE,
                  INVENTORY_ITEM_ID,
                  UOM_CODE,
                  SHIP_DATE_ACTUAL,
                  FOB_POINT,
                  SHIP_VIA,
                  WAYBILL_NUMBER,
                  PRIMARY_SALESREP_ID,
                  SALES_ORDER,
                  SALES_ORDER_LINE,
                  SALES_ORDER_DATE,
                  SALES_ORDER_SOURCE,
                  INTERFACE_LINE_CONTEXT,
                  INTERFACE_LINE_ATTRIBUTE1,
                  INTERFACE_LINE_ATTRIBUTE2,
                  INTERFACE_LINE_ATTRIBUTE3,
                  INTERFACE_LINE_ATTRIBUTE4,
                  INTERFACE_LINE_ATTRIBUTE5,
                  INTERFACE_LINE_ATTRIBUTE6,
                  INTERFACE_LINE_ATTRIBUTE7,
                  INTERFACE_LINE_ATTRIBUTE8,
                  INTERFACE_LINE_ATTRIBUTE9,
                     INTERFACE_LINE_ATTRIBUTE10,
                     INTERFACE_LINE_ATTRIBUTE11,
                     INTERFACE_LINE_ATTRIBUTE12,
                     INTERFACE_LINE_ATTRIBUTE13,
                     INTERFACE_LINE_ATTRIBUTE14,
                     line_number,
                  BATCH_SOURCE_NAME,
                  SET_OF_BOOKS_ID,
                  LINE_TYPE,
                  DESCRIPTION,
                  CURRENCY_CODE,
                  AMOUNT,
                  CUST_TRX_TYPE_ID,
               -- TERM_ID,
                  ORIG_SYSTEM_BILL_CUSTOMER_ID,
                  ORIG_SYSTEM_BILL_ADDRESS_ID,
                  ORIG_SYSTEM_SHIP_CUSTOMER_ID,
                  ATTRIBUTE15,
                  GL_DATE,
                  org_id,
                  warehouse_id,
                  interface_status)
               values
                  (r1.VAT_TAX_ID,
                  r1.TAX_CODE,
                  r1.TAX_EXEMPT_FLAG,
                  r1.CREATED_BY,
                  sysdate,--CREATION_DATE,
                  r1.LAST_UPDATED_BY,
                  sysdate,--r.LAST_UPDATE_DATE,
                  r1.ORIG_SYSTEM_SHIP_ADDRESS_ID,
                  r1.ORIG_SYSTEM_SOLD_CUSTOMER_ID,
                  r1.CONVERSION_TYPE,
                  r1.CONVERSION_DATE,
                  r1.CONVERSION_RATE,
                  x_trx_number,--TRX_NUMBER,
                  -1,--r.QUANTITY,
                  -1,--r.QUANTITY_ORDERED,
                  abs(x_amount),--r.UNIT_SELLING_PRICE,
                  abs(x_amount),--r.UNIT_STANDARD_PRICE,
                  r1.INVENTORY_ITEM_ID,--r.INVENTORY_ITEM_ID,
                  null,--r.UOM_CODE,
                  r1.SHIP_DATE_ACTUAL,
                  r1.FOB_POINT,
                  r1.SHIP_VIA,
                  r1.WAYBILL_NUMBER,
                  r1.PRIMARY_SALESREP_ID,
                  r1.SALES_ORDER,
                  r1.SALES_ORDER_LINE,
                  r1.SALES_ORDER_DATE,
                  r1.SALES_ORDER_SOURCE,
                  r1.INTERFACE_LINE_CONTEXT,
                  v_gg_no,--INTERFACE_LINE_ATTRIBUTE1,
                  r1.INTERFACE_LINE_ATTRIBUTE2,
                  r1.INTERFACE_LINE_ATTRIBUTE3,
                  r1.INTERFACE_LINE_ATTRIBUTE4,
                  r1.INTERFACE_LINE_ATTRIBUTE5,
                  x_line_number,--r1.INTERFACE_LINE_ATTRIBUTE6,
                  r1.INTERFACE_LINE_ATTRIBUTE7,
                  r1.INTERFACE_LINE_ATTRIBUTE8,
                  r1.INTERFACE_LINE_ATTRIBUTE9,
                     r1.INTERFACE_LINE_ATTRIBUTE10,
                     r1.INTERFACE_LINE_ATTRIBUTE11,
                     r1.INTERFACE_LINE_ATTRIBUTE12,
                     r1.INTERFACE_LINE_ATTRIBUTE13,
                     r1.INTERFACE_LINE_ATTRIBUTE14,
                     x_line_number,
                  r1.BATCH_SOURCE_NAME,
                  r1.SET_OF_BOOKS_ID,
                  r1.LINE_TYPE,
                  'Rebate',--r.DESCRIPTION,
                  r1.CURRENCY_CODE,
                  x_amount,--r.AMOUNT,
                  V_CUST_TRX_TYPE_ID,--CUST_TRX_TYPE_ID, credit memo
               -- r1.TERM_ID,
                  r1.ORIG_SYSTEM_BILL_CUSTOMER_ID,
                  r1.ORIG_SYSTEM_BILL_ADDRESS_ID,
                  r1.ORIG_SYSTEM_SHIP_CUSTOMER_ID,
                  r1.ATTRIBUTE15,
                  r1.GL_DATE,
                  r1.org_id,
                  r1.warehouse_id,
                  '');

KDSMIS · 发表于 2013-4-7 09:58

bailang3106 · 发表于 2013-5-8 14:01

今天正好在做AR invoice import,很有用

meiliangdeng · 发表于 2013-6-17 11:16

谢谢，正好学习到AR接口导入技术。

854741179 · 发表于 2013-8-23 09:25

dweiwei108 发表于 2012-3-26 13:58
insert into ra_interface_lines_all
( VAT_TAX_ID,
TAX_CODE ...

鼓掌，鼓掌。

cai94918 · 发表于 2014-12-1 13:16

下载了，我顶一个..