1. Tables and Views for Financials
  2. ZX_TRANSACTION_LINES_GT

ZX_TRANSACTION_LINES_GT

This table stores Transaction Lines information

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

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_ID NUMBER 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_ID NUMBER Yes Transaction line identifier Active
LINE_LEVEL_ACTION VARCHAR2 30 Yes Column to store action at the transaction line level 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
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 NUMBER Yes Transaction line amount Active
TRX_LINE_QUANTITY NUMBER Transaction line quantity 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
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
TRX_SIC_CODE VARCHAR2 150 Standard industry classification code of the transaction Active
FOB_POINT VARCHAR2 30 Free on Board point Active
SHIP_TO_PARTY_ID NUMBER Ship to party identifier Active
SHIP_FROM_PARTY_ID NUMBER Ship from party identifier Active
POA_PARTY_ID NUMBER Point of acceptance party identifier Active
POO_PARTY_ID NUMBER Point of origin party identifier Active
BILL_TO_PARTY_ID NUMBER Bill to party identifier Active
BILL_FROM_PARTY_ID NUMBER Bill from party identifier Active
MERCHANT_PARTY_ID NUMBER Merchant party identifier recorded for the Payables expense report Active
SHIP_TO_PARTY_SITE_ID NUMBER Ship to party site identifier Active
SHIP_FROM_PARTY_SITE_ID NUMBER Ship from party site 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
BILL_TO_PARTY_SITE_ID NUMBER Bill to party site identifier Active
BILL_FROM_PARTY_SITE_ID NUMBER Bill from party site identifier Active
SHIP_TO_LOCATION_ID NUMBER Ship to location identifier Active
SHIP_FROM_LOCATION_ID NUMBER Ship from location identifier Active
POA_LOCATION_ID NUMBER Point of Acceptance location identifier Active
POO_LOCATION_ID NUMBER Point of Origin location identifier Active
BILL_TO_LOCATION_ID NUMBER Bill to location identifier Active
BILL_FROM_LOCATION_ID NUMBER Bill from location identifier Active
ACCOUNT_CCID NUMBER Account identifier Active
ACCOUNT_STRING VARCHAR2 2000 Column to store concatanated account string value Active
MERCHANT_PARTY_COUNTRY VARCHAR2 150 Merchant party country code 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
REF_DOC_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_LINE_ID NUMBER Transaction line identifier for the reference document Active
REF_DOC_LIN_TRX_USER_KEY1 VARCHAR2 150 First component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY2 VARCHAR2 150 Second component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY3 VARCHAR2 150 Third component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LINE_QUANTITY NUMBER Reference document line quantity 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
APP_FROM_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the applied from document Active
APPLIED_FROM_LINE_ID NUMBER Transaction line identifier for the applied from document Active
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 Active
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 Active
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 Active
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 Active
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 Active
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 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
ADJ_DOC_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the adjusted document Active
ADJUSTED_DOC_LINE_ID NUMBER Transaction line identifier for the adjusted document Active
ADJ_DOC_LIN_TRX_USER_KEY1 VARCHAR2 150 First component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY2 VARCHAR2 150 Second component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY3 VARCHAR2 150 Third component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJUSTED_DOC_NUMBER VARCHAR2 150 Transaction number of the adjusted document Active
ADJUSTED_DOC_DATE DATE Adjusted document date 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
APP_TO_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite keyfor uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the applied to document Active
APPLIED_TO_TRX_LINE_ID NUMBER Transaction line identifier for the applied to document Active
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 Active
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 Active
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 Active
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 Active
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 Active
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 Active
TRX_ID_LEVEL2 NUMBER Transaction identifier at a level between trx_id and trx_line_id Active
TRX_ID_LEVEL3 NUMBER Transaction identifier at a level between trx_id_level2 and trx_line_id Active
TRX_ID_LEVEL4 NUMBER Transaction identifier at a level between trx_id_level3 and trx_line_id Active
TRX_ID_LEVEL5 NUMBER Transaction identifier at a level between trx_id_level4 and trx_line_id Active
TRX_ID_LEVEL6 NUMBER Transaction identifier at a level between trx_id_level5 and trx_line_id Active
HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the user composite key to uniquely identify the transaction Active
LINE_TRX_USER_KEY1 VARCHAR2 150 First component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY2 VARCHAR2 150 Second component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY3 VARCHAR2 150 Third component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the line user composite key for uniquely identifying the transaction line Active
TRX_LINE_NUMBER NUMBER Transaction line number 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_WAYBILL_NUMBER VARCHAR2 50 Waybill number of the transaction Active
TRX_LINE_GL_DATE DATE Accounting date for the transaction line Active
MERCHANT_PARTY_NAME VARCHAR2 150 Merchant party name recorded for the Payables expense report Active
MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 150 Merchant party document number recorded for the Payables expense report Active
MERCHANT_PARTY_REFERENCE VARCHAR2 250 Merchant party reference recorded for the Payables expense report Active
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 150 Merchant party taxpayer ID recorded for the Payables expense report Active
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 150 Merchant party tax registration number recorded for the Payables expense report Active
PAYING_PARTY_ID NUMBER Not currently used Active
OWN_HQ_PARTY_ID NUMBER Not currently used Active
TRADING_HQ_PARTY_ID NUMBER Not currently used Active
POI_PARTY_ID NUMBER Not currently used Active
POD_PARTY_ID NUMBER Not currently used Active
TITLE_TRANSFER_PARTY_ID NUMBER Not currently used Active
PAYING_PARTY_SITE_ID NUMBER Not currently used Active
OWN_HQ_PARTY_SITE_ID NUMBER Not currently used Active
TRADING_HQ_PARTY_SITE_ID NUMBER Not currently used Active
POI_PARTY_SITE_ID NUMBER Not currently used Active
POD_PARTY_SITE_ID NUMBER Not currently used Active
TITLE_TRANSFER_PARTY_SITE_ID NUMBER Not currently used 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
TITLE_TRANSFER_LOCATION_ID NUMBER Not currently used Active
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 Active
ASSET_FLAG VARCHAR2 1 Not currently used Active
ASSET_NUMBER VARCHAR2 150 Not currently used Active
ASSET_ACCUM_DEPRECIATION NUMBER Not currently used Active
ASSET_TYPE VARCHAR2 150 Not currently used Active
ASSET_COST NUMBER Not currently used Active
NUMERIC1 NUMBER Not currently used Active
NUMERIC2 NUMBER Not currently used Active
NUMERIC3 NUMBER Not currently used Active
NUMERIC4 NUMBER Not currently used Active
NUMERIC5 NUMBER Not currently used Active
NUMERIC6 NUMBER Not currently used Active
NUMERIC7 NUMBER Not currently used Active
NUMERIC8 NUMBER Not currently used Active
NUMERIC9 NUMBER Not currently used Active
NUMERIC10 NUMBER Not currently used Active
CHAR1 VARCHAR2 150 Not currently used Active
CHAR2 VARCHAR2 150 Not currently used Active
CHAR3 VARCHAR2 150 Not currently used Active
CHAR4 VARCHAR2 150 Not currently used Active
CHAR5 VARCHAR2 150 Not currently used Active
CHAR6 VARCHAR2 150 Not currently used Active
CHAR7 VARCHAR2 150 Not currently used Active
CHAR8 VARCHAR2 150 Not currently used Active
CHAR9 VARCHAR2 150 Not currently used Active
CHAR10 VARCHAR2 150 Not currently used Active
DATE1 DATE Not currently used Active
DATE2 DATE Not currently used Active
DATE3 DATE Not currently used Active
DATE4 DATE Not currently used Active
DATE5 DATE Not currently used Active
DATE6 DATE Not currently used Active
DATE7 DATE Not currently used Active
DATE8 DATE Not currently used Active
DATE9 DATE Not currently used Active
DATE10 DATE Not currently used Active
SHIP_TO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for ship to party of the transaction line Active
SHIP_FROM_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for ship from party of the transaction line Active
POA_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for point of acceptance party of the transaction line Active
POO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for point of origin party of the transaction line Active
PAYING_PARTY_TAX_PROF_ID NUMBER Not currently used Active
OWN_HQ_PARTY_TAX_PROF_ID NUMBER Not currently used Active
TRADING_HQ_PARTY_TAX_PROF_ID NUMBER Not currently used Active
POI_PARTY_TAX_PROF_ID NUMBER Not currently used Active
POD_PARTY_TAX_PROF_ID NUMBER Not currently used Active
BILL_TO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for bill to party of the transaction line Active
BILL_FROM_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for bill from party of the transaction line Active
TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER Not currently used Active
SHIP_TO_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for ship to party site of the transaction line Active
SHIP_FROM_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for ship from party site of the transaction line Active
POA_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for point of acceptance party site of the transaction line Active
POO_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for point of origin party site of the transaction line Active
PAYING_SITE_TAX_PROF_ID NUMBER Not currently used Active
OWN_HQ_SITE_TAX_PROF_ID NUMBER Not currently used Active
TRADING_HQ_SITE_TAX_PROF_ID NUMBER Not currently used Active
POI_SITE_TAX_PROF_ID NUMBER Not currently used Active
POD_SITE_TAX_PROF_ID NUMBER Not currently used Active
BILL_TO_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for bill to party site of the transaction line Active
BILL_FROM_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for bill from party site of the transaction line Active
TITLE_TRANS_SITE_TAX_PROF_ID NUMBER Not currently used Active
MERCHANT_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for merchant party of the transaction line Active
HQ_ESTB_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for HQ establishment 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
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
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
SOURCE_APPLICATION_ID NUMBER Source document application identifier Active
SOURCE_ENTITY_CODE VARCHAR2 30 Source document entity code Active
SOURCE_EVENT_CLASS_CODE VARCHAR2 30 Source document event class code Active
SOURCE_TRX_ID NUMBER Source document transaction identifier Active
SOURCE_LINE_ID NUMBER Source document transaction line identifier Active
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. Active
UNIT_PRICE NUMBER Unit Price of the transaction line item or product Active
START_EXPENSE_DATE DATE Start expense date of a Payables Invoice distribution 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
DEFAULTING_ATTRIBUTE1 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE2 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE3 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE4 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE5 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE6 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE7 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE8 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE9 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE10 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
SOURCE_TAX_LINE_ID NUMBER Column to record source document tax line identifier that is represented by the current transaction line for billing purposes Active
APPLIED_FROM_TRX_NUMBER VARCHAR2 150 Transaction number of the applied from document 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
APPLIED_TO_TRX_NUMBER VARCHAR2 150 Applied to document transaction number Active
EXEMPT_REASON_CODE VARCHAR2 30 Exemption reason code Active
INTERFACE_ENTITY_CODE VARCHAR2 30 Column to temporarily store entity code of the transaction line interface table Active
INTERFACE_LINE_ID NUMBER Column to temporarily store identifier of the interface line corresponding to the transaction line during import of transactions into Receivables Active
HISTORICAL_TAX_CODE_ID NUMBER 18 Tax classification code identifier stored on the historical transactions Active
TRX_LINE_CURRENCY_CODE VARCHAR2 15 Transaction line currency code Active
TRX_LINE_CURRENCY_CONV_RATE NUMBER Transaction line exchange rate Active
TRX_LINE_CURRENCY_CONV_DATE DATE Transaction line date of the exchange rate Active
TRX_LINE_CURRENCY_CONV_TYPE VARCHAR2 30 Transaction line exchange rate type Active
TRX_LINE_MAU NUMBER Minimum accountable unit of the transaction line currency Active
TRX_LINE_PRECISION NUMBER Precision of the transaction line currency Active
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER Column to record bill to customer account site use identifier for Receivables Active
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER Column to record ship to customer account site use identifier for Receivables. Active
SHIP_THIRD_PTY_ACCT_ID NUMBER Column to record ship to customer account identifier for Receivables or ship from supplier identifier for Payables Active
BILL_THIRD_PTY_ACCT_ID NUMBER Column to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables Active
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 Active
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 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
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
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 Active
TAX_DATE DATE For internal use only Active
TAX_DETERMINE_DATE DATE For internal use only Active
TAX_POINT_DATE DATE For internal use only Active
SUBSCRIPTION_DATE DATE For internal use only Active
PROD_FC_CATEG_ID NUMBER Oracle internal use only
INTENDED_USE_CLASSIF_ID NUMBER Oracle internal use only
MATCH_TYPE VARCHAR2 25 Indicates the type of match for Payables transaction.
TAX_INVOICE_NUMBER VARCHAR2 150 Oracle internal use only.
TAX_INVOICE_DATE DATE Oracle internal use only.
REQUISITION_TYPE VARCHAR2 25 Oracle internal use only.
PURCHASING_CATEGORY_ID NUMBER 18 Oracle internal use only.
DROP_SHIP_FLAG VARCHAR2 1 Oracle internal use only.
CONSIGNED_FLAG VARCHAR2 1 Oracle internal use only.
DESTINATION_TYPE_CODE VARCHAR2 25 Oracle internal use only.
CONSIGN_ITM_UPON_RECPT_FLAG VARCHAR2 1 Oracle internal use only.
EXPENDITURE_TYPE VARCHAR2 30 Oracle internal use only.
PORT_OF_DISCHARGE VARCHAR2 150 Oracle internal use only.
PORT_OF_LOADING VARCHAR2 150 Oracle internal use only.
DELIVERY_TYPE VARCHAR2 30 Oracle internal use only.
DOCUMENT_TYPE VARCHAR2 30 Oracle internal use only.
SHIPMENT_TYPE VARCHAR2 25 Oracle internal use only.
WHT_GROUP_ID NUMBER 18 Oracle internal use only.
FOS_TRANSACTION_ID NUMBER 18 Oracle internal use only.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 Oracle internal use only.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Oracle internal use only.
FINAL_TRANSACTION_NODE_FLAG VARCHAR2 1 Oracle internal use only.
FIRST_PTY_REG_ID NUMBER 18 Oracle internal use only.
THIRD_PTY_REG_ID NUMBER 18 Oracle internal use only.
DEBIT_ACCOUNT_CCID NUMBER 18 Debit account identifier for the transaction line.
CREDIT_ACCOUNT_CCID NUMBER 18 Credit account identifier for the transaction line.
INDIRECT_TAX_LINE_ID NUMBER 18 Oracle internal use only.
TAX_REGIME_CODE VARCHAR2 30 Oracle internal use only.
TAX_REGIME_ID NUMBER 18 Oracle internal use only.
TAX VARCHAR2 30 Oracle internal use only.
TAX_ID NUMBER 18 Oracle internal use only.
TAX_JURISDICTION_CODE VARCHAR2 30 Oracle internal use only.
TAX_JURISDICTION_ID NUMBER 18 Oracle internal use only.
PAYMENT_DATE DATE Oracle internal use only.
PAYMENT_ID NUMBER 18 Oracle internal use only.
CHECKRUN_ID NUMBER 18 Oracle internal use only.
PAYMENT_AMT NUMBER Oracle internal use only.
DISCOUNT_AMT NUMBER Oracle internal use only.
LINK_TO_TRX_LINE_ID NUMBER 18 Oracle internal use only.
PACKING_CHARGE NUMBER Oracle internal use only.
PURCHASE_BASIS VARCHAR2 30 Oracle internal use only.
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Oracle internal use only.
LINE_GROUP_ID NUMBER 18 Oracle internal use only.
PAYMENT_NUMBER NUMBER 18 Oracle internal use only.
WHT_TAX_CLASSIFICATION_CODE VARCHAR2 30 Oracle internal use only.
EXPENDITURE_TYPE_ID NUMBER 18 Oracle internal use only.
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Oracle internal use only.
DOCUMENT_SUB_TYPE VARCHAR2 240 Oracle internal use only.
FIRST_PTY_REG_NUM VARCHAR2 60 Oracle internal use only.
THIRD_PTY_REG_NUM VARCHAR2 60 Oracle internal use only.
FINAL_DISCHARGE_LOCATION_CODE VARCHAR2 60 Oracle internal use only.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
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.
TRANSACTION_LINE_GEOGRAPHY_ID NUMBER 18 Column to store the geography ID of the place where the transaction took place. For example, the geography ID of the city where an employee incurred a meal.

Indexes

Index Uniqueness Columns Status
ZX_TRANSACTION_LINES_GT_U1 Unique APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, INDIRECT_TAX_LINE_ID, TRX_LEVEL_TYPE, PAYMENT_ID, CHECKRUN_ID, PAYMENT_NUMBER Active