VIEW: ZX.ZX_TRANSACTION#

Source

View Text - Preformatted

select FIRST_PTY_ORG_ID FIRST_PTY_ORG_ID, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID, APPLICATION_ID APPLICATION_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_TYPE_CODE EVENT_TYPE_CODE, TRX_ID TRX_ID, TRX_NUMBER TRX_NUMBER, INTERNAL_ORG_LOCATION_ID INTERNAL_ORG_LOCATION_ID, TAX_EVENT_TYPE_CODE TAX_EVENT_TYPE_CODE, TRX_DATE TRX_DATE, DOCUMENT_EVENT_TYPE DOCUMENT_EVENT_TYPE, LEDGER_ID LEDGER_ID, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, PRECISION PRECISION, LEGAL_ENTITY_PTP_ID LEGAL_ENTITY_PTP_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ROUNDING_SHIP_TO_PARTY_ID ROUNDING_SHIP_TO_PARTY_ID, ROUNDING_SHIP_FROM_PARTY_ID ROUNDING_SHIP_FROM_PARTY_ID, ROUNDING_BILL_TO_PARTY_ID ROUNDING_BILL_TO_PARTY_ID, ROUNDING_BILL_FROM_PARTY_ID ROUNDING_BILL_FROM_PARTY_ID, RNDG_SHIP_TO_PARTY_SITE_ID RNDG_SHIP_TO_PARTY_SITE_ID, RNDG_SHIP_FROM_PARTY_SITE_ID RNDG_SHIP_FROM_PARTY_SITE_ID, RNDG_BILL_TO_PARTY_SITE_ID RNDG_BILL_TO_PARTY_SITE_ID, RNDG_BILL_FROM_PARTY_SITE_ID RNDG_BILL_FROM_PARTY_SITE_ID, 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, TRX_DESCRIPTION TRX_DESCRIPTION, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE, SUPPLIER_TAX_INVOICE_NUMBER SUPPLIER_TAX_INVOICE_NUMBER, SUPPLIER_TAX_INVOICE_DATE SUPPLIER_TAX_INVOICE_DATE, SUPPLIER_EXCHANGE_RATE SUPPLIER_EXCHANGE_RATE, TAX_INVOICE_DATE TAX_INVOICE_DATE, TAX_INVOICE_NUMBER TAX_INVOICE_NUMBER, TITLE_TRANSFER_LOCATION_ID TITLE_TRANSFER_LOCATION_ID, TAX_MANUAL_ENTRY_FLAG TAX_MANUAL_ENTRY_FLAG, ESTABLISHMENT_ID ESTABLISHMENT_ID, RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY, QUOTE_FLAG QUOTE_FLAG, CTRL_TOTAL_HDR_TX_AMT CTRL_TOTAL_HDR_TX_AMT, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE, TAX_REPORTING_FLAG TAX_REPORTING_FLAG, SHIP_TO_CUST_ACCT_SITE_USE_ID SHIP_TO_CUST_ACCT_SITE_USE_ID, BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_CUST_ACCT_SITE_USE_ID, PROVNL_TAX_DETERMINATION_DATE PROVNL_TAX_DETERMINATION_DATE, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER, SHIP_THIRD_PTY_ACCT_ID SHIP_THIRD_PTY_ACCT_ID, BILL_THIRD_PTY_ACCT_ID BILL_THIRD_PTY_ACCT_ID, SHIP_THIRD_PTY_ACCT_SITE_ID SHIP_THIRD_PTY_ACCT_SITE_ID, BILL_THIRD_PTY_ACCT_SITE_ID BILL_THIRD_PTY_ACCT_SITE_ID, VALIDATION_CHECK_FLAG VALIDATION_CHECK_FLAG, 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"

View Text - HTML Formatted

SELECT FIRST_PTY_ORG_ID FIRST_PTY_ORG_ID
, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, APPLICATION_ID APPLICATION_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, TRX_ID TRX_ID
, TRX_NUMBER TRX_NUMBER
, INTERNAL_ORG_LOCATION_ID INTERNAL_ORG_LOCATION_ID
, TAX_EVENT_TYPE_CODE TAX_EVENT_TYPE_CODE
, TRX_DATE TRX_DATE
, DOCUMENT_EVENT_TYPE DOCUMENT_EVENT_TYPE
, LEDGER_ID LEDGER_ID
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, PRECISION PRECISION
, LEGAL_ENTITY_PTP_ID LEGAL_ENTITY_PTP_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ROUNDING_SHIP_TO_PARTY_ID ROUNDING_SHIP_TO_PARTY_ID
, ROUNDING_SHIP_FROM_PARTY_ID ROUNDING_SHIP_FROM_PARTY_ID
, ROUNDING_BILL_TO_PARTY_ID ROUNDING_BILL_TO_PARTY_ID
, ROUNDING_BILL_FROM_PARTY_ID ROUNDING_BILL_FROM_PARTY_ID
, RNDG_SHIP_TO_PARTY_SITE_ID RNDG_SHIP_TO_PARTY_SITE_ID
, RNDG_SHIP_FROM_PARTY_SITE_ID RNDG_SHIP_FROM_PARTY_SITE_ID
, RNDG_BILL_TO_PARTY_SITE_ID RNDG_BILL_TO_PARTY_SITE_ID
, RNDG_BILL_FROM_PARTY_SITE_ID RNDG_BILL_FROM_PARTY_SITE_ID
, 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
, TRX_DESCRIPTION TRX_DESCRIPTION
, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE
, SUPPLIER_TAX_INVOICE_NUMBER SUPPLIER_TAX_INVOICE_NUMBER
, SUPPLIER_TAX_INVOICE_DATE SUPPLIER_TAX_INVOICE_DATE
, SUPPLIER_EXCHANGE_RATE SUPPLIER_EXCHANGE_RATE
, TAX_INVOICE_DATE TAX_INVOICE_DATE
, TAX_INVOICE_NUMBER TAX_INVOICE_NUMBER
, TITLE_TRANSFER_LOCATION_ID TITLE_TRANSFER_LOCATION_ID
, TAX_MANUAL_ENTRY_FLAG TAX_MANUAL_ENTRY_FLAG
, ESTABLISHMENT_ID ESTABLISHMENT_ID
, RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID
, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY
, QUOTE_FLAG QUOTE_FLAG
, CTRL_TOTAL_HDR_TX_AMT CTRL_TOTAL_HDR_TX_AMT
, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE
, TAX_REPORTING_FLAG TAX_REPORTING_FLAG
, SHIP_TO_CUST_ACCT_SITE_USE_ID SHIP_TO_CUST_ACCT_SITE_USE_ID
, BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_CUST_ACCT_SITE_USE_ID
, PROVNL_TAX_DETERMINATION_DATE PROVNL_TAX_DETERMINATION_DATE
, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER
, SHIP_THIRD_PTY_ACCT_ID SHIP_THIRD_PTY_ACCT_ID
, BILL_THIRD_PTY_ACCT_ID BILL_THIRD_PTY_ACCT_ID
, SHIP_THIRD_PTY_ACCT_SITE_ID SHIP_THIRD_PTY_ACCT_SITE_ID
, BILL_THIRD_PTY_ACCT_SITE_ID BILL_THIRD_PTY_ACCT_SITE_ID
, VALIDATION_CHECK_FLAG VALIDATION_CHECK_FLAG
, 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"