DW_AP_EXPENSE_DIST_ALL_CF

This table contains details of Payables expense distribution transactions and the currency used.This table supports the post SLA/Pre-SLA details of the transaction distribution.

Details

Module: Payables

Key Columns

REF_AE_HEADER_ID, INVOICE_ID, TEMP_LINE_NUM, INVOICE_DISTRIBUTION_ID, AE_HEADER_ID, PREPAY_APP_DIST_ID, DISTRIBUTION_LINE_NUMBER, INVOICE_LINE_NUMBER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INVOICE_ID NUMBER 38 0 True Invoice identifier.
INVOICE_LINE_NUMBER NUMBER True Invoice line number.
DISTRIBUTION_LINE_NUMBER NUMBER 38 0 True Distribution line number.
INVOICE_DISTRIBUTION_ID NUMBER 38 0 True Invoice distribution identifier.
PREPAY_APP_DIST_ID NUMBER 38 0 True Prepayment application distribution identifier.
REF_AE_HEADER_ID NUMBER 38 0 True Reversed subledger journal entry header identifier.
TEMP_LINE_NUM NUMBER 38 0 True Intermediary line number generated by the accounting engine when the entries are in most detail form.
AE_HEADER_ID NUMBER 38 0 True Subledger journal entry identifier.
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of invoice identifier, invoice line number, distribution line number, invoice distribution identifier, prepayment application distribution identifier,Reversed subledger journal entry header identifier,Intermediary line number generated by the accounting engine when the entries are in most detail form and Subledger journal entry identifier.
PRE_SLA_FLAG VARCHAR2 16 Is pre SLA data flag DW_YN_LKP_TL YN_LKP_CODE
INVOICE_NUMBER VARCHAR2 64 Invoice number.
INVOICE_GROUP VARCHAR2 64 Invoice Group or Invoice batch name
PURCHASE_ORDER_NUMBER VARCHAR2 32 Purchase order number.
PURCHASE_ORDER_LINE_NUMBER NUMBER Purchase order line number.
PURCHASE_ORDER_SHIPMENT_NUM NUMBER Purchase order shipment number.
PURCHASE_ORDER_DIST_NUMBER NUMBER Purchase order distribution number.
RECEIVING_SHIPMENT_RECEIPT_NUM VARCHAR2 32 Shipment receipt number.
RECEIVING_SHIPMENT_RECEIPT_ID NUMBER 38 0 This column stores the receiving shipment receiving receipt header unique identifier
RECEIVING_SHIPMENT_LINE_NUMBER NUMBER 38 0 Shipment line number.
RECEIVING_SHIPMENT_LINE_ID NUMBER 38 0 This column stores the receiving shipment receiving receipt line unique identifier
INVOICE_DESCRIPTION VARCHAR2 256 Invoice description.
PAYMENT_REASON_COMMENTS VARCHAR2 256 Reason for payment.
DISTRIBUTION_DESCRIPTION VARCHAR2 256 Distribution description.
LEDGER_ID NUMBER 38 0 Self-contained accounting information set for single or multiple legal or management entities. DW_LEDGER_D LEDGER_ID
PARTY_ID NUMBER 38 0 Party identifier DW_PARTY_D PARTY_ID
SUPPLIER_ID NUMBER 38 0 Invoice supplier identifier
SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
SUPPLIER_SITE_ID NUMBER 38 0 Supplier site identifier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
THIRD_PARTY_ID NUMBER 38 0 Third party payee identifier. DW_PARTY_D SUPPLIER_ID
PAYABLES_BU_ID NUMBER 38 0 Payables invoicing business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
PAYABLES_CODE_COMB_ID NUMBER 38 0 Expense account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 GL account identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT1_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT1_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT2_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT2_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT3_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT3_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT4_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT4_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT5_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT5_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT6_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT6_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT7_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT7_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT8_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT8_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT9_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT9_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT10_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT10_D GL_SEGMENT_VALUESET_CODE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
INV_DIST_VALIDATION_STATUS VARCHAR2 32 Invoice Distribution validation status.Values are from the table DW_AP_INV_VAL_STATUS_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. DW_AP_INV_VAL_STATUS_LKP_TL AP_INV_VAL_STATUS_LKP_CODE
INV_DIST_REVERSAL_INDICATOR VARCHAR2 16 Flag that indicates if distribution is part of a reversal pair.Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL CODE
INV_DISTRIBUTION_MATCH_TYPE VARCHAR2 32 Indicates whether an invoice matched a PO or a receipt of material.Values are from the table DW_AP_DIST_MATCH_STATUS_LKP_TL with CODE_TYPE=MATCH_STATUS. DW_AP_DIST_MATCH_STATUS_LKP_TL AP_DIST_MATCH_STATUS_LKP_CODE
INVOICED_ON_DATE DATE Date when invoiced is created.
INVOICE_RECEIVED_DATE DATE Date when invoice is received.
PURCHASE_ORDER_DATE TIMESTAMP Purchase order creation date.
PAYMENT_TERMS_ID NUMBER 38 0 Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
INVOICE_TYPE_CODE VARCHAR2 32 Invoice type. Values are from the table DW_AP_INVOICE_TYPE_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_AP_INVOICE_TYPE_LKP_TL AP_INVOICE_TYPE_LKP_CODE
DISTRIBUTION_TYPE_CODE VARCHAR2 32 Distribution type. Values are from the table DW_AP_DISTRIBUTION_TYPE_LKP_TL with CODE_TYPE=INVOICE DISTRIBUTION TYPE. Possible values are ITEM, ERV, NONREC_TAX, TRV, FREIGHT, MISCELLANEOUS, TIPV, AWT, IPV, REC_TAX, ACCRUAL, PREPAY, TERV, and so on. DW_AP_DISTRIBUTION_TYPE_LKP_TL AP_DISTRIBUTION_TYPE_LKP_CODE
PREPAY_DIST_TYPE_CODE VARCHAR2 32 Type of prepayment application distribution.
INVOICE_SOURCE_CODE VARCHAR2 32 Invoice source. Values are from the table DW_AP_INVOICE_SOURCE_LKP_TL with CODE_TYPE=SOURCE. Possible values are INVOICE GATEWAY, Recurring Invoice, SelfService, Confirm PaymentBatch, LOANS, Manual Invoice Entry, QuickCheck, and so on. DW_AP_INVOICE_SOURCE_LKP_TL AP_INVOICE_SOURCE_LKP_CODE
INVOICE_ACCOUNTING_STATUS_CODE VARCHAR2 32 Invoice distribution accounting status. Values are from the table DW_AP_ACCOUNTING_STATUS_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. DW_AP_ACCOUNTING_STATUS_LKP_TL AP_ACCOUNTING_STATUS_LKP_CODE
INVOICE_CANCELLED_FLAG VARCHAR2 32 Indicates a cancelled invoice. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_CODE
DISTRIBUTION_CANCELLED_FLAG VARCHAR2 16 Indicates a cancelled distribution. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_CODE
CREATED_BY_USER_ID VARCHAR2 128 User who created the record. DW_USER_D USERNAME
UPDATED_BY_USER_ID VARCHAR2 128 User who updated the record. DW_USER_D USERNAME
HEADER_CREATED_BY_USER_ID VARCHAR2 128 User who created the invoice. DW_USER_D USERNAME
HEADER_UPDATED_BY_USER_ID VARCHAR2 128 User who updated the invoice. DW_USER_D USERNAME
INVOICE_CREATION_DATE TIMESTAMP Date when invoice row was created in the table.
INVOICE_CREATION_DATE_1 DATE Date when invoice row was created in the table.
INVOICE_ACCOUNTING_DATE DATE Date when invoice was accounted
INVOICE_VOUCHER_NUMBER NUMBER Voucher number (Sequential Numbering) for invoice
INVOICE_APPROVAL_STATUS_CODE VARCHAR 64 Invoice approval status. Values are from the table DW_AP_INV_APPR_STATUS_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, and so on. DW_AP_INV_APPR_STATUS_LKP_TL AP_INV_APPR_STATUS_LKP_CODE
INVOICE_VALIDATION_STATUS_CODE VARCHAR 32 Invoice validation status. Values are from the table DW_AP_INV_VAL_STATUS_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. DW_AP_INV_VAL_STATUS_LKP_TL AP_INV_VAL_STATUS_LKP_CODE
INVOICE_PO_NUMBER VARCHAR2 32 PO number the invoice is matched to.
INVOICE_PAYMENT_STATUS_CODE VARCHAR 16 Invoice payment status. Values are from the table DW_AP_INV_SCH_STATUS_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. DW_AP_INV_SCH_STATUS_LKP_TL AP_INV_SCH_STATUS_LKP_CODE
INVOICE_PAYMENT_METHOD_CODE VARCHAR 32 Payment method (Header). Values are from the table DW_AP_PAYMENT_METHOD_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_AP_PAYMENT_METHOD_LKP_TL AP_PAYMENT_METHOD_LKP_CODE
PO_DISTRIBUTION_ID NUMBER 38 0 Purchase order distribution identifier for purchase order or receipt matched invoice distributions
DISTRIBUTION_POSTED_FLAG VARCHAR2 16 Derived Field using POSTED_FLAG DW_YN_LKP_TL YN_LKP_CODE
TRACK_AS_ASSET VARCHAR2 16 Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N
TRANSACTION_UOM_CODE VARCHAR2 32 UOM used for the quantity invoiced during matching of this distributions
DISTRIBUTION_UNIT_PRICE NUMBER Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections
DISTRIBUTION_QUANTITY NUMBER Quantity billed for purchase order or receipt matched invoice distributions
LINE_SOURCE_CODE VARCHAR2 32 Source of the invoice line. Validated against AP_LOOKUP_CODES.LOOKUP_CODE for LOOKUP_TYPE LINE SOURCE
LINE_TYPE_LOOKUP_CODE VARCHAR2 32 Type of invoice line. Valid values from INVOICE LINE TYPE lookup codes.
REQUESTER_ID NUMBER 38 0 The name of the person who the requested items are intended for. DW_PERSON_NAME_CURRENT_D PERSON_ID
LINE_PURCHASING_CATEGORY_ID NUMBER 38 0 Item category unique identifier
LINE_DESCRIPTION VARCHAR2 256 Description of the invoice line.
CONSUMPTION_ADVICE_AVAILABLE VARCHAR2 16 Flag to check if Consumption advice line identifier is available or not.
SHIP_TO_LOCATION_ID NUMBER 38 0 Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched.
INVENTORY_ITEM_ID NUMBER Inventory item identifier. Validated against EGP_SYSTEM_ITEMS.INVENTORY_ITEM_ID
ITEM_DESCRIPTION VARCHAR2 256 Description of the item in the invoice line.
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.
INVOICE_LINE_UNIT_PRICE NUMBER Price charged per unit of a good or service.
INVOICE_LINE_QUANTITY NUMBER Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines
TRANSACTION_LINE_UOM_CODE VARCHAR2 32 Unit of measure for QUANTITY_INVOICED. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE
LINE_APPROVAL_STATUS VARCHAR2 32 Indicates if an invoice line has been approved.
INVOICE_CANCELLED_DATE DATE Date when the invoice was canceled.
INVOICE_INTER_COMPANY_FLAG VARCHAR2 16 Intercompany flag added to incorporate FUN team's intercompany feature. DW_YESNO_LKP_TL YESNO_LKP_CODE
XLA_MANUAL_OVERRIDE_FLAG VARCHAR2 32 Indicates a manual override. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_CODE
SOURCE_DISTRIBUTION_TYPE VARCHAR2 32 Classification of transaction source distribution.
ACCOUNTING_LINE_CODE VARCHAR2 32 Short name of a rule to convert transactional data into a journal entry line.
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 16 Indicates whether the journal line rule is seeded.
AE_LINE_NUM NUMBER 38 0 Number that is associated with each subledger journal entry line.
ACCOUNTING_CLASS_CODE VARCHAR2 32 Short name of a lookup type that is shared across application used to classify journal entry lines. DW_XLA_ACCOUNT_CLASS_LKP_TL ACCOUNTING_CLASS_CODE
ACCOUNTING_DATE DATE Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. For SLA transaction its from SLA for PRESLA from presla distribution.
FIRST_PARTY_REGISTRATION_ID NUMBER 38 0 First party tax registration identifier.
THIRD_PARTY_REGISTRATION_ID NUMBER 38 0 Third party tax registration identifier.
TAX_CLASSIFICATION_CODE VARCHAR2 32 Tax classification code used by Procure To Pay products.
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.
TAX_RATE NUMBER The rate specified for a tax status in effect for a period of time.
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.
TAX VARCHAR2 32 A classification of a charge imposed by a government through a fiscal or tax authority.
TAX_JURISDICTION_CODE VARCHAR2 32 Internal ID of the Tax Jurisdiction.
SELF_ASSESSED_FLAG VARCHAR2 16 Y or N indicates whether this is a self-assessed tax line DW_YN_LKP_TL YN_LKP_CODE
WHT_CALC_POINT_FLAG VARCHAR2 16 Point of withholding application. Possible values are P (payment) and I (invoice).
SUMMARY_TAX_LINE_ID NUMBER 38 0 Tax Driver: Transactions category assigned by user.
CONTENT_OWNER_ID NUMBER 38 0 Party tax profile identifier for configuration owner of this tax
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.
CHARGE_APPLICABLE_TO_DIST_ID NUMBER 38 0 Invoice distribution to which 100% of current charge is applied
TAX_RATE_ID NUMBER 38 0 Tax rate identifier specified for a tax status for an effective time period.
TAX_ID NUMBER 38 0 Tax identifier
PROJECT_ID NUMBER Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions DW_PROJECT_D PROJECT_ID
TASK_ID NUMBER Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions. DW_PROJECT_ELEMENT_D PROJ_ELEMENT_ID
EXPENDITURE_TYPE_ID NUMBER Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions. DW_PROJECT_EXPENDITURE_TYPE_D EXPENDITURE_TYPE_ID
EXPENDITURE_ORG_ID NUMBER Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions. DW_INTERNAL_ORG_D ORGANIZATION_ID
EXPENDITURE_ITEM_DATE DATE Date on which a project related transaction is incurred.
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_MC_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
FISCAL_PERIOD_NAME VARCHAR2 64 Accounting period name.
PREPAY_INVOICE_ID NUMBER 38 0 Prepay Invoice identifier.
PREPAY_INVOICE_NUMBER VARCHAR2 64 Prepay Invoice number.
PREPAY_LINE_NUMBER NUMBER Prepay Invoice Line number.
TAX_AMT_INCLUDED_FLAG VARCHAR2 16 Y or N indicates whether this summary tax line is inclusive DW_YN_LKP_TL YN_LKP_CODE
PA_ADDITION_FLAG VARCHAR2 16 Flag that indicates if project related invoice distributions have been transferred into Oracle Projects
DEF_ACCTG_ACCRUAL_CCID NUMBER 38 0 Accrual account that is initially debited for deferred expenses
DEF_ACCTG_START_DATE DATE The start date of the deferred expense period
DEF_ACCTG_END_DATE DATE The end date of the deferred expense period
XDL_CREATION_DATE TIMESTAMP Who column indicates the date and time of the creation of the row.
INV_VOUCHER_NUM VARCHAR2 64 Voucher number - validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled)
INV_CREATION_DATE_FISCAL_PERIOD_NAME VARCHAR2 64 Accounting Period Name based on Invoice creation date
INVOICED_ON_DATE_FISCAL_PERIOD_NAME VARCHAR2 64 Accounting Period Name based on Invoiced on date
INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2 16 Y indicates that prepayment is included in the invoice amount DW_YN_LKP_TL YN_LKP_CODE
EARLIEST_SETTLEMENT_DATE DATE Date associated with a prepayment after which you can apply the prepayment against invoices. Only used for temporary prepayments. Column is null for permanent prepayments and other invoice types
INVOICE_REQUESTER_ID NUMBER 38 0 Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers DW_PERSON_NAME_CURRENT_D PERSON_ID
PURCHASE_ORDER_ID NUMBER 38 0 Document header unique identifier
PROCUREMENT_BU_ID NUMBER 38 0 Proc BU ID DW_INTERNAL_ORG_D ORGANIZATION_ID
REQUISITION_BU_ID NUMBER 38 0 Req BU ID DW_INTERNAL_ORG_D ORGANIZATION_ID
BUYER_ID NUMBER 38 0 Buyer unique identifier DW_PERSON_D PERSON_ID
MODE_OF_TRANSPORT VARCHAR2 32 Type of transportation used to ship the product, such as truck, air or boat
PO_PAYMENT_TERMS_ID NUMBER 38 0 Payment terms unique identifier
PO_CREATION_DATE_1 DATE Indicates the date and time of the creation of PO Header
SOURCE_AGREEMENT_DOC_STYLE_ID NUMBER 38 0 Document Style Identifier DW_DOC_STYLE_LINES_TL STYLE_ID
SOURCE_AGREEMENT_DOC_TYPE VARCHAR2 32 BLANKET or CONTRACT
AGREEMENT_PROCUREMENT_BU_ID NUMBER 38 0 Procurement BU of the Agreement (Blanket or Contract) DW_INTERNAL_ORG_D ORGANIZATION_ID
PURCHASE_ORDER_LINE_ID NUMBER 38 0 PO_LINE_ID
PO_LINE_PURCHASING_CATEGORY_ID NUMBER 38 0 Item category unique identifier. DW_ITEM_CATEGORIES_D CATEGORY_ID
SPEND_PURCHASING_CATEGORY_ID NUMBER 38 0 Item category unique identifier. This is coalesced from PO_LINE_PURCHASING_CATEGORY_ID (purchase order side) and LINE_PURCHASING_CATEGORY_ID (invoice side). DW_ITEM_CATEGORIES_D CATEGORY_ID
SPEND_ITEM_ID NUMBER 38 0 Purchase order item unique identifier. This is coalesced from PO_LINE_ITEM_ID (purchase order side) and INVENTORY_ITEM_ID (invoice side). DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
PO_LINE_TYPE_ID NUMBER 38 0 Line type unique identifier. DW_PURCHASING_LINE_TYPE_D LINE_TYPE_ID
PO_LINE_ITEM_ID NUMBER 38 0 Purchase order item unique identifier. DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID
PO_LINE_ITEM_DESCRIPTION VARCHAR2 256 Purchase order item description.
SPEND_ITEM_DESCRIPTION VARCHAR2 256 Purchase order item description. This is coalesced from PO_LINE_ITEM_DESCRIPTION (purchase order side) and ITEM_DESCRIPTION (invoice side).
MATCH_BASIS VARCHAR2 32 Matching basis of the line type
PURCHASE_BASIS VARCHAR2 32 Purchase basis of the line type
PO_SCHEDULE_ID NUMBER 38 0 Purchase order schedule identifier.
PO_SCHEDULE_NUMBER NUMBER Purchase order schedule number.
MATCH_OPTION VARCHAR2 32 Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt.
SHIP_TO_ORGANIZATION_ID NUMBER 38 0 Ship-to organization unique identifier for purchase order matched invoices. DW_INTERNAL_ORG_D ORGANIZATION_ID
SHIP_TO_CUST_ID NUMBER 38 0 Customer to whom merchandise is being sent DW_PARTY_D PARTY_ID
SHIP_TO_CUST_LOCATION_ID NUMBER 38 0 Attribute,Location where the supplier should ship the goods DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
DESTINATION_TYPE VARCHAR2 32 Final destination of the purchased items.Possible values are Drop-ship, Inventory, Expense, Manufacturing etc.
IS_PURCHASE_ORDER_MATCHED_FLAG VARCHAR2 16 Flag that indicates if invoice is matched to a Purchase Order or Receipt of a Purchase Order. DW_YESNO_LKP_TL YESNO_LKP_CODE
IS_AGREEMENT_LEAKAGE_FLAG VARCHAR2 16 Flag that indicates purchase order line does not have a agreement associated even though an open blanket agreement is available for the item. Conditions for agreement leakage flag (For 'Inventory Item' Based Purchase Orders only) - - Blanket Header is Approved - Blanket Line was created before PO distribution was created - If Blanket line was cancelled than it was cancelled later than PO distribution creation - If Blanket line was closed than it was closed later than PO distribution creation - PO distribution was created when agreement was available (Blanket Start and End Date) - Blanket Line was not expired before PO distribution was created - The Requisitioning BU in PO is Enabled as Requisitioning BU in Agreement - Item in the PO line matches with item in the Blanket Line DW_YESNO_LKP_TL YESNO_LKP_CODE
IS_NEGOTIATED_FLAG VARCHAR2 16 Flag that indicates if negotiation check box was selected for purchase order line. DW_YESNO_LKP_TL YESNO_LKP_CODE
IS_SOURCING_BASED_FLAG VARCHAR2 16 Flag that indicates if purchase order line has sourcing negotiation id assigned. DW_YESNO_LKP_TL YESNO_LKP_CODE
IS_REQUISITION_BASED_FLAG VARCHAR2 16 Flag that indicates if purchase order is associated with a requisition. DW_YESNO_LKP_TL YESNO_LKP_CODE
REQUISITION_DISTRIBUTION_ID NUMBER 38 0 Requisition distribution unique identifier
REQ_LAST_APPROVAL_DATE DATE This attribute captures the time when the requisition lines is last approved. It is used to compute the average approval time metric for the items on requisition lines.
REQ_LAST_SUBMITTED_DATE DATE This attribute captures the time when the requisition line is last submitted for approval. It is used to compute the average approval time metric for the items on requisition lines.
REQ_APPROVED_DATE DATE Date when Requisition is approved
REQ_CREATION_DATE DATE Who column: indicates the date and time of the creation of the row.
CONTRACT_ID NUMBER 38 0 Contract Identified.Used when Oracle Contract Billing or Oracle Grants Accounting is installed. DW_AWARD_D AWARD_ID
FUNDING_ALLOCATION_ID NUMBER 38 0 Specifies the name of the project funding override.
FUNDING_SOURCE_ID NUMBER 38 0 Award funding source identifier
EXPENDITURE_CATEGORY_ID NUMBER 38 0 Expenditure Category Identifier DW_PROJECT_EXP_CATEGORY_D EXPENDITURE_CATEGORY_ID
PROJECT_UNIT_ID NUMBER 38 0 Project unit assigned to the project.
PROJECT_ORGANIZATION_ID NUMBER 38 0 Indicates the identifier of the business unit associated to the row. DW_INTERNAL_ORG_D ORGANIZATION_ID
PUOM_CODE VARCHAR2 32 Line Primary Unit Of Measure code
PUOM_CONVERSION_FACTOR NUMBER Primary Unit of Measure to Transation Unit of Measure Conversion Rate
PUOM_INVOICE_LINE_QUANTITY NUMBER Line Quantity in Primary Unit of Measure
PERMANENT_FLAG VARCHAR2 16 Permanent Indicator
INVOICE_HOLD_FLAG VARCHAR2 16 Indicates if invoice had any hold in the past. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_CODE
HOLD_STATUS_FLAG VARCHAR2 16 Indicates that the invoice is on hold. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. DW_YESNO_LKP_TL YESNO_LKP_CODE
TRX_CURRENCY_CODE VARCHAR2 16 In case of POSTSLA data (PRE_SLA_FLAG = N), this represents the XLA transaction currency, but for PRESLA data (PRE_SLA_FLAG = Y) this represent the invoice currency defined at a header level
TRX_DIST_AMOUNT BIGDECIMAL 10 For POSTSLA data (PRE_SLA_FLAG = N), this is the XLA distribution transaction amount, for PRESLA data (PRE_SLA_FLAG = Y) this represents the invoice distribution amount
TRX_LINE_AMOUNT BIGDECIMAL 10 For POSTSLA data (PRE_SLA_FLAG = N), this is the XLA line transaction amount, for PRESLA data (PRE_SLA_FLAG = Y) this represents the invoice line amount
INVOICE_CURRENCY_CODE VARCHAR2 16 Invoice currency code.
INVOICE_AMOUNT NUMBER Invoice amount in transaction currency.
INVOICE_PAID_AMOUNT NUMBER Amount paid against an invoice.
REMAINING_INVOICE_AMOUNT NUMBER Remaining invoice amount to be paid
LEDGER_CURRENCY_CODE VARCHAR2 16 Functional currency of the ledger.
LEDGER_DIST_AMOUNT BIGDECIMAL 10 Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line.
LEDGER_LINE_AMOUNT BIGDECIMAL 10 Line level unrounded accounted debit amount of the journal entry line minus Line level unrounded accounted credit amount of the journal entry line.
LEDGER_INVOICE_AMOUNT NUMBER Invoice amount in ledger currency.
LEDGER_INVOICE_PAID_AMOUNT NUMBER Amount paid against an invoice in ledger currency.
LEDGER_REMAINING_INVOICE_AMOUNT NUMBER Remaining invoice amount to be paid in ledger currency
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURRENCY_EXCH_RATE BIGDECIMAL 10 Global currency conversion rate.
GLOBAL_DIST_AMOUNT BIGDECIMAL 10 Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line.
GLOBAL_LINE_AMOUNT BIGDECIMAL 10 Line level unrounded global debit amount for the journal line minus Line level unrounded global credit amount for the journal line.
GLOBAL_INVOICE_AMOUNT NUMBER Invoice amount in global currency.
GLOBAL_INVOICE_PAID_AMOUNT NUMBER Amount paid against an invoice in global currency.
GLOBAL_REMAINING_INVOICE_AMOUNT NUMBER Remaining invoice amount to be paid in global currency