1. Tables and Views for Financials
  2. ZX_TRANSACTION_LINES

ZX_TRANSACTION_LINES

This table stores Transaction Lines info

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_TRANSACTION_LINES_PK

TRX_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
APPLICATION_ID NUMBER Yes Application Identifier of the transaction Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the application event class for the transaction Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction Active
TRX_LINE_ID NUMBER 18 Yes Transaction line identifier Active
TRX_LINE_NUMBER NUMBER Yes Transaction line number Active
TRX_ID NUMBER 18 Yes Primary transaction identifier Active
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. Active
TRX_LINE_TYPE VARCHAR2 30 Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC. Active
TRX_LINE_DATE DATE Transaction line date Active
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction business category code of the transaction line Active
LINE_INTENDED_USE VARCHAR2 240 Intended use code of the transaction line. This identifies the purpose for which the product is used. Active
USER_DEFINED_FISC_CLASS VARCHAR2 30 User defined fiscal classification code of the transaction line Active
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. Active
LINE_AMT NUMBER Transaction line amount Active
TRX_LINE_QUANTITY NUMBER Transaction line quantity Active
UNIT_PRICE NUMBER Unit Price of the transaction line item or product Active
PRODUCT_ID NUMBER Column to store internal identifier of the inventory item or memo line used on this transaction line. Active
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Product fiscal classification code of the inventory item Active
PRODUCT_ORG_ID NUMBER Identifier of the organization for the inventory item Active
UOM_CODE VARCHAR2 30 Unit of measure code for the inventory item Active
PRODUCT_TYPE VARCHAR2 240 Product type code of the inventory item. Possible values are GOODS and SERVICES. Active
PRODUCT_CODE VARCHAR2 300 Inventory item code Active
PRODUCT_CATEGORY VARCHAR2 240 Product category code of the transaction line Active
MERCHANT_PARTY_ID NUMBER Merchant party identifier recorded for the Payables expense report Active
ACCOUNT_CCID NUMBER Account identifier Active
ACCOUNT_STRING VARCHAR2 2000 Column to store concatanated account string value Active
REF_DOC_LINE_ID NUMBER Transaction line identifier for the reference document Active
REF_DOC_LINE_QUANTITY NUMBER Reference document line quantity Active
REF_DOC_APPLICATION_ID NUMBER Reference document application identifier Active
REF_DOC_ENTITY_CODE VARCHAR2 30 Reference document entity code Active
REF_DOC_EVENT_CLASS_CODE VARCHAR2 30 Reference document event class code Active
REF_DOC_TRX_ID NUMBER Reference document transaction identifier Active
APPLIED_FROM_LINE_ID NUMBER Transaction line identifier for the applied from document Active
APPLIED_FROM_APPLICATION_ID NUMBER Applied from document application identifier Active
APPLIED_FROM_ENTITY_CODE VARCHAR2 30 Applied from document entity code Active
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 30 Applied from document event class code Active
APPLIED_FROM_TRX_ID NUMBER Applied from document transaction identifier Active
ADJUSTED_DOC_LINE_ID NUMBER Transaction line identifier for the adjusted document Active
ADJUSTED_DOC_DATE DATE Adjusted document date Active
ADJUSTED_DOC_APPLICATION_ID NUMBER Adjusted document application identifier Active
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 30 Adjusted document entity code Active
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Adjusted document event class code Active
ADJUSTED_DOC_TRX_ID NUMBER Adjusted document transaction identifier Active
TRX_LINE_DESCRIPTION VARCHAR2 240 Description for the transaction line Active
PRODUCT_DESCRIPTION VARCHAR2 240 Description of the inventory item or memo line used on the transaction line Active
TRX_LINE_GL_DATE DATE Accounting date for the transaction line Active
LINE_LEVEL_ACTION VARCHAR2 30 Yes Column to store action at the transaction line level Active
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. Active
BILL_FROM_PARTY_SITE_ID NUMBER Bill from party site identifier Active
BILL_TO_PARTY_SITE_ID NUMBER Bill to party site identifier Active
SHIP_FROM_PARTY_SITE_ID NUMBER Ship from party site identifier Active
SHIP_TO_PARTY_SITE_ID NUMBER Ship to party site identifier Active
SHIP_TO_PARTY_ID NUMBER Ship to party identifier Active
SHIP_FROM_PARTY_ID NUMBER Ship from party identifier Active
BILL_TO_PARTY_ID NUMBER Bill to party identifier Active
BILL_FROM_PARTY_ID NUMBER Bill from party identifier Active
SHIP_TO_LOCATION_ID NUMBER Ship to location identifier Active
SHIP_FROM_LOCATION_ID NUMBER Ship from location identifier Active
BILL_TO_LOCATION_ID NUMBER Bill to location identifier Active
BILL_FROM_LOCATION_ID NUMBER Bill from location identifier Active
POA_LOCATION_ID NUMBER Point of acceptance location identifier Active
POO_LOCATION_ID NUMBER Point of origin location identifier Active
PAYING_LOCATION_ID NUMBER Not currently used Active
OWN_HQ_LOCATION_ID NUMBER Not currently used Active
TRADING_HQ_LOCATION_ID NUMBER Not currently used Active
POC_LOCATION_ID NUMBER Not currently used Active
POI_LOCATION_ID NUMBER Not currently used Active
POD_LOCATION_ID NUMBER Not currently used Active
TAX_REGIME_ID NUMBER 18 Tax regime identifier Active
TAX_REGIME_CODE VARCHAR2 30 Tax regime code Active
TAX_ID NUMBER 18 Tax identifier Active
TAX VARCHAR2 30 Tax Active
TAX_STATUS_ID NUMBER 18 Tax status identifier Active
TAX_STATUS_CODE VARCHAR2 30 Tax status code Active
TAX_RATE_ID NUMBER 18 Tax rate identifier Active
TAX_RATE_CODE VARCHAR2 50 Tax rate code Active
TAX_RATE NUMBER Tax rate Active
TAX_LINE_AMT NUMBER Tax line amount Active
LINE_CLASS VARCHAR2 30 Column to store event class for the transaction line Active
TRX_SHIPPING_DATE DATE Shipping date of the transaction at header or line level Active
TRX_RECEIPT_DATE DATE Receipt date of the transaction at header or line level Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Tax exemption certificate number Active
EXEMPT_REASON VARCHAR2 240 Tax exemption reason Active
CASH_DISCOUNT NUMBER Cash discount amount Active
VOLUME_DISCOUNT NUMBER Volume discount quantity Active
TRADING_DISCOUNT NUMBER Trading discount amount Active
TRANSFER_CHARGE NUMBER Transfer charge Active
TRANSPORTATION_CHARGE NUMBER Transportation charge Active
INSURANCE_CHARGE NUMBER Insurance charge Active
OTHER_CHARGE NUMBER Other charge Active
POA_PARTY_ID NUMBER Point of acceptance party identifier Active
POO_PARTY_ID NUMBER Point of origin party identifier Active
POA_PARTY_SITE_ID NUMBER Point of acceptance party site identifier Active
POO_PARTY_SITE_ID NUMBER Point of origin party site identifier Active
MERCHANT_PARTY_COUNTRY VARCHAR2 150 Merchant party country code Active
APPLIED_TO_APPLICATION_ID NUMBER Applied to document application identifier Active
APPLIED_TO_ENTITY_CODE VARCHAR2 30 Applied to document entity code Active
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 30 Applied to document event class code Active
APPLIED_TO_TRX_ID NUMBER Applied to document transaction identifier Active
APPLIED_TO_TRX_LINE_ID NUMBER Transaction line identifier for the applied to document Active
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 Active
CTRL_TOTAL_LINE_TX_AMT NUMBER Control amount for the total tax amount at the line level Active
INPUT_TAX_CLASSIFICATION_CODE VARCHAR2 30 Tax classifiation code for Procure To Pay products Active
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax classifiation code for Order To Cash products Active
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. Active
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. Active
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. Active
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. Active
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. Active
EXEMPT_REASON_CODE VARCHAR2 30 Exemption reason code Active
RECEIVABLES_TRX_TYPE_ID NUMBER Transaction type identifier for Receivables transactions Active
RECEIVABLES_TRX_TYPE_SEQ_ID NUMBER Transaction type identifier for Receivables transactions Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ASSESSABLE_VALUE NUMBER Assessable Value Active
PROD_FC_CATEG_ID NUMBER Product fiscal category unique identifier
INTENDED_USE_CLASSIF_ID NUMBER Default intended use code for transactions for a specified country.
SOURCE_APPLICATION_ID NUMBER 18 Source document application identifier.
SOURCE_TRX_ID NUMBER 18 Source document transaction identifier.
SOURCE_LINE_ID NUMBER 18 Source document transaction line identifier.
SOURCE_ENTITY_CODE VARCHAR2 30 Source document entity code.
SOURCE_EVENT_CLASS_CODE VARCHAR2 30 Source document event class code.
SOURCE_TRX_LEVEL_TYPE VARCHAR2 30 Column to record the level at which the source document line identifier is stored.
ADJUSTED_DOC_NUMBER VARCHAR2 150 Adjusted Document Number
APPLIED_FROM_TRX_NUMBER VARCHAR2 150 Applied from Transaction Number
APPLIED_TO_TRX_NUMBER VARCHAR2 150 Applied To Transaction Number
BILL_THIRD_PTY_ACCT_ID NUMBER 18 Third Party Billing Account Identifier
BILL_THIRD_PTY_ACCT_SITE_ID NUMBER 18 Third Party Billing Account Site Identifier
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER 18 Third Party Billing Account Site Usage Identifier
CHAR1 VARCHAR2 150 Extensibility Character Column 1
CHAR2 VARCHAR2 150 Extensibility Character Column 2
CHAR3 VARCHAR2 150 Extensibility Character Column 3
CHAR4 VARCHAR2 150 Extensibility Character Column 4
CHAR5 VARCHAR2 150 Extensibility Character Column 5
CHAR6 VARCHAR2 150 Extensibility Character Column 6
CHAR7 VARCHAR2 150 Extensibility Character Column 7
CHAR8 VARCHAR2 150 Extensibility Character Column 8
CHAR9 VARCHAR2 150 Extensibility Character Column 9
CHAR10 VARCHAR2 150 Extensibility Character Column 9
DATE1 DATE Extensibility Date Column 1
DATE10 DATE Extensibility Date Column 10
DATE2 DATE Extensibility Date Column 2
DATE3 DATE Extensibility Date Column 3
DATE4 DATE Extensibility Date Column 4
DATE5 DATE Extensibility Date Column 5
DATE6 DATE Extensibility Date Column 6
DATE7 DATE Extensibility Date Column 7
DATE8 DATE Extensibility Date Column 8
DATE9 DATE Extensibility Date Column 9
FOB_POINT VARCHAR2 30 Freight Point
MERCHANT_PTY_DOC_NUMBER VARCHAR2 150 Merchant Party Document Number
MERCHANT_PTY_NAME VARCHAR2 150 Merchant Party Name
MERCHANT_PTY_REFERENCE VARCHAR2 250 Merchant Party Reference
MERCHANT_PTY_TAXPAYER_ID VARCHAR2 150 Merchant Party Tax Payer ID
MERCHANT_PTY_TAX_PROF_ID NUMBER 18 Merchant Party Tax Profile ID
MERCHANT_PTY_TAX_REG_NUMBER VARCHAR2 150 Merchant Party Tax Registration Number
NUMERIC1 NUMBER Extensibility Numeric Column 1
NUMERIC10 NUMBER Extensibility Numeric Column 10
NUMERIC2 NUMBER Extensibility Numeric Column 2
NUMERIC3 NUMBER Extensibility Numeric Column 3
NUMERIC4 NUMBER Extensibility Numeric Column 4
NUMERIC5 NUMBER Extensibility Numeric Column 5
NUMERIC6 NUMBER Extensibility Numeric Column 6
NUMERIC7 NUMBER Extensibility Numeric Column 7
NUMERIC8 NUMBER Extensibility Numeric Column 8
NUMERIC9 NUMBER Extensibility Numeric Column 9
START_EXPENSE_DATE DATE Start Expense Date
SHIP_THIRD_PTY_ACCT_ID NUMBER 18 Third Party Shipping Account Identifier
SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER 18 Third Party Shipping Account Site Identifier
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER 18 Third Party Shipping Account Site Use Identifier
TRADING_HQ_PARTY_ID NUMBER 18 Trading HQ Party Idenifier
TRADING_HQ_PARTY_SITE_ID NUMBER 18 Trading HQ Party Site Identifier
TRX_LINE_CURRENCY_CODE VARCHAR2 15 Transaction Line Currency Code
TRX_LINE_CURRENCY_CONV_DATE DATE Transaction Line Currency Conversion date
TRX_LINE_CURRENCY_CONV_RATE NUMBER Transaction Line Currency Conversion rate.
TRX_LINE_CURRENCY_CONV_TYPE VARCHAR2 30 Transaction Line Currency Conversion type.
TRX_LINE_MAU NUMBER Trasaction Line minimum accountable unit.
TRX_LINE_PRECISION NUMBER Transaction Line Precision.
TRX_SIC_CODE VARCHAR2 150 Transaction SIC code
TRX_WAYBILL_NUMBER VARCHAR2 50 Transaction Way Bill Number
TAX_INVOICE_NUMBER VARCHAR2 150 Number of the tax invoice used to meet specific tax reporting requirements of different countries.
TAX_INVOICE_DATE DATE Date of the tax invoice used to meet specific tax reporting requirements of different countries.
WHT_GROUP_ID NUMBER 18 Withholding group identifier for the transaction line.
REQUISITION_TYPE VARCHAR2 25 Requisition type associated a transaction line.
PURCHASING_CATEGORY_ID NUMBER 18 Item category identifier for a transaction line.
DROP_SHIP_FLAG VARCHAR2 1 Yes or No indicates whether a transaction line is a drop ship transaction.
CONSIGNED_FLAG VARCHAR2 1 Yes or No indicates whether a transaction line is consigned.
DESTINATION_TYPE_CODE VARCHAR2 25 Destination type code for a good or service on a transaction line.
CONSIGN_ITM_UPON_RECPT_FLAG VARCHAR2 1 Yes or No indicates a consigned item upon receipt.
EXPENDITURE_TYPE VARCHAR2 30 Project expenditure type used to build accounting flexfield for project-related distribution line.
PORT_OF_DISCHARGE VARCHAR2 150 Location code where a ship voluntarily and without cause of necessity breaks bulk and discharges part or all of its cargo.
PORT_OF_LOADING VARCHAR2 150 Location code where shipments are loaded and secured aboard a vessel.
DELIVERY_TYPE VARCHAR2 30 Delivery type for a good or service on a transaction line.
DOCUMENT_TYPE VARCHAR2 30 Document type for a good or service on a transaction line.
SHIPMENT_TYPE VARCHAR2 25 Shipment type associated with a transaction line.
FOS_TRANSACTION_ID NUMBER 18 Supply chain financial orchestration agreement identifier.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 Final destination location identifier for the purchases made by the customer.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of the manufacture
FINAL_TRANSACTION_NODE_FLAG VARCHAR2 1 Yes or No indicates whether the internal material transfer is backed by an invoice.
CREDIT_ACCOUNT_CCID NUMBER 18 Credit account identifier for the transaction line.
DEBIT_ACCOUNT_CCID NUMBER 18 Debit account identifier for the transaction line.
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
LOAD_STATUS VARCHAR2 30 Enterprise Service Scheduler: indicates the request status of the interface load job that created the row.
LINK_TO_TRX_LINE_ID NUMBER 18 Item line identifier associated with a charge line.
PACKING_CHARGE NUMBER Amount of the packing charge on a transaction.
PURCHASE_BASIS VARCHAR2 30 Monetary value basis of the line type.
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Indicates whether the underlying procure-to-pay transaction allows accrual on receipt. Valid values: Y and N.
LINE_GROUP_ID NUMBER 18 Identifer to group multiple transaction lines together, such as grouping mutiple shipment lines as one fulfillment line.
TRX_APPL_SHORT_NAME VARCHAR2 1000 Application short name of the transaction.
TRX_NUMBER VARCHAR2 150 Alphanumeric identifier on a transaction.
SHIP_TO_PTY_NUMBER VARCHAR2 30 Party number used for shipping merchandise.
SHIP_TO_PTY_NAME VARCHAR2 360 Party name used for shipping merchandise.
SHIP_FROM_PTY_NUMBER VARCHAR2 30 Party number from whom goods are shipped.
SHIP_FROM_PTY_NAME VARCHAR2 360 Party name from whom goods are shipped.
BILL_TO_PTY_NUMBER VARCHAR2 30 Party number that is responsible for receiving and paying the invoice.
BILL_TO_PTY_NAME VARCHAR2 360 Party name that is responsible for receiving and paying the invoice.
BILL_FROM_PTY_NUMBER VARCHAR2 30 Party number that is responsible for sending the invoice.
BILL_FROM_PTY_NAME VARCHAR2 360 Party name that is responsible for sending the invoice.
SHIP_TO_LOCATION_NAME VARCHAR2 240 Location for the place where goods are received from a vendor.
SHIP_FRM_PTY_SITE_CODE VARCHAR2 240 Code for the party site from where goods are shipped.
BILL_TO_LOCATION_NAME VARCHAR2 240 Location for the customer that is responsible for receiving and paying the invoice.
BILL_FRM_PTY_SITE_CODE VARCHAR2 240 Code for the party site that is responsible for sending the invoice.
BATCH_NAME VARCHAR2 240 Batch name to be used in conjunction with transaction number to identify the parent transaction.
DEBIT_ACCT_STRING VARCHAR2 1000 Concatenated accounting flexfield segments associated with the debit account.
CREDIT_ACCT_STRING VARCHAR2 1000 Concatenated accounting flexfield segments associated with the credit account.
ADJ_DOC_LINE_NUMBER NUMBER Numeric identifier of a line on the adjusted document.
ADJ_DOC_NUMBER VARCHAR2 150 Transaction number of the adjusted document.
ADJ_DOC_APP_SHORT_NAME VARCHAR2 1000 Application short name of the adjusted document.
APP_FRM_LINE_NUMBER NUMBER Numeric identifier of a line on the applied from document.
APP_FRM_DOC_NUMBER VARCHAR2 150 Transaction number of the applied from document.
APP_FRM_APPL_SHORT_NAME VARCHAR2 1000 Application short name of the applied from document.
REF_DOC_LINE_NUMBER NUMBER Numeric identifier of a line on the reference document associated with the transaction.
REF_DOC_NUMBER VARCHAR2 150 Transaction number of the reference document associated with the transaction.
REF_DOC_APPL_SHORT_NAME VARCHAR2 1000 Application short name of the reference document associated with the transaction.
FIRST_PTY_REG_NUM VARCHAR2 60 First party tax registration number of the transaction.
FIRST_PTY_REG_ID VARCHAR2 20 First party tax registration ID of the transaction.
THIRD_PTY_REG_NUM VARCHAR2 60 Third party tax registration number of the transaction.
THIRD_PTY_REG_ID VARCHAR2 20 Third party tax registration ID of the transaction.
MATCH_TYPE VARCHAR2 25 Indicates the type of match for Payables transaction. Valid va;ues are purchase order, receipt, or consumption.
SOURCE_TRX_NUMBER VARCHAR2 150 Transacation identifier of the source transaction.
SOURCE_LINE_NUMBER NUMBER 18 Line number of the source transaction.
SOURCE_TRX_DATE DATE Transaction date of the source taxable transaction.
SOURCE_APPL_SHORT_NAME VARCHAR2 1000 Application short name associated with the source transaction.
APP_TO_LINE_NUMBER NUMBER 18 Line number of the receipt that is applied to invoice.
APP_TO_APPL_SHORT_NAME VARCHAR2 1000 Application short name of the receipt that is applied to invoice.
EXPENDITURE_TYPE_ID NUMBER 18 Project expenditure type identifier.
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Country for which the transaction is deemed to have taken place for taxation purposes.
DOCUMENT_SUB_TYPE VARCHAR2 240 Classification used by a tax authority to categorize a document associated with a transaction for a tax.
FINAL_DISCHARGE_LOCATION_CODE VARCHAR2 60 Final destination location code for the purchases made by the customer.
RETAINAGE_AMT NUMBER Retainage amount for the item line.
RETAINAGE_PERCENTAGE NUMBER Retainage percentage for the item line.
TAX_GROSS_NET_FLAG VARCHAR2 1 Transaction tax calculated on the gross or net amount identifier.
WHT_GROSS_NET_FLAG VARCHAR2 1 Withholding tax calculated on the gross or net amount identifier.

Foreign Keys

Table Foreign Table Foreign Key Column
ZX_TRANSACTION_LINES zx_transaction TRX_ID
zx_sim_trx_dists zx_transaction_lines TRX_LINE_ID

Indexes

Index Uniqueness Tablespace Columns Status
ZX_TRANSACTION_LINES_N1 Non Unique FUSION_TS_TX_DATA TRX_ID Active
ZX_TRANSACTION_LINES_U1 Unique FUSION_TS_TX_IDX TRX_LINE_ID Active