[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_INVOICE_DISTRIBUTIONS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_INVOICE_DISTRIBUTIONS_ALL
|
| Subobject Name: | |
| Status: | VALID |
AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. This table corresponds to the Invoice distributions window of Invoice workbench.
There is one row for each invoice distribution. A distribution must be associated with an invoice and invoice line. An invoice / invoice line can have multiple distributions. Examples of when your Oracle Payables application automatically creates rows in this table include the following:
� Distribution set is entered at the invoice header level or invoice lines level.
� Invoice line matched to a purchase order or receipt. The system uses the information from the matched purchase order or receipt to create the distributions
� Invoice matched to an credit or debit memo
� Allocation rules are defined for Tax, Freight & Misc lines
� Apply or Unapply prepayment on an invoice
� Payables automatically calculate withholding tax.
� Payables create an interest invoice.
When an invoice is accounted, the Accounting Process creates accounting events, accounting entry headers and accounting entry lines for those distributions that have accounting dates included in the selected accounting date range. The Transfer to General Ledger process can then transfer the accounting entries to General Ledger as journal entries.
Values for POSTED_FLAG are Y for accounted distributions or N for unaccounted distributions. Invoice distributions can be interfaced over/from Oracle Assets or Oracle Projects. Oracle Payables application sets the ASSETS_ADDITION_FLAG to U for distributions not tested by Oracle Assets; Oracle Assets then adjusts this flag after it tests a distribution for assignment as an asset.
To avoid the same invoice distribution being interfaced to Oracle Project and Oracle Assets, any project-related invoice distributions should be interfaced to Oracle projects first before interfacing to Oracle Assets. If a project-related invoice distribution is charged to a capital project in Oracle Projects, Oracle Projects sets the ASSETS_ADDITION_FLAG to P when the PA_ADDITION_FLAG is set to Y, Z, or T. Oracle Assets only picks up invoice distributions with the ASSET_ADDITION_FLAG set to U, and if project-related, with the PA_ADDITION_FLAG set to Y, Z, or T. PA_ADDITION_FLAG tracks the status of project-related supplier invoice distributions and expense report distributions.
For supplier invoice distributions entered via Oracle Payables, the PA_ADDITION_FLAG is set to N if the distribution is project-related, otherwise it is set to E, and it is updated by Oracle Projects when the distribution is processed by the Oracle Projects Interface Supplier Invoice process. Oracle Projects sets the PA_ADDITION_FLAG to Y or Z after the item is successfully processed, or may be set to a rejection code if the line is rejected during transfer to Oracle Projects.
All rejects can be found in Payables Lookup listing. Retransfer of the line can be done after correcting the rejection reason.
For supplier invoice adjustment distributions interfaced from Oracle Projects to Oracle Payables (which must net to zero with another distribution), the value for the PA_ADDITION_FLAG is set to T.
The accounting code combinations stored in this table is meta data for creating accounting entries in Subledger Accounting. Payables provides the code combinations stored in this table to Subledger Accounting as a source for accounting attributes for deriving the accounting code combinations. Subledger Accounting generates the final accounting entries that are posted to General Ledger. The accounting code combination used in the final accounting entries can be same as that stored in AP_INVOICE_DISTRIBUTIONS_ALL table or can
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_INVOICE_DISTRIBUTIONS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INVOICE_ID
INVOICE_LINE_NUMBER
DISTRIBUTION_LINE_NUMBER
|
| AP_INVOICE_DISTRIBUTIONS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
INVOICE_DISTRIBUTION_ID
|
| AP_INVOICE_DISTRIBUTIONS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
|
| AP_INVOICE_DISTRIBUTIONS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PA_ADDITION_FLAG
PROJECT_ID
REQUEST_ID
|
| AP_INVOICE_DISTRIBUTIONS_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AWT_INVOICE_PAYMENT_ID
|
| AP_INVOICE_DISTRIBUTIONS_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AWT_INVOICE_ID
|
| AP_INVOICE_DISTRIBUTIONS_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RCV_TRANSACTION_ID
|
| AP_INVOICE_DISTRIBUTIONS_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACCOUNTING_EVENT_ID
|
| AP_INVOICE_DISTRIBUTIONS_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_TRANSFER_STATUS
|
| AP_INVOICE_DISTRIBUTIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
POSTED_FLAG
ORG_ID
|
| AP_INVOICE_DISTRIBUTIONS_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PREPAY_DISTRIBUTION_ID
|
| AP_INVOICE_DISTRIBUTIONS_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AWARD_ID
|
| AP_INVOICE_DISTRIBUTIONS_N23 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RELATED_ID
|
| AP_INVOICE_DISTRIBUTIONS_N24 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CORRECTED_INVOICE_DIST_ID
|
| AP_INVOICE_DISTRIBUTIONS_N25 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_REVERSAL_ID
|
| AP_INVOICE_DISTRIBUTIONS_N26 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OLD_DISTRIBUTION_ID
|
| AP_INVOICE_DISTRIBUTIONS_N27 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVOICE_ID
OLD_DIST_LINE_NUMBER
|
| AP_INVOICE_DISTRIBUTIONS_N28 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CHARGE_APPLICABLE_TO_DIST_ID
|
| AP_INVOICE_DISTRIBUTIONS_N29 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DETAIL_TAX_DIST_ID
|
| AP_INVOICE_DISTRIBUTIONS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DIST_CODE_COMBINATION_ID
|
| AP_INVOICE_DISTRIBUTIONS_N30 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BC_EVENT_ID
|
| AP_INVOICE_DISTRIBUTIONS_N31 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSETS_ADDITION_FLAG
POSTED_FLAG
SET_OF_BOOKS_ID
ACCOUNTING_DATE
|
| AP_INVOICE_DISTRIBUTIONS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACCOUNTING_DATE
|
| AP_INVOICE_DISTRIBUTIONS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_ID
|
| AP_INVOICE_DISTRIBUTIONS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSETS_ADDITION_FLAG
ASSETS_TRACKING_FLAG
POSTED_FLAG
ORG_ID
|
| AP_INVOICE_DISTRIBUTIONS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_DISTRIBUTION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNTING_DATE | DATE | Yes | Accounting date | |
| ACCRUAL_POSTED_FLAG | VARCHAR2 | (1) | Accrual accounting status of the distribution. Values may be: Y if distribution has been accounted and system is set up for accrual basis accounting, or N if either the distribution has not been accounted or accrual basis accounting is not used. | |
| ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if distribution has been transferred into Oracle Assets (U, Y, or N) |
| ASSETS_TRACKING_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N |
| CASH_POSTED_FLAG | VARCHAR2 | (1) | Cash basis accounting status of the distribution. Values may be: Y if distribution has been accounted and the system is set up for cash basis accounting, N if either the distribution has not been accounted or system is not set up for cash basis accounting, or P if distribution has been partially accounted in the cash set of books | |
| DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | Distribution number for an invoice line. This is unique sequence per invoice line. |
| DIST_CODE_COMBINATION_ID | NUMBER | (15) | Yes | Accounting Flexfield identifier for account associated with a distribution. Foreign key from the GL_CODE_COMBINATIONS table. |
| INVOICE_ID | NUMBER | (15) | Yes | Unique internal identifier for the invoice line of the associated Invoice. Foreign key to the AP_INVOICES_ALL table. |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Distribution type. Validated against AP_LOOKUP_CODES. Lookup type is INVOICE DISTRIBUTION TYPE |
| PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting period name, foreign key from the GL_PERIODS table. |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Ledger unique identifer |
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| AMOUNT | NUMBER | Invoice distribution amount | ||
| BASE_AMOUNT | NUMBER | Distribution amount in functional currency. This column gets populated for the invoice entered in non-functional currency and this column corresponds to the 'Functional Amount' field of Invoice Distribution window. | ||
| BASE_INVOICE_PRICE_VARIANCE | NUMBER | No longer used | ||
| BATCH_ID | NUMBER | (15) | Invoice Batch Identifier. This column will be populated if Invoices are entered in batches. Foreign key to the AP_BATCHES_ALL table. | |
| CREATED_BY | NUMBER | (15) | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| DESCRIPTION | VARCHAR2 | (240) | Distribution line description | |
| EXCHANGE_RATE_VARIANCE | NUMBER | No longer used | ||
| FINAL_MATCH_FLAG | VARCHAR2 | (1) | Final match indicator for distribution matched to a purchase order | |
| INCOME_TAX_REGION | VARCHAR2 | (10) | Reporting region for distribution for 1099 supplier | |
| INVOICE_PRICE_VARIANCE | NUMBER | No longer used | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table. | |
| MATCH_STATUS_FLAG | VARCHAR2 | (1) | Validation status for the distribution. This flag is used to derive Invoice Status. Possible values for this flag:� Null or N for invoice distributions that are not tested and validated, T for distributions that have been tested, A for distributions that have been tested and validated, S for distributions that have been selected for validation | |
| POSTED_FLAG | VARCHAR2 | (1) | Flag that indicates if invoice distribution line has been accounted. Valid values are 'Y' or 'N'. | |
| PO_DISTRIBUTION_ID | NUMBER | (15) | Purchase order distribution identifier for purchase order or receipt matched invoice distributions. Foreign key to the PO_DISTRIBUTIONS_ALL table. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Enhanced Who column Concurrent Program who column - application id of the program that last updated this row. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table. | |
| PROGRAM_ID | NUMBER | (15) | Enhanced Who column Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table. | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row. | ||
| QUANTITY_INVOICED | NUMBER | Quantity billed for purchase order or receipt matched invoice distributions | ||
| RATE_VAR_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| REQUEST_ID | NUMBER | (15) | Enhanced Who column Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table. | |
| REVERSAL_FLAG | VARCHAR2 | (1) | Flag that indicates if distribution is part of a reversal pair | |
| TYPE_1099 | VARCHAR2 | (10) | Income tax type, for 1099 reporting purposes. This column corresponds to 'Income Tax Type' field in Invoice Distributions window. | |
| UNIT_PRICE | NUMBER | Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections | ||
| AMOUNT_ENCUMBERED | NUMBER | No longer used | ||
| BASE_AMOUNT_ENCUMBERED | NUMBER | No longer used | ||
| ENCUMBERED_FLAG | VARCHAR2 | (1) | Flag indicating encumbrance status of distribution | |
| EXCHANGE_DATE | DATE | No longer used | ||
| EXCHANGE_RATE | NUMBER | No longer used | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | No longer used | |
| PRICE_ADJUSTMENT_FLAG | VARCHAR2 | (1) | No longer used | |
| PRICE_VAR_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| QUANTITY_UNENCUMBERED | NUMBER | No longer used | ||
| STAT_AMOUNT | NUMBER | Amount associated with a distribution for measuring statistical quantities | ||
| AMOUNT_TO_POST | NUMBER | No longer used | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| BASE_AMOUNT_TO_POST | NUMBER | No longer used | ||
| CASH_JE_BATCH_ID | NUMBER | (15) | No longer used | |
| EXPENDITURE_ITEM_DATE | DATE | Date for project expenditure item used to build Accounting Flexfield for project-related distribution | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Identifier for project organization used to build Accounting Flexfield for project-related distribution | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Project expenditure type used to build Accounting Flexfield for project-related distribution | |
| JE_BATCH_ID | NUMBER | (15) | No longer used | |
| PARENT_INVOICE_ID | NUMBER | (15) | Identifier for invoice matched to a credit or debit memo | |
| PA_ADDITION_FLAG | VARCHAR2 | (1) | Flag that indicates if project related invoice distributions have been transferred into Oracle Projects | |
| PA_QUANTITY | NUMBER | (22) | Project item quantity used to build Accounting Flexfield for project-related distribution | |
| POSTED_AMOUNT | NUMBER | No longer used | ||
| POSTED_BASE_AMOUNT | NUMBER | No longer used | ||
| PREPAY_AMOUNT_REMAINING | NUMBER | Amount of prepayment that can still be applied to an invoice | ||
| PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | No longer used | |
| PROJECT_ID | NUMBER | (15) | Identifier for project used to build Accounting Flexfield for project-related distribution | |
| TASK_ID | NUMBER | (15) | Identifier for project task used to build Accounting Flexfield for project-related distribution | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | No longer used | |
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | No longer used | |
| EARLIEST_SETTLEMENT_DATE | DATE | No longer used | ||
| REQ_DISTRIBUTION_ID | NUMBER | (15) | No longer used | |
| QUANTITY_VARIANCE | NUMBER | No longer used | ||
| BASE_QUANTITY_VARIANCE | NUMBER | No longer used | ||
| PACKET_ID | NUMBER | (15) | Budgetary control packet identifier for distributions that fail funds checking | |
| AWT_FLAG | VARCHAR2 | (1) | Flag to determine if distribution is subject to withholding tax (Y, N, null) | |
| AWT_GROUP_ID | NUMBER | (15) | Withholding Tax group identifier at Invoice Validation. This column corresponds to 'Invoice Withholding Tax Group' | |
| AWT_TAX_RATE_ID | NUMBER | (15) | Withholding tax rate identifier | |
| AWT_GROSS_AMOUNT | NUMBER | Amount subject to withholding tax | ||
| AWT_INVOICE_ID | NUMBER | (15) | Refers to the withholding tax invoice created from this distribution | |
| AWT_ORIGIN_GROUP_ID | NUMBER | (15) | Foreign key to AP_AWT_GROUPS; refers to the parent withholding tax group; this column is only populated for automatically created withholding tax distributions | |
| REFERENCE_1 | VARCHAR2 | (30) | Reference information from Oracle Projects expense reports or other external source invoice loading program | |
| REFERENCE_2 | VARCHAR2 | (30) | Reference information from Oracle Projects expense reports or other external source invoice loading program | |
| ORG_ID | NUMBER | (15) | Unique internal identifier of the Operating Unit to which the invoice belongs. | |
| OTHER_INVOICE_ID | NUMBER | (15) | No longer used | |
| AWT_INVOICE_PAYMENT_ID | NUMBER | (15) | Refers to the parent invoice payment. This column is populated only for automatically created withholding tax distributions at payment time | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| LINE_GROUP_NUMBER | NUMBER | (15) | No longer used | |
| RECEIPT_VERIFIED_FLAG | VARCHAR2 | (1) | Indicates whether payables department verified the receipt for the expense line. Used for expense reports. | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether payables department requires that a receipt be sent to them for the expense line. Used for expense reports. | |
| RECEIPT_MISSING_FLAG | VARCHAR2 | (1) | Indicates whether the employee does not possess a receipt for an expense line. Used for expense reports. | |
| JUSTIFICATION | VARCHAR2 | (240) | Expense justification given while submitting expense report. | |
| EXPENSE_GROUP | VARCHAR2 | (80) | Expense group: User-defined label used to identify a group of expense lines contained on a single receipt, for example, a hotel bill. | |
| START_EXPENSE_DATE | DATE | Date when incurred expense started. Used for Expense Reports | ||
| END_EXPENSE_DATE | DATE | Date when incurred expense ended. Used for Expense Reports | ||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of receipt. Used for Expense Reports | |
| RECEIPT_CONVERSION_RATE | NUMBER | Exchange rate for currency of receipt. Used for Expense Reports | ||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | Amount in receipt currency. Used for Expense Reports | ||
| DAILY_AMOUNT | NUMBER | Daily expense amount. Used for Expense Reports | ||
| WEB_PARAMETER_ID | NUMBER | Self-Service Web Applications parameter identifier. Used by self service applications like iExpenses. | ||
| ADJUSTMENT_REASON | VARCHAR2 | (240) | Reason for expense adjustment | |
| AWARD_ID | NUMBER | (15) | If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information | |
| MRC_ACCRUAL_POSTED_FLAG | VARCHAR2 | (2000) | ||
| MRC_CASH_POSTED_FLAG | VARCHAR2 | (2000) | ||
| MRC_DIST_CODE_COMBINATION_ID | VARCHAR2 | (2000) | No longer used | |
| MRC_AMOUNT | VARCHAR2 | (2000) | ||
| MRC_BASE_AMOUNT | VARCHAR2 | (2000) | No longer used | |
| MRC_BASE_INV_PRICE_VARIANCE | VARCHAR2 | (2000) | No longer used | |
| MRC_EXCHANGE_RATE_VARIANCE | VARCHAR2 | (2000) | No longer used | |
| MRC_POSTED_FLAG | VARCHAR2 | (2000) | ||
| MRC_PROGRAM_APPLICATION_ID | VARCHAR2 | (2000) | ||
| MRC_PROGRAM_ID | VARCHAR2 | (2000) | ||
| MRC_PROGRAM_UPDATE_DATE | VARCHAR2 | (2000) | ||
| MRC_RATE_VAR_CCID | VARCHAR2 | (2000) | No longer used | |
| MRC_REQUEST_ID | VARCHAR2 | (2000) | ||
| MRC_EXCHANGE_DATE | VARCHAR2 | (2000) | No longer used | |
| MRC_EXCHANGE_RATE | VARCHAR2 | (2000) | No longer used | |
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | (2000) | No longer used | |
| MRC_AMOUNT_TO_POST | VARCHAR2 | (2000) | ||
| MRC_BASE_AMOUNT_TO_POST | VARCHAR2 | (2000) | ||
| MRC_CASH_JE_BATCH_ID | VARCHAR2 | (2000) | ||
| MRC_JE_BATCH_ID | VARCHAR2 | (2000) | ||
| MRC_POSTED_AMOUNT | VARCHAR2 | (2000) | ||
| MRC_POSTED_BASE_AMOUNT | VARCHAR2 | (2000) | ||
| MRC_RECEIPT_CONVERSION_RATE | VARCHAR2 | (2000) | No longer used | |
| CREDIT_CARD_TRX_ID | NUMBER | (15) | Identifies the credit card transaction from which the expense line is derived. This column is populated when credit card transactions for expense reports entered in Oracle Internet Expenses are exported. | |
| DIST_MATCH_TYPE | VARCHAR2 | (25) | Flag that indicates type of distribution match. Validated against AP_LOOKUP_CODES with lookup type as MATCH_STATUS | |
| RCV_TRANSACTION_ID | NUMBER | (15) | Receipt identifier for receipt matched to invoice distributions. Foreign key to the RCV_TRANSACTIONS. | |
| INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | Unique internal Identifier of the invoice distribution record. Generated using a database sequence. |
| PARENT_REVERSAL_ID | NUMBER | (15) | Invoice distribution identifier for distribution being reversed by the current distribution | |
| TAX_RECOVERABLE_FLAG | VARCHAR2 | (1) | Indicates whether this tax line is recoverable or not. Used for tax lines | |
| PA_CC_AR_INVOICE_ID | NUMBER | (15) | No longer used | |
| PA_CC_AR_INVOICE_LINE_NUM | NUMBER | (15) | No longer used | |
| PA_CC_PROCESSED_CODE | VARCHAR2 | (1) | No longer used | |
| MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | (80) | Third party document number. Used for Expense Reports | |
| MERCHANT_NAME | VARCHAR2 | (80) | Third party name. Used for Expense Reports | |
| MERCHANT_REFERENCE | VARCHAR2 | (240) | Third party reference. Used for Expense Reports | |
| MERCHANT_TAX_REG_NUMBER | VARCHAR2 | (80) | Third party tax registration number. Used for Expense Reports | |
| MERCHANT_TAXPAYER_ID | VARCHAR2 | (80) | Third party tax identification number. Used for Expense Reports | |
| COUNTRY_OF_SUPPLY | VARCHAR2 | (5) | Country where services or goods were originated. Used for Expense Reports | |
| MATCHED_UOM_LOOKUP_CODE | VARCHAR2 | (25) | UOM used for the quantity invoiced during matching of this distributions | |
| GMS_BURDENABLE_RAW_COST | NUMBER | (22) | Burdenable Raw Cost | |
| ACCOUNTING_EVENT_ID | NUMBER | (15) | Accounting event identifier. Refers to the accounting event that accounted for the distribution. Foreign key to the XLA_EVENTS table. | |
| PREPAY_DISTRIBUTION_ID | NUMBER | (15) | Invoice distribution identifier for the distribution on the prepayment that originated the prepayment application represented by the current distribution | |
| UPGRADE_POSTED_AMT | NUMBER | This column is only used during the upgrade to create accounting entries for Cash basis accounting. | ||
| UPGRADE_BASE_POSTED_AMT | NUMBER | This column is only used during the upgrade to create accounting entries for Cash basis accounting. | ||
| INVENTORY_TRANSFER_STATUS | VARCHAR2 | (1) | Inventory transfer status indicates whether the invoice distribution has been processed by the transfer invoice variance program. A value of 'N' indicates that the distribution has not been transferred. A value of NULL indicates that either the distribution was transferred or is not eligible for transfer to inventory valuation. The default value of this column at the time of distribution creation is 'N' | |
| COMPANY_PREPAID_INVOICE_ID | NUMBER | (15) | Invoice ID when this line is an prepaid credit card transaction | |
| CC_REVERSAL_FLAG | VARCHAR2 | (1) | Invoice ID when this line is an prepaid credit card transaction | |
| AWT_WITHHELD_AMT | NUMBER | No Longer Used | ||
| INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2 | (1) | No longer used | |
| PRICE_CORRECT_INV_ID | NUMBER | (15) | No longer used | |
| PRICE_CORRECT_QTY | NUMBER | No longer used | ||
| PA_CMT_XFACE_FLAG | VARCHAR2 | (1) | Flag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost. | |
| CANCELLATION_FLAG | VARCHAR2 | (1) | A value of Y indicates that the distribution line has been created during the Invoice Cancel. | |
| INVOICE_LINE_NUMBER | NUMBER | Invoice line number for parent line | ||
| CORRECTED_INVOICE_DIST_ID | NUMBER | (15) | Invoice distribution identifier for invoice distribution corrected via current distribution. For price, quantity, or invoice line corrections | |
| ROUNDING_AMT | NUMBER | Amount corresponding to rounding included in BASE_AMOUNT if any | ||
| CHARGE_APPLICABLE_TO_DIST_ID | NUMBER | (15) | Invoice distribution to which 100% of current charge is applied | |
| CORRECTED_QUANTITY | NUMBER | Quantity corrected via price, quantity, or invoice line correction. Column populated for correcting distribution | ||
| RELATED_ID | NUMBER | (15) | Identifier linking related distributions. Used for linking related IPV, ERV, ITEM, or ACCRUAL. Populated from INVOICE_DISTRIBUTION_ID of ITEM or ACCRUAL distribution if any, IPV if no ITEM or ACCRUAL or ERV otherwise | |
| ASSET_BOOK_TYPE_CODE | VARCHAR2 | (15) | Asset Book. Defaults from invoice line for newly created distributions or distributions that have changed ASSETS_TRACKING_FLAG from N to Y | |
| ASSET_CATEGORY_ID | NUMBER | (15) | Asset Category. Defaults from invoice line for newly created distributions or distributions that have changed ASSETS_TRACKING_FLAG from N to Y | |
| DISTRIBUTION_CLASS | VARCHAR2 | (30) | Flag that indicates whether this distribution is permanent or built in candidate mode for display to the user. Validated against AP_LOOKUP_CODES with lookup type as DISTRIBUTION CLASS | |
| FINAL_PAYMENT_ROUNDING | NUMBER | Rounding amount to relieve the invoice liability completely for foreign currency invoices paid with more than one prepayment application or payment. This is calculated when the invoice becomes fully paid by a prepayment application. This amount is added to the largest PREPAY distribution on the invoice | ||
| FINAL_APPLICATION_ROUNDING | NUMBER | Rounding amount to relieve the prepaid expense completely. This is calculated during final application of a prepayment, and is added to the PREPAY distribution on the invoice that the prepayment is applied to that has the same account as the prepayment distribution with an outstanding balance to relieve | ||
| AMOUNT_AT_PREPAY_XRATE | NUMBER | Invoice distribution amount in functional currency at prepayment invoice exchange rate. Populated for PREPAY type distributions on foreign currency invoices | ||
| CASH_BASIS_FINAL_APP_ROUNDING | NUMBER | Rounding amount to relieve the prepaid expense completely when the accounting method used is cash basis. This is calculated during final application of a foreign currency prepayment, and is added to the PREPAY distribution on the invoice that the prepayment is applied to that has the same account as the prepayment distribution that has an outstanding balance to relieve | ||
| AMOUNT_AT_PREPAY_PAY_XRATE | NUMBER | Invoice distribution amount in functional currency at prepayment payment exchange rate. Populated for PREPAY type distributions on foreign currency invoices | ||
| INTENDED_USE | VARCHAR2 | (30) | Tax Driver: Intended use of product Identifies the intended use of an Inventory item or non-Inventory based product fiscal classification, when the intended use is a factor either in tax determination or tax recovery. | |
| DETAIL_TAX_DIST_ID | NUMBER | Unique internal identifier for detail tax line of E-Business Tax repository. This identifier is used to fetch the tax distribution information for an invoice line from Tax repository and displayed if 'Tax Distribution' button is pressed. Foreign key to the REC_NREC_TAX_DIST_ID column of the ZX_REC_NREC_DIST table. | ||
| REC_NREC_RATE | NUMBER | Recovery / Non-recovery rate | ||
| RECOVERY_RATE_ID | NUMBER | Recovery rate identifier. | ||
| RECOVERY_RATE_NAME | VARCHAR2 | (150) | Recovery rate name | |
| RECOVERY_TYPE_CODE | VARCHAR2 | (30) | Recovery type code | |
| RECOVERY_RATE_CODE | VARCHAR2 | (30) | ||
| WITHHOLDING_TAX_CODE_ID | NUMBER | (15) | Withholding tax code unique ideintifier populated for the tax distributions generated by EBTax. | |
| TAX_ALREADY_DISTRIBUTED_FLAG | VARCHAR2 | (1) | Internal processing flag for Payables, indicating whether tax has already been distributed. | |
| SUMMARY_TAX_LINE_ID | NUMBER | Unique internal identifier for summary tax line of E-Business Tax repository. This identifier is used to fetch the summary tax line information for an invoice line from Tax repository and displayed if 'Tax Details' button is pressed. Foreign key to the SUMMARY_TAX_LINE_ID column of the ZX_LINES_SUMMARY table. | ||
| TAXABLE_AMOUNT | NUMBER | The taxable amount for the distribution. This column used during upgrade and intended for internal use only. | ||
| TAXABLE_BASE_AMOUNT | NUMBER | The taxable amount in functional currency for the distribution. This column used during upgrade and intended for internal use only. | ||
| EXTRA_PO_ERV | NUMBER | ERV value for receipt matched distributions, based on the receipt and PO exchange rates. Used to simplify encumbrace code. | ||
| PREPAY_TAX_DIFF_AMOUNT | NUMBER | Amount resulting from a tax rate or recovery rate change between the Prepayment invoice date and the Standard invoice date. | ||
| TAX_CODE_ID | NUMBER | (15) | The tax code that was used on this distribution for the invoice date. This column used during upgrade and intended for internal use only. | |
| VAT_CODE | VARCHAR2 | (15) | No longer used | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_CALCULATED_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_RECOVERY_RATE | NUMBER | No longer used | ||
| TAX_RECOVERY_OVERRIDE_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_CODE_OVERRIDE_FLAG | VARCHAR2 | (1) | No Longer Used | |
| TOTAL_DIST_AMOUNT | NUMBER | Sum Total of Amounts related to this distribution including variance amounts from related Invoice distributions. | ||
| TOTAL_DIST_BASE_AMOUNT | NUMBER | Sum Total of Amounts related to this distribution including variance amounts from related Invoice distributions in Base Currency. | ||
| PREPAY_TAX_PARENT_ID | NUMBER | (15) | No longer used | |
| CANCELLED_FLAG | VARCHAR2 | (1) | ||
| OLD_DISTRIBUTION_ID | NUMBER | (15) | This column indicates 11i distribution id for the upgraded invoices. | |
| OLD_DIST_LINE_NUMBER | NUMBER | (15) | This column indicates 11i distribution line number for the upgraded invoices. | |
| AMOUNT_VARIANCE | NUMBER | Amount variance in entered currency for invoice distributions matched to service shipment or receipt | ||
| BASE_AMOUNT_VARIANCE | NUMBER | Amount variance in functional currency for invoice distributions matched to service shipment or receipt | ||
| HISTORICAL_FLAG | VARCHAR2 | (1) | Flag to represents whether the document / invoice has been upgraded from a prior release or whether it has been newly created. | |
| RCV_CHARGE_ADDITION_FLAG | VARCHAR2 | (1) | Indicates if a distribution has been transferred to Oracle Procurement. | |
| AWT_RELATED_ID | NUMBER | (15) | Identifier linking related distributions. Used for linking related Invoice Distribution for this Withholding Distribution. Populated from INVOICE_DISTRIBUTION_ID of the related distribution. | |
| RELATED_RETAINAGE_DIST_ID | NUMBER | (15) | Related Retainage Invoice Distribution Identifier | |
| RETAINED_AMOUNT_REMAINING | NUMBER | Retained amount available for release | ||
| BC_EVENT_ID | NUMBER | Identifier of Accounting Event raised for Encumbrance accounting | ||
| RETAINED_INVOICE_DIST_ID | NUMBER | (15) | Retained Invoice Distribution Identifier. | |
| FINAL_RELEASE_ROUNDING | NUMBER | Rounding amount due to final release of an invoice with retainage | ||
| FULLY_PAID_ACCTD_FLAG | VARCHAR2 | (1) | This column is used internally by Payables accounting engine and populated only for Federal customers. A value of Y represents fully paid and accounted invoice or NULL. | |
| ROOT_DISTRIBUTION_ID | NUMBER | (15) | Identifier of the original distribution that has been price adjusted retroactively. This column is populated on PO Price Adjustment and Adjustment documents. | |
| XINV_PARENT_REVERSAL_ID | NUMBER | (15) | Cross-invoice parent reversal identifier of the distribution that has been reversed. This column is populated on a distribution that negates a distribution on a different invoice. | |
| RECURRING_PAYMENT_ID | NUMBER | (15) | Recurring invoice identifier | |
| RELEASE_INV_DIST_DERIVED_FROM | NUMBER | (15) | Retainage release invoice distribution identifier used for subledger accounting business flows | |
| PAY_AWT_GROUP_ID | NUMBER | (15) | Withholding Tax group identifier at Payment time. This column correspods to 'Payment Withholding Tax Group'. |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG
, ASSETS_ADDITION_FLAG
, ASSETS_TRACKING_FLAG
, CASH_POSTED_FLAG
, DISTRIBUTION_LINE_NUMBER
, DIST_CODE_COMBINATION_ID
, INVOICE_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LINE_TYPE_LOOKUP_CODE
, PERIOD_NAME
, SET_OF_BOOKS_ID
, ACCTS_PAY_CODE_COMBINATION_ID
, AMOUNT
, BASE_AMOUNT
, BASE_INVOICE_PRICE_VARIANCE
, BATCH_ID
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, EXCHANGE_RATE_VARIANCE
, FINAL_MATCH_FLAG
, INCOME_TAX_REGION
, INVOICE_PRICE_VARIANCE
, LAST_UPDATE_LOGIN
, MATCH_STATUS_FLAG
, POSTED_FLAG
, PO_DISTRIBUTION_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUANTITY_INVOICED
, RATE_VAR_CODE_COMBINATION_ID
, REQUEST_ID
, REVERSAL_FLAG
, TYPE_1099
, UNIT_PRICE
, AMOUNT_ENCUMBERED
, BASE_AMOUNT_ENCUMBERED
, ENCUMBERED_FLAG
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, PRICE_ADJUSTMENT_FLAG
, PRICE_VAR_CODE_COMBINATION_ID
, QUANTITY_UNENCUMBERED
, STAT_AMOUNT
, AMOUNT_TO_POST
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, BASE_AMOUNT_TO_POST
, CASH_JE_BATCH_ID
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, JE_BATCH_ID
, PARENT_INVOICE_ID
, PA_ADDITION_FLAG
, PA_QUANTITY
, POSTED_AMOUNT
, POSTED_BASE_AMOUNT
, PREPAY_AMOUNT_REMAINING
, PROJECT_ACCOUNTING_CONTEXT
, PROJECT_ID
, TASK_ID
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, EARLIEST_SETTLEMENT_DATE
, REQ_DISTRIBUTION_ID
, QUANTITY_VARIANCE
, BASE_QUANTITY_VARIANCE
, PACKET_ID
, AWT_FLAG
, AWT_GROUP_ID
, AWT_TAX_RATE_ID
, AWT_GROSS_AMOUNT
, AWT_INVOICE_ID
, AWT_ORIGIN_GROUP_ID
, REFERENCE_1
, REFERENCE_2
, ORG_ID
, OTHER_INVOICE_ID
, AWT_INVOICE_PAYMENT_ID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, LINE_GROUP_NUMBER
, RECEIPT_VERIFIED_FLAG
, RECEIPT_REQUIRED_FLAG
, RECEIPT_MISSING_FLAG
, JUSTIFICATION
, EXPENSE_GROUP
, START_EXPENSE_DATE
, END_EXPENSE_DATE
, RECEIPT_CURRENCY_CODE
, RECEIPT_CONVERSION_RATE
, RECEIPT_CURRENCY_AMOUNT
, DAILY_AMOUNT
, WEB_PARAMETER_ID
, ADJUSTMENT_REASON
, AWARD_ID
, MRC_ACCRUAL_POSTED_FLAG
, MRC_CASH_POSTED_FLAG
, MRC_DIST_CODE_COMBINATION_ID
, MRC_AMOUNT
, MRC_BASE_AMOUNT
, MRC_BASE_INV_PRICE_VARIANCE
, MRC_EXCHANGE_RATE_VARIANCE
, MRC_POSTED_FLAG
, MRC_PROGRAM_APPLICATION_ID
, MRC_PROGRAM_ID
, MRC_PROGRAM_UPDATE_DATE
, MRC_RATE_VAR_CCID
, MRC_REQUEST_ID
, MRC_EXCHANGE_DATE
, MRC_EXCHANGE_RATE
, MRC_EXCHANGE_RATE_TYPE
, MRC_AMOUNT_TO_POST
, MRC_BASE_AMOUNT_TO_POST
, MRC_CASH_JE_BATCH_ID
, MRC_JE_BATCH_ID
, MRC_POSTED_AMOUNT
, MRC_POSTED_BASE_AMOUNT
, MRC_RECEIPT_CONVERSION_RATE
, CREDIT_CARD_TRX_ID
, DIST_MATCH_TYPE
, RCV_TRANSACTION_ID
, INVOICE_DISTRIBUTION_ID
, PARENT_REVERSAL_ID
, TAX_RECOVERABLE_FLAG
, PA_CC_AR_INVOICE_ID
, PA_CC_AR_INVOICE_LINE_NUM
, PA_CC_PROCESSED_CODE
, MERCHANT_DOCUMENT_NUMBER
, MERCHANT_NAME
, MERCHANT_REFERENCE
, MERCHANT_TAX_REG_NUMBER
, MERCHANT_TAXPAYER_ID
, COUNTRY_OF_SUPPLY
, MATCHED_UOM_LOOKUP_CODE
, GMS_BURDENABLE_RAW_COST
, ACCOUNTING_EVENT_ID
, PREPAY_DISTRIBUTION_ID
, UPGRADE_POSTED_AMT
, UPGRADE_BASE_POSTED_AMT
, INVENTORY_TRANSFER_STATUS
, COMPANY_PREPAID_INVOICE_ID
, CC_REVERSAL_FLAG
, AWT_WITHHELD_AMT
, INVOICE_INCLUDES_PREPAY_FLAG
, PRICE_CORRECT_INV_ID
, PRICE_CORRECT_QTY
, PA_CMT_XFACE_FLAG
, CANCELLATION_FLAG
, INVOICE_LINE_NUMBER
, CORRECTED_INVOICE_DIST_ID
, ROUNDING_AMT
, CHARGE_APPLICABLE_TO_DIST_ID
, CORRECTED_QUANTITY
, RELATED_ID
, ASSET_BOOK_TYPE_CODE
, ASSET_CATEGORY_ID
, DISTRIBUTION_CLASS
, FINAL_PAYMENT_ROUNDING
, FINAL_APPLICATION_ROUNDING
, AMOUNT_AT_PREPAY_XRATE
, CASH_BASIS_FINAL_APP_ROUNDING
, AMOUNT_AT_PREPAY_PAY_XRATE
, INTENDED_USE
, DETAIL_TAX_DIST_ID
, REC_NREC_RATE
, RECOVERY_RATE_ID
, RECOVERY_RATE_NAME
, RECOVERY_TYPE_CODE
, RECOVERY_RATE_CODE
, WITHHOLDING_TAX_CODE_ID
, TAX_ALREADY_DISTRIBUTED_FLAG
, SUMMARY_TAX_LINE_ID
, TAXABLE_AMOUNT
, TAXABLE_BASE_AMOUNT
, EXTRA_PO_ERV
, PREPAY_TAX_DIFF_AMOUNT
, TAX_CODE_ID
, VAT_CODE
, AMOUNT_INCLUDES_TAX_FLAG
, TAX_CALCULATED_FLAG
, TAX_RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG
, TAX_CODE_OVERRIDE_FLAG
, TOTAL_DIST_AMOUNT
, TOTAL_DIST_BASE_AMOUNT
, PREPAY_TAX_PARENT_ID
, CANCELLED_FLAG
, OLD_DISTRIBUTION_ID
, OLD_DIST_LINE_NUMBER
, AMOUNT_VARIANCE
, BASE_AMOUNT_VARIANCE
, HISTORICAL_FLAG
, RCV_CHARGE_ADDITION_FLAG
, AWT_RELATED_ID
, RELATED_RETAINAGE_DIST_ID
, RETAINED_AMOUNT_REMAINING
, BC_EVENT_ID
, RETAINED_INVOICE_DIST_ID
, FINAL_RELEASE_ROUNDING
, FULLY_PAID_ACCTD_FLAG
, ROOT_DISTRIBUTION_ID
, XINV_PARENT_REVERSAL_ID
, RECURRING_PAYMENT_ID
, RELEASE_INV_DIST_DERIVED_FROM
, PAY_AWT_GROUP_ID
FROM AP.AP_INVOICE_DISTRIBUTIONS_ALL;
AP.AP_INVOICE_DISTRIBUTIONS_ALL does not reference any database object
AP.AP_INVOICE_DISTRIBUTIONS_ALL is referenced by following:
APPS
AP_INVOICE_DISTRIBUTIONS
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INV_DISTS_TARGET
IGI_AP_INVOICE_DIST_EXP_T1
IGI_AP_INVOICE_DIST_T1
IGI_AP_INVOICE_DIST_T2
IGI_AP_INVOICE_DIST_T3
JAI_AP_IDA_ARIUD_T1
JAI_AP_IDA_BRIUD_T1
|
|
|
|