[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JL_ZZ_AP_AWT_TYPES |
|---|---|
| Object Type: | TABLE |
| Owner: | JL |
| FND Design Data: |  JL.JL_ZZ_AP_AWT_TYPES
|
| Subobject Name: | |
| Status: | VALID |
JL_ZZ_AP_AWT_TYPES contains information about the withholding tax types defined for Argentina and Colombia.
.
The Withholding tax types will be used while calculating withholding taxes for Argentina and Colombia. The Withholding Tax Type is required when defining withholding tax names. It will be used to set up the withholding applicablility for Suppliers and Company Locations.
.
This table corresponds to the Withholding Tax Types window.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JL_ZZ_AP_AWT_TYPES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 AWT_TYPE_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AWT_TYPE_CODE | VARCHAR2 | (30) | Yes | Withholding tax type code |
| JURISDICTION_TYPE | VARCHAR2 | (30) | Yes | Jurisdiction type (Federal, Provincial, Zonal or Municipal) |
| FOREIGN_SUPPLIER_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the tax type is applicable to foreign suppliers |
| TAXABLE_BASE_AMOUNT_BASIS | VARCHAR2 | (30) | Yes | Invoice or payment basis for taxable base amount |
| MIN_TAX_AMOUNT_LEVEL | VARCHAR2 | (30) | Yes | Minimum taxable base amount level (withholding type/category/NA) |
| MIN_WH_AMOUNT_LEVEL | VARCHAR2 | (30) | Yes | Minimum withheld amount compared by withholding type/category/NA |
| TAX_AUTHORITY_ID | NUMBER | (15) | Yes | Tax authority ID |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| DESCRIPTION | VARCHAR2 | (80) | Withholding tax type description | |
| PROVINCE_CODE | VARCHAR2 | (30) | Province code | |
| CITY_CODE | VARCHAR2 | (30) | City code | |
| MIN_TAX_AMOUNT | NUMBER | Minimum taxable base amount | ||
| MIN_WH_AMOUNT | NUMBER | Minimum withheld amount | ||
| CERTIFICATE_HEADER | VARCHAR2 | (240) | Certificate header text | |
| SUPPLIER_EXEMPT_LEVEL | VARCHAR2 | (30) | Supplier exemption level (Withholding type, Category or N/A) | |
| CUMULATIVE_PAYMENT_FLAG | VARCHAR2 | (1) | Indicates whether cumulative payment is applicable | |
| CREDIT_LETTER_FLAG | VARCHAR2 | (1) | Indicates whether credit letters are allowed | |
| MULTILAT_CONTRIB_FLAG | VARCHAR2 | (1) | Indicates whether multilateral contribution is allowed | |
| PARTIAL_PAYMENT_FLAG | VARCHAR2 | (1) | Indicates whether partial payment must be paid in full | |
| VAT_INCLUSIVE_FLAG | VARCHAR2 | (1) | Indicates whether the basis for VAT inclusive must be gross | |
| USER_DEFINED_FORMULA_FLAG | VARCHAR2 | (1) | Indicates whether user defined formula will be used | |
| START_DATE_ACTIVE | DATE | Start date active | ||
| END_DATE_ACTIVE | DATE | End date active | ||
| 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 | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| DGI_TAX_TYPE_CODE | VARCHAR2 | (30) | Tax Type Reporting Code |
Cut, paste (and edit) the following text to query this object:
SELECT AWT_TYPE_CODE
, JURISDICTION_TYPE
, FOREIGN_SUPPLIER_FLAG
, TAXABLE_BASE_AMOUNT_BASIS
, MIN_TAX_AMOUNT_LEVEL
, MIN_WH_AMOUNT_LEVEL
, TAX_AUTHORITY_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, DESCRIPTION
, PROVINCE_CODE
, CITY_CODE
, MIN_TAX_AMOUNT
, MIN_WH_AMOUNT
, CERTIFICATE_HEADER
, SUPPLIER_EXEMPT_LEVEL
, CUMULATIVE_PAYMENT_FLAG
, CREDIT_LETTER_FLAG
, MULTILAT_CONTRIB_FLAG
, PARTIAL_PAYMENT_FLAG
, VAT_INCLUSIVE_FLAG
, USER_DEFINED_FORMULA_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_LOGIN
, DGI_TAX_TYPE_CODE
FROM JL.JL_ZZ_AP_AWT_TYPES;
JL.JL_ZZ_AP_AWT_TYPES does not reference any database object
JL.JL_ZZ_AP_AWT_TYPES is referenced by following:
APPS
JL_ZZ_AP_AWT_TYPES
|
|
|
|