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

TABLE: ZX.ZX_LINES_DET_FACTORS

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_LINES_DET_FACTORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnEVENT_CLASS_CODE
ColumnENTITY_CODE
ColumnTRX_ID
ColumnTRX_LINE_ID
ColumnTRX_LEVEL_TYPE
ColumnICX_SESSION_ID
ZX_LINES_DET_FACTORS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_CLASS_MAPPING_ID
ColumnTRX_ID
ColumnTRX_LINE_ID
ColumnTRX_LEVEL_TYPE
ColumnICX_SESSION_ID
ZX_LINES_DET_FACTORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
ColumnTRX_ID
Columns
Name Datatype Length Mandatory Comments
INTERNAL_ORGANIZATION_ID NUMBER
Yes Internal organization identifier of the transaction
APPLICATION_ID NUMBER
Yes Application Identifier of the transaction
ENTITY_CODE VARCHAR2 (30) Yes Entity code of the application event class for the transaction
EVENT_CLASS_CODE VARCHAR2 (30) Yes Application event class of the transaction
EVENT_CLASS_MAPPING_ID NUMBER

EVENT_TYPE_CODE VARCHAR2 (30) Yes Application event type for the transaction
DOC_EVENT_STATUS VARCHAR2 (30)
Lookup code that indicates event status of the transaction
LINE_LEVEL_ACTION VARCHAR2 (30) Yes Column to store action at the transaction line level
TRX_ID NUMBER
Yes Primary transaction identifier
TRX_LINE_ID NUMBER

Transaction line identifier
TRX_LEVEL_TYPE VARCHAR2 (30) Yes Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the user composite key to uniquely identify the transaction
LINE_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line user composite key for uniquely identifying the transaction line
LINE_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line user composite key for uniquely identifying the transaction line
LINE_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line user composite key for uniquely identifying the transaction line
LINE_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line user composite key for uniquely identifying the transaction line
LINE_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line user composite key for uniquely identifying the transaction line
LINE_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line user composite key for uniquely identifying the transaction line
TRX_DATE DATE
Yes Transaction date
TRX_DOC_REVISION VARCHAR2 (150)
Revision number for the transaction.
LEDGER_ID NUMBER (15)
Ledger identifying column
TRX_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
CURRENCY_CONVERSION_DATE DATE

Date of the exchange rate
CURRENCY_CONVERSION_RATE NUMBER

Exchange rate
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type
MINIMUM_ACCOUNTABLE_UNIT NUMBER

Minimum accountable unit of the transaction currency
PRECISION NUMBER

Precision of the transaction currency
LEGAL_ENTITY_ID NUMBER
Yes Legal entity identifier for the transaction
ESTABLISHMENT_ID NUMBER

Establishment identifier of the first party
RECEIVABLES_TRX_TYPE_ID NUMBER

Transaction type identifier for Receivables transactions
DEFAULT_TAXATION_COUNTRY VARCHAR2 (2)
Default taxation country code
TRX_NUMBER VARCHAR2 (150)
Transaction number, typically the number that enables a user to identify a transaction
TRX_LINE_NUMBER NUMBER

Transaction line number
TRX_LINE_DESCRIPTION VARCHAR2 (240)
Description for the transaction line
TRX_DESCRIPTION VARCHAR2 (240)
Description for the transaction
TRX_COMMUNICATED_DATE DATE

Printed or Received date of the transaction
BATCH_SOURCE_ID NUMBER

Batch source identifier for Receivables transactions
BATCH_SOURCE_NAME VARCHAR2 (150)
Batch source name for Receivables transactions
DOC_SEQ_ID NUMBER

Identifies the document sequence
DOC_SEQ_NAME VARCHAR2 (150)
Name of the document sequence
DOC_SEQ_VALUE VARCHAR2 (240)
Value of the document sequence
TRX_DUE_DATE DATE

Payment due date of the transaction
TRX_TYPE_DESCRIPTION VARCHAR2 (240)
Transaction type description for Receivables transactions
DOCUMENT_SUB_TYPE VARCHAR2 (240)
Document sub type code
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 (150)
Transaction number on the supplier tax invoice
SUPPLIER_TAX_INVOICE_DATE DATE

Transaction date on the supplier tax invoice
SUPPLIER_EXCHANGE_RATE NUMBER

Exchange rate on the supplier tax invoice
TAX_INVOICE_DATE DATE

Number for tax invoice generated by Receivables
TAX_INVOICE_NUMBER VARCHAR2 (150)
Transaction date for tax invoice generated by Receivables
FIRST_PTY_ORG_ID NUMBER

Party tax profile identifier for the first party organization of the transaction
TAX_EVENT_CLASS_CODE VARCHAR2 (30)
Tax event class code of the transaction
TAX_EVENT_TYPE_CODE VARCHAR2 (30)
Tax event type code of the transaction
RDNG_SHIP_TO_PTY_TX_PROF_ID NUMBER

Party tax profile identifier for the ship to party of the transaction used for rounding of tax amounts
RDNG_SHIP_FROM_PTY_TX_PROF_ID NUMBER

