1. Tables and Views for Financials
  2. AP_SELF_ASSESSED_TAX_DIST_ALL

AP_SELF_ASSESSED_TAX_DIST_ALL

AP_SELF_ASSESSED_TAX_DIST contains self assessed tax distributions

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

AP_SELF_ASSESSED_TAX_DIST_PK

INVOICE_DISTRIBUTION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INVOICE_DISTRIBUTION_ID NUMBER 18 Yes Unique identifier for this table Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
ACCOUNTING_DATE DATE Yes Accounting date on self assessed tax distribution. Active
ACCRUAL_POSTED_FLAG VARCHAR2 1 Flag that indicates if distribution has been accounted for in the accrual set of books (Y or N) Active
ASSETS_ADDITION_FLAG VARCHAR2 1 Yes Flag that indicates if distribution has been transferred into Oracle Assets (U, Y, or N) Active
ASSETS_TRACKING_FLAG VARCHAR2 1 Yes Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N Active
CASH_POSTED_FLAG VARCHAR2 1 Flag that indicates if distribution has been accounted for in the cash set of books (Y or N) Active
DISTRIBUTION_LINE_NUMBER NUMBER 18 Yes Distribution number on self assessed tax distribution. Active
DIST_CODE_COMBINATION_ID NUMBER 18 Yes Accounting flexfield identifier for account associated with a distribution Active
INVOICE_ID NUMBER 18 Yes Identifier of invoice on the self assessed tax distribution. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LINE_TYPE_LOOKUP_CODE VARCHAR2 25 Yes Distribution type. Validated against AP_LOOKUP_CODES. Lookup type is INVOICE DISTRIBUTION TYPE Active
PERIOD_NAME VARCHAR2 15 Yes Name of the accounting period on the self assessed tax distribution. Active
SET_OF_BOOKS_ID NUMBER 18 Yes Ledger identifier on the self assessed tax distribution. Active
SELF_ASSESSED_FLAG VARCHAR2 1 Yes Flag to indicate if the tax distributions is self assessed Active
AMOUNT NUMBER Amount on self assessed tax distribution. Active
BASE_AMOUNT NUMBER Amount of invoice in functional currency, only used for foreign currency invoices Active
BATCH_ID NUMBER 18 Batch identifier on self assessed tax distribution. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
DESCRIPTION VARCHAR2 240 Description of the self assessed tax distribution. Active
FINAL_MATCH_FLAG VARCHAR2 1 Final match indicator for distribution matched to a purchase order Active
INCOME_TAX_REGION VARCHAR2 10 Reporting region for distribution for 1099 supplier Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MATCH_STATUS_FLAG VARCHAR2 1 Validation status of the self assessed tax distribution. Active
POSTED_FLAG VARCHAR2 1 Flag that indicates if invoice distribution has been accounted Active
PO_DISTRIBUTION_ID NUMBER 18 Purchase order distribution identifier for purchase order or receipt matched invoice distributions Active
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). Active
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). Active
PROGRAM_UPDATE_DATE DATE Concurrent Program who column - date when a program last updated this row). Active
QUANTITY_INVOICED NUMBER Quantity billed for purchase order or receipt matched invoice distributions Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
REVERSAL_FLAG VARCHAR2 1 Flag that indicates if distribution is part of a reversal pair Active
TYPE_1099 VARCHAR2 10 1099 type of self assessed tax distribution. Active
UNIT_PRICE NUMBER Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections Active
ENCUMBERED_FLAG VARCHAR2 1 Flag indicating encumbrance status of distribution Active
STAT_AMOUNT NUMBER Amount associated with a distribution for measuring statistical quantities Active
EXPENDITURE_ITEM_DATE DATE Date for project expenditure item used to build Accounting Flexfield for project-related distribution Active
EXPENDITURE_ORGANIZATION_ID NUMBER 18 Identifier for project organization used to build Accounting Flexfield for project-related distribution Active
EXPENDITURE_TYPE VARCHAR2 30 Project expenditure type used to build Accounting Flexfield for project-related distribution Active
PARENT_INVOICE_ID NUMBER 18 Identifier for invoice matched to a credit or debit memo Active
PA_ADDITION_FLAG VARCHAR2 1 Flag that indicates if project related invoice distributions have been transferred into Oracle Projects Active
PA_QUANTITY NUMBER Project item quantity used to build Accounting Flexfield for project-related distribution Active
PREPAY_AMOUNT_REMAINING NUMBER Amount of prepayment that can still be applied to an invoice Active
PROJECT_ID NUMBER 18 Identifier for project used to build Accounting Flexfield for project-related distribution Active
TASK_ID NUMBER 18 Identifier for project task used to build Accounting Flexfield for project-related distribution Active
USSGL_TRANSACTION_CODE VARCHAR2 30 Transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables) Active
USSGL_TRX_CODE_CONTEXT VARCHAR2 30 USSGL Transaction Code Descriptive Flexfield context column Active
QUANTITY_VARIANCE NUMBER Quantity variance amount for invoice distribution lines matched to purchase order or receipt Active
BASE_QUANTITY_VARIANCE NUMBER Quantity variance amount in functional currency for invoice distribution lines matched to purchase order or receipt Active
PACKET_ID NUMBER 18 Budgetary control packet identifier for distributions that fail funds checking Active
AWT_FLAG VARCHAR2 1 Flag to determine if distribution is subject to withholding tax (Y, N, null) Active
AWT_GROUP_ID NUMBER 18 Withholding tax group identifier Active
AWT_TAX_RATE_ID NUMBER 18 Withholding tax rate identifier Active
AWT_GROSS_AMOUNT NUMBER Amount subject to withholding tax Active
AWT_INVOICE_ID NUMBER 18 Refers to the withholding tax invoice created from this distribution Active
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 Active
REFERENCE_1 VARCHAR2 30 Reference information from Oracle Projects expense reports or other external source invoice loading program Active
REFERENCE_2 VARCHAR2 30 Reference information from Oracle Projects expense reports or other external source invoice loading program Active
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 Active
RECEIPT_VERIFIED_FLAG VARCHAR2 1 Indicates whether receipts verified Active
RECEIPT_REQUIRED_FLAG VARCHAR2 1 Indicates whether receipts required Active
RECEIPT_MISSING_FLAG VARCHAR2 1 Indicates whether receipts missing Active
JUSTIFICATION VARCHAR2 240 Justification of the expense on self assessed tax distribution. Active
EXPENSE_GROUP VARCHAR2 80 Expense group on self assessed tax distribution. Active
START_EXPENSE_DATE DATE Date when incurred expense started. Used for Expense Reports Active
END_EXPENSE_DATE DATE Date when incurred expense ended. Used for Expense Reports Active
RECEIPT_CURRENCY_CODE VARCHAR2 15 Currency code of receipt. Used for Expense Reports Active
RECEIPT_CONVERSION_RATE NUMBER Exchange rate for currency of receipt. Used for Expense Reports Active
RECEIPT_CURRENCY_AMOUNT NUMBER Amount in receipt currency. Used for Expense Reports Active
DAILY_AMOUNT NUMBER Daily expense amount. Used for Expense Reports Active
WEB_PARAMETER_ID NUMBER Self-Service Web Applications parameter identifier Active
ADJUSTMENT_REASON VARCHAR2 240 Reason for expense adjustment in the self assessed tax distribution. Active
AWARD_ID NUMBER 18 If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information Active
DIST_MATCH_TYPE VARCHAR2 25 Flag that indicates type of distribution match. Validated against AP_LOOKUP_CODES with lookup type as MATCH_STATUS Active
RCV_TRANSACTION_ID NUMBER 18 Receipt identifier for receipt matched invoice distributions Active
PARENT_REVERSAL_ID NUMBER 18 Invoice distribution identifier for distribution being reversed by the current distribution Active
TAX_RECOVERABLE_FLAG VARCHAR2 1 Indicates whether this tax line is recoverable or not. Used for tax lines Active
TAX_CODE_ID NUMBER 18 The tax code that was used on this distribution for the invoice date Active
MERCHANT_DOCUMENT_NUMBER VARCHAR2 80 Third party document number. Used for Expense Reports Active
MERCHANT_NAME VARCHAR2 80 Third party name. Used for Expense Reports Active
MERCHANT_REFERENCE VARCHAR2 240 Third party reference. Used for Expense Reports Active
MERCHANT_TAX_REG_NUMBER VARCHAR2 80 Third party tax registration number. Used for Expense Reports Active
MERCHANT_TAXPAYER_ID VARCHAR2 80 Third party tax identification number. Used for Expense Reports Active
COUNTRY_OF_SUPPLY VARCHAR2 5 Country where services or goods were originated. Used for Expense Report Active
MATCHED_UOM_LOOKUP_CODE VARCHAR2 25 UOM used for the quantity invoiced during matching of this distributions Active
GMS_BURDENABLE_RAW_COST NUMBER Burdenable raw cost on self assessed tax distribution. Active
ACCOUNTING_EVENT_ID NUMBER 18 Accounting event identifier. Refers to the accounting event that accounted for the distribution Active
PREPAY_DISTRIBUTION_ID NUMBER 18 Invoice distribution identifier for the distribution on the prepayment that originated the prepayment application represented by the current distribution Active
CREDIT_CARD_TRX_ID NUMBER 18 Credit card transaction identifier Active
UPGRADE_POSTED_AMT NUMBER This column is only used during the upgrade to create accounting entries for Cash basis accounting Active
UPGRADE_BASE_POSTED_AMT NUMBER This column is only used during the upgrade to create accounting entries for Cash basis accounting Active
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 Active
COMPANY_PREPAID_INVOICE_ID NUMBER 18 Invoice ID when this line is an prepaid credit card transaction Active
CC_REVERSAL_FLAG VARCHAR2 1 Invoice ID when this line is an prepaid credit card transaction Active
AWT_WITHHELD_AMT NUMBER Withheld amount on self assessed tax distribution. Active
PA_CMT_XFACE_FLAG VARCHAR2 1 Flag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost Active
CANCELLATION_FLAG VARCHAR2 1 Flag indicating whether distribution has been cancelled Active
INVOICE_LINE_NUMBER NUMBER Invoice line number for parent line Active
ROUNDING_AMT NUMBER Amount corresponding to rounding included in BASE_AMOUNT if any Active
CHARGE_APPLICABLE_TO_DIST_ID NUMBER 18 Invoice distribution to which 100% of current charge is applied Active
CORRECTED_INVOICE_DIST_ID NUMBER 18 Invoice distribution identifier for invoice distribution corrected via current distribution. For price, quantity, or invoice line corrections Active
CORRECTED_QUANTITY NUMBER Quantity corrected via price, quantity, or invoice line correction. Column populated for correcting distribution Active
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 Active
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 Active
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 Active
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 Active
INTENDED_USE VARCHAR2 30 Tax Driver: Intended use of product Active
DETAIL_TAX_DIST_ID NUMBER Cross reference to E-Business Tax repository. Active
REC_NREC_RATE NUMBER Recovery or nonrecovery rate on self assessed tax distribution. Active
RECOVERY_RATE_ID NUMBER Recovery rate identifier on self assessed tax distribution. Active
RECOVERY_RATE_NAME VARCHAR2 150 Tax recovery type name on self assessed tax distribution. Active
RECOVERY_TYPE_CODE VARCHAR2 30 Tax recovery type code on self assessed tax distribution. Active
WITHHOLDING_TAX_CODE_ID NUMBER 18 Separating out withholding tax functionality AWT package used to populate tax_code_id on withholding tax distributions with withholding tax code. Active
TAX_ALREADY_DISTRIBUTED_FLAG VARCHAR2 1 Internal processing flag for Payables, indicating whether tax has already been distributed. Active
SUMMARY_TAX_LINE_ID NUMBER Cross reference to E-Business Tax repository. Active
TAXABLE_AMOUNT NUMBER Oracle internal use only. Active
TAXABLE_BASE_AMOUNT NUMBER Oracle internal use only. Active
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. Active
EXTRA_PO_ERV NUMBER ERV value for receipt matched distributions, based on the receipt and PO exchange rates. Used to simplify encumbrace code. Active
SELF_ASSESSED_TAX_LIAB_CCID NUMBER 18 Liability account identifier for the self assessed tax distributions. Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
RCV_CHARGE_ADDITION_FLAG VARCHAR2 1 Indicates if a distribution has been transferred to Oracle Procurement Active
BC_EVENT_ID NUMBER 18 Identifier of Accounting Event raised for Encumbrance accounting Active
AMOUNT_VARIANCE NUMBER Amount variance in entered currency for invoice distributions matched to service shipment or receipt. Active
BASE_AMOUNT_VARIANCE NUMBER Amount variance in functional currency for invoice distributions matched to service shipment or receipt. Active
PJC_CONTEXT_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for project related standardized code collection. Active
PJC_PROJECT_ID NUMBER 18 Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_TASK_ID NUMBER 18 Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_EXPENDITURE_TYPE_ID NUMBER 18 Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_EXPENDITURE_ITEM_DATE DATE Date on which a project related transaction is incurred. Active
PJC_ORGANIZATION_ID NUMBER 18 Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions Active
PJC_BILLABLE_FLAG VARCHAR2 1 Flag that indicates if a project related item is available to be billed to customers Active
PJC_CAPITALIZABLE_FLAG VARCHAR2 1 Flag that indicates if a project related item is eligible for capitalization Active
PJC_WORK_TYPE_ID NUMBER 18 Identifier for project related classsification of the worked performed Active
PJC_CONTRACT_ID NUMBER 18 Contract Identified.Used when Oracle Contract Billing or Oracle Grants Accounting is installed Active
PJC_CONTRACT_LINE_ID NUMBER 18 Tracks contract line information. Used when Oracle Contract Billing or Oracle Grants Accounting is installed Active
PJC_FUNDING_ALLOCATION_ID NUMBER 18 Specifies the name of the project funding override Active
PJC_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE3 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE4 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE5 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE6 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE7 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE8 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE9 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_RESERVED_ATTRIBUTE10 VARCHAR2 150 Reserved for future project-related functionality Active
PJC_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user definable project information Active
PJC_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user definable project information Active
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. Active
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 Funds check and funds reservation status for self assessed tax distribution.
DATA_SET_ID NUMBER Data set identifier for processing budgetary control funds reservation requests.
DEF_ACCTG_ACCRUAL_CCID NUMBER 18 Accrual acount 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

