SELECT * FROM gl_import_references;--总账-xla SELECT * FROM gl_interface;--总账标准接口表 SELECT * FROM gl_daily_rates;--汇率 SELECT * FROM gl_daily_balances; --AP 部分表 SELECT * FROM ap_invoices_all;--应付发票 SELECT * FROM ap_invoice_lines_all;--应付发票行 SELECT * FROM ap_in...
AP_INVOICES_INTERFACE contains header information about invoices that you create or load for import. AP_INVOICES_INTERFACE_ is the audit table for AP_INVOICES_INTERFACE. Details Schema: FUSION Object owner: AP Object type: TABLE Tablespace: INTERFACE Primary Key Name Columns AP_INVOICES_INTERF...
-- Create tableDROPTABLECUX.cux_ap_invoice_interface;createtableCUX.cux_ap_invoice_interface(OU_NAME VARCHAR2(240),--组织invoice_type VARCHAR2(240),--发票类型vendor_name VARCHAR2(240),--供应商名称site_name VARCHAR2(240),--供应商地点invoice_date VARCHAR2(240),--发票日期gl_date VARCHAR2...
AP_INVOICES_ALL.AWT_GROUP_ID, only if you don't enter another value for AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID, or AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME. AWT_GROUP_NAME Name of the withholding tax group. The import process assigns the tax group to the invoice line unless you specif...
ap_invoices_interface 表结构 abap types 包含表结构 数据 关健字是语句的第一个词,它决定整个语句的意义,有四种不同类型的关健字 . 1.说明性关健字 TYPES,DATA,TABLES,这些关健字说明定义数据类型或者说明程序可以访问的数据对象 TYPES: 用来定义数据结构类型 。
Oracle Payables - Version 12.1.3 and later: R12:AP: APXIIMPT:Interface Description Flexfield (DFF) values is not getting Copied to Invoice Distributions for PO Match
AP_INVOICES_INTERFACE contains header information about invoices that you create or load for import. AP_INVOICES_INTERFACE_ is the audit table for AP_INVOICES_INTERFACE.
AP_INVOICES_ALL.EXCLUSIVE_PAYMENT_FLAG OPERATING_UNIT Name of the business unit that processes invoices for purchase orders raised by one or more requisitioning business units. Validation If you populate both the AP_INVOICES_INTERFACE.ORG_ID and AP_INVOICES_INTERFACE.OPERATING_UNIT columns and they...
AP_INVOICES_ALL.EXCLUSIVE_PAYMENT_FLAG OPERATING_UNIT Name of the business unit that processes invoices for purchase orders raised by one or more requisitioning business units. Validation If you populate both the AP_INVOICES_INTERFACE.ORG_ID and AP_INVOICES_INTERFACE.OPERATING_UNIT columns and they...
Tablespace: INTERFACE Primary Key Name Columns AP_INVOICES_INTERFACE_PK INVOICE_ID, LOAD_REQUEST_ID Columns NameDatatypeLengthPrecisionNot-nullCommentsFlexfield-mapping INVOICE_ID NUMBER 18 Yes Invoice identifier. Must be unique. INVOICE_NUM VARCHAR2 50 Supplier invoice number. Validation: must be ...