Party tax profile identifier for the ship from party of the transaction used for rounding of tax amounts
RDNG_BILL_TO_PTY_TX_PROF_ID NUMBER

Party tax profile identifier for the bill to party of the transaction used for rounding of tax amounts
RDNG_BILL_FROM_PTY_TX_PROF_ID NUMBER

Party tax profile identifier for the bill from party of the transaction used for rounding of tax amounts
RDNG_SHIP_TO_PTY_TX_P_ST_ID NUMBER

Party tax profile identifier for the ship to party site of the transaction used for rounding of tax amounts
RDNG_SHIP_FROM_PTY_TX_P_ST_ID NUMBER

Party tax profile identifier for the ship from party site of the transaction used for rounding of tax amounts
RDNG_BILL_TO_PTY_TX_P_ST_ID NUMBER

Party tax profile identifier for the bill to party site of the transaction used for rounding of tax amounts
RDNG_BILL_FROM_PTY_TX_P_ST_ID NUMBER

Party tax profile identifier for the bill from party site of the transaction used for rounding of tax amounts
LINE_INTENDED_USE VARCHAR2 (240)
Intended use code of the transaction line. This identifies the purpose for which the product is used.
TRX_LINE_TYPE VARCHAR2 (30)
Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC.
TRX_SHIPPING_DATE DATE

Shipping date of the transaction at header or line level
TRX_RECEIPT_DATE DATE

Receipt date of the transaction at header or line level
TRX_SIC_CODE VARCHAR2 (150)
Standard industry classification code of the transaction
FOB_POINT VARCHAR2 (30)
Free on Board point
TRX_WAYBILL_NUMBER VARCHAR2 (50)
Waybill number of the transaction
PRODUCT_ID NUMBER

Column to store internal identifier of the inventory item or memo line used on this transaction line.
PRODUCT_FISC_CLASSIFICATION VARCHAR2 (240)
Product fiscal classification code of the inventory item
PRODUCT_ORG_ID NUMBER

Identifier of the organization for the inventory item
UOM_CODE VARCHAR2 (30)
Unit of measure code for the inventory item
PRODUCT_TYPE VARCHAR2 (240)
Product type code of the inventory item. Possible values are GOODS and SERVICES.
PRODUCT_CODE VARCHAR2 (40)
Inventory item code
PRODUCT_CATEGORY VARCHAR2 (240)
Product category code of the transaction line
PRODUCT_DESCRIPTION VARCHAR2 (240)
Description of the inventory item or memo line used on the transaction line
USER_DEFINED_FISC_CLASS VARCHAR2 (30)
User defined fiscal classification code of the transaction line
LINE_AMT NUMBER
Yes Transaction line amount
TRX_LINE_QUANTITY NUMBER

Transaction line quantity
CASH_DISCOUNT NUMBER

Cash discount amount
VOLUME_DISCOUNT NUMBER

Volume discount quantity
TRADING_DISCOUNT NUMBER

Trading discount amount
TRANSFER_CHARGE NUMBER

Transfer charge
TRANSPORTATION_CHARGE NUMBER

Transportation charge
INSURANCE_CHARGE NUMBER

Insurance charge
OTHER_CHARGE NUMBER

Other charge
ASSESSABLE_VALUE NUMBER

Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes
ASSET_FLAG VARCHAR2 (1)
Not currently used
ASSET_NUMBER VARCHAR2 (150)
Not currently used
ASSET_ACCUM_DEPRECIATION NUMBER

Not currently used
ASSET_TYPE VARCHAR2 (150)
Not currently used
ASSET_COST NUMBER

Not currently used
RELATED_DOC_APPLICATION_ID NUMBER

Related document application identifier
RELATED_DOC_ENTITY_CODE VARCHAR2 (30)
Related document entity code
RELATED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Related document event class code
RELATED_DOC_TRX_ID NUMBER

Primary itransaction dentifier for the related document
REL_DOC_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the user composite key for the uniquely identifying related document
REL_DOC_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the user composite key for the uniquely identifying related document
RELATED_DOC_NUMBER VARCHAR2 (150)
Transaction number for related document
RELATED_DOC_DATE DATE

Related document date
APPLIED_FROM_APPLICATION_ID NUMBER

Applied from document application identifier
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
Applied from document entity code
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
Applied from document event class code
APPLIED_FROM_TRX_ID NUMBER

Applied from document transaction identifier
APP_FROM_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the header level user composite key for uniquely identifying the applied from document
APP_FROM_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the header level user composite key for uniquely identifying the applied from document
APPLIED_FROM_LINE_ID NUMBER

Transaction line identifier for the applied from document
APP_FROM_LIN_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line level user composite key for uniquely identifying the applied from document line
APP_FROM_LIN_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line level user composite key for uniquely identifying the applied from document line
ADJUSTED_DOC_APPLICATION_ID NUMBER

Adjusted document application identifier
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Adjusted document entity code
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Adjusted document event class code
ADJUSTED_DOC_TRX_ID NUMBER

Adjusted document transaction identifier
ADJ_DOC_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the header level user composite key for uniquely identifying the adjusted document
ADJ_DOC_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the header level user composite key for uniquely identifying the adjusted document
ADJUSTED_DOC_LINE_ID NUMBER

