DBA Data[Home] [Help] [Dependency Information]

TABLE: JL.JL_ZZ_AP_SUP_AWT_CD_ALL

Object Details
Object Name: JL_ZZ_AP_SUP_AWT_CD_ALL
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_ZZ_AP_SUP_AWT_CD_ALL
Subobject Name:
Status: VALID


JL_ZZ_AP_SUP_AWT_CD_ALL stores the primary and secondary withholding tax codes applicable to Argentine and Colombian suppliers. This information is part of the withholding tax setup and it will be the source for defaulting multiple tax names per invoice distribution lines when performing all transactions related to document entry such as Enter Invoices, Recurring and Import Invoices.
This table corresponds to the Supplier Withholding Tax Codes window.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_ZZ_AP_SUP_AWT_CD_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPP_AWT_CODE_ID
JL_ZZ_AP_SUP_AWT_CD_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPP_AWT_TYPE_ID
ColumnTAX_ID
ColumnEFFECTIVE_START_DATE
Columns
Name Datatype Length Mandatory Comments
SUPP_AWT_CODE_ID NUMBER (15) Yes Supplier withholding tax code ID
SUPP_AWT_TYPE_ID NUMBER (15) Yes Supplier withholding tax type ID
TAX_ID NUMBER (15) Yes Tax ID
PRIMARY_TAX_FLAG VARCHAR2 (1) Yes Indicates whether the tax name is the primary one or not
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
EXEMPTION_START_DATE DATE

Exemption start date
EXEMPTION_END_DATE DATE

Exemption end date
EXEMPTION_RATE NUMBER

Exemption rate
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
ORG_ID NUMBER (15)
Organization ID
EFFECTIVE_START_DATE DATE

Tax code Effective start date
EFFECTIVE_END_DATE DATE

Tax code Effective end date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUPP_AWT_CODE_ID
,      SUPP_AWT_TYPE_ID
,      TAX_ID
,      PRIMARY_TAX_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      EXEMPTION_START_DATE
,      EXEMPTION_END_DATE
,      EXEMPTION_RATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM JL.JL_ZZ_AP_SUP_AWT_CD_ALL;

Dependencies

[top of page]

JL.JL_ZZ_AP_SUP_AWT_CD_ALL does not reference any database object

JL.JL_ZZ_AP_SUP_AWT_CD_ALL is referenced by following:

SchemaJL
ViewJL_ZZ_AP_SUP_AWT_CD_ALL#