DW_AP_INVOICE_DISTRIBUTIONS_EN

This is the entity table for invoice distribution information.

Details

Module: Payables

Key Columns

INVOICE_DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVOICE_DISTRIBUTION_ID NUMBER 38 0 True The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier. Value is derived from a combination of invoice identifier and LineNumber    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 128     The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.    
INVOICE_LINE_NUMBER NUMBER       The unique number for the invoice line associated with the invoice distribution.    
DISTRIBUTION_LINE_NUMBER NUMBER 38 0   The line number associated with the invoice distribution.    
ACCOUNTING_DATE DATE       The date when the invoice distribution is to be accounted.    
LINE_TYPE_LOOKUP_CODE VARCHAR2 32     The type of invoice line associated with the invoice distribution. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE.    
POSTED_FLAG VARCHAR2 16     Indicates whether the invoice distribution line has been accounted.    
CANCELLATION_FLAG VARCHAR2 16     Indicates whether an invoice distribution is canceled. The default value is false. If the value if true, then it indicates the invoice distribution is canceled.    
AMOUNT NUMBER       The amount on the invoice distribution.    
BASE_AMOUNT NUMBER       The invoice distribution amount in the ledger currency. This is only used for foreign currency invoices.    
CREATED_BY VARCHAR2 128     The user who created the invoice distribution.    
LAST_UPDATED_BY VARCHAR2 128     The user who last updated the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.    
RCV_TRANSACTION_ID NUMBER 38 0   The identifier of the receipt of material that originated the invoice distribution.    
INVOICE_ID NUMBER 38 0   The unique identifier of the invoice associated with the invoice distribution. DW_AP_INVOICES_EN  
DESCRIPTION VARCHAR2 256     The description of the invoice distribution.    
DIST_CODE_COMBINATION_ID NUMBER 38 0   The identifier of the accounting flexfield for the account associated with the distribution. DW_GL_CODE_COMBINATION_D  
REVERSAL_FLAG VARCHAR2 16     Indicates whether a distribution is part of a reversal pair. The default value is false. If the value if true, then it indicates that the distribution is part of a reversal pair.    
DIST_MATCH_TYPE VARCHAR2 32     Indicates if the invoice is matched to a purchase order or to a receipt of material. A list of accepted values is defined in the lookup type INVOICE LINE MATCH TYPE.    
PO_DISTRIBUTION_ID NUMBER 38 0   Purchase order distribution identifier for purchase order or receipt matched invoice distributions    
ASSETS_TRACKING_FLAG VARCHAR2 16     Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N    
MATCHED_UOM_LOOKUP_CODE VARCHAR2 32     UOM used for the quantity invoiced during matching of this distributions    
UNIT_PRICE NUMBER       Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections    
QUANTITY_INVOICED NUMBER       Quantity billed for purchase order or receipt matched invoice distributions    
MATCH_STATUS_FLAG VARCHAR2 16     Indicates whether the invoice distribution is generated for a purchase order matched line.    
ACCOUNTING_EVENT_ID NUMBER 38 0   Accounting event identifier. Refers to the accounting event that accounted for the distribution    
PJC_PROJECT_ID NUMBER       dentifier of the project used to build the transaction descriptive flexfield for project related transaction distributions    
PJC_TASK_ID NUMBER       Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions.    
PJC_EXPENDITURE_TYPE_ID NUMBER       Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions.    
PJC_ORGANIZATION_ID NUMBER       Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions.    
PJC_EXPENDITURE_ITEM_DATE DATE       Date on which a project related transaction is incurred.    
L_INVOICE_ID NUMBER 38 0   Invoice line number associated with the event.    
L_LINE_NUMBER NUMBER 38 0   Number of the invoice line.    
L_AMOUNT NUMBER       Line amount in invoice currency    
L_LINE_TYPE_LOOKUP_CODE VARCHAR2 32     The type of invoice line. The value must be provided while creating an invoice line. A list of accepted values is defined in the lookup type INVOICE LINE TYPE    
L_ACCOUNTING_DATE DATE       The accounting date for the invoice line. It is used to default the accounting date to invoice distributions.    
L_CANCELLED_FLAG VARCHAR2 16     Indicates whether an invoice line is canceled. Possible values are null, Y or N. If the value is Y, then it indicates that the line has been canceled.    
L_PREPAY_INVOICE_ID NUMBER 38 0   The identifier of the prepayment invoice applied to the invoice line.    
L_PREPAY_LINE_NUMBER NUMBER       The line number of the prepayment line applied to the invoice line.    
L_LINE_SOURCE VARCHAR2 32     Source of the invoice line. Validated against AP_LOOKUP_CODES.LOOKUP_CODE for LOOKUP_TYPE LINE SOURCE    
L_REQUESTER_ID NUMBER 38 0   The name of the person who the requested items are intended for.    
L_PURCHASING_CATEGORY_ID NUMBER 38 0   Item category unique identifier    
L_DESCRIPTION VARCHAR2 256     Description of the invoice line.    
L_CONSUMPTION_ADVICE_LINE_ID NUMBER 38 0   Consumption advice line identifier. Used for consumption advice matching.    
L_SHIP_TO_LOCATION_ID NUMBER 38 0   Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched.    
L_INVENTORY_ITEM_ID NUMBER       Inventory item identifier. Validated against EGP_SYSTEM_ITEMS.INVENTORY_ITEM_ID    
L_ITEM_DESCRIPTION VARCHAR2 256     Description of the item in the invoice line.    
L_PRODUCT_TYPE VARCHAR2 256     Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user.    
L_UNIT_PRICE NUMBER       Price charged per unit of a good or service.    
L_QUANTITY_INVOICED NUMBER       Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines    
L_UNIT_MEAS_LOOKUP_CODE VARCHAR2 32     Unit of measure for QUANTITY_INVOICED. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE    
L_WFAPPROVAL_STATUS VARCHAR2 32     Indicates if an invoice line has been approved.    
H_INVOICE_ID NUMBER 38 0   Invoice identifier.    
H_ACCTS_PAY_CODE_COMBINATION_ID NUMBER 38 0   Accounting Flexfield identifier for accounts payable liability account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
H_APPROVAL_STATUS VARCHAR2 32     Status of manual authorization invoice approval (used for reference purposes only).    
H_CANCELLED_DATE DATE       Date when the invoice was canceled.    
H_CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
H_CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
H_DESCRIPTION VARCHAR2 256     Statement that describes the invoice.    
H_DOC_SEQUENCE_VALUE NUMBER       Voucher number (Sequential Numbering) for invoice    
H_EXCHANGE_RATE NUMBER       Ratio at which the principal unit of one currency is converted into another currency for an invoice.    
H_GL_DATE DATE       Accounting date to default to invoice distributions    
H_INVOICE_AMOUNT NUMBER       Invoice amount in transaction currency.    
H_INVOICE_CURRENCY_CODE VARCHAR2 16     Currency code used on the invoice.    
H_INVOICE_DATE DATE       Date when an event will occur or occurred.    
H_INVOICE_NUM VARCHAR2 64     Unique number for supplier invoice.    
H_INVOICE_RECEIVED_DATE DATE       Date when the invoice was received. This is used to calculate when the invoice is due.    
H_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
H_LAST_UPDATE_DATE TIMESTAMP       Indicates the date and time of the last update of the row.    
H_LAST_UPDATED_BY VARCHAR2 64     Who column: indicates the user who last updated the row.    
H_LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
H_ORG_ID NUMBER 38 0   Business Unit Identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
H_PARTY_ID NUMBER 38 0   Supplier identifier. DW_PARTY_D PARTY_ID
H_PAYMENT_CURRENCY_CODE VARCHAR2 16     Currency code of payment    
H_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
H_PAYMENT_REASON_COMMENTS VARCHAR2 256     Free text field available for entering a reason for the payment    
H_PAYMENT_STATUS_FLAG VARCHAR2 16     Flag that indicates if invoice has been paid (Y, N, or P)    
H_REMIT_TO_SUPPLIER_ID NUMBER 38 0   Third party supplier identifier DW_PARTY_D SUPPLIER_ID
H_ROUTING_ATTRIBUTE1 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE2 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE3 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE4 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE5 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_SET_OF_BOOKS_ID NUMBER 38 0   Ledger identifier of the invoice. DW_LEDGER_D LEDGER_ID
H_SOURCE VARCHAR2 32     Feeder system from which an invoice is imported.    
H_TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
H_VENDOR_ID NUMBER 38 0   Invoice supplier identifier    
H_VENDOR_SITE_ID NUMBER 38 0   Physical location of the supplier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
H_WFAPPROVAL_STATUS VARCHAR2 64     Status of invoice in the Invoice Approval Workflow process    
H_BATCH_ID NUMBER 38 0   Unique invoice group identifier.    
H_INV_ACCOUNTING_STATUS_CODE VARCHAR2 32     Derived accounting status    
H_INTERCOMPANY_FLAG VARCHAR2 16     Intercompany flag added to incorporate FUN team's intercompany feature.    
H_PO_HEADER_ID NUMBER 38 0   PO Header identifier.    
H_FIRST_PARTY_REGISTRATION_ID NUMBER 38 0   First party tax registration identifier.    
H_THIRD_PARTY_REGISTRATION_ID NUMBER 38 0   Third party tax registration identifier.    
L_TAX_CLASSIFICATION_CODE VARCHAR2 32     Tax classification code used by Procure To Pay products.    
L_TAX_RATE_CODE VARCHAR2 256     Tax rate name associated with tax rate identifier. Tax_rate_id is unique while a tax_rate_code may have different tax rates based on date ranges.    
L_TAX_RATE NUMBER       The rate specified for a tax status in effect for a period of time.    
L_TAX_REGIME_CODE VARCHAR2 32     Tax Regime Code: The set of tax rules that determines the treatment of one or more taxes administered by a tax authority. e.g., VAT Regime in Argentina.    
L_TAX VARCHAR2 32     A classification of a charge imposed by a government through a fiscal or tax authority.    
L_TAX_JURISDICTION_CODE VARCHAR2 32     Internal ID of the Tax Jurisdiction.    
L_SUMMARY_TAX_LINE_ID NUMBER 38 0   Tax Driver: Transactions category assigned by user.    
CHARGE_APPLICABLE_TO_DIST_ID NUMBER 38 0   Invoice distribution to which 100% of current charge is applied    
AWT_RELATED_ID NUMBER 38 0   Identifier linking related distributions. Used for linking related Invoice Distribution for this Withholding Distribution. Populated from INVOICE_DISTRIBUTION_ID of the related distribution.    
ASSETS_ADDITION_FLAG VARCHAR2 16     Flag that indicates if distribution has been transferred into Oracle Assets (U, Y, or N)    
ASSET_BOOK_TYPE_CODE VARCHAR2 32     Asset Book. Defaults from invoice line for newly created distributions or distributions that have changed ASSETS_TRACKING_FLAG from N to Y DW_FA_BOOKS_D BOOK_TYPE_CODE
ASSET_CATEGORY_ID NUMBER 38 0   Asset Category. Defaults from invoice line for newly created distributions or distributions that have changed ASSETS_TRACKING_FLAG from N to Y DW_FA_CATEGORIES_D CATEGORY_ID
PA_ADDITION_FLAG VARCHAR2 16     Flag that indicates if project related invoice distributions have been transferred into Oracle Projects