Transaction line identifier for the adjusted document
ADJ_DOC_LIN_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line level user composite key for uniquely identifying the adjusted document line
ADJ_DOC_LIN_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line level user composite key for uniquely identifying the adjusted document line
ADJUSTED_DOC_NUMBER VARCHAR2 (150)
Transaction number of the adjusted document
ADJUSTED_DOC_DATE DATE

Adjusted document date
APPLIED_TO_APPLICATION_ID NUMBER

Applied to document application identifier
APPLIED_TO_ENTITY_CODE VARCHAR2 (30)
Applied to document entity code
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 (30)
Applied to document event class code
APPLIED_TO_TRX_ID NUMBER

Applied to document transaction identifier
APP_TO_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the header level user composite key for uniquely identifying the applied to document
APP_TO_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the header level user composite keyfor uniquely identifying the applied to document
APP_TO_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the header level user composite key for uniquely identifying the applied to document
APP_TO_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the header level user composite key for uniquely identifying the applied to document
APP_TO_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the header level user composite key for uniquely identifying the applied to document
APP_TO_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the header level user composite key for uniquely identifying the applied to document
APPLIED_TO_TRX_LINE_ID NUMBER

Transaction line identifier for the applied to document
APP_TO_LIN_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line level user composite key for uniquely identifying the applied to document line
APP_TO_LIN_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line level user composite key for uniquely identifying the applied to document line
APP_TO_LIN_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line level user composite key for uniquely identifying the applied to document line
APP_TO_LIN_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line level user composite key for uniquely identifying the applied to document line
APP_TO_LIN_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line level user composite key for uniquely identifying the applied to document line
APP_TO_LIN_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line level user composite key for uniquely identifying the applied to document line
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
Transaction business category code of the transaction line
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
Tax exemption certificate number
EXEMPT_REASON VARCHAR2 (240)
Tax exemption reason
HISTORICAL_FLAG VARCHAR2 (1)
Y or N represents whether the document or invoice has been upgraded from a prior release or whether it has been newly created.
TRX_LINE_GL_DATE DATE

Accounting date for the transaction line
LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2 (1) Yes Lookup code to indicate whether any tax is included in the transaction line amount and unit price. Possible values are A, N, S and I.
ACCOUNT_CCID NUMBER

Account identifier
ACCOUNT_STRING VARCHAR2 (2000)
Column to store concatanated account string value
MERCHANT_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for merchant party of the transaction line
HQ_ESTB_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for HQ establishment of the transaction line
NUMERIC1 NUMBER

Not currently used
NUMERIC2 NUMBER

Not currently used
NUMERIC3 NUMBER

Not currently used
NUMERIC4 NUMBER

Not currently used
NUMERIC5 NUMBER

Not currently used
NUMERIC6 NUMBER

Not currently used
NUMERIC7 NUMBER

Not currently used
NUMERIC8 NUMBER

Not currently used
NUMERIC9 NUMBER

Not currently used
NUMERIC10 NUMBER

Not currently used
CHAR1 VARCHAR2 (150)
Not currently used
CHAR2 VARCHAR2 (150)
Not currently used
CHAR3 VARCHAR2 (150)
Not currently used
CHAR4 VARCHAR2 (150)
Not currently used
CHAR5 VARCHAR2 (150)
Not currently used
CHAR6 VARCHAR2 (150)
Not currently used
CHAR7 VARCHAR2 (150)
Not currently used
CHAR8 VARCHAR2 (150)
Not currently used
CHAR9 VARCHAR2 (150)
Not currently used
CHAR10 VARCHAR2 (150)
Not currently used
DATE1 DATE

Not currently used
DATE2 DATE

Not currently used
DATE3 DATE

Not currently used
DATE4 DATE

Not currently used
DATE5 DATE

Not currently used
DATE6 DATE

Not currently used
DATE7 DATE

Not currently used
DATE8 DATE

Not currently used
DATE9 DATE

Not currently used
DATE10 DATE

Not currently used
MERCHANT_PARTY_NAME VARCHAR2 (150)
Merchant party name recorded for the Payables expense report
MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 (150)
Merchant party document number recorded for the Payables expense report
MERCHANT_PARTY_REFERENCE VARCHAR2 (250)
Merchant party reference recorded for the Payables expense report
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 (150)
Merchant party taxpayer ID recorded for the Payables expense report
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 (150)
Merchant party tax registration number recorded for the Payables expense report
MERCHANT_PARTY_ID NUMBER

Merchant party identifier recorded for the Payables expense report
MERCHANT_PARTY_COUNTRY VARCHAR2 (150)
Merchant party country code
SHIP_TO_LOCATION_ID NUMBER

Ship to location identifier
SHIP_FROM_LOCATION_ID NUMBER

Ship from location identifier
POA_LOCATION_ID NUMBER

Point of Acceptance location identifier
POO_LOCATION_ID NUMBER

Point of Origin location identifier
BILL_TO_LOCATION_ID NUMBER

Bill to location identifier
BILL_FROM_LOCATION_ID NUMBER

