Records in the AP_INVOICE_LINES_INTERFACE table create one or more invoice distributions. One row might create more than one distribution. For example, if you enter a tax line and prorate it across three item lines, the import process creates three tax invoice distributions. INVOICE_ID E...
AP Invoices应付发票【Open Interface】 以R12为例,具体介绍应付发票导入,R12导入应付发票较11i有部分不同,比如: 11i,ap_invoice_lines_interface弹性域写入发票分配行,r12默认写入发票行,可能过profile设定,把行上的弹性域带到分配行上,profile:AP_COPY Invoice Lines Flex fied 设为Y; 发票税导入: 11i通过税码...
CMR_AP_INVOICE_DIST_ID NUMBER 18 Internal AP Invoice Distribution Identifier TO_DELETE VARCHAR2 20 To identify if the corresponding row in interface table is to be deleted EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Identifier of the AP Invoice distribution line in the source system INVOICE_ID NUMBE...
TABLE - AP.AP_INCOME_TAX_REGIONS TABLE - AP.AP_INCOME_TAX_TYPES TABLE - AP.AP_INTEREST_PERIODS TABLE - AP.AP_INTERFACE_CONTROLS TABLE - AP.AP_INTERFACE_REJECTIONS TABLE - AP.AP_INVOICES_ALL TABLE - AP.AP_INVOICES_INTERFACE TABLE - AP.AP_INVOICES_UPG_CONTROL TABLE - AP.AP_INVOICE_DI...
Table List: 接口表 数据表 说明 ap_invoices_interface ap_invoices_all AP头 ap_invoice_lines_interface ap_invoice_distributions_all AP行 ap_interface_rejections 错误信息表 Table Relation: invoice_id Error Table: SELECT air.reject_lookup_code ...
根据原table的不同,可以是invoice_id 或check_id ORG_ID,AP_INVOICE_PAYMENTS_ALL,发票付款记录. 此表连接付款(CHECK_ID)信息到其相对应的发票. 此表包含支付给供应商的发票付款 . 当你确认了一笔自动付款批, 输入了手工付款, 或执行了快速支付,Oracle 应付都会更新此表. 对应于每笔发票的每笔支付在此表中...
财务模块专题-AP模块业务及技术分析 技术分析 财务模块专题-AP模块底层详解 文档作者: Boyle.lee 创建日期: 19-Mar-07 i
Checkinvoicedistributionforlinetypecode. Validatetaxcodefortaxlines.Checkinap_tax_codes_all. Validatepurchaseorderdetailsforinvoicematchedagainstpoandgetpo_distribution_id. InterfaceTable ap_invoice_interface ap_invoice_lines_interface ap_interface_controls ...
These solutions that can be integrated with NetSuite have capabilities to capture, process, and deliver the data to NetSuite. It contains the features and functionalities of automated document management, robust AP automation, OCR smart invoice capture, general ledger distribution, and approval workflow...
PO_REQ_DISTRIBUTIONS_ALL is one of three tables storing your requisition information. This table corresponds to the requisition Distributions window, accessible through the Requisitions window Distribution里的三个Account信息所对应的PO_REQ_DISTRIBUTIONS_ALL表里的字段 ...