AP_INVOICES_ALL 这个表包含用户输入的应付发票信息. 每一条记录对应一张应付发票. 一条应付发票记录对应多条发票分配行记录. 一条应付发票记录对应多条计划付款记录. EXPENSE REPORT类型的应付发票,必须在AP_EXPENSE_REPORT_HEADERS_ALL表里有值. INTEREST类型应付发票对应发票过期所产生费用, 他与过期应付发票的联系...
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...
AP_INVOICES_ALL 每一条记录对应一张应付发票. 一条应付发票记录对应多条计划付款记录. INTEREST类型应付发票对应发票过期所产生费用, 他与过期应付发票的联系通过AP_INVOICE_RELATIONSHIPS 维护. AWT: 预扣税发票 DEBIT: 借项凭单 INTEREST: 利息发票 PREPAYMENT: 预付款及垫款 QUICKMATCH: 快速匹配标准发票 payment_m...
AP_INVOICES_ALL stores all of the invoices recorded in the system. AP_INVOICE_PAYMENTS_ALL stores the records of all of the payments recorded against the invoices in AP_INVOICES_ALL AP_CHECKS_ALL stores the records of all the checks paidinthe system One of the functions of AP_INVOICE_PAYME...
AP_INVOICES_ALL_ AP_INVOICES_INTERFACE AP_INVOICES_INTERFACE_ AP_INVOICE_AGING_GT AP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_DISTRIBUTIONS_ALL_ AP_INVOICE_DISTRIBUTIONS_GT AP_INVOICE_KEY_IND_ALL AP_INVOICE_LINES_ALL AP_INVOICE_LINES_ALL_ AP_INVOICE_LINES_INTERFACE AP_INVOICE_LINES_INTERFACE_ AP_INV...
症状: 1.AP Invoice状态为已付(AP_INVOICES_ALL.PAYMENT_STATUS_FLAG='Y'),但是实际未付款。 2.AP Invoice的付款计划的状态未付款(AP_PAYMENT_SCHEDULES_ALL.PAYMENT_STATUS_FLAG=‘N’) 3.AP Invoice查看付款和查看预付款均无记录 4.表表AP_INVOICE_... ...
症状:1.APInvoice状态为已付(AP_INVOICES_ALL.PAYMENT_STATUS_FLAG='Y'),但是实际未付款。2.APInvoice的付款计划的状态未付...AP_PAYMENT_SCHEDULES_ALL 类似,没有什么差异2.表AP_INVOICES_ALL(APinvoiceheader)比较差异如下 根据我以往经验对数据修复(Datafix)的方法:1.网上或 ...
SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL B WHERE B.INVOICE_ID = 697444; --Invoice付款计划表 SELECT * FROM AP_PAYMENT_SCHEDULES_ALL C WHERE C.INVOICE_ID = 697444; --From ap_invoices_all.invoice_id --2.Invoice验证并创建会计科目时产生的数据如下表 ...
AP_INVOICES_ALL_PK INVOICE_ID Columns NameDatatypeLengthPrecisionNot-nullCommentsFlexfield-mappingStatus INVOICE_ID NUMBER 18 Yes Unique invoice identifier. Active LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active LAST_UPDATED_BY VARCHAR...