Bill from location identifier
PAYING_LOCATION_ID NUMBER

Not currently used
OWN_HQ_LOCATION_ID NUMBER

Not currently used
TRADING_HQ_LOCATION_ID NUMBER

Not currently used
POC_LOCATION_ID NUMBER

Not currently used
POI_LOCATION_ID NUMBER

Not currently used
POD_LOCATION_ID NUMBER

Not currently used
TITLE_TRANSFER_LOCATION_ID NUMBER

Not currently used
SHIP_TO_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for ship to party of the transaction line
SHIP_FROM_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for ship from party of the transaction line
POA_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for point of acceptance party of the transaction line
POO_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for point of origin party of the transaction line
PAYING_PARTY_TAX_PROF_ID NUMBER

Not currently used
OWN_HQ_PARTY_TAX_PROF_ID NUMBER

Not currently used
TRADING_HQ_PARTY_TAX_PROF_ID NUMBER

Not currently used
POI_PARTY_TAX_PROF_ID NUMBER

Not currently used
POD_PARTY_TAX_PROF_ID NUMBER

Not currently used
BILL_TO_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for bill to party of the transaction line
BILL_FROM_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for bill from party of the transaction line
TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER

Not currently used
SHIP_TO_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for ship to party site of the transaction line
SHIP_FROM_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for ship from party site of the transaction line
POA_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for point of acceptance party site of the transaction line
POO_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for point of origin party site of the transaction line
PAYING_SITE_TAX_PROF_ID NUMBER

Not currently used
OWN_HQ_SITE_TAX_PROF_ID NUMBER

Not currently used
TRADING_HQ_SITE_TAX_PROF_ID NUMBER

Not currently used
POI_SITE_TAX_PROF_ID NUMBER

Not currently used
POD_SITE_TAX_PROF_ID NUMBER

Not currently used
BILL_TO_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for bill to party site of the transaction line
BILL_FROM_SITE_TAX_PROF_ID NUMBER

Party tax profile identifier for bill from party site of the transaction line
TITLE_TRANS_SITE_TAX_PROF_ID NUMBER

Not currently used
CTRL_HDR_TX_APPL_FLAG VARCHAR2 (1)
Y or N indicates whether the control amount for the total tax amount is available at the header level
CTRL_TOTAL_LINE_TX_AMT NUMBER

Control amount for the total tax amount at the line level
CTRL_TOTAL_HDR_TX_AMT NUMBER

Control amount at the header level for the total tax amount
REF_DOC_APPLICATION_ID NUMBER

Reference document application identifier
REF_DOC_ENTITY_CODE VARCHAR2 (30)
Reference document entity code
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Reference document event class code
REF_DOC_TRX_ID NUMBER

Reference document transaction identifier
REF_DOC_HDR_TRX_USER_KEY1 VARCHAR2 (150)
First component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the header level user composite key for uniquely identifying the reference document
REF_DOC_HDR_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the header level user composite key for uniquely identifying the reference document
REF_DOC_LINE_ID NUMBER

Transaction line identifier for the reference document
REF_DOC_LIN_TRX_USER_KEY1 VARCHAR2 (150)
First component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY2 VARCHAR2 (150)
Second component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY3 VARCHAR2 (150)
Third component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY4 VARCHAR2 (150)
Fourth component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY5 VARCHAR2 (150)
Fifth component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LIN_TRX_USER_KEY6 VARCHAR2 (150)
Sixth component of the line level user composite key for uniquely identifying the reference document line
REF_DOC_LINE_QUANTITY NUMBER

Reference document line quantity
LINE_CLASS VARCHAR2 (30)
Column to store event class for the transaction line
TRX_LINE_DATE DATE

Transaction line date
INPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (50)
Tax classifiation code for Procure To Pay products
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (50)
Tax classifiation code for Order To Cash products
INTERNAL_ORG_LOCATION_ID NUMBER

Internal organization location identifier of the transaction
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PORT_OF_ENTRY_CODE VARCHAR2 (30)
Port of entry code
TAX_REPORTING_FLAG VARCHAR2 (1)
Tax reporting flag for lease management
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
Y or N indicates if the transaction line amount includes tax amount
COMPOUNDING_TAX_FLAG VARCHAR2 (1)
Y or N indicates if one of the taxes is compounded with another tax for the transaction line
TRX_ID_LEVEL5 NUMBER

Transaction identifier at a level between trx_id_level4 and trx_line_id
TRX_ID_LEVEL2 NUMBER

Transaction identifier at a level between trx_id and trx_line_id
TRX_ID_LEVEL3 NUMBER

Transaction identifier at a level between trx_id_level2 and trx_line_id
TRX_ID_LEVEL4 NUMBER

Transaction identifier at a level between trx_id_level3 and trx_line_id
EVENT_ID NUMBER (15)
Unique identifier of a specific event that triggers call to a tax processing API. This value will be stamped on all transaction lines passed as input during that API call.
THRESHOLD_INDICATOR_FLAG VARCHAR2 (1)
Y or N indicates if there are thresholds applied at the document level or not. This column is used for supporting integration with third party tax vendors.
PROVNL_TAX_DETERMINATION_DATE DATE

