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

TABLE: ZX.ZX_REP_TRX_JX_EXT_T

Object Details
Object Name: ZX_REP_TRX_JX_EXT_T
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_REP_TRX_JX_EXT_T
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_REP_TRX_JX_EXT_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDETAIL_TAX_LINE_EXT_ID
ZX_REP_TRX_JX_EXT_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDETAIL_TAX_LINE_ID
Columns
Name Datatype Length Mandatory Comments
DETAIL_TAX_LINE_EXT_ID NUMBER (15) Yes Unique identifier
DETAIL_TAX_LINE_ID NUMBER (15)
Detail tax line identifier
NUMERIC1 NUMBER

Numeric extensible parameter
NUMERIC2 NUMBER

Numeric extensible parameter
NUMERIC3 NUMBER

Numeric extensible parameter
NUMERIC4 NUMBER

Numeric extensible parameter
NUMERIC5 NUMBER

Numeric extensible parameter
NUMERIC6 NUMBER

Numeric extensible parameter
NUMERIC7 NUMBER

Numeric extensible parameter
NUMERIC8 NUMBER

Numeric extensible parameter
NUMERIC9 NUMBER

Numeric extensible parameter
NUMERIC10 NUMBER

Numeric extensible parameter
NUMERIC11 NUMBER

Numeric extensible parameter
NUMERIC12 NUMBER

Numeric extensible parameter
NUMERIC13 NUMBER

Numeric extensible parameter
NUMERIC14 NUMBER

Numeric extensible parameter
NUMERIC15 NUMBER

Numeric extensible parameter
NUMERIC16 NUMBER

Numeric extensible parameter
ATTRIBUTE1 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE2 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE3 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE4 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE5 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE6 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE7 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE8 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE9 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE10 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE11 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE12 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE13 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE14 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE15 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE16 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE17 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE18 VARCHAR2 (150)
Character extensible parameter
DOCUMENT_SUB_TYPE_MNG VARCHAR2 (80)
Document sub type meaning
TAX_STATUS_MNG VARCHAR2 (80)
Tax status name
TRX_BUSINESS_CATEGORY_MNG VARCHAR2 (80)
Meaning for transaction business category
GDF_AP_INVOICES_ATT2 VARCHAR2 (150)
Reserved for country specific localizations
GDF_AP_INVOICES_ATT3 VARCHAR2 (150)
Reserved for country specific localizations
GDF_AP_INVOICES_ATT4 VARCHAR2 (150)
Reserved for country specific localizations
GDF_AP_INVOICES_ATT11 VARCHAR2 (150)
Reserved for country specific localizations
GDF_AP_INVOICES_ATT12 VARCHAR2 (150)
Reserved for country specific localizations
GDF_AP_INVOICES_ATT13 VARCHAR2 (150)
Reserved for country specific localizations
GDF_AP_INVOICE_DIST_ATT1 VARCHAR2 (150)
Reserved for country specific localizations
GDF_PO_VENDOR_SITES_ATT17 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_BILL_ATT10 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_BILL_ATT12 VARCHAR2 (150)
Reserved for country specific localizations
GDF_PARTY_SITES_BILL_ATT8 VARCHAR2 (150)
Reserved for country specific localizations
GDF_PARTY_SITES_BILL_ATT9 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT3 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT4 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT5 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT6 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT7 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT8 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT9 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_ATT19 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_LINES_ATT1 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_LINES_ATT2 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_TYPES_ATT5 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_TYPES_ATT6 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_CUST_TRX_TYPES_ATT7 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_BATCH_SOURCES_ATT1 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_BATCH_SOURCES_ATT2 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_BATCH_SOURCES_ATT3 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_BATCH_SOURCES_ATT4 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_BATCH_SOURCES_ATT7 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_ADDRESSES_BILL_ATT9 VARCHAR2 (150)
Reserved for country specific localizations
GDF_RA_ADDRESSES_SHIP_ATT9 VARCHAR2 (150)
Reserved for country specific localizations
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID NUMBER

Login user identifier of last concurrent program to update this record
ATTRIBUTE19 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE20 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE21 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE22 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE23 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE24 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE25 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE26 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE27 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE28 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE29 VARCHAR2 (150)
Character extensible parameter
ATTRIBUTE30 VARCHAR2 (150)
Character extensible parameter
Query Text

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


SELECT DETAIL_TAX_LINE_EXT_ID
,      DETAIL_TAX_LINE_ID
,      NUMERIC1
,      NUMERIC2
,      NUMERIC3
,      NUMERIC4
,      NUMERIC5
,      NUMERIC6
,      NUMERIC7
,      NUMERIC8
,      NUMERIC9
,      NUMERIC10
,      NUMERIC11
,      NUMERIC12
,      NUMERIC13
,      NUMERIC14
,      NUMERIC15
,      NUMERIC16
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      DOCUMENT_SUB_TYPE_MNG
,      TAX_STATUS_MNG
,      TRX_BUSINESS_CATEGORY_MNG
,      GDF_AP_INVOICES_ATT2
,      GDF_AP_INVOICES_ATT3
,      GDF_AP_INVOICES_ATT4
,      GDF_AP_INVOICES_ATT11
,      GDF_AP_INVOICES_ATT12
,      GDF_AP_INVOICES_ATT13
,      GDF_AP_INVOICE_DIST_ATT1
,      GDF_PO_VENDOR_SITES_ATT17
,      GDF_RA_CUST_BILL_ATT10
,      GDF_RA_CUST_BILL_ATT12
,      GDF_PARTY_SITES_BILL_ATT8
,      GDF_PARTY_SITES_BILL_ATT9
,      GDF_RA_CUST_TRX_ATT3
,      GDF_RA_CUST_TRX_ATT4
,      GDF_RA_CUST_TRX_ATT5
,      GDF_RA_CUST_TRX_ATT6
,      GDF_RA_CUST_TRX_ATT7
,      GDF_RA_CUST_TRX_ATT8
,      GDF_RA_CUST_TRX_ATT9
,      GDF_RA_CUST_TRX_ATT19
,      GDF_RA_CUST_TRX_LINES_ATT1
,      GDF_RA_CUST_TRX_LINES_ATT2
,      GDF_RA_CUST_TRX_TYPES_ATT5
,      GDF_RA_CUST_TRX_TYPES_ATT6
,      GDF_RA_CUST_TRX_TYPES_ATT7
,      GDF_RA_BATCH_SOURCES_ATT1
,      GDF_RA_BATCH_SOURCES_ATT2
,      GDF_RA_BATCH_SOURCES_ATT3
,      GDF_RA_BATCH_SOURCES_ATT4
,      GDF_RA_BATCH_SOURCES_ATT7
,      GDF_RA_ADDRESSES_BILL_ATT9
,      GDF_RA_ADDRESSES_SHIP_ATT9
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM ZX.ZX_REP_TRX_JX_EXT_T;

Dependencies

[top of page]

ZX.ZX_REP_TRX_JX_EXT_T does not reference any database object

ZX.ZX_REP_TRX_JX_EXT_T is referenced by following:

SchemaZX
ViewZX_REP_TRX_JX_EXT_T#