This table contains details of Payables expense distribution transactions and the currency used.This table supports the post SLA account details coming from the subledger accounting module.
Module: Payables
INVOICE_LINE_NUMBER, INVOICE_ID, PREPAY_APP_DIST_ID, INVOICE_DISTRIBUTION_ID, DISTRIBUTION_LINE_NUMBER, TEMP_LINE_NUM, REF_AE_HEADER_ID, AE_HEADER_ID
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 | 256 | 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. | ||||
SUBLEDGER_FACT_LINKAGE_ID | VARCHAR2 | 256 | Subledger Fact Linkage Identifier | ||||
LINKAGE_ID | NUMBER | 38 | 0 | Sub ledger linkage 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. | ||||
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_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 10 value set code. | DW_GL_SEGMENT_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_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. | DW_CODE_VALUES_LKP_TL | CODE | ||
INV_DIST_REVERSAL_INDICATOR | VARCHAR2 | 16 | Flag that indicates if distribution is part of a reversal pair.Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_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_CODE_VALUES_LKP_TL with CODE_TYPE=MATCH_STATUS. | DW_CODE_VALUES_LKP_TL | CODE | ||
ACCOUNTING_DATE | DATE | 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_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 | ||
DISTRIBUTION_TYPE_CODE | VARCHAR2 | 32 | Distribution type. Values are from the table DW_CODE_VALUES_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_CODE_VALUES_LKP_TL | 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_CODE_VALUES_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_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_ACCOUNTING_STATUS_CODE | VARCHAR2 | 32 | Invoice distribution accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_CANCELLED_FLAG | VARCHAR2 | 32 | Indicates a cancelled invoice. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | CODE | ||
DISTRIBUTION_CANCELLED_FLAG | VARCHAR2 | 16 | Indicates a cancelled distribution. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | CODE | ||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Invoice currency code. | ||||
TRANSACTION_AMOUNT | NUMBER | Distribution amount in invoice currency. | |||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | ||||
GLOBAL_CURRENCY_EXCH_RATE | BIGDECIMAL | 10 | Global currency conversion rate. | ||||
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_CODE_VALUES_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_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_VALIDATION_STATUS_CODE | VARCHAR | 32 | Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. | DW_CODE_VALUES_LKP_TL | 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_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_PAYMENT_METHOD_CODE | VARCHAR | 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 | ||
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 | ||||
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. | |||
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 | ||||
INVOICE_LINE_AMOUNT | NUMBER | Line amount in invoice currency | |||||
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. | ||||
XLA_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line. | ||||
XLA_LEDGER_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line. | ||||
XLA_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
XLA_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
XLA_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line. | ||||
XLA_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted credit for journal entry line. | ||||
XLA_GLOBAL_AMOUNT | BIGDECIMAL | 10 | Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line. | ||||
XLA_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded global debit amount for the journal line. | ||||
XLA_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded global credit amount for the journal line. | ||||
XLA_MANUAL_OVERRIDE_FLAG | VARCHAR2 | 32 | Indicates a manual override. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | 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 | ||
XLA_LINE_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | Line level unrounded entered debit amount for the journal line minus Line level unrounded entered credit amount for the journal line. | ||||
XLA_LINE_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded entered debit amount for the journal line. | ||||
XLA_LINE_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded entered credit amount for the journal line. | ||||
XLA_LINE_LEDGER_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. | ||||
XLA_LINE_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded accounted debit amount of the journal entry line. | ||||
XLA_LINE_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded accounted credit amount of the journal entry line. | ||||
XLA_LINE_GLOBAL_AMOUNT | BIGDECIMAL | 10 | Line level unrounded global debit amount for the journal line minus Line level unrounded global credit amount for the journal line. | ||||
XLA_LINE_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded global debit amount for the journal line. | ||||
XLA_LINE_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded global credit amount for the journal line. | ||||
XLA_LEDGER_ID | NUMBER | 38 | 0 | Self-contained accounting information set for single or multiple legal or management entities. | |||
XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | ||||
XLA_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Entered currency for the transaction data | ||||
XLA_ACCOUNTING_DATE | DATE | Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | |||||
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 | ||||
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 | |||
PARENT_LINE_NUMBER | NUMBER | Invoice line number. | |||||
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_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 | ||||
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. |
Copyright © 2019, 2023, Oracle and/or its affiliates.