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

TABLE: ZX.ZX_TRANSACTION_LINES_GT

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

Temporary Table Details

ZX.ZX_TRANSACTION_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
ZX_TRANSACTION_LINES_GT_U1 NORMAL UNIQUE Tablespace ColumnAPPLICATION_ID
ColumnENTITY_CODE
ColumnEVENT_CLASS_CODE
ColumnTRX_ID
ColumnTRX_LINE_ID
ColumnTRX_LEVEL_TYPE
Columns
Name Datatype Length Mandatory Comments
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
TRX_ID NUMBER

Primary transaction 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.
TRX_LINE_ID NUMBER

Transaction line identifier
LINE_LEVEL_ACTION VARCHAR2 (30) Yes Column to store action at the transaction line level
LINE_CLASS VARCHAR2 (30)
Column to store event class for the transaction line
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_LINE_TYPE VARCHAR2 (30)
Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC.
TRX_LINE_DATE DATE

Transaction line date
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
Transaction business category code of the transaction line
LINE_INTENDED_USE VARCHAR2 (240)
Intended use code of the transaction line. This identifies the purpose for which the product is used.
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
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
Tax exemption certificate number
EXEMPT_REASON VARCHAR2 (240)
Tax exemption reason
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
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
TRX_SIC_CODE VARCHAR2 (150)
Standard industry classification code of the transaction
FOB_POINT VARCHAR2 (30)
Free on Board point
SHIP_TO_PARTY_ID NUMBER

Ship to party identifier
SHIP_FROM_PARTY_ID NUMBER

Ship from party identifier
POA_PARTY_ID NUMBER

Point of acceptance party identifier
POO_PARTY_ID NUMBER

Point of origin party identifier
BILL_TO_PARTY_ID NUMBER

Bill to party identifier
BILL_FROM_PARTY_ID NUMBER

Bill from party identifier
MERCHANT_PARTY_ID NUMBER

Merchant party identifier recorded for the Payables expense report
SHIP_TO_PARTY_SITE_ID NUMBER

Ship to party site identifier
SHIP_FROM_PARTY_SITE_ID NUMBER

Ship from party site identifier
POA_PARTY_SITE_ID NUMBER

Point of acceptance party site identifier
POO_PARTY_SITE_ID NUMBER

Point of origin party site identifier
BILL_TO_PARTY_SITE_ID NUMBER

Bill to party site identifier
BILL_FROM_PARTY_SITE_ID NUMBER

Bill from party site identifier
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
ACCOUNT_CCID NUMBER

Account identifier
ACCOUNT_STRING VARCHAR2 (2000)
Column to store concatanated account string value
MERCHANT_PARTY_COUNTRY VARCHAR2 (150)
Merchant party country code
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
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_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
TRX_ID_LEVEL5 NUMBER

Transaction identifier at a level between trx_id_level4 and trx_line_id
TRX_ID_LEVEL6 NUMBER

Transaction identifier at a level between trx_id_level5 and trx_line_id
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_LINE_NUMBER NUMBER

Transaction line number
TRX_LINE_DESCRIPTION VARCHAR2 (240)
Description for the transaction line
PRODUCT_DESCRIPTION VARCHAR2 (240)
Description of the inventory item or memo line used on the transaction line
TRX_WAYBILL_NUMBER VARCHAR2 (50)
Waybill number of the transaction
TRX_LINE_GL_DATE DATE

Accounting date for the transaction line
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
PAYING_PARTY_ID NUMBER

Not currently used
OWN_HQ_PARTY_ID NUMBER

Not currently used
TRADING_HQ_PARTY_ID NUMBER

Not currently used
POI_PARTY_ID NUMBER

Not currently used
POD_PARTY_ID NUMBER

Not currently used
TITLE_TRANSFER_PARTY_ID NUMBER

Not currently used
PAYING_PARTY_SITE_ID NUMBER

Not currently used
OWN_HQ_PARTY_SITE_ID NUMBER

Not currently used
TRADING_HQ_PARTY_SITE_ID NUMBER

Not currently used
POI_PARTY_SITE_ID NUMBER

Not currently used
POD_PARTY_SITE_ID NUMBER