Transaction date of the original transaction in case of lease management when a lease contract is revised
UNIT_PRICE NUMBER

Unit Price of the transaction line item or product
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER

Column to record ship to customer account site use identifier for Receivables.
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER

Column to record bill to customer account site use identifier for Receivables
TRX_BATCH_ID NUMBER (15)
Transaction batch identifier
APPLIED_TO_TRX_NUMBER VARCHAR2 (150)
Applied to document transaction number
START_EXPENSE_DATE DATE

Start expense date of a Payables Invoice distribution
SOURCE_APPLICATION_ID NUMBER

Source document application identifier
SOURCE_ENTITY_CODE VARCHAR2 (30)
Source document entity code
SOURCE_EVENT_CLASS_CODE VARCHAR2 (30)
Source document event class code
SOURCE_TRX_ID NUMBER

Source document transaction identifier
SOURCE_LINE_ID NUMBER

Source document transaction line identifier
SOURCE_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the source document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
RECORD_TYPE_CODE VARCHAR2 (30) Yes Lookup code to indicate whether the record is migrated, seeded or defined by the user
REF_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the reference document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
APPLIED_TO_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the applied to document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2 (30)
ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
INCLUSIVE_TAX_OVERRIDE_FLAG VARCHAR2 (1)
Y or N indicates whether any system determined inclusive tax line is updated or overridden by the user for this transaction line
TAX_PROCESSING_COMPLETED_FLAG VARCHAR2 (1)
Y or N indicates whether the tax calculation is pending for this transaction line
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
APPLICATION_DOC_STATUS VARCHAR2 (30)
Transaction status as stored by the application
USER_UPD_DET_FACTORS_FLAG VARCHAR2 (1)
SOURCE_TAX_LINE_ID NUMBER

Column to record source document tax line identifier that is represented by the current transaction line for billing purposes
REVERSED_APPLN_ID NUMBER

Reversed transaction application Identifier
REVERSED_ENTITY_CODE VARCHAR2 (30)
Reversed transaction entity code
REVERSED_EVNT_CLS_CODE VARCHAR2 (30)
Reversed transaction event class code
REVERSED_TRX_ID NUMBER

Reversed transaction identifier
REVERSED_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the reversed transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
REVERSED_TRX_LINE_ID NUMBER

Reversed transaction line identifier
TAX_CALCULATION_DONE_FLAG VARCHAR2 (1)
Y or N indicates whether the taxes have been determined for this transaction line previously
APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
Transaction number of the applied from document
PARTNER_MIGRATED_FLAG VARCHAR2 (1)
Y or N indicates if the transaction is migrated to third party tax vendor repository. Null for newly created transactions.
SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER

Column to record ship to customer account site identifier for Receivables or ship from supplier site identifier for Payables
BILL_THIRD_PTY_ACCT_SITE_ID NUMBER

Column to record bill to customer account site identifier for Receivables or bill from supplier site identifier for Payables
SHIP_THIRD_PTY_ACCT_ID NUMBER

Column to record ship to customer account identifier for Receivables or ship from supplier identifier for Payables
BILL_THIRD_PTY_ACCT_ID NUMBER

Column to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables
EXEMPTION_CONTROL_FLAG VARCHAR2 (1)
Lookup code to control the application of exemptions to the transaction line during tax lines calculation. Possible values are R, S and E.
EXEMPT_REASON_CODE VARCHAR2 (30)
Exemption reason code
INTERFACE_ENTITY_CODE VARCHAR2 (30)
Column to temporarily store entity code of the transaction line interface table
INTERFACE_LINE_ID NUMBER

Column to temporarily store identifier of the interface line corresponding to the transaction line during import of transactions into Receivables
DEFAULTING_ATTRIBUTE1 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE2 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE3 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE4 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE5 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE6 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE7 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE8 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE9 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
DEFAULTING_ATTRIBUTE10 VARCHAR2 (150)
Attribute used in rules for defaulting one of the tax determining factors
TRX_ID_LEVEL6 NUMBER

Transaction identifier at a level between trx_id_level5 and trx_line_id
HISTORICAL_TAX_CODE_ID NUMBER (15)
Tax classification code identifier stored on the historical transactions
ICX_SESSION_ID NUMBER (15)
ICX user session identifier
TRX_LINE_CURRENCY_CODE VARCHAR2 (15)
Transaction line currency code
TRX_LINE_CURRENCY_CONV_RATE NUMBER

Transaction line exchange rate
TRX_LINE_CURRENCY_CONV_DATE DATE

Transaction line date of the exchange rate
TRX_LINE_PRECISION NUMBER

Precision of the transaction line currency
TRX_LINE_MAU NUMBER

Minimum accountable unit of the transaction line currency
TRX_LINE_CURRENCY_CONV_TYPE VARCHAR2 (30)
Transaction line exchange rate type
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
TOTAL_INC_TAX_AMT NUMBER

Query Text

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


SELECT INTERNAL_ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_CLASS_MAPPING_ID
,      EVENT_TYPE_CODE
,      DOC_EVENT_STATUS
,      LINE_LEVEL_ACTION
,      TRX_ID
,      TRX_LINE_ID
,      TRX_LEVEL_TYPE
,      HDR_TRX_USER_KEY1
,      HDR_TRX_USER_KEY2
,      HDR_TRX_USER_KEY3
,      HDR_TRX_USER_KEY4
,      HDR_TRX_USER_KEY5
,      HDR_TRX_USER_KEY6
,      LINE_TRX_USER_KEY1
,      LINE_TRX_USER_KEY2
,      LINE_TRX_USER_KEY3
,      LINE_TRX_USER_KEY4
,      LINE_TRX_USER_KEY5
,      LINE_TRX_USER_KEY6
,      TRX_DATE
,      TRX_DOC_REVISION
,      LEDGER_ID
,      TRX_CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      LEGAL_ENTITY_ID
,      ESTABLISHMENT_ID
,      RECEIVABLES_TRX_TYPE_ID
,      DEFAULT_TAXATION_COUNTRY
,      TRX_NUMBER
,      TRX_LINE_NUMBER
,      TRX_LINE_DESCRIPTION
,      TRX_DESCRIPTION
,      TRX_COMMUNICATED_DATE
,      BATCH_SOURCE_ID
,      BATCH_SOURCE_NAME
,      DOC_SEQ_ID
,      DOC_SEQ_NAME
,      DOC_SEQ_VALUE
,      TRX_DUE_DATE
,      TRX_TYPE_DESCRIPTION
,      DOCUMENT_SUB_TYPE
,      SUPPLIER_TAX_INVOICE_NUMBER
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_EXCHANGE_RATE
,      TAX_INVOICE_DATE
,      TAX_INVOICE_NUMBER
,      FIRST_PTY_ORG_ID
,      TAX_EVENT_CLASS_CODE
,      TAX_EVENT_TYPE_CODE
,      RDNG_SHIP_TO_PTY_TX_PROF_ID
,      RDNG_SHIP_FROM_PTY_TX_PROF_ID
,      RDNG_BILL_TO_PTY_TX_PROF_ID
,      RDNG_BILL_FROM_PTY_TX_PROF_ID
,      RDNG_SHIP_TO_PTY_TX_P_ST_ID
,      RDNG_SHIP_FROM_PTY_TX_P_ST_ID
,      RDNG_BILL_TO_PTY_TX_P_ST_ID
,      RDNG_BILL_FROM_PTY_TX_P_ST_ID
,      LINE_INTENDED_USE
,      TRX_LINE_TYPE
,      TRX_SHIPPING_DATE
,      TRX_RECEIPT_DATE
,      TRX_SIC_CODE
,      FOB_POINT
,      TRX_WAYBILL_NUMBER
,      PRODUCT_ID
,      PRODUCT_FISC_CLASSIFICATION
,      PRODUCT_ORG_ID
,      UOM_CODE
,      PRODUCT_TYPE
,      PRODUCT_CODE
,      PRODUCT_CATEGORY
,      PRODUCT_DESCRIPTION
,      USER_DEFINED_FISC_CLASS
,      LINE_AMT
,      TRX_LINE_QUANTITY
,      CASH_DISCOUNT
,      VOLUME_DISCOUNT
,      TRADING_DISCOUNT
,      TRANSFER_CHARGE
,      TRANSPORTATION_CHARGE
,      INSURANCE_CHARGE
,      OTHER_CHARGE
,      ASSESSABLE_VALUE
,      ASSET_FLAG
,      ASSET_NUMBER
,      ASSET_ACCUM_DEPRECIATION
,      ASSET_TYPE
,      ASSET_COST
,      RELATED_DOC_APPLICATION_ID
,      RELATED_DOC_ENTITY_CODE
,      RELATED_DOC_EVENT_CLASS_CODE
,      RELATED_DOC_TRX_ID
,      REL_DOC_HDR_TRX_USER_KEY1
,      REL_DOC_HDR_TRX_USER_KEY2
,      REL_DOC_HDR_TRX_USER_KEY3
,      REL_DOC_HDR_TRX_USER_KEY4
,      REL_DOC_HDR_TRX_USER_KEY5
,      REL_DOC_HDR_TRX_USER_KEY6
,      RELATED_DOC_NUMBER
,      RELATED_DOC_DATE
,      APPLIED_FROM_APPLICATION_ID
,      APPLIED_FROM_ENTITY_CODE
,      APPLIED_FROM_EVENT_CLASS_CODE
,      APPLIED_FROM_TRX_ID
,      APP_FROM_HDR_TRX_USER_KEY1
,      APP_FROM_HDR_TRX_USER_KEY2
,      APP_FROM_HDR_TRX_USER_KEY3
,      APP_FROM_HDR_TRX_USER_KEY4
,      APP_FROM_HDR_TRX_USER_KEY5
,      APP_FROM_HDR_TRX_USER_KEY6
,      APPLIED_FROM_LINE_ID
,      APP_FROM_LIN_TRX_USER_KEY1
,      APP_FROM_LIN_TRX_USER_KEY2
,      APP_FROM_LIN_TRX_USER_KEY3
,      APP_FROM_LIN_TRX_USER_KEY4
,      APP_FROM_LIN_TRX_USER_KEY5
,      APP_FROM_LIN_TRX_USER_KEY6
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      ADJ_DOC_HDR_TRX_USER_KEY1
,      ADJ_DOC_HDR_TRX_USER_KEY2
,      ADJ_DOC_HDR_TRX_USER_KEY3
,      ADJ_DOC_HDR_TRX_USER_KEY4
,      ADJ_DOC_HDR_TRX_USER_KEY5
,      ADJ_DOC_HDR_TRX_USER_KEY6
,      ADJUSTED_DOC_LINE_ID
,      ADJ_DOC_LIN_TRX_USER_KEY1
,      ADJ_DOC_LIN_TRX_USER_KEY2
,      ADJ_DOC_LIN_TRX_USER_KEY3
,      ADJ_DOC_LIN_TRX_USER_KEY4
,      ADJ_DOC_LIN_TRX_USER_KEY5
,      ADJ_DOC_LIN_TRX_USER_KEY6
,      ADJUSTED_DOC_NUMBER
,      ADJUSTED_DOC_DATE
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_EVENT_CLASS_CODE
,      APPLIED_TO_TRX_ID
,      APP_TO_HDR_TRX_USER_KEY1
,      APP_TO_HDR_TRX_USER_KEY2
,      APP_TO_HDR_TRX_USER_KEY3
,      APP_TO_HDR_TRX_USER_KEY4
,      APP_TO_HDR_TRX_USER_KEY5
,      APP_TO_HDR_TRX_USER_KEY6
,      APPLIED_TO_TRX_LINE_ID
,      APP_TO_LIN_TRX_USER_KEY1
,      APP_TO_LIN_TRX_USER_KEY2
,      APP_TO_LIN_TRX_USER_KEY3
,      APP_TO_LIN_TRX_USER_KEY4
,      APP_TO_LIN_TRX_USER_KEY5
,      APP_TO_LIN_TRX_USER_KEY6
,      TRX_BUSINESS_CATEGORY
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      HISTORICAL_FLAG
,      TRX_LINE_GL_DATE
,      LINE_AMT_INCLUDES_TAX_FLAG
,      ACCOUNT_CCID
,      ACCOUNT_STRING
,      MERCHANT_PARTY_TAX_PROF_ID
,      HQ_ESTB_PARTY_TAX_PROF_ID
,      NUMERIC1
,      NUMERIC2
,      NUMERIC3
,      NUMERIC4
,      NUMERIC5
,      NUMERIC6
,      NUMERIC7
,      NUMERIC8
,      NUMERIC9
,      NUMERIC10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      CHAR10
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      DATE9
,      DATE10
,      MERCHANT_PARTY_NAME
,      MERCHANT_PARTY_DOCUMENT_NUMBER
,      MERCHANT_PARTY_REFERENCE
,      MERCHANT_PARTY_TAXPAYER_ID
,      MERCHANT_PARTY_TAX_REG_NUMBER
,      MERCHANT_PARTY_ID
,      MERCHANT_PARTY_COUNTRY
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_LOCATION_ID
,      POA_LOCATION_ID
,      POO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      BILL_FROM_LOCATION_ID
,      PAYING_LOCATION_ID
,      OWN_HQ_LOCATION_ID
,      TRADING_HQ_LOCATION_ID
,      POC_LOCATION_ID
,      POI_LOCATION_ID
,      POD_LOCATION_ID
,      TITLE_TRANSFER_LOCATION_ID
,      SHIP_TO_PARTY_TAX_PROF_ID
,      SHIP_FROM_PARTY_TAX_PROF_ID
,      POA_PARTY_TAX_PROF_ID
,      POO_PARTY_TAX_PROF_ID
,      PAYING_PARTY_TAX_PROF_ID
,      OWN_HQ_PARTY_TAX_PROF_ID
,      TRADING_HQ_PARTY_TAX_PROF_ID
,      POI_PARTY_TAX_PROF_ID
,      POD_PARTY_TAX_PROF_ID
,      BILL_TO_PARTY_TAX_PROF_ID
,      BILL_FROM_PARTY_TAX_PROF_ID
,      TITLE_TRANS_PARTY_TAX_PROF_ID
,      SHIP_TO_SITE_TAX_PROF_ID
,      SHIP_FROM_SITE_TAX_PROF_ID
,      POA_SITE_TAX_PROF_ID
,      POO_SITE_TAX_PROF_ID
,      PAYING_SITE_TAX_PROF_ID
,      OWN_HQ_SITE_TAX_PROF_ID
,      TRADING_HQ_SITE_TAX_PROF_ID
,      POI_SITE_TAX_PROF_ID
,      POD_SITE_TAX_PROF_ID
,      BILL_TO_SITE_TAX_PROF_ID
,      BILL_FROM_SITE_TAX_PROF_ID
,      TITLE_TRANS_SITE_TAX_PROF_ID
,      CTRL_HDR_TX_APPL_FLAG
,      CTRL_TOTAL_LINE_TX_AMT
,      CTRL_TOTAL_HDR_TX_AMT
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      REF_DOC_HDR_TRX_USER_KEY1
,      REF_DOC_HDR_TRX_USER_KEY2
,      REF_DOC_HDR_TRX_USER_KEY3
,      REF_DOC_HDR_TRX_USER_KEY4
,      REF_DOC_HDR_TRX_USER_KEY5
,      REF_DOC_HDR_TRX_USER_KEY6
,      REF_DOC_LINE_ID
,      REF_DOC_LIN_TRX_USER_KEY1
,      REF_DOC_LIN_TRX_USER_KEY2
,      REF_DOC_LIN_TRX_USER_KEY3
,      REF_DOC_LIN_TRX_USER_KEY4
,      REF_DOC_LIN_TRX_USER_KEY5
,      REF_DOC_LIN_TRX_USER_KEY6
,      REF_DOC_LINE_QUANTITY
,      LINE_CLASS
,      TRX_LINE_DATE
,      INPUT_TAX_CLASSIFICATION_CODE
,      OUTPUT_TAX_CLASSIFICATION_CODE
,      INTERNAL_ORG_LOCATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PORT_OF_ENTRY_CODE
,      TAX_REPORTING_FLAG
,      TAX_AMT_INCLUDED_FLAG
,      COMPOUNDING_TAX_FLAG
,      TRX_ID_LEVEL5
,      TRX_ID_LEVEL2
,      TRX_ID_LEVEL3
,      TRX_ID_LEVEL4
,      EVENT_ID
,      THRESHOLD_INDICATOR_FLAG
,      PROVNL_TAX_DETERMINATION_DATE
,      UNIT_PRICE
,      SHIP_TO_CUST_ACCT_SITE_USE_ID
,      BILL_TO_CUST_ACCT_SITE_USE_ID
,      TRX_BATCH_ID
,      APPLIED_TO_TRX_NUMBER
,      START_EXPENSE_DATE
,      SOURCE_APPLICATION_ID
,      SOURCE_ENTITY_CODE
,      SOURCE_EVENT_CLASS_CODE
,      SOURCE_TRX_ID
,      SOURCE_LINE_ID
,      SOURCE_TRX_LEVEL_TYPE
,      RECORD_TYPE_CODE
,      REF_DOC_TRX_LEVEL_TYPE
,      APPLIED_TO_TRX_LEVEL_TYPE
,      APPLIED_FROM_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      INCLUSIVE_TAX_OVERRIDE_FLAG
,      TAX_PROCESSING_COMPLETED_FLAG
,      OBJECT_VERSION_NUMBER
,      APPLICATION_DOC_STATUS
,      USER_UPD_DET_FACTORS_FLAG
,      SOURCE_TAX_LINE_ID
,      REVERSED_APPLN_ID
,      REVERSED_ENTITY_CODE
,      REVERSED_EVNT_CLS_CODE
,      REVERSED_TRX_ID
,      REVERSED_TRX_LEVEL_TYPE
,      REVERSED_TRX_LINE_ID
,      TAX_CALCULATION_DONE_FLAG
,      APPLIED_FROM_TRX_NUMBER
,      PARTNER_MIGRATED_FLAG
,      SHIP_THIRD_PTY_ACCT_SITE_ID
,      BILL_THIRD_PTY_ACCT_SITE_ID
,      SHIP_THIRD_PTY_ACCT_ID
,      BILL_THIRD_PTY_ACCT_ID
,      EXEMPTION_CONTROL_FLAG
,      EXEMPT_REASON_CODE
,      INTERFACE_ENTITY_CODE
,      INTERFACE_LINE_ID
,      DEFAULTING_ATTRIBUTE1
,      DEFAULTING_ATTRIBUTE2
,      DEFAULTING_ATTRIBUTE3
,      DEFAULTING_ATTRIBUTE4
,      DEFAULTING_ATTRIBUTE5
,      DEFAULTING_ATTRIBUTE6
,      DEFAULTING_ATTRIBUTE7
,      DEFAULTING_ATTRIBUTE8
,      DEFAULTING_ATTRIBUTE9
,      DEFAULTING_ATTRIBUTE10
,      TRX_ID_LEVEL6
,      HISTORICAL_TAX_CODE_ID
,      ICX_SESSION_ID
,      TRX_LINE_CURRENCY_CODE
,      TRX_LINE_CURRENCY_CONV_RATE
,      TRX_LINE_CURRENCY_CONV_DATE
,      TRX_LINE_PRECISION
,      TRX_LINE_MAU
,      TRX_LINE_CURRENCY_CONV_TYPE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE_CATEGORY
,      TOTAL_INC_TAX_AMT
FROM ZX.ZX_LINES_DET_FACTORS;

Dependencies

[top of page]

ZX.ZX_LINES_DET_FACTORS does not reference any database object

ZX.ZX_LINES_DET_FACTORS is referenced by following:

SchemaAPPS
SynonymZX_LINES_DET_FACTORS
SynonymZX_LINES_DET_FACTORS_TMP