Foreign Keys

Table Foreign Table Foreign Key Column
AP_SELF_ASSESSED_TAX_DIST_ALL ap_invoice_distributions_all INVOICE_DISTRIBUTION_ID
AP_SELF_ASSESSED_TAX_DIST_ALL ap_invoices_all INVOICE_ID

Indexes

Index Uniqueness Tablespace Columns Status
AP_SELF_ASSESSED_TAX_DIST_N1 Non Unique FUSION_TS_TX_IDX ACCOUNTING_EVENT_ID Active
AP_SELF_ASSESSED_TAX_DIST_N2 Non Unique FUSION_TS_TX_IDX BC_EVENT_ID Active
AP_SELF_ASSESSED_TAX_DIST_N23 Non Unique FUSION_TS_TX_IDX RELATED_ID Active
AP_SELF_ASSESSED_TAX_DIST_N24 Non Unique FUSION_TS_TX_IDX CORRECTED_INVOICE_DIST_ID Active
AP_SELF_ASSESSED_TAX_DIST_N28 Non Unique FUSION_TS_TX_IDX CHARGE_APPLICABLE_TO_DIST_ID Active
AP_SELF_ASSESSED_TAX_DIST_N29 Non Unique FUSION_TS_TX_IDX DETAIL_TAX_DIST_ID Active
AP_SELF_ASSESSED_TAX_DIST_N3 Non Unique FUSION_TS_TX_IDX DIST_CODE_COMBINATION_ID Active
AP_SELF_ASSESSED_TAX_DIST_N30 Non Unique FUSION_TS_TX_IDX INVOICE_ID, CANCELLATION_FLAG
AP_SELF_ASSESSED_TAX_DIST_N31 Non Unique FUSION_TS_TX_IDX INVOICE_ID, MATCH_STATUS_FLAG
AP_SELF_ASSESSED_TAX_DIST_N4 Non Unique FUSION_TS_TX_IDX POSTED_FLAG Active
AP_SELF_ASSESSED_TAX_DIST_N5 Non Unique Default ASSETS_ADDITION_FLAG, SET_OF_BOOKS_ID, POSTED_FLAG
AP_SELF_ASSESSED_TAX_DIST_U1 Unique FUSION_TS_TX_IDX INVOICE_ID, INVOICE_LINE_NUMBER, DISTRIBUTION_LINE_NUMBER Active
AP_SELF_ASSESS_TAX_DIST_U2 Unique FUSION_TS_TX_DATA INVOICE_DISTRIBUTION_ID Active