VIEW: ZX.ZX_TRANSACTION_LINES#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, TRX_LINE_ID TRX_LINE_ID, TRX_LINE_NUMBER TRX_LINE_NUMBER, TRX_ID TRX_ID, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, TRX_LINE_TYPE TRX_LINE_TYPE, TRX_LINE_DATE TRX_LINE_DATE, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, LINE_INTENDED_USE LINE_INTENDED_USE, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, LINE_AMT_INCLUDES_TAX_FLAG LINE_AMT_INCLUDES_TAX_FLAG, LINE_AMT LINE_AMT, TRX_LINE_QUANTITY TRX_LINE_QUANTITY, UNIT_PRICE UNIT_PRICE, PRODUCT_ID PRODUCT_ID, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, PRODUCT_ORG_ID PRODUCT_ORG_ID, UOM_CODE UOM_CODE, PRODUCT_TYPE PRODUCT_TYPE, PRODUCT_CODE PRODUCT_CODE, PRODUCT_CATEGORY PRODUCT_CATEGORY, MERCHANT_PARTY_ID MERCHANT_PARTY_ID, ACCOUNT_CCID ACCOUNT_CCID, ACCOUNT_STRING ACCOUNT_STRING, REF_DOC_LINE_ID REF_DOC_LINE_ID, REF_DOC_LINE_QUANTITY REF_DOC_LINE_QUANTITY, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE, REF_DOC_TRX_ID REF_DOC_TRX_ID, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID, ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_LINE_ID, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION, TRX_LINE_GL_DATE TRX_LINE_GL_DATE, LINE_LEVEL_ACTION LINE_LEVEL_ACTION, HISTORICAL_FLAG HISTORICAL_FLAG, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID, BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID, BILL_TO_PARTY_ID BILL_TO_PARTY_ID, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, BILL_FROM_LOCATION_ID BILL_FROM_LOCATION_ID, POA_LOCATION_ID POA_LOCATION_ID, POO_LOCATION_ID POO_LOCATION_ID, PAYING_LOCATION_ID PAYING_LOCATION_ID, OWN_HQ_LOCATION_ID OWN_HQ_LOCATION_ID, TRADING_HQ_LOCATION_ID TRADING_HQ_LOCATION_ID, POC_LOCATION_ID POC_LOCATION_ID, POI_LOCATION_ID POI_LOCATION_ID, POD_LOCATION_ID POD_LOCATION_ID, TAX_REGIME_ID TAX_REGIME_ID, TAX_REGIME_CODE TAX_REGIME_CODE, TAX_ID TAX_ID, TAX TAX, TAX_STATUS_ID TAX_STATUS_ID, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_CODE TAX_RATE_CODE, TAX_RATE TAX_RATE, TAX_LINE_AMT TAX_LINE_AMT, LINE_CLASS LINE_CLASS, TRX_SHIPPING_DATE TRX_SHIPPING_DATE, TRX_RECEIPT_DATE TRX_RECEIPT_DATE, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON EXEMPT_REASON, CASH_DISCOUNT CASH_DISCOUNT, VOLUME_DISCOUNT VOLUME_DISCOUNT, TRADING_DISCOUNT TRADING_DISCOUNT, TRANSFER_CHARGE TRANSFER_CHARGE, TRANSPORTATION_CHARGE TRANSPORTATION_CHARGE, INSURANCE_CHARGE INSURANCE_CHARGE, OTHER_CHARGE OTHER_CHARGE, POA_PARTY_ID POA_PARTY_ID, POO_PARTY_ID POO_PARTY_ID, POA_PARTY_SITE_ID POA_PARTY_SITE_ID, POO_PARTY_SITE_ID POO_PARTY_SITE_ID, MERCHANT_PARTY_COUNTRY MERCHANT_PARTY_COUNTRY, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE, APPLIED_TO_EVENT_CLASS_CODE APPLIED_TO_EVENT_CLASS_CODE, APPLIED_TO_TRX_ID APPLIED_TO_TRX_ID, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID, CTRL_HDR_TX_APPL_FLAG CTRL_HDR_TX_APPL_FLAG, CTRL_TOTAL_LINE_TX_AMT CTRL_TOTAL_LINE_TX_AMT, INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE, REF_DOC_TRX_LEVEL_TYPE REF_DOC_TRX_LEVEL_TYPE, APPLIED_TO_TRX_LEVEL_TYPE APPLIED_TO_TRX_LEVEL_TYPE, APPLIED_FROM_TRX_LEVEL_TYPE APPLIED_FROM_TRX_LEVEL_TYPE, ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_TRX_LEVEL_TYPE, EXEMPTION_CONTROL_FLAG EXEMPTION_CONTROL_FLAG, EXEMPT_REASON_CODE EXEMPT_REASON_CODE, RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "ZX"."ZX_TRANSACTION_LINES"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, TRX_LINE_ID TRX_LINE_ID
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, TRX_ID TRX_ID
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, TRX_LINE_TYPE TRX_LINE_TYPE
, TRX_LINE_DATE TRX_LINE_DATE
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, LINE_INTENDED_USE LINE_INTENDED_USE
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, LINE_AMT_INCLUDES_TAX_FLAG LINE_AMT_INCLUDES_TAX_FLAG
, LINE_AMT LINE_AMT
, TRX_LINE_QUANTITY TRX_LINE_QUANTITY
, UNIT_PRICE UNIT_PRICE
, PRODUCT_ID PRODUCT_ID
, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION
, PRODUCT_ORG_ID PRODUCT_ORG_ID
, UOM_CODE UOM_CODE
, PRODUCT_TYPE PRODUCT_TYPE
, PRODUCT_CODE PRODUCT_CODE
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, MERCHANT_PARTY_ID MERCHANT_PARTY_ID
, ACCOUNT_CCID ACCOUNT_CCID
, ACCOUNT_STRING ACCOUNT_STRING
, REF_DOC_LINE_ID REF_DOC_LINE_ID
, REF_DOC_LINE_QUANTITY REF_DOC_LINE_QUANTITY
, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID
, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE
, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE
, REF_DOC_TRX_ID REF_DOC_TRX_ID
, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID
, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID
, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE
, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID
, ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_LINE_ID
, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE
, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID
, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID
, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION
, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION
, TRX_LINE_GL_DATE TRX_LINE_GL_DATE
, LINE_LEVEL_ACTION LINE_LEVEL_ACTION
, HISTORICAL_FLAG HISTORICAL_FLAG
, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID
, BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID
, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, BILL_TO_PARTY_ID BILL_TO_PARTY_ID
, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, BILL_FROM_LOCATION_ID BILL_FROM_LOCATION_ID
, POA_LOCATION_ID POA_LOCATION_ID
, POO_LOCATION_ID POO_LOCATION_ID
, PAYING_LOCATION_ID PAYING_LOCATION_ID
, OWN_HQ_LOCATION_ID OWN_HQ_LOCATION_ID
, TRADING_HQ_LOCATION_ID TRADING_HQ_LOCATION_ID
, POC_LOCATION_ID POC_LOCATION_ID
, POI_LOCATION_ID POI_LOCATION_ID
, POD_LOCATION_ID POD_LOCATION_ID
, TAX_REGIME_ID TAX_REGIME_ID
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX_ID TAX_ID
, TAX TAX
, TAX_STATUS_ID TAX_STATUS_ID
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE_CODE TAX_RATE_CODE
, TAX_RATE TAX_RATE
, TAX_LINE_AMT TAX_LINE_AMT
, LINE_CLASS LINE_CLASS
, TRX_SHIPPING_DATE TRX_SHIPPING_DATE
, TRX_RECEIPT_DATE TRX_RECEIPT_DATE
, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON EXEMPT_REASON
, CASH_DISCOUNT CASH_DISCOUNT
, VOLUME_DISCOUNT VOLUME_DISCOUNT
, TRADING_DISCOUNT TRADING_DISCOUNT
, TRANSFER_CHARGE TRANSFER_CHARGE
, TRANSPORTATION_CHARGE TRANSPORTATION_CHARGE
, INSURANCE_CHARGE INSURANCE_CHARGE
, OTHER_CHARGE OTHER_CHARGE
, POA_PARTY_ID POA_PARTY_ID
, POO_PARTY_ID POO_PARTY_ID
, POA_PARTY_SITE_ID POA_PARTY_SITE_ID
, POO_PARTY_SITE_ID POO_PARTY_SITE_ID
, MERCHANT_PARTY_COUNTRY MERCHANT_PARTY_COUNTRY
, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID
, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE
, APPLIED_TO_EVENT_CLASS_CODE APPLIED_TO_EVENT_CLASS_CODE
, APPLIED_TO_TRX_ID APPLIED_TO_TRX_ID
, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID
, CTRL_HDR_TX_APPL_FLAG CTRL_HDR_TX_APPL_FLAG
, CTRL_TOTAL_LINE_TX_AMT CTRL_TOTAL_LINE_TX_AMT
, INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE
, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE
, REF_DOC_TRX_LEVEL_TYPE REF_DOC_TRX_LEVEL_TYPE
, APPLIED_TO_TRX_LEVEL_TYPE APPLIED_TO_TRX_LEVEL_TYPE
, APPLIED_FROM_TRX_LEVEL_TYPE APPLIED_FROM_TRX_LEVEL_TYPE
, ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_TRX_LEVEL_TYPE
, EXEMPTION_CONTROL_FLAG EXEMPTION_CONTROL_FLAG
, EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "ZX"."ZX_TRANSACTION_LINES"