AP_INVOICES_ALL table structure

AP_INVOICES_ALL This table contains the invoice payable information entered by the user. Each record corresponds to one invoice payable. One invoice payable record corresponds to multiple invoice distribution line records. One invoice payable record corresponds to multiple planned payment records. The invoice payable for the expense report type must have a value in the AP_EXPENSE_REPORT_HEADERS_ALL table. The INTEREST invoice is due to the cost incurred due to the invoice expiration. The INTEREST contact is maintained through AP_INVOICE_RELATIONSHIPS. INVOICE_TYPE_LOOKUP_CODE invoice payable type AWT: tax invoice CREDIT: arrears notification DEBIT: DEBIT coupon Expense report: employee expenditure REPORT INTEREST: INTEREST invoice MIXED: MIXED invoice PREPAYMENT: PREPAYMENT and advances QUICKDEFAULT: purchase the default standard invoice QUICKMATCH: Quick matching of Standard invoices STANDARD: STANDARD invoice Payment_method_lookup_code -- Payment Method CHECK: CHECK CLEARING: liquidation and ticket exchange EFT: electronic transfer WIRE: WIRE transfer payment Payment_status_flag -- payment status N: no payment Y: pay all P: Partial payment SOURCE -- what is the invoice payable and the SOURCE? Credit card: CREDIT CARD Edi gateway: E-commerce GATEWAY ERS: Electronic Receipt Settlement Invoice gateway: INVOICE GATEWAY Intercompany: within the company Oracle Assets: Oracle Assets Oracle Project Accounting: Oracle Project Accounting Oracle Property manager: Oracle Property Management PA_IC_INVOICES: Oracle inter-company project invoice PA_IP_INVOICES: Oracle project invoice Recurring invoice: Regular INVOICE RTS: Return to supplier SelfService: self-service applications XpenseXpress: Fee payable report --------------------------------------------------- Select -- Unique flag Column Invoice_id -- Standard System Column , Creation_date , Creatd_by , Last_update_date , Last_updated_by , Last_update_login , Program_application_id , Program_id , Program_update_date , Request_id -- Parent Column , Org_id -- Organization ID , Set_of_books_id -- Set ID , Batch_id -- invoice Batch ID -- Source column , Source -- source Type -- ID column of the current record , Invoice_num -- invoice number , Invoice_date -- Invoice date (date of the information recorded in the current record) , Invoice_type_lookup_code -- invoice type (the information type recorded in the current record) , Description -- description (description of the information recorded in the current record) , Payment_status_flag -- payment status (the status of the information recorded in the current record) , Approval_status -- invoice approval status (for reference only) , Approval_description -- Description of the Approval Status , Posting_status -- posting status , Authorized_by -- User ID for approving prepaid invoices , Cancelled_date -- Date on which the invoice is canceled , Cancelled_by -- User ID used to cancel the invoice -- Attribute Column , Attribute_category -- attribute Extension , Attribute1 ~ 15 , Global_attribute_category -- Global attribute Extension , Global_attribute1 ~ 15 , Invoice_amount -- invoice amount , Pay_curr_invoice_amount -- invoice amount based on payment currency , Amount_paid -- the amount paid , Payment_amount_total -- the invoiced amount , Freight_amount -- freight amount (used to calculate the valid amount used for discount and provide the default amount allocated proportionally) , Base_amount -- the currency amount, only when the invoice currency is foreign currency , Approved_amount -- invoice amount approved (refer only) , Tax_amount-Tax Amount , Pre_withholding_amount -- prepayment Tax Amount , Amount_applicable_to_discount -- applicable to the discount amount , Discount_amount_taken -- Take the discount amount , Cancelled_amount -- original amount of the canceled invoice , Temp_cancelled_amount -- the original amount of the temporary storage used to cancel the invoice before the invoice is canceled , Terms_date -- the scheduled payment time calculated based on the payment terms , Voucher_num -- coupon number (Verification: Enable sequence number/do not verify: no startup sequence number) , Gl_date -- specifies the accounting date, which defaults to the invoice distribution line. , Goods_inclued_date -- Date of receipt of the item , Invoice_received_date -- Date on which the invoice is received , Earliest_settlement_date -- the date on which the payment is made for the approved prepayment invoice (only for temporary prepayment, other invoice types) , Awt_flag -- indicates the tax deduction method (A: Automatic calculation/M: manual calculation) , Auto_tax_calc_flag -- whether to automatically calculate the tax based on the Tax Code (Y: Header level, L: Line level, T: tax code level, N: not automatically calculated) , Exclusive_payment_flag -- whether to pay separately based on the account file -- External Connection ID , Invoice_currency_code -- invoice currency , Payment_currency_code -- payment invoice currency (same as invoice currency or fixed exchange rate enabled) , Payment_method_lookup_code -- Payment Method Name , Pay_group_lookup_code -- payment group name , Vat_code -- Tax Law , Awt_group_id -- tax deduction group ID , Vendor_id -- supplier ID , Vendor_site_id -- supplier address ID , Terms_id -- payment term ID , Accts_pay_code_combination_id -- Account Payable Accounting , Po_header_id -- po id (invoice type: QUICKMATCH/po default/prepayments) , Recurring_payment_id -- ID of the recurring invoice , Award_id -- retained to the oracle Grants Management System -- 11i disabled Column , Original_prepayment_amount -- the original prepayment, 11i has been disabled , Invoice_distribution_total -- total invoice distribution, 11i disabled , Vendor_prepay_amount -- supplier prepaid, 11i disabled , Prepay_flag -- prepaid, 11i disabled -- = Exchange Rate , Exchange_rate -- foreign currency invoice Exchange Rate , Exchange_rate_type -- foreign currency invoice exchange rate type , Exchange_date -- valid exchange rate date, which usually occupies the transaction date , Payment_cross_date -- exchange rate date between the invoice currency and the payment currency , Payment_cross_rate_type -- exchange rate type between the invoice currency and the payment currency , Payment_cross_rate_date -- exchange rate date between the invoice currency and the payment currency -- = Document , Doc_sequence_id -- Document ID numbered in sequence , Doc_sequence_value -- Document Value of sequential number , Doc_category_code -- document type numbered in sequence -- = American Standard General Ledger diary (USSGL: US Standard General Ledger journal entries) , Ussgl_transaction_code -- default USSGL transaction code , Ussgl_trx_code_context -- Context column of USSGL transaction code -- = Project , Project_id -- Project ID, used to create a default accounting elastic domain , Task_id -- project task ID, used to create a default accounting elastic domain , Expenditure_type -- Project expense type, used to create the default accounting elastic domain , Expenditure_item_date -- project expenditure item date , Pa_quantity -- number of items in the project , Expenditure_organization_id -- project organization ID , Pa_default_dist_ccid -- the project-related accounting account, which defaults to the invoice distribution line. , Project_accounting_context -- Context column of the Project Accounting elastic domain , Reference1 -- oracle project fee report reference information , Reference2 -- = Multi-currency report (MRC Multiple Reporting Currencies) , Mrc_base_amount -- , Mrc_exchange_rate -- , Mrc_exchange_rate_type -- , Mrc_exchange_date -- From ap_invoices_all