# DW_AP_EXPENSE_DIST_CF

This table contains details of PRE SLA Payables expense distribution transactions.

## Details

Module: Payables

## Key Columns

INVOICE_ID, INVOICE_DISTRIBUTION_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. |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
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 |  | Pre SLA Ledger Id from invoice header | 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
ACCOUNTING_DATE | DATE |  |  |  | Invoice distribution accounting date. |  |
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
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 |  |
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 |  | PO 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 |  |  | Invoice currency code. |  |
TRX_DIST_AMOUNT | NUMBER |  |  |  | Distribution amount in invoice currency. |  |
TRX_LINE_AMOUNT | NUMBER |  |  |  | Line amount in invoice currency |  |
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 |  |  | Ledger currency code of pre SLA Ledger Id from invoice header |  |
LEDGER_DIST_AMOUNT | NUMBER |  |  |  | Amount of invoice in functional currency, only used for foreign currency invoices |  |
LEDGER_LINE_AMOUNT | NUMBER |  |  |  | Invoice line amount in ledger currency |  |
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 | NUMBER |  |  |  | Amount of invoice in global currency |  |
GLOBAL_LINE_AMOUNT | NUMBER |  |  |  | Invoice line amount in global currency |  |
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 |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.