1. Tables and Views for Financials
  2. AP_AWT_TEMP_DISTRIBUTIONS_ALL

AP_AWT_TEMP_DISTRIBUTIONS_ALL

AP_AWT_TEMP_DISTRIBUTIONS_ALL contains temporary withholding tax type invoice distributions for projected withholding tax or unconfirmed payment batches.

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Not-null Comments
INVOICE_ID NUMBER 18 Yes Unique invoice identifier that identifies an invoice against which withholding amount is calculated.
PAYMENT_NUM NUMBER 18 Number of payment document paying invoice.
GROUP_ID NUMBER 18 Yes Withholding Tax group unique identifier
TAX_NAME VARCHAR2 15 Yes Withholding tax name applied on a invoice.
TAX_CODE_COMBINATION_ID NUMBER 18 Yes Accounting Flexfield identifier for account to which withholding taxes are posted
GROSS_AMOUNT NUMBER Yes Amount on the invoice that is subjected to withholding.
WITHHOLDING_AMOUNT NUMBER Yes Amount of withholding tax applied on invoice.
BASE_WITHHOLDING_AMOUNT NUMBER Amount of withholding tax in the functional currency
ACCOUNTING_DATE DATE Yes Accounting date of a transaction.
PERIOD_NAME VARCHAR2 15 Yes Name of the period which is associated with the withholding tax.
CHECKRUN_NAME VARCHAR2 255 Identifies the payment batch name in which this distribution was created during automatic withholding. This column is only populated if automatic withholding of tax is performed during payment
TAX_RATE_ID NUMBER 18 Yes Unique identifier of withholding tax applied on invoice.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
INVOICE_PAYMENT_ID NUMBER 18 Payment number unique identifier
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.
AWT_RELATED_ID NUMBER 18 Identifier linking related distributions. Used for linking related Invoice Distribution. Populated from INVOICE_DISTRIBUTION_ID of the related distribution
CHECKRUN_ID NUMBER 18 Unique identifier of payment batch during which withholding amount is calculated.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SUMMARY_TAX_LINE_ID NUMBER 18 Attribute to link withholding distribution to withholding summary line in Payables and to link with withholding lines in Fusion Tax.
DETAIL_TAX_LINE_ID NUMBER 18 Withholding tax line identifier.

Foreign Keys

Table Foreign Table Foreign Key Column
AP_AWT_TEMP_DISTRIBUTIONS_ALL ap_invoices_all INVOICE_ID
AP_AWT_TEMP_DISTRIBUTIONS_ALL ap_awt_tax_rates_all TAX_RATE_ID
AP_AWT_TEMP_DISTRIBUTIONS_ALL ap_awt_groups GROUP_ID
AP_AWT_TEMP_DISTRIBUTIONS_ALL ap_invoice_payments_all INVOICE_PAYMENT_ID
AP_AWT_TEMP_DISTRIBUTIONS_ALL ap_inv_selection_criteria_all CHECKRUN_ID
AP_AWT_TEMP_DISTRIBUTIONS_ALL gl_code_combinations TAX_CODE_COMBINATION_ID
AP_AWT_TEMP_DISTRIBUTIONS_ALL ap_invoice_distributions_all AWT_RELATED_ID

Indexes

Index Uniqueness Tablespace Columns
AP_AWT_TEMP_DISTRIBUTIONS_N1 Non Unique Default INVOICE_ID, PAYMENT_NUM