This is the entity table for invoice headers at invoice id grain
Module: Payables
INVOICE_ID
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. |