DW_AP_INVOICES_EN

This is the entity table for invoice headers at invoice id grain

Details

Module: Payables

Key Columns

INVOICE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVOICE_ID NUMBER 38 0 True Invoice identifier.    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier. Value is derived from a combination of invoice identifier.    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 128     Invoice identifier.    
ACCTS_PAY_CODE_COMBINATION_ID NUMBER 38 0   Accounting Flexfield identifier for accounts payable liability account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
APPROVAL_STATUS VARCHAR2 32     Status of manual authorization invoice approval (used for reference purposes only).    
CANCELLED_DATE DATE       Date when the invoice was canceled.    
CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
DESCRIPTION VARCHAR2 256     Statement that describes the invoice.    
DOC_SEQUENCE_VALUE NUMBER       Voucher number (Sequential Numbering) for invoice    
EXCHANGE_RATE NUMBER       Ratio at which the principal unit of one currency is converted into another currency for an invoice.    
GL_DATE DATE       Accounting date to default to invoice distributions    
INVOICE_AMOUNT NUMBER       Invoice amount in transaction currency.    
INVOICE_CURRENCY_CODE VARCHAR2 16     Currency code used on the invoice.    
INVOICE_DATE DATE       Date when an event will occur or occurred.    
INVOICE_NUM VARCHAR2 64     Unique number for supplier invoice.    
INVOICE_RECEIVED_DATE DATE       Date when the invoice was received. This is used to calculate when the invoice is due.    
INVOICE_TYPE_LOOKUP_CODE VARCHAR2 32     Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on. DW_CODE_VALUES_LKP_TL CODE
LAST_UPDATE_DATE TIMESTAMP       Indicates the date and time of the last update of the row.    
LAST_UPDATED_BY VARCHAR2 64     Who column: indicates the user who last updated the row.    
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
ORG_ID NUMBER 38 0   Business Unit Identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
PARTY_ID NUMBER 38 0   Supplier identifier. DW_PARTY_D PARTY_ID
PAYMENT_CURRENCY_CODE VARCHAR2 16     Currency code of payment    
PAYMENT_METHOD_CODE VARCHAR2 32     Payment method (Header). Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_CODE_VALUES_LKP_TL CODE
PAYMENT_REASON_COMMENTS VARCHAR2 256     Free text field available for entering a reason for the payment    
PAYMENT_STATUS_FLAG VARCHAR2 16     Flag that indicates if invoice has been paid (Y, N, or P)    
REMIT_TO_SUPPLIER_ID NUMBER 38 0   Third party supplier identifier DW_PARTY_D SUPPLIER_ID
ROUTING_ATTRIBUTE1 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
ROUTING_ATTRIBUTE2 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
ROUTING_ATTRIBUTE3 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
ROUTING_ATTRIBUTE4 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
ROUTING_ATTRIBUTE5 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
SET_OF_BOOKS_ID NUMBER 38 0   Ledger identifier of the invoice. DW_LEDGER_D LEDGER_ID
SOURCE VARCHAR2 32     Feeder system from which an invoice is imported.    
TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
VENDOR_SITE_ID NUMBER 38 0   Physical location of the supplier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
WFAPPROVAL_STATUS VARCHAR2 64     Status of invoice in the Invoice Approval Workflow process    
INV_ACCOUNTING_STATUS_CODE VARCHAR2 32          
PRIOR_IED_FLAG VARCHAR2 16          
BATCH_ID NUMBER 38 0   Unique invoice group identifier.    
INTERCOMPANY_FLAG VARCHAR2 16     Intercompany flag added to incorporate FUN team's intercompany feature.    
BASE_AMOUNT NUMBER       When the Calculate User Exchange Rate option is enabled and when the exchange rate type is User, the user can enter a value for BASE_AMOUNT so the system can calculate the exchange rate.    
FIRST_PARTY_REGISTRATION_ID NUMBER 38 0   First party tax registration identifier.    
THIRD_PARTY_REGISTRATION_ID NUMBER 38 0   Third party tax registration identifier.