[Home] [Help] [Dependency Information]
Object Name: | AP_AWT_TEMP_DISTRIBUTIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_AWT_TEMP_DISTRIBUTIONS_ALL |
Subobject Name: | |
Status: | VALID |
AP_AWT_TEMP_DISTRIBUTIONS_ALL contains temporary
withholding tax type invoice distributions for projected withholding
tax or unconfirmed payment batches.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_AWT_TEMP_DISTRIBUTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING |
INVOICE_ID
PAYMENT_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Unique invoice identifier |
PAYMENT_NUM | NUMBER | (15) | Payment number | |
GROUP_ID | NUMBER | (15) | Yes | Withholding Tax group unique identifier |
TAX_NAME | VARCHAR2 | (15) | Yes | Withholding tax code |
TAX_CODE_COMBINATION_ID | NUMBER | (15) | Yes | Accounting Flexfield identifier for account to which withholding taxes are posted |
GROSS_AMOUNT | NUMBER | Yes | Amount subject to withholding | |
WITHHOLDING_AMOUNT | NUMBER | Yes | Amount of withholding tax | |
BASE_WITHHOLDING_AMOUNT | NUMBER | Amount of withholding tax in the functional currency | ||
ACCOUNTING_DATE | DATE | Yes | Accounting date | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | Period name |
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 | (15) | Yes | Tax rate unique identifier |
ORG_ID | NUMBER | (15) | Organization identifier | |
INVOICE_PAYMENT_ID | NUMBER | (15) | Payment number unique identifier | |
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 | |
AWT_RELATED_ID | NUMBER | (15) | Identifier linking related distributions. Used for linking related Invoice Distribution. Populated from INVOICE_DISTRIBUTION_ID of the related distribution. | |
CHECKRUN_ID | NUMBER | (15) | Payment batch identifier |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, PAYMENT_NUM
, GROUP_ID
, TAX_NAME
, TAX_CODE_COMBINATION_ID
, GROSS_AMOUNT
, WITHHOLDING_AMOUNT
, BASE_WITHHOLDING_AMOUNT
, ACCOUNTING_DATE
, PERIOD_NAME
, CHECKRUN_NAME
, TAX_RATE_ID
, ORG_ID
, INVOICE_PAYMENT_ID
, 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
, AWT_RELATED_ID
, CHECKRUN_ID
FROM AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL;
AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL does not reference any database object
AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL is referenced by following:
|
|
|