[Home] [Help]
[Dependency Information]
[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 |
ap_self_assessed_tax_dist contains self assessed tax distributions
| 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
|
| AP_SELF_ASSESSED_TAX_DIST_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSETS_ADDITION_FLAG
SET_OF_BOOKS_ID
POSTED_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | Unique identifier for this table |
| ORG_ID | NUMBER | (15) | Yes | Organization identifier |
| 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 | Flag that indicates if distribution has been accounted for in the cash set of books (Y or N) |
| DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | Distribution number |
| DIST_CODE_COMBINATION_ID | NUMBER | (15) | Yes | Accounting flexfield identifier for account associated with a distribution |
| INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| 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 |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identifier |
| SELF_ASSESSED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the tax distributions is self assessed |
| AMOUNT | NUMBER | Invoice distribution amount | ||
| BASE_AMOUNT | NUMBER | Amount of invoice in functional currency, only used for foreign currency invoices | ||
| BATCH_ID | NUMBER | (15) | Invoice batch identifier | |
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| DESCRIPTION | VARCHAR2 | (240) | 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 FND_LOGINS.LOGIN_ID). | |
| MATCH_STATUS_FLAG | VARCHAR2 | (1) | Validation status | |
| POSTED_FLAG | VARCHAR2 | (1) | Flag that indicates if invoice distribution has been accounted | |
| PO_DISTRIBUTION_ID | NUMBER | (15) | Purchase order distribution identifier for purchase order or receipt matched invoice distributions | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | 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 | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| REVERSAL_FLAG | VARCHAR2 | (1) | Flag that indicates if distribution is part of a reversal pair | |
| TYPE_1099 | VARCHAR2 | (10) | 1099 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 | ||
| 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) | Transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables) | |
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | USSGL Transaction Code Descriptive Flexfield context column | |
| QUANTITY_VARIANCE | NUMBER | Quantity variance amount for invoice distribution lines matched to purchase order or receipt | ||
| BASE_QUANTITY_VARIANCE | NUMBER | Quantity variance amount in functional currency for invoice distribution lines matched to purchase order or receipt | ||
| 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 | |
| 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 receipts verified | |
| RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether receipts required | |
| RECEIPT_MISSING_FLAG | VARCHAR2 | (1) | Indicates whether receipts missing | |
| JUSTIFICATION | VARCHAR2 | (240) | Expense justification | |
| EXPENSE_GROUP | VARCHAR2 | (80) | Expense group | |
| 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 invoice distributions | |
| 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 | |
| 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) | Credit card transaction identifier | |
| 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 | |
| DETAIL_TAX_DIST_ID | NUMBER | Cross reference to E-Business Tax repository. | ||
| 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 | |
| WITHHOLDING_TAX_CODE_ID | NUMBER | (15) | Separating out withholding tax functionality AWT package used to populate tax_code_id on withholding tax distributions with withholding tax code. | |
| TAX_ALREADY_DISTRIBUTED_FLAG | VARCHAR2 | (1) | Internal processing flag for Payables, indicating whether tax has already been distributed. | |
| SUMMARY_TAX_LINE_ID | NUMBER | Cross reference to E-Business Tax repository. | ||
| TAXABLE_AMOUNT | NUMBER | For Internal Use Only | ||
| TAXABLE_BASE_AMOUNT | NUMBER | 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:
AP
AP_SELF_ASSESSED_TAX_DIST_ALL#
|
|
|
|