AP_INVOICES_ALL 表结构 AP_INVOICES_ALL 这个表包含用户输入的应付发票信息. 每一条记录对应一张应付发票. 一条应付发票记录对应多条发票分配行记录. 一条应付发票记录对应多条计划付款记录. EXPENSE REPORT类型的应付发票,必须在AP_EXPENSE_REPORT_HEADERS_ALL表里有值. INTEREST类型应付
如果有意向欢迎电话联系或者加微信:18980820575(备注:SSL证书合作)期待与您的合作! AP_INVOICES_ALL 每一条记录对应一张应付发票. 一条应付发票记录对应多条计划付款记录. INTEREST类型应付发票对应发票过期所产生费用, 他与过期应付发票的联系通过AP_INVOICE_RELATIONSHIPS 维护. AWT: 预扣税发票 DEBIT: 借项凭单 INTE...
ap_invoices_all.approval_status AP发票界面中的一般页签,有个状态的栏位,即APPROVAL_STATUS_DISPLAY 但是到表ap_invoices_all中没有此栏位。另外approval_status/approval_description是空的。 可以到ap_invoices_v中查看APPROVAL_STATUS_LOOKUP_CODE 由此可以得到状态的值。 select * from AP_LOOKUP_CODES t where...
SELECT * FROM gl_daily_balances; --AP 部分表 SELECT * FROM ap_invoices_all;--应付发票 SELECT * FROM ap_invoice_lines_all;--应付发票行 SELECT * FROM ap_invoice_distributions_all;--应付发票分配行 SELECT * FROM ap_checks_all;--应付付款 SELECT * FROM ap_payment_schedules_all; SELECT * ...
*/--1、导入数据/*select * from CUX.cux_ap_invoice_interface for update*/--2.为数据分配编号/*DECLARE CURSOR cur IS SELECT ap.rowid, ap.* FROM cux.cux_ap_invoice_interface ap; l_num NUMBER := 0; BEGIN FOR i IN cur LOOP ...
AP_INVOICES_ALL.VENDOR_ID VENDOR_NUM Number of the supplier. You must identify the supplier by entering a value for one of the following columns in this table: VENDOR_ID, VENDOR_NUM, VENDOR_SITE_ID, VENDOR_SITE CODE, or PO_NUMBER. ...
*/--1、导入数据/*select * from CUX.cux_ap_invoice_interface for update*/--2.为数据分配编号/*DECLARE CURSOR cur IS SELECT ap.rowid, ap.* FROM cux.cux_ap_invoice_interface ap; l_num NUMBER := 0; BEGIN FOR i IN cur LOOP ...
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 unique for the supplier site. INVOICE_TYPE_LOOKU...
ap_invoices_all i, po_vendors v, po_vendor_sites_all vs WHERE i.invoice_id = ps.invoice_id AND i.vendor_id = v.vendor_id AND i.vendor_site_id = vs.vendor_site_id AND i.payment_status_flag ='N' AND (nvl(ps.amount_remaining, 0) * nvl(i.exchange_rate,1)) != 0 ...
ap_invoices_interface 表结构 abap types 包含表结构 数据 关健字是语句的第一个词,它决定整个语句的意义,有四种不同类型的关健字 . 1.说明性关健字 TYPES,DATA,TABLES,这些关健字说明定义数据类型或者说明程序可以访问的数据对象 TYPES: 用来定义数据结构类型 。