AP_INVOICES_ALL 这个表包含用户输入的应付发票信息. 每一条记录对应一张应付发票. 一条应付发票记录对应多条发票分配行记录. 一条应付发票记录对应多条计划付款记录. EXPENSE REPORT类型的应付发票,必须在AP_EXPENSE_REPORT_HEADERS_ALL表里有值. INTEREST类型应付发票对应发票过期所产生费用, 他与过期应付发票的联系...
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 t.lookup_type = 'PREPAY STA...
AP_INVOICES_ALL 每一条记录对应一张应付发票. 一条应付发票记录对应多条计划付款记录. INTEREST类型应付发票对应发票过期所产生费用, 他与过期应付发票的联系通过AP_INVOICE_RELATIONSHIPS 维护. AWT: 预扣税发票 DEBIT: 借项凭单 INTEREST: 利息发票 PREPAYMENT: 预付款及垫款 QUICKMATCH: 快速匹配标准发票 payment_m...
AP_DISTRIBUTION_SETS_ALL_ AP_DISTRIBUTION_SET_LINES_ALL AP_DISTRIBUTION_SET_LINES_ALL_ AP_DOC_SEQUENCE_AUDIT AP_ERRORS_GT AP_HISTORY_CHECKS_ALL AP_HISTORY_INVOICES_ALL AP_HISTORY_INV_PAYMENTS_ALL AP_HOLDS_ALL AP_HOLD_CODES AP_HOLD_CODES_ AP_IDR_OPTIONS AP_IDR_OPTIONS_ AP_IDR_OPTION_EXTE...
AP_SELECTED_INVOICES_ALL is a temporary table that stores information about invoices selected for payment in a payment batch. Your Oracle Payables application inserts into this table after you initiate a payment batch. There will be one row for each invo
ap_invoices_all.approval_status AP发票界面中的一般页签,有个状态的栏位,即APPROVAL_STATUS_DISPLAY 但是到表ap_invoices_all中没有此栏位。另外approval_status/approval_description是空的。 可以到ap_invoices_v中查看APPROVAL_STATUS_LOOKUP_CODE 由此可以得到状态的值。
AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice youenter. An invoice can have one or more invoice distribution lines. An invoice can also have one or more scheduled payments. An invoice of type EXPENSE REPORT mu