Not currently used
TITLE_TRANSFER_PARTY_SITE_ID NUMBER

Not currently used
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
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
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
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
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
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.
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.
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
INPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax classifiation code for Procure To Pay products
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (50)
Tax classifiation code for Order To Cash products
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.
UNIT_PRICE NUMBER

Unit Price of the transaction line item or product
START_EXPENSE_DATE DATE

Start expense date of a Payables Invoice distribution
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)
Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
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.
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
SOURCE_TAX_LINE_ID NUMBER

Column to record source document tax line identifier that is represented by the current transaction line for billing purposes
APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
Transaction number of the applied from document
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.
APPLIED_TO_TRX_NUMBER VARCHAR2 (150)
Applied to document transaction number
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
HISTORICAL_TAX_CODE_ID NUMBER (15)
Tax classification code identifier stored on the historical transactions
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_CURRENCY_CONV_TYPE VARCHAR2 (30)
Transaction line exchange rate type
TRX_LINE_MAU NUMBER

Minimum accountable unit of the transaction line currency
TRX_LINE_PRECISION NUMBER

Precision of the transaction line currency
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER

Column to record bill to customer account site use identifier for Receivables
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER

Column to record ship to customer account site use identifier for Receivables.
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
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
RECEIVABLES_TRX_TYPE_ID NUMBER

Transaction type identifier for Receivables transactions
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
USER_UPD_DET_FACTORS_FLAG VARCHAR2 (1)
Y or N indicates whether the user has updated additional tax determining factors like transaction business category, assessable value
TAX_DATE DATE

For internal use only
TAX_DETERMINE_DATE DATE

For internal use only
TAX_POINT_DATE DATE

For internal use only
SUBSCRIPTION_DATE DATE

For internal use only
Query Text

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


SELECT APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_ID
,      TRX_LEVEL_TYPE
,      TRX_LINE_ID
,      LINE_LEVEL_ACTION
,      LINE_CLASS
,      TRX_SHIPPING_DATE
,      TRX_RECEIPT_DATE
,      TRX_LINE_TYPE
,      TRX_LINE_DATE
,      TRX_BUSINESS_CATEGORY
,      LINE_INTENDED_USE
,      USER_DEFINED_FISC_CLASS
,      LINE_AMT
,      TRX_LINE_QUANTITY
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      CASH_DISCOUNT
,      VOLUME_DISCOUNT
,      TRADING_DISCOUNT
,      TRANSFER_CHARGE
,      TRANSPORTATION_CHARGE
,      INSURANCE_CHARGE
,      OTHER_CHARGE
,      PRODUCT_ID
,      PRODUCT_FISC_CLASSIFICATION
,      PRODUCT_ORG_ID
,      UOM_CODE
,      PRODUCT_TYPE
,      PRODUCT_CODE
,      PRODUCT_CATEGORY
,      TRX_SIC_CODE
,      FOB_POINT
,      SHIP_TO_PARTY_ID
,      SHIP_FROM_PARTY_ID
,      POA_PARTY_ID
,      POO_PARTY_ID
,      BILL_TO_PARTY_ID
,      BILL_FROM_PARTY_ID
,      MERCHANT_PARTY_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_FROM_PARTY_SITE_ID
,      POA_PARTY_SITE_ID
,      POO_PARTY_SITE_ID
,      BILL_TO_PARTY_SITE_ID
,      BILL_FROM_PARTY_SITE_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_LOCATION_ID
,      POA_LOCATION_ID
,      POO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      BILL_FROM_LOCATION_ID
,      ACCOUNT_CCID
,      ACCOUNT_STRING
,      MERCHANT_PARTY_COUNTRY
,      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
,      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_ID_LEVEL2
,      TRX_ID_LEVEL3
,      TRX_ID_LEVEL4
,      TRX_ID_LEVEL5
,      TRX_ID_LEVEL6
,      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_LINE_NUMBER
,      TRX_LINE_DESCRIPTION
,      PRODUCT_DESCRIPTION
,      TRX_WAYBILL_NUMBER
,      TRX_LINE_GL_DATE
,      MERCHANT_PARTY_NAME
,      MERCHANT_PARTY_DOCUMENT_NUMBER
,      MERCHANT_PARTY_REFERENCE
,      MERCHANT_PARTY_TAXPAYER_ID
,      MERCHANT_PARTY_TAX_REG_NUMBER
,      PAYING_PARTY_ID
,      OWN_HQ_PARTY_ID
,      TRADING_HQ_PARTY_ID
,      POI_PARTY_ID
,      POD_PARTY_ID
,      TITLE_TRANSFER_PARTY_ID
,      PAYING_PARTY_SITE_ID
,      OWN_HQ_PARTY_SITE_ID
,      TRADING_HQ_PARTY_SITE_ID
,      POI_PARTY_SITE_ID
,      POD_PARTY_SITE_ID
,      TITLE_TRANSFER_PARTY_SITE_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
,      ASSESSABLE_VALUE
,      ASSET_FLAG
,      ASSET_NUMBER
,      ASSET_ACCUM_DEPRECIATION
,      ASSET_TYPE
,      ASSET_COST
,      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
,      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
,      MERCHANT_PARTY_TAX_PROF_ID
,      HQ_ESTB_PARTY_TAX_PROF_ID
,      LINE_AMT_INCLUDES_TAX_FLAG
,      HISTORICAL_FLAG
,      CTRL_HDR_TX_APPL_FLAG
,      CTRL_TOTAL_LINE_TX_AMT
,      INPUT_TAX_CLASSIFICATION_CODE
,      OUTPUT_TAX_CLASSIFICATION_CODE
,      SOURCE_APPLICATION_ID
,      SOURCE_ENTITY_CODE
,      SOURCE_EVENT_CLASS_CODE
,      SOURCE_TRX_ID
,      SOURCE_LINE_ID
,      SOURCE_TRX_LEVEL_TYPE
,      UNIT_PRICE
,      START_EXPENSE_DATE
,      REF_DOC_TRX_LEVEL_TYPE
,      APPLIED_TO_TRX_LEVEL_TYPE
,      APPLIED_FROM_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      DEFAULTING_ATTRIBUTE1
,      DEFAULTING_ATTRIBUTE2
,      DEFAULTING_ATTRIBUTE3
,      DEFAULTING_ATTRIBUTE4
,      DEFAULTING_ATTRIBUTE5
,      DEFAULTING_ATTRIBUTE6
,      DEFAULTING_ATTRIBUTE7
,      DEFAULTING_ATTRIBUTE8
,      DEFAULTING_ATTRIBUTE9
,      DEFAULTING_ATTRIBUTE10
,      SOURCE_TAX_LINE_ID
,      APPLIED_FROM_TRX_NUMBER
,      EXEMPTION_CONTROL_FLAG
,      APPLIED_TO_TRX_NUMBER
,      EXEMPT_REASON_CODE
,      INTERFACE_ENTITY_CODE
,      INTERFACE_LINE_ID
,      HISTORICAL_TAX_CODE_ID
,      TRX_LINE_CURRENCY_CODE
,      TRX_LINE_CURRENCY_CONV_RATE
,      TRX_LINE_CURRENCY_CONV_DATE
,      TRX_LINE_CURRENCY_CONV_TYPE
,      TRX_LINE_MAU
,      TRX_LINE_PRECISION
,      BILL_TO_CUST_ACCT_SITE_USE_ID
,      SHIP_TO_CUST_ACCT_SITE_USE_ID
,      SHIP_THIRD_PTY_ACCT_ID
,      BILL_THIRD_PTY_ACCT_ID
,      SHIP_THIRD_PTY_ACCT_SITE_ID
,      BILL_THIRD_PTY_ACCT_SITE_ID
,      RECEIVABLES_TRX_TYPE_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      USER_UPD_DET_FACTORS_FLAG
,      TAX_DATE
,      TAX_DETERMINE_DATE
,      TAX_POINT_DATE
,      SUBSCRIPTION_DATE
FROM ZX.ZX_TRANSACTION_LINES_GT;

Dependencies

[top of page]

ZX.ZX_TRANSACTION_LINES_GT does not reference any database object

ZX.ZX_TRANSACTION_LINES_GT is referenced by following:

SchemaAPPS
SynonymZX_TRANSACTION_LINES_GT