[Home] [Help] [Dependency Information]
Object Name: | AP_SELF_ASSESSED_TAX_DIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_SELF_ASSESSED_TAX_DIST_ALL |
Subobject Name: | |
Status: | VALID |
This table holds distributions of self assessed taxes. Self-assessed tax amounts are taxes that are liable to tax authority by buyer and it has no impact on the amount due to the supplier.
As these taxes are not included in the supplier liability amount, a new table copy of AP_INVOICE_DISTRIBUTIONS table is created with the name as AP_SELF_ASSESSED_TAX_DIST_ALL, with the exception that there will be an additional column, SELF_ASSESSED_TAX_LIAB_CCID. The value in this column will be used instead of the liability (or liabilities, in the case of automatic offsets) used on �regular� distributions.
In addition there will be a column called SELF_ASSESSED_FLAG added which is required as part of the SLA uptake.
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_SELF_ASSESSED_TAX_DIST_ALL table or can be different depending on the rules setup in Subledger Accounting. The XLA_AE_HEADERS and XLA_AE_LINES tables in Subledger Accounting stores the accounting entries posted to General Ledger.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_SELF_ASSESSED_TAX_DIST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INVOICE_ID
INVOICE_LINE_NUMBER DISTRIBUTION_LINE_NUMBER |
AP_SELF_ASSESSED_TAX_DIST_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INVOICE_DISTRIBUTION_ID |
AP_SELF_ASSESSED_TAX_DIST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACCOUNTING_EVENT_ID |
AP_SELF_ASSESSED_TAX_DIST_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BC_EVENT_ID |
AP_SELF_ASSESSED_TAX_DIST_N23 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RELATED_ID |
AP_SELF_ASSESSED_TAX_DIST_N24 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CORRECTED_INVOICE_DIST_ID |
AP_SELF_ASSESSED_TAX_DIST_N28 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CHARGE_APPLICABLE_TO_DIST_ID |
AP_SELF_ASSESSED_TAX_DIST_N29 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DETAIL_TAX_DIST_ID |
AP_SELF_ASSESSED_TAX_DIST_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DIST_CODE_COMBINATION_ID |
AP_SELF_ASSESSED_TAX_DIST_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POSTED_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | Unique internal Identifier of the invoice distribution record. Generated using a database sequence. |
ORG_ID | NUMBER | (15) | Yes | Unique internal identifier of the Operating Unit to which the invoice belongs. |
ACCOUNTING_DATE | DATE | Yes | Accounting date | |
ACCRUAL_POSTED_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if distribution has been accounted for in the accrual set of books (Y or N) |
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) | Yes | 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 Identifer. |
SELF_ASSESSED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the tax distributions is self assessed |
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. | ||
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. | |
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 | 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 | ||
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 | ||
ENCUMBERED_FLAG | VARCHAR2 | (1) | Flag indicating encumbrance status of distribution | |
STAT_AMOUNT | NUMBER | Amount associated with a distribution for measuring statistical quantities | ||
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 | |
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 | |
PREPAY_AMOUNT_REMAINING | NUMBER | Amount of prepayment that can still be applied to an invoice | ||
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. | |
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 Payment time. This column correspods 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 | |
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 | |
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 | ||
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 | |
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. | |
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 | |
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. | |
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 Report | |
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 | |
PREPAY_DISTRIBUTION_ID | NUMBER | (15) | Invoice distribution identifier for the distribution on the prepayment that originated the prepayment application represented by the current distribution | |
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. | |
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 | Stores AWT withheld 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) | Flag indicating whether distribution has been cancelled | |
INVOICE_LINE_NUMBER | NUMBER | Invoice line number for parent line | ||
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_INVOICE_DIST_ID | NUMBER | (15) | Invoice distribution identifier for invoice distribution corrected via current distribution. For price, quantity, or invoice line corrections | |
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 | |
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 | (30) | Recovery rate name | |
RECOVERY_TYPE_CODE | VARCHAR2 | (30) | Recovery type code | |
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. | ||
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. | ||
EXTRA_PO_ERV | NUMBER | ERV value for receipt matched distributions, based on the receipt and PO exchange rates. Used to simplify encumbrace code. | ||
SELF_ASSESSED_TAX_LIAB_CCID | NUMBER | (15) | Liability account identifier for the self assessed tax distributions. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
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 | |
PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | No longer Used | |
RCV_CHARGE_ADDITION_FLAG | VARCHAR2 | (1) | Indicates if a distribution has been transferred to Oracle Procurement | |
BC_EVENT_ID | NUMBER | (15) | Identifier of Accounting Event raised for Encumbrance accounting | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_DISTRIBUTION_ID
, ORG_ID
, 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
, SELF_ASSESSED_FLAG
, AMOUNT
, BASE_AMOUNT
, BATCH_ID
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, FINAL_MATCH_FLAG
, INCOME_TAX_REGION
, LAST_UPDATE_LOGIN
, MATCH_STATUS_FLAG
, POSTED_FLAG
, PO_DISTRIBUTION_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUANTITY_INVOICED
, REQUEST_ID
, REVERSAL_FLAG
, TYPE_1099
, UNIT_PRICE
, ENCUMBERED_FLAG
, STAT_AMOUNT
, EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, PARENT_INVOICE_ID
, PA_ADDITION_FLAG
, PA_QUANTITY
, PREPAY_AMOUNT_REMAINING
, PROJECT_ID
, TASK_ID
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, 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
, AWT_INVOICE_PAYMENT_ID
, 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
, DIST_MATCH_TYPE
, RCV_TRANSACTION_ID
, PARENT_REVERSAL_ID
, TAX_RECOVERABLE_FLAG
, TAX_CODE_ID
, 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
, CREDIT_CARD_TRX_ID
, UPGRADE_POSTED_AMT
, UPGRADE_BASE_POSTED_AMT
, INVENTORY_TRANSFER_STATUS
, COMPANY_PREPAID_INVOICE_ID
, CC_REVERSAL_FLAG
, AWT_WITHHELD_AMT
, PA_CMT_XFACE_FLAG
, CANCELLATION_FLAG
, INVOICE_LINE_NUMBER
, ROUNDING_AMT
, CHARGE_APPLICABLE_TO_DIST_ID
, CORRECTED_INVOICE_DIST_ID
, CORRECTED_QUANTITY
, RELATED_ID
, ASSET_BOOK_TYPE_CODE
, ASSET_CATEGORY_ID
, DISTRIBUTION_CLASS
, INTENDED_USE
, DETAIL_TAX_DIST_ID
, REC_NREC_RATE
, RECOVERY_RATE_ID
, RECOVERY_RATE_NAME
, RECOVERY_TYPE_CODE
, WITHHOLDING_TAX_CODE_ID
, TAX_ALREADY_DISTRIBUTED_FLAG
, SUMMARY_TAX_LINE_ID
, TAXABLE_AMOUNT
, TAXABLE_BASE_AMOUNT
, PREPAY_TAX_DIFF_AMOUNT
, EXTRA_PO_ERV
, SELF_ASSESSED_TAX_LIAB_CCID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, 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
, PROJECT_ACCOUNTING_CONTEXT
, RCV_CHARGE_ADDITION_FLAG
, BC_EVENT_ID
, AMOUNT_VARIANCE
, BASE_AMOUNT_VARIANCE
FROM AP.AP_SELF_ASSESSED_TAX_DIST_ALL;
AP.AP_SELF_ASSESSED_TAX_DIST_ALL does not reference any database object
AP.AP_SELF_ASSESSED_TAX_DIST_ALL is referenced by following:
|
|
|