AP_INVOICE_DISTRIBUTIONS_ALL_
AP_INVOICE_DISTRIBUTIONS_ALL contains the invoice distribution information that is manually entered or system-generated. AP_INVOICE_DISTRIBUTIONS_ALL_ is the audit table for AP_INVOICE_DISTRIBUTIONS_ALL.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
AP_INVOICE_DISTRIBUTIONS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_DISTRIBUTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
ACCOUNTING_DATE | DATE | Date when the invoice distribution is to be accounted. | ||||
ASSETS_ADDITION_FLAG | VARCHAR2 | 1 | Flag that indicates if distribution has been transferred into Oracle Assets (U, Y, or N) | |||
ASSETS_TRACKING_FLAG | VARCHAR2 | 1 | Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N | |||
DISTRIBUTION_LINE_NUMBER | NUMBER | 18 | Invoice line number associated with the invoice distribution. | |||
DIST_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for account associated with a distribution | |||
INVOICE_ID | NUMBER | 18 | Unique invoice distribution identifier. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Distribution type. Validated against AP_LOOKUP_CODES. Lookup type is INVOICE DISTRIBUTION TYPE | |||
PERIOD_NAME | VARCHAR2 | 15 | Period name for the invoice distribution. | |||
SET_OF_BOOKS_ID | NUMBER | 18 | Ledger identifier of the invoice distribution. | |||
AMOUNT | NUMBER | Amount on invoice distribution. | ||||
BASE_AMOUNT | NUMBER | Amount of invoice in functional currency, only used for foreign currency invoices | ||||
BATCH_ID | NUMBER | 18 | Unique invoice group identifier used for invoice distribution. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | |||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | ||||
DESCRIPTION | VARCHAR2 | 240 | Statement that describes the distribution. | |||
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 | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
MATCH_STATUS_FLAG | VARCHAR2 | 1 | Indicates whether the invoice distribution is generated for a purchase order matched line. | |||
POSTED_FLAG | VARCHAR2 | 1 | Flag that indicates if invoice distribution line has been accounted | |||
PO_DISTRIBUTION_ID | NUMBER | 18 | Purchase order distribution identifier for purchase order or receipt matched invoice distributions | |||
PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |||
PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |||
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 | ||||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
REVERSAL_FLAG | VARCHAR2 | 1 | Flag that indicates if distribution is part of a reversal pair | |||
TYPE_1099 | VARCHAR2 | 10 | Payments of type 1099 made to a supplier. A 1099 supplier may receive payments of more than one type. | |||
UNIT_PRICE | NUMBER | Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections | ||||
ENCUMBERED_FLAG | VARCHAR2 | 1 | Flag indicating encumbrance status of distribution | |||
STAT_AMOUNT | NUMBER | Amount associated with a distribution for measuring statistical quantities | ||||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
EXPENDITURE_ITEM_DATE | DATE | Date for project expenditure item used to build Accounting Flexfield for project-related distribution | ||||
EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | 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 | |||
PARENT_INVOICE_ID | NUMBER | 18 | 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 | Project item quantity used to build Accounting Flexfield for project-related distribution | ||||
PREPAY_AMOUNT_REMAINING | NUMBER | Amount of prepayment that can still be applied to an invoice | ||||
PROJECT_ID | NUMBER | 18 | Identifier for project used to build Accounting Flexfield for project-related distribution | |||
TASK_ID | NUMBER | 18 | Identifier for project task used to build Accounting Flexfield for project-related distribution | |||
AWT_FLAG | VARCHAR2 | 1 | Flag to determine if distribution is subject to withholding tax (Y, N, null) | |||
AWT_GROUP_ID | NUMBER | 18 | Withholding tax group identifier | |||
AWT_TAX_RATE_ID | NUMBER | 18 | Withholding tax rate identifier | |||
AWT_GROSS_AMOUNT | NUMBER | Amount subject to withholding tax | ||||
AWT_INVOICE_ID | NUMBER | 18 | Refers to the withholding tax invoice created from this distribution | |||
AWT_ORIGIN_GROUP_ID | NUMBER | 18 | 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 | 18 | Indicates the identifier of the business unit associated to the row. | |||
AWT_INVOICE_PAYMENT_ID | NUMBER | 18 | 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 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
RECEIPT_VERIFIED_FLAG | VARCHAR2 | 1 | Indicates whether receipts verified | |||
RECEIPT_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether receipts required | |||
RECEIPT_MISSING_FLAG | VARCHAR2 | 1 | Indicates whether receipts missing | |||
JUSTIFICATION | VARCHAR2 | 240 | Reason, fact, circumstance, or explanation that justifies or defends. | |||
EXPENSE_GROUP | VARCHAR2 | 80 | Expense group associated with the invoice distribution. | |||
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 | ||||
ADJUSTMENT_REASON | VARCHAR2 | 240 | Reason for adjustment on the invoice distribution. | |||
AWARD_ID | NUMBER | 18 | If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information | |||
CREDIT_CARD_TRX_ID | NUMBER | 18 | Credit card transaction identifier | |||
DIST_MATCH_TYPE | VARCHAR2 | 25 | Indicates whether an invoice matched a PO or a receipt of material. | |||
RCV_TRANSACTION_ID | NUMBER | 18 | Receipt identifier for receipt matched invoice distributions | |||
INVOICE_DISTRIBUTION_ID | NUMBER | 18 | Yes | Unique identifier for this table | ||
PARENT_REVERSAL_ID | NUMBER | 18 | 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 | |||
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 | Burdenable Raw Cost | ||||
ACCOUNTING_EVENT_ID | NUMBER | 18 | Accounting event identifier. Refers to the accounting event that accounted for the distribution | |||
PREPAY_DISTRIBUTION_ID | NUMBER | 18 | 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 t create accounting entries for Cash basis accounting | ||||
UPGRADE_BASE_POSTED_AMT | NUMBER | This column is only used during the upgrade t 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 | 18 | 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 | |||
INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2 | 1 | Indicates whether prepayment amount is included in the invoice amount. | |||
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 | 18 | 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 | 18 | 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 | 18 | 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 | 30 | 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 | 18 | 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 | |||
INTENDED_USE_CLASSIF_ID | NUMBER | 18 | Tax Driver: Intended use identifier | |||
DETAIL_TAX_DIST_ID | NUMBER | Cross reference to E-Business Tax repository. | ||||
REC_NREC_RATE | NUMBER | Indicates whether a tax rate is recoverable or nonrecoverable. | ||||
RECOVERY_RATE_ID | NUMBER | Recovery rate identifier. | ||||
RECOVERY_RATE_NAME | VARCHAR2 | 150 | Recovery rate name | |||
RECOVERY_TYPE_CODE | VARCHAR2 | 30 | Mechanism to administer the recovery process for a specific tax. | |||
RECOVERY_RATE_CODE | VARCHAR2 | 30 | Rate at which tax is recoverable for a line when you record recoverable tax. | |||
WITHHOLDING_TAX_CODE_ID | NUMBER | 18 | Unique code to identify withholding tax rates applicable to supplier invoices. | |||
TAX_ALREADY_DISTRIBUTED_FLAG | VARCHAR2 | 1 | Internal processing indicator for Oracle Fusion Payables, indicating whether tax was distributed. | |||
SUMMARY_TAX_LINE_ID | NUMBER | Cross reference to E-Business Tax repository. | ||||
TAXABLE_AMOUNT | NUMBER | Taxable amount for the distribution. This column is used during upgrade and is intended for internal use only. | ||||
TAXABLE_BASE_AMOUNT | NUMBER | Taxable amount in ledger currency for the distribution. This column is used during upgrade and is intended for internal use only. | ||||
EXTRA_PO_ERV | NUMBER | ERV value for receipt matched distributions, based on the receipt and PO conversion rates. Used to simplify encumbrance code. | ||||
PREPAY_TAX_DIFF_AMOUNT | NUMBER | Amount resulting from a tax rate o r recovery rate change between the Prepayment invoice date and the Standard invoice date. | ||||
TAX_CODE_ID | NUMBER | 18 | The tax code that was used on this distribution for the invoice date | |||
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. | ||||
OLD_DISTRIBUTION_ID | NUMBER | 18 | Distribution identifier from old table | |||
OLD_DIST_LINE_NUMBER | NUMBER | 18 | Old invoice distribution line number. | |||
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 created. | |||
AWT_RELATED_ID | NUMBER | 18 | 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 | 18 | 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 | 18 | 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 | 18 | 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 | 18 | 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 | 18 | Recurring invoice identifier. | |||
RELEASE_INV_DIST_DERIVED_FROM | NUMBER | 18 | Retainage release invoice distribution identifier used for subledger accounting business flows | |||
QUANTITY_VARIANCE | NUMBER | Quantity variance on the distribution. | ||||
BASE_QUANTITY_VARIANCE | NUMBER | Variance on quantity of the invoice distribution. | ||||
EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Source of currency conversion rate for invoice distribution. For example, user defined, spot, or corporate. | |||
EXCHANGE_RATE | NUMBER | Ratio at which the principal unit of one currency is converted into another currency for invoice distribution. | ||||
EXCHANGE_DATE | DATE | Date when a conversion rate is used to convert an amount into another currency for invoice distribution. | ||||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project related standardized code collection. | |||
PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions | |||
PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions. | |||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions. | |||
PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which a project related transaction is incurred. | ||||
PJC_ORGANIZATION_ID | NUMBER | 18 | Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions. | |||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project related item is available to be billed to customers. | |||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project related item is eligible for capitalization. | |||
PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project related classification of the worked performed. | |||
PJC_CONTRACT_ID | NUMBER | 18 | Contract Identified.Used when Oracle Contract Billing or Oracle Grants Accounting is installed. | |||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. Used when Oracle Contract Billing or Oracle Grants Accounting is installed. | |||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding override | |||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality | |||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user definable project information | |||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user definable project information | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
BUDGET_DATE | DATE | Budgetary Calendar Period Date applicable for funds check | ||||
FUNDS_STATUS | VARCHAR2 | 30 | Status of the funds for an invoice distribution. | |||
CONSUMPTION_ADVICE_HEADER_ID | NUMBER | 18 | Consumption advice header identifier for consumption advice matched distributions. | |||
CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Consumption advice line identifier for consumption advice matched distributions. | |||
DATA_SET_ID | NUMBER | Data set identifier for processing budgetary control funds reservation requests. | ||||
DETAIL_TAX_LINE_ID | NUMBER | 18 | Withholding tax line identifier. | |||
PRODUCT_TABLE | VARCHAR2 | 30 | Name of the product source table used for generating an invoice distribution. | Active | ||
REFERENCE_KEY1 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view. | Active | ||
REFERENCE_KEY2 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | ||
REFERENCE_KEY3 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | ||
REFERENCE_KEY4 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | ||
REFERENCE_KEY5 | VARCHAR2 | 150 | Primary key information that will uniquely identify a record in other products view | Active | ||
DEF_ACCTG_ACCRUAL_CCID | NUMBER | 18 | Accrual account that is initially debited for deferred expenses | |||
DEF_ACCTG_START_DATE | DATE | Deferred accounting start date | ||||
DEF_ACCTG_END_DATE | DATE | Deferred accounting end date | ||||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | |||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | |||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
AP_INVOICE_DISTRIBUTIONS_N1_ | Non Unique | Default | INVOICE_DISTRIBUTION_ID |
AP_INVOICE_DISTRIBUTIONS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_DISTRIBUTION_ID |