ZX_REP_TRX_JX_EXT_T

Index for DETAIL_TAX_LINE_ID for table ZX_REP_TRX_JX_EXT_T

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_REP_TRX_JX_EXT_T_PK

DETAIL_TAX_LINE_EXT_ID

Columns

Name Datatype Length Precision Not-null Comments
DETAIL_TAX_LINE_EXT_ID NUMBER 18 Yes Unique identifier
DETAIL_TAX_LINE_ID NUMBER 18 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 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
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 VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APP_NAME VARCHAR2 240 Application identifier of last concurrent program to update this record
PROGRAM_NAME VARCHAR2 30 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 Descriptive Flexfield: segment of the user descriptive flexfield.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
BOX_NUMBER1_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER2_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER3_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER4_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER5_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER6_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER7_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER8_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER9_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
BOX_NUMBER10_ID NUMBER 18 Tax box assigned to a taxable transaction, upto 10 boxes per transaction. Foreign key to zx_reporting_codes_b.
REPORTING_TYPE_ID NUMBER 18 Reporting type associated with the tax box numbers.
PERIODICITY_CODE VARCHAR2 30 Determines whether the rule associated with the taxable transaction is for periodic or annual.
BOX_NUMBER1 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER2 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER3 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER4 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER5 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER6 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER7 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER8 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER9 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_NUMBER10 VARCHAR2 60 Tax box number assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE1 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE2 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE3 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE4 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE5 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE6 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE7 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE8 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE9 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_VALUE_TYPE_CODE10 VARCHAR2 30 Tax box type assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG1 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG2 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG3 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG4 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG5 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG6 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG7 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG8 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG9 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
BOX_SIGN_FLAG10 VARCHAR2 1 Tax box sign assigned to a taxable transaction, upto 10 boxes per transaction.
ATTRIBUTE31 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE32 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE33 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE34 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE35 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE36 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE37 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE38 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE39 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE40 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE41 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE42 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE43 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE44 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE45 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE46 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE47 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE48 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE49 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE50 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.

Indexes

Index Uniqueness Tablespace Columns
ZX_REP_TRX_JX_EXT_T_N1 Non Unique Default DETAIL_TAX_LINE_ID
ZX_REP_TRX_JX_EXT_T_U1 Unique Default DETAIL_TAX_LINE_EXT_ID