VIEW: ZX.ZX_LINES_DET_FACTORS#

Source

View Text - Preformatted

select INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID, APPLICATION_ID APPLICATION_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_CLASS_MAPPING_ID EVENT_CLASS_MAPPING_ID, EVENT_TYPE_CODE EVENT_TYPE_CODE, DOC_EVENT_STATUS DOC_EVENT_STATUS, LINE_LEVEL_ACTION LINE_LEVEL_ACTION, TRX_ID TRX_ID, TRX_LINE_ID TRX_LINE_ID, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, HDR_TRX_USER_KEY1 HDR_TRX_USER_KEY1, HDR_TRX_USER_KEY2 HDR_TRX_USER_KEY2, HDR_TRX_USER_KEY3 HDR_TRX_USER_KEY3, HDR_TRX_USER_KEY4 HDR_TRX_USER_KEY4, HDR_TRX_USER_KEY5 HDR_TRX_USER_KEY5, HDR_TRX_USER_KEY6 HDR_TRX_USER_KEY6, LINE_TRX_USER_KEY1 LINE_TRX_USER_KEY1, LINE_TRX_USER_KEY2 LINE_TRX_USER_KEY2, LINE_TRX_USER_KEY3 LINE_TRX_USER_KEY3, LINE_TRX_USER_KEY4 LINE_TRX_USER_KEY4, LINE_TRX_USER_KEY5 LINE_TRX_USER_KEY5, LINE_TRX_USER_KEY6 LINE_TRX_USER_KEY6, TRX_DATE TRX_DATE, TRX_DOC_REVISION TRX_DOC_REVISION, 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_ID LEGAL_ENTITY_ID, ESTABLISHMENT_ID ESTABLISHMENT_ID, RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY, TRX_NUMBER TRX_NUMBER, TRX_LINE_NUMBER TRX_LINE_NUMBER, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION, TRX_DESCRIPTION TRX_DESCRIPTION, TRX_COMMUNICATED_DATE TRX_COMMUNICATED_DATE, BATCH_SOURCE_ID BATCH_SOURCE_ID, BATCH_SOURCE_NAME BATCH_SOURCE_NAME, DOC_SEQ_ID DOC_SEQ_ID, DOC_SEQ_NAME DOC_SEQ_NAME, DOC_SEQ_VALUE DOC_SEQ_VALUE, TRX_DUE_DATE TRX_DUE_DATE, TRX_TYPE_DESCRIPTION TRX_TYPE_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, FIRST_PTY_ORG_ID FIRST_PTY_ORG_ID, TAX_EVENT_CLASS_CODE TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE TAX_EVENT_TYPE_CODE, RDNG_SHIP_TO_PTY_TX_PROF_ID RDNG_SHIP_TO_PTY_TX_PROF_ID, RDNG_SHIP_FROM_PTY_TX_PROF_ID RDNG_SHIP_FROM_PTY_TX_PROF_ID, RDNG_BILL_TO_PTY_TX_PROF_ID RDNG_BILL_TO_PTY_TX_PROF_ID, RDNG_BILL_FROM_PTY_TX_PROF_ID RDNG_BILL_FROM_PTY_TX_PROF_ID, RDNG_SHIP_TO_PTY_TX_P_ST_ID RDNG_SHIP_TO_PTY_TX_P_ST_ID, RDNG_SHIP_FROM_PTY_TX_P_ST_ID RDNG_SHIP_FROM_PTY_TX_P_ST_ID, RDNG_BILL_TO_PTY_TX_P_ST_ID RDNG_BILL_TO_PTY_TX_P_ST_ID, RDNG_BILL_FROM_PTY_TX_P_ST_ID RDNG_BILL_FROM_PTY_TX_P_ST_ID, LINE_INTENDED_USE LINE_INTENDED_USE, TRX_LINE_TYPE TRX_LINE_TYPE, TRX_SHIPPING_DATE TRX_SHIPPING_DATE, TRX_RECEIPT_DATE TRX_RECEIPT_DATE, TRX_SIC_CODE TRX_SIC_CODE, FOB_POINT FOB_POINT, TRX_WAYBILL_NUMBER TRX_WAYBILL_NUMBER, 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, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, LINE_AMT LINE_AMT, TRX_LINE_QUANTITY TRX_LINE_QUANTITY, 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, ASSESSABLE_VALUE ASSESSABLE_VALUE, ASSET_FLAG ASSET_FLAG, ASSET_NUMBER ASSET_NUMBER, ASSET_ACCUM_DEPRECIATION ASSET_ACCUM_DEPRECIATION, ASSET_TYPE ASSET_TYPE, ASSET_COST ASSET_COST, RELATED_DOC_APPLICATION_ID RELATED_DOC_APPLICATION_ID, RELATED_DOC_ENTITY_CODE RELATED_DOC_ENTITY_CODE, RELATED_DOC_EVENT_CLASS_CODE RELATED_DOC_EVENT_CLASS_CODE, RELATED_DOC_TRX_ID RELATED_DOC_TRX_ID, REL_DOC_HDR_TRX_USER_KEY1 REL_DOC_HDR_TRX_USER_KEY1, REL_DOC_HDR_TRX_USER_KEY2 REL_DOC_HDR_TRX_USER_KEY2, REL_DOC_HDR_TRX_USER_KEY3 REL_DOC_HDR_TRX_USER_KEY3, REL_DOC_HDR_TRX_USER_KEY4 REL_DOC_HDR_TRX_USER_KEY4, REL_DOC_HDR_TRX_USER_KEY5 REL_DOC_HDR_TRX_USER_KEY5, REL_DOC_HDR_TRX_USER_KEY6 REL_DOC_HDR_TRX_USER_KEY6, RELATED_DOC_NUMBER RELATED_DOC_NUMBER, RELATED_DOC_DATE RELATED_DOC_DATE, 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, APP_FROM_HDR_TRX_USER_KEY1 APP_FROM_HDR_TRX_USER_KEY1, APP_FROM_HDR_TRX_USER_KEY2 APP_FROM_HDR_TRX_USER_KEY2, APP_FROM_HDR_TRX_USER_KEY3 APP_FROM_HDR_TRX_USER_KEY3, APP_FROM_HDR_TRX_USER_KEY4 APP_FROM_HDR_TRX_USER_KEY4, APP_FROM_HDR_TRX_USER_KEY5 APP_FROM_HDR_TRX_USER_KEY5, APP_FROM_HDR_TRX_USER_KEY6 APP_FROM_HDR_TRX_USER_KEY6, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID, APP_FROM_LIN_TRX_USER_KEY1 APP_FROM_LIN_TRX_USER_KEY1, APP_FROM_LIN_TRX_USER_KEY2 APP_FROM_LIN_TRX_USER_KEY2, APP_FROM_LIN_TRX_USER_KEY3 APP_FROM_LIN_TRX_USER_KEY3, APP_FROM_LIN_TRX_USER_KEY4 APP_FROM_LIN_TRX_USER_KEY4, APP_FROM_LIN_TRX_USER_KEY5 APP_FROM_LIN_TRX_USER_KEY5, APP_FROM_LIN_TRX_USER_KEY6 APP_FROM_LIN_TRX_USER_KEY6, 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, ADJ_DOC_HDR_TRX_USER_KEY1 ADJ_DOC_HDR_TRX_USER_KEY1, ADJ_DOC_HDR_TRX_USER_KEY2 ADJ_DOC_HDR_TRX_USER_KEY2, ADJ_DOC_HDR_TRX_USER_KEY3 ADJ_DOC_HDR_TRX_USER_KEY3, ADJ_DOC_HDR_TRX_USER_KEY4 ADJ_DOC_HDR_TRX_USER_KEY4, ADJ_DOC_HDR_TRX_USER_KEY5 ADJ_DOC_HDR_TRX_USER_KEY5, ADJ_DOC_HDR_TRX_USER_KEY6 ADJ_DOC_HDR_TRX_USER_KEY6, ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_LINE_ID, ADJ_DOC_LIN_TRX_USER_KEY1 ADJ_DOC_LIN_TRX_USER_KEY1, ADJ_DOC_LIN_TRX_USER_KEY2 ADJ_DOC_LIN_TRX_USER_KEY2, ADJ_DOC_LIN_TRX_USER_KEY3 ADJ_DOC_LIN_TRX_USER_KEY3, ADJ_DOC_LIN_TRX_USER_KEY4 ADJ_DOC_LIN_TRX_USER_KEY4, ADJ_DOC_LIN_TRX_USER_KEY5 ADJ_DOC_LIN_TRX_USER_KEY5, ADJ_DOC_LIN_TRX_USER_KEY6 ADJ_DOC_LIN_TRX_USER_KEY6, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE, 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, APP_TO_HDR_TRX_USER_KEY1 APP_TO_HDR_TRX_USER_KEY1, APP_TO_HDR_TRX_USER_KEY2 APP_TO_HDR_TRX_USER_KEY2, APP_TO_HDR_TRX_USER_KEY3 APP_TO_HDR_TRX_USER_KEY3, APP_TO_HDR_TRX_USER_KEY4 APP_TO_HDR_TRX_USER_KEY4, APP_TO_HDR_TRX_USER_KEY5 APP_TO_HDR_TRX_USER_KEY5, APP_TO_HDR_TRX_USER_KEY6 APP_TO_HDR_TRX_USER_KEY6, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID, APP_TO_LIN_TRX_USER_KEY1 APP_TO_LIN_TRX_USER_KEY1, APP_TO_LIN_TRX_USER_KEY2 APP_TO_LIN_TRX_USER_KEY2, APP_TO_LIN_TRX_USER_KEY3 APP_TO_LIN_TRX_USER_KEY3, APP_TO_LIN_TRX_USER_KEY4 APP_TO_LIN_TRX_USER_KEY4, APP_TO_LIN_TRX_USER_KEY5 APP_TO_LIN_TRX_USER_KEY5, APP_TO_LIN_TRX_USER_KEY6 APP_TO_LIN_TRX_USER_KEY6, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON EXEMPT_REASON, HISTORICAL_FLAG HISTORICAL_FLAG, TRX_LINE_GL_DATE TRX_LINE_GL_DATE, LINE_AMT_INCLUDES_TAX_FLAG LINE_AMT_INCLUDES_TAX_FLAG, ACCOUNT_CCID ACCOUNT_CCID, ACCOUNT_STRING ACCOUNT_STRING, MERCHANT_PARTY_TAX_PROF_ID MERCHANT_PARTY_TAX_PROF_ID, HQ_ESTB_PARTY_TAX_PROF_ID HQ_ESTB_PARTY_TAX_PROF_ID, NUMERIC1 NUMERIC1, NUMERIC2 NUMERIC2, NUMERIC3 NUMERIC3, NUMERIC4 NUMERIC4, NUMERIC5 NUMERIC5, NUMERIC6 NUMERIC6, NUMERIC7 NUMERIC7, NUMERIC8 NUMERIC8, NUMERIC9 NUMERIC9, NUMERIC10 NUMERIC10, CHAR1 CHAR1, CHAR2 CHAR2, CHAR3 CHAR3, CHAR4 CHAR4, CHAR5 CHAR5, CHAR6 CHAR6, CHAR7 CHAR7, CHAR8 CHAR8, CHAR9 CHAR9, CHAR10 CHAR10, DATE1 DATE1, DATE2 DATE2, DATE3 DATE3, DATE4 DATE4, DATE5 DATE5, DATE6 DATE6, DATE7 DATE7, DATE8 DATE8, DATE9 DATE9, DATE10 DATE10, MERCHANT_PARTY_NAME MERCHANT_PARTY_NAME, MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_DOCUMENT_NUMBER, MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_REFERENCE, MERCHANT_PARTY_TAXPAYER_ID MERCHANT_PARTY_TAXPAYER_ID, MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAX_REG_NUMBER, MERCHANT_PARTY_ID MERCHANT_PARTY_ID, MERCHANT_PARTY_COUNTRY MERCHANT_PARTY_COUNTRY, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, POA_LOCATION_ID POA_LOCATION_ID, POO_LOCATION_ID POO_LOCATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, BILL_FROM_LOCATION_ID BILL_FROM_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, TITLE_TRANSFER_LOCATION_ID TITLE_TRANSFER_LOCATION_ID, SHIP_TO_PARTY_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROF_ID, SHIP_FROM_PARTY_TAX_PROF_ID SHIP_FROM_PARTY_TAX_PROF_ID, POA_PARTY_TAX_PROF_ID POA_PARTY_TAX_PROF_ID, POO_PARTY_TAX_PROF_ID POO_PARTY_TAX_PROF_ID, PAYING_PARTY_TAX_PROF_ID PAYING_PARTY_TAX_PROF_ID, OWN_HQ_PARTY_TAX_PROF_ID OWN_HQ_PARTY_TAX_PROF_ID, TRADING_HQ_PARTY_TAX_PROF_ID TRADING_HQ_PARTY_TAX_PROF_ID, POI_PARTY_TAX_PROF_ID POI_PARTY_TAX_PROF_ID, POD_PARTY_TAX_PROF_ID POD_PARTY_TAX_PROF_ID, BILL_TO_PARTY_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID, BILL_FROM_PARTY_TAX_PROF_ID BILL_FROM_PARTY_TAX_PROF_ID, TITLE_TRANS_PARTY_TAX_PROF_ID TITLE_TRANS_PARTY_TAX_PROF_ID, SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_SITE_TAX_PROF_ID, SHIP_FROM_SITE_TAX_PROF_ID SHIP_FROM_SITE_TAX_PROF_ID, POA_SITE_TAX_PROF_ID POA_SITE_TAX_PROF_ID, POO_SITE_TAX_PROF_ID POO_SITE_TAX_PROF_ID, PAYING_SITE_TAX_PROF_ID PAYING_SITE_TAX_PROF_ID, OWN_HQ_SITE_TAX_PROF_ID OWN_HQ_SITE_TAX_PROF_ID, TRADING_HQ_SITE_TAX_PROF_ID TRADING_HQ_SITE_TAX_PROF_ID, POI_SITE_TAX_PROF_ID POI_SITE_TAX_PROF_ID, POD_SITE_TAX_PROF_ID POD_SITE_TAX_PROF_ID, BILL_TO_SITE_TAX_PROF_ID BILL_TO_SITE_TAX_PROF_ID, BILL_FROM_SITE_TAX_PROF_ID BILL_FROM_SITE_TAX_PROF_ID, TITLE_TRANS_SITE_TAX_PROF_ID TITLE_TRANS_SITE_TAX_PROF_ID, CTRL_HDR_TX_APPL_FLAG CTRL_HDR_TX_APPL_FLAG, CTRL_TOTAL_LINE_TX_AMT CTRL_TOTAL_LINE_TX_AMT, CTRL_TOTAL_HDR_TX_AMT CTRL_TOTAL_HDR_TX_AMT, 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, REF_DOC_HDR_TRX_USER_KEY1 REF_DOC_HDR_TRX_USER_KEY1, REF_DOC_HDR_TRX_USER_KEY2 REF_DOC_HDR_TRX_USER_KEY2, REF_DOC_HDR_TRX_USER_KEY3 REF_DOC_HDR_TRX_USER_KEY3, REF_DOC_HDR_TRX_USER_KEY4 REF_DOC_HDR_TRX_USER_KEY4, REF_DOC_HDR_TRX_USER_KEY5 REF_DOC_HDR_TRX_USER_KEY5, REF_DOC_HDR_TRX_USER_KEY6 REF_DOC_HDR_TRX_USER_KEY6, REF_DOC_LINE_ID REF_DOC_LINE_ID, REF_DOC_LIN_TRX_USER_KEY1 REF_DOC_LIN_TRX_USER_KEY1, REF_DOC_LIN_TRX_USER_KEY2 REF_DOC_LIN_TRX_USER_KEY2, REF_DOC_LIN_TRX_USER_KEY3 REF_DOC_LIN_TRX_USER_KEY3, REF_DOC_LIN_TRX_USER_KEY4 REF_DOC_LIN_TRX_USER_KEY4, REF_DOC_LIN_TRX_USER_KEY5 REF_DOC_LIN_TRX_USER_KEY5, REF_DOC_LIN_TRX_USER_KEY6 REF_DOC_LIN_TRX_USER_KEY6, REF_DOC_LINE_QUANTITY REF_DOC_LINE_QUANTITY, LINE_CLASS LINE_CLASS, TRX_LINE_DATE TRX_LINE_DATE, INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE, INTERNAL_ORG_LOCATION_ID INTERNAL_ORG_LOCATION_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE, TAX_REPORTING_FLAG TAX_REPORTING_FLAG, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG, COMPOUNDING_TAX_FLAG COMPOUNDING_TAX_FLAG, TRX_ID_LEVEL5 TRX_ID_LEVEL5, TRX_ID_LEVEL2 TRX_ID_LEVEL2, TRX_ID_LEVEL3 TRX_ID_LEVEL3, TRX_ID_LEVEL4 TRX_ID_LEVEL4, EVENT_ID EVENT_ID, THRESHOLD_INDICATOR_FLAG THRESHOLD_INDICATOR_FLAG, PROVNL_TAX_DETERMINATION_DATE PROVNL_TAX_DETERMINATION_DATE, UNIT_PRICE UNIT_PRICE, 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, TRX_BATCH_ID TRX_BATCH_ID, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER, START_EXPENSE_DATE START_EXPENSE_DATE, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE, SOURCE_TRX_ID SOURCE_TRX_ID, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_TRX_LEVEL_TYPE SOURCE_TRX_LEVEL_TYPE, RECORD_TYPE_CODE RECORD_TYPE_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, INCLUSIVE_TAX_OVERRIDE_FLAG INCLUSIVE_TAX_OVERRIDE_FLAG, TAX_PROCESSING_COMPLETED_FLAG TAX_PROCESSING_COMPLETED_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, APPLICATION_DOC_STATUS APPLICATION_DOC_STATUS, USER_UPD_DET_FACTORS_FLAG USER_UPD_DET_FACTORS_FLAG, SOURCE_TAX_LINE_ID SOURCE_TAX_LINE_ID, REVERSED_APPLN_ID REVERSED_APPLN_ID, REVERSED_ENTITY_CODE REVERSED_ENTITY_CODE, REVERSED_EVNT_CLS_CODE REVERSED_EVNT_CLS_CODE, REVERSED_TRX_ID REVERSED_TRX_ID, REVERSED_TRX_LEVEL_TYPE REVERSED_TRX_LEVEL_TYPE, REVERSED_TRX_LINE_ID REVERSED_TRX_LINE_ID, TAX_CALCULATION_DONE_FLAG TAX_CALCULATION_DONE_FLAG, APPLIED_FROM_TRX_NUMBER APPLIED_FROM_TRX_NUMBER, PARTNER_MIGRATED_FLAG PARTNER_MIGRATED_FLAG, SHIP_THIRD_PTY_ACCT_SITE_ID SHIP_THIRD_PTY_ACCT_SITE_ID, BILL_THIRD_PTY_ACCT_SITE_ID BILL_THIRD_PTY_ACCT_SITE_ID, SHIP_THIRD_PTY_ACCT_ID SHIP_THIRD_PTY_ACCT_ID, BILL_THIRD_PTY_ACCT_ID BILL_THIRD_PTY_ACCT_ID, EXEMPTION_CONTROL_FLAG EXEMPTION_CONTROL_FLAG, EXEMPT_REASON_CODE EXEMPT_REASON_CODE, INTERFACE_ENTITY_CODE INTERFACE_ENTITY_CODE, INTERFACE_LINE_ID INTERFACE_LINE_ID, DEFAULTING_ATTRIBUTE1 DEFAULTING_ATTRIBUTE1, DEFAULTING_ATTRIBUTE2 DEFAULTING_ATTRIBUTE2, DEFAULTING_ATTRIBUTE3 DEFAULTING_ATTRIBUTE3, DEFAULTING_ATTRIBUTE4 DEFAULTING_ATTRIBUTE4, DEFAULTING_ATTRIBUTE5 DEFAULTING_ATTRIBUTE5, DEFAULTING_ATTRIBUTE6 DEFAULTING_ATTRIBUTE6, DEFAULTING_ATTRIBUTE7 DEFAULTING_ATTRIBUTE7, DEFAULTING_ATTRIBUTE8 DEFAULTING_ATTRIBUTE8, DEFAULTING_ATTRIBUTE9 DEFAULTING_ATTRIBUTE9, DEFAULTING_ATTRIBUTE10 DEFAULTING_ATTRIBUTE10, TRX_ID_LEVEL6 TRX_ID_LEVEL6, HISTORICAL_TAX_CODE_ID HISTORICAL_TAX_CODE_ID, ICX_SESSION_ID ICX_SESSION_ID, TRX_LINE_CURRENCY_CODE TRX_LINE_CURRENCY_CODE, TRX_LINE_CURRENCY_CONV_RATE TRX_LINE_CURRENCY_CONV_RATE, TRX_LINE_CURRENCY_CONV_DATE TRX_LINE_CURRENCY_CONV_DATE, TRX_LINE_PRECISION TRX_LINE_PRECISION, TRX_LINE_MAU TRX_LINE_MAU, TRX_LINE_CURRENCY_CONV_TYPE TRX_LINE_CURRENCY_CONV_TYPE, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, TOTAL_INC_TAX_AMT TOTAL_INC_TAX_AMT from "ZX"."ZX_LINES_DET_FACTORS"

View Text - HTML Formatted

SELECT INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, APPLICATION_ID APPLICATION_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_CLASS_MAPPING_ID EVENT_CLASS_MAPPING_ID
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, DOC_EVENT_STATUS DOC_EVENT_STATUS
, LINE_LEVEL_ACTION LINE_LEVEL_ACTION
, TRX_ID TRX_ID
, TRX_LINE_ID TRX_LINE_ID
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, HDR_TRX_USER_KEY1 HDR_TRX_USER_KEY1
, HDR_TRX_USER_KEY2 HDR_TRX_USER_KEY2
, HDR_TRX_USER_KEY3 HDR_TRX_USER_KEY3
, HDR_TRX_USER_KEY4 HDR_TRX_USER_KEY4
, HDR_TRX_USER_KEY5 HDR_TRX_USER_KEY5
, HDR_TRX_USER_KEY6 HDR_TRX_USER_KEY6
, LINE_TRX_USER_KEY1 LINE_TRX_USER_KEY1
, LINE_TRX_USER_KEY2 LINE_TRX_USER_KEY2
, LINE_TRX_USER_KEY3 LINE_TRX_USER_KEY3
, LINE_TRX_USER_KEY4 LINE_TRX_USER_KEY4
, LINE_TRX_USER_KEY5 LINE_TRX_USER_KEY5
, LINE_TRX_USER_KEY6 LINE_TRX_USER_KEY6
, TRX_DATE TRX_DATE
, TRX_DOC_REVISION TRX_DOC_REVISION
, 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_ID LEGAL_ENTITY_ID
, ESTABLISHMENT_ID ESTABLISHMENT_ID
, RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID
, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY
, TRX_NUMBER TRX_NUMBER
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION
, TRX_DESCRIPTION TRX_DESCRIPTION
, TRX_COMMUNICATED_DATE TRX_COMMUNICATED_DATE
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, BATCH_SOURCE_NAME BATCH_SOURCE_NAME
, DOC_SEQ_ID DOC_SEQ_ID
, DOC_SEQ_NAME DOC_SEQ_NAME
, DOC_SEQ_VALUE DOC_SEQ_VALUE
, TRX_DUE_DATE TRX_DUE_DATE
, TRX_TYPE_DESCRIPTION TRX_TYPE_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
, FIRST_PTY_ORG_ID FIRST_PTY_ORG_ID
, TAX_EVENT_CLASS_CODE TAX_EVENT_CLASS_CODE
, TAX_EVENT_TYPE_CODE TAX_EVENT_TYPE_CODE
, RDNG_SHIP_TO_PTY_TX_PROF_ID RDNG_SHIP_TO_PTY_TX_PROF_ID
, RDNG_SHIP_FROM_PTY_TX_PROF_ID RDNG_SHIP_FROM_PTY_TX_PROF_ID
, RDNG_BILL_TO_PTY_TX_PROF_ID RDNG_BILL_TO_PTY_TX_PROF_ID
, RDNG_BILL_FROM_PTY_TX_PROF_ID RDNG_BILL_FROM_PTY_TX_PROF_ID
, RDNG_SHIP_TO_PTY_TX_P_ST_ID RDNG_SHIP_TO_PTY_TX_P_ST_ID
, RDNG_SHIP_FROM_PTY_TX_P_ST_ID RDNG_SHIP_FROM_PTY_TX_P_ST_ID
, RDNG_BILL_TO_PTY_TX_P_ST_ID RDNG_BILL_TO_PTY_TX_P_ST_ID
, RDNG_BILL_FROM_PTY_TX_P_ST_ID RDNG_BILL_FROM_PTY_TX_P_ST_ID
, LINE_INTENDED_USE LINE_INTENDED_USE
, TRX_LINE_TYPE TRX_LINE_TYPE
, TRX_SHIPPING_DATE TRX_SHIPPING_DATE
, TRX_RECEIPT_DATE TRX_RECEIPT_DATE
, TRX_SIC_CODE TRX_SIC_CODE
, FOB_POINT FOB_POINT
, TRX_WAYBILL_NUMBER TRX_WAYBILL_NUMBER
, 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
, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, LINE_AMT LINE_AMT
, TRX_LINE_QUANTITY TRX_LINE_QUANTITY
, 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
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, ASSET_FLAG ASSET_FLAG
, ASSET_NUMBER ASSET_NUMBER
, ASSET_ACCUM_DEPRECIATION ASSET_ACCUM_DEPRECIATION
, ASSET_TYPE ASSET_TYPE
, ASSET_COST ASSET_COST
, RELATED_DOC_APPLICATION_ID RELATED_DOC_APPLICATION_ID
, RELATED_DOC_ENTITY_CODE RELATED_DOC_ENTITY_CODE
, RELATED_DOC_EVENT_CLASS_CODE RELATED_DOC_EVENT_CLASS_CODE
, RELATED_DOC_TRX_ID RELATED_DOC_TRX_ID
, REL_DOC_HDR_TRX_USER_KEY1 REL_DOC_HDR_TRX_USER_KEY1
, REL_DOC_HDR_TRX_USER_KEY2 REL_DOC_HDR_TRX_USER_KEY2
, REL_DOC_HDR_TRX_USER_KEY3 REL_DOC_HDR_TRX_USER_KEY3
, REL_DOC_HDR_TRX_USER_KEY4 REL_DOC_HDR_TRX_USER_KEY4
, REL_DOC_HDR_TRX_USER_KEY5 REL_DOC_HDR_TRX_USER_KEY5
, REL_DOC_HDR_TRX_USER_KEY6 REL_DOC_HDR_TRX_USER_KEY6
, RELATED_DOC_NUMBER RELATED_DOC_NUMBER
, RELATED_DOC_DATE RELATED_DOC_DATE
, 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
, APP_FROM_HDR_TRX_USER_KEY1 APP_FROM_HDR_TRX_USER_KEY1
, APP_FROM_HDR_TRX_USER_KEY2 APP_FROM_HDR_TRX_USER_KEY2
, APP_FROM_HDR_TRX_USER_KEY3 APP_FROM_HDR_TRX_USER_KEY3
, APP_FROM_HDR_TRX_USER_KEY4 APP_FROM_HDR_TRX_USER_KEY4
, APP_FROM_HDR_TRX_USER_KEY5 APP_FROM_HDR_TRX_USER_KEY5
, APP_FROM_HDR_TRX_USER_KEY6 APP_FROM_HDR_TRX_USER_KEY6
, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID
, APP_FROM_LIN_TRX_USER_KEY1 APP_FROM_LIN_TRX_USER_KEY1
, APP_FROM_LIN_TRX_USER_KEY2 APP_FROM_LIN_TRX_USER_KEY2
, APP_FROM_LIN_TRX_USER_KEY3 APP_FROM_LIN_TRX_USER_KEY3
, APP_FROM_LIN_TRX_USER_KEY4 APP_FROM_LIN_TRX_USER_KEY4
, APP_FROM_LIN_TRX_USER_KEY5 APP_FROM_LIN_TRX_USER_KEY5
, APP_FROM_LIN_TRX_USER_KEY6 APP_FROM_LIN_TRX_USER_KEY6
, 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
, ADJ_DOC_HDR_TRX_USER_KEY1 ADJ_DOC_HDR_TRX_USER_KEY1
, ADJ_DOC_HDR_TRX_USER_KEY2 ADJ_DOC_HDR_TRX_USER_KEY2
, ADJ_DOC_HDR_TRX_USER_KEY3 ADJ_DOC_HDR_TRX_USER_KEY3
, ADJ_DOC_HDR_TRX_USER_KEY4 ADJ_DOC_HDR_TRX_USER_KEY4
, ADJ_DOC_HDR_TRX_USER_KEY5 ADJ_DOC_HDR_TRX_USER_KEY5
, ADJ_DOC_HDR_TRX_USER_KEY6 ADJ_DOC_HDR_TRX_USER_KEY6
, ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_LINE_ID
, ADJ_DOC_LIN_TRX_USER_KEY1 ADJ_DOC_LIN_TRX_USER_KEY1
, ADJ_DOC_LIN_TRX_USER_KEY2 ADJ_DOC_LIN_TRX_USER_KEY2
, ADJ_DOC_LIN_TRX_USER_KEY3 ADJ_DOC_LIN_TRX_USER_KEY3
, ADJ_DOC_LIN_TRX_USER_KEY4 ADJ_DOC_LIN_TRX_USER_KEY4
, ADJ_DOC_LIN_TRX_USER_KEY5 ADJ_DOC_LIN_TRX_USER_KEY5
, ADJ_DOC_LIN_TRX_USER_KEY6 ADJ_DOC_LIN_TRX_USER_KEY6
, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE
, 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
, APP_TO_HDR_TRX_USER_KEY1 APP_TO_HDR_TRX_USER_KEY1
, APP_TO_HDR_TRX_USER_KEY2 APP_TO_HDR_TRX_USER_KEY2
, APP_TO_HDR_TRX_USER_KEY3 APP_TO_HDR_TRX_USER_KEY3
, APP_TO_HDR_TRX_USER_KEY4 APP_TO_HDR_TRX_USER_KEY4
, APP_TO_HDR_TRX_USER_KEY5 APP_TO_HDR_TRX_USER_KEY5
, APP_TO_HDR_TRX_USER_KEY6 APP_TO_HDR_TRX_USER_KEY6
, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID
, APP_TO_LIN_TRX_USER_KEY1 APP_TO_LIN_TRX_USER_KEY1
, APP_TO_LIN_TRX_USER_KEY2 APP_TO_LIN_TRX_USER_KEY2
, APP_TO_LIN_TRX_USER_KEY3 APP_TO_LIN_TRX_USER_KEY3
, APP_TO_LIN_TRX_USER_KEY4 APP_TO_LIN_TRX_USER_KEY4
, APP_TO_LIN_TRX_USER_KEY5 APP_TO_LIN_TRX_USER_KEY5
, APP_TO_LIN_TRX_USER_KEY6 APP_TO_LIN_TRX_USER_KEY6
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON EXEMPT_REASON
, HISTORICAL_FLAG HISTORICAL_FLAG
, TRX_LINE_GL_DATE TRX_LINE_GL_DATE
, LINE_AMT_INCLUDES_TAX_FLAG LINE_AMT_INCLUDES_TAX_FLAG
, ACCOUNT_CCID ACCOUNT_CCID
, ACCOUNT_STRING ACCOUNT_STRING
, MERCHANT_PARTY_TAX_PROF_ID MERCHANT_PARTY_TAX_PROF_ID
, HQ_ESTB_PARTY_TAX_PROF_ID HQ_ESTB_PARTY_TAX_PROF_ID
, NUMERIC1 NUMERIC1
, NUMERIC2 NUMERIC2
, NUMERIC3 NUMERIC3
, NUMERIC4 NUMERIC4
, NUMERIC5 NUMERIC5
, NUMERIC6 NUMERIC6
, NUMERIC7 NUMERIC7
, NUMERIC8 NUMERIC8
, NUMERIC9 NUMERIC9
, NUMERIC10 NUMERIC10
, CHAR1 CHAR1
, CHAR2 CHAR2
, CHAR3 CHAR3
, CHAR4 CHAR4
, CHAR5 CHAR5
, CHAR6 CHAR6
, CHAR7 CHAR7
, CHAR8 CHAR8
, CHAR9 CHAR9
, CHAR10 CHAR10
, DATE1 DATE1
, DATE2 DATE2
, DATE3 DATE3
, DATE4 DATE4
, DATE5 DATE5
, DATE6 DATE6
, DATE7 DATE7
, DATE8 DATE8
, DATE9 DATE9
, DATE10 DATE10
, MERCHANT_PARTY_NAME MERCHANT_PARTY_NAME
, MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_DOCUMENT_NUMBER
, MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_REFERENCE
, MERCHANT_PARTY_TAXPAYER_ID MERCHANT_PARTY_TAXPAYER_ID
, MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAX_REG_NUMBER
, MERCHANT_PARTY_ID MERCHANT_PARTY_ID
, MERCHANT_PARTY_COUNTRY MERCHANT_PARTY_COUNTRY
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, POA_LOCATION_ID POA_LOCATION_ID
, POO_LOCATION_ID POO_LOCATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, BILL_FROM_LOCATION_ID BILL_FROM_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
, TITLE_TRANSFER_LOCATION_ID TITLE_TRANSFER_LOCATION_ID
, SHIP_TO_PARTY_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROF_ID
, SHIP_FROM_PARTY_TAX_PROF_ID SHIP_FROM_PARTY_TAX_PROF_ID
, POA_PARTY_TAX_PROF_ID POA_PARTY_TAX_PROF_ID
, POO_PARTY_TAX_PROF_ID POO_PARTY_TAX_PROF_ID
, PAYING_PARTY_TAX_PROF_ID PAYING_PARTY_TAX_PROF_ID
, OWN_HQ_PARTY_TAX_PROF_ID OWN_HQ_PARTY_TAX_PROF_ID
, TRADING_HQ_PARTY_TAX_PROF_ID TRADING_HQ_PARTY_TAX_PROF_ID
, POI_PARTY_TAX_PROF_ID POI_PARTY_TAX_PROF_ID
, POD_PARTY_TAX_PROF_ID POD_PARTY_TAX_PROF_ID
, BILL_TO_PARTY_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID
, BILL_FROM_PARTY_TAX_PROF_ID BILL_FROM_PARTY_TAX_PROF_ID
, TITLE_TRANS_PARTY_TAX_PROF_ID TITLE_TRANS_PARTY_TAX_PROF_ID
, SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_SITE_TAX_PROF_ID
, SHIP_FROM_SITE_TAX_PROF_ID SHIP_FROM_SITE_TAX_PROF_ID
, POA_SITE_TAX_PROF_ID POA_SITE_TAX_PROF_ID
, POO_SITE_TAX_PROF_ID POO_SITE_TAX_PROF_ID
, PAYING_SITE_TAX_PROF_ID PAYING_SITE_TAX_PROF_ID
, OWN_HQ_SITE_TAX_PROF_ID OWN_HQ_SITE_TAX_PROF_ID
, TRADING_HQ_SITE_TAX_PROF_ID TRADING_HQ_SITE_TAX_PROF_ID
, POI_SITE_TAX_PROF_ID POI_SITE_TAX_PROF_ID
, POD_SITE_TAX_PROF_ID POD_SITE_TAX_PROF_ID
, BILL_TO_SITE_TAX_PROF_ID BILL_TO_SITE_TAX_PROF_ID
, BILL_FROM_SITE_TAX_PROF_ID BILL_FROM_SITE_TAX_PROF_ID
, TITLE_TRANS_SITE_TAX_PROF_ID TITLE_TRANS_SITE_TAX_PROF_ID
, CTRL_HDR_TX_APPL_FLAG CTRL_HDR_TX_APPL_FLAG
, CTRL_TOTAL_LINE_TX_AMT CTRL_TOTAL_LINE_TX_AMT
, CTRL_TOTAL_HDR_TX_AMT CTRL_TOTAL_HDR_TX_AMT
, 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
, REF_DOC_HDR_TRX_USER_KEY1 REF_DOC_HDR_TRX_USER_KEY1
, REF_DOC_HDR_TRX_USER_KEY2 REF_DOC_HDR_TRX_USER_KEY2
, REF_DOC_HDR_TRX_USER_KEY3 REF_DOC_HDR_TRX_USER_KEY3
, REF_DOC_HDR_TRX_USER_KEY4 REF_DOC_HDR_TRX_USER_KEY4
, REF_DOC_HDR_TRX_USER_KEY5 REF_DOC_HDR_TRX_USER_KEY5
, REF_DOC_HDR_TRX_USER_KEY6 REF_DOC_HDR_TRX_USER_KEY6
, REF_DOC_LINE_ID REF_DOC_LINE_ID
, REF_DOC_LIN_TRX_USER_KEY1 REF_DOC_LIN_TRX_USER_KEY1
, REF_DOC_LIN_TRX_USER_KEY2 REF_DOC_LIN_TRX_USER_KEY2
, REF_DOC_LIN_TRX_USER_KEY3 REF_DOC_LIN_TRX_USER_KEY3
, REF_DOC_LIN_TRX_USER_KEY4 REF_DOC_LIN_TRX_USER_KEY4
, REF_DOC_LIN_TRX_USER_KEY5 REF_DOC_LIN_TRX_USER_KEY5
, REF_DOC_LIN_TRX_USER_KEY6 REF_DOC_LIN_TRX_USER_KEY6
, REF_DOC_LINE_QUANTITY REF_DOC_LINE_QUANTITY
, LINE_CLASS LINE_CLASS
, TRX_LINE_DATE TRX_LINE_DATE
, INPUT_TAX_CLASSIFICATION_CODE INPUT_TAX_CLASSIFICATION_CODE
, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE
, INTERNAL_ORG_LOCATION_ID INTERNAL_ORG_LOCATION_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE
, TAX_REPORTING_FLAG TAX_REPORTING_FLAG
, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG
, COMPOUNDING_TAX_FLAG COMPOUNDING_TAX_FLAG
, TRX_ID_LEVEL5 TRX_ID_LEVEL5
, TRX_ID_LEVEL2 TRX_ID_LEVEL2
, TRX_ID_LEVEL3 TRX_ID_LEVEL3
, TRX_ID_LEVEL4 TRX_ID_LEVEL4
, EVENT_ID EVENT_ID
, THRESHOLD_INDICATOR_FLAG THRESHOLD_INDICATOR_FLAG
, PROVNL_TAX_DETERMINATION_DATE PROVNL_TAX_DETERMINATION_DATE
, UNIT_PRICE UNIT_PRICE
, 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
, TRX_BATCH_ID TRX_BATCH_ID
, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER
, START_EXPENSE_DATE START_EXPENSE_DATE
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE
, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE
, SOURCE_TRX_ID SOURCE_TRX_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_TRX_LEVEL_TYPE SOURCE_TRX_LEVEL_TYPE
, RECORD_TYPE_CODE RECORD_TYPE_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
, INCLUSIVE_TAX_OVERRIDE_FLAG INCLUSIVE_TAX_OVERRIDE_FLAG
, TAX_PROCESSING_COMPLETED_FLAG TAX_PROCESSING_COMPLETED_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, APPLICATION_DOC_STATUS APPLICATION_DOC_STATUS
, USER_UPD_DET_FACTORS_FLAG USER_UPD_DET_FACTORS_FLAG
, SOURCE_TAX_LINE_ID SOURCE_TAX_LINE_ID
, REVERSED_APPLN_ID REVERSED_APPLN_ID
, REVERSED_ENTITY_CODE REVERSED_ENTITY_CODE
, REVERSED_EVNT_CLS_CODE REVERSED_EVNT_CLS_CODE
, REVERSED_TRX_ID REVERSED_TRX_ID
, REVERSED_TRX_LEVEL_TYPE REVERSED_TRX_LEVEL_TYPE
, REVERSED_TRX_LINE_ID REVERSED_TRX_LINE_ID
, TAX_CALCULATION_DONE_FLAG TAX_CALCULATION_DONE_FLAG
, APPLIED_FROM_TRX_NUMBER APPLIED_FROM_TRX_NUMBER
, PARTNER_MIGRATED_FLAG PARTNER_MIGRATED_FLAG
, SHIP_THIRD_PTY_ACCT_SITE_ID SHIP_THIRD_PTY_ACCT_SITE_ID
, BILL_THIRD_PTY_ACCT_SITE_ID BILL_THIRD_PTY_ACCT_SITE_ID
, SHIP_THIRD_PTY_ACCT_ID SHIP_THIRD_PTY_ACCT_ID
, BILL_THIRD_PTY_ACCT_ID BILL_THIRD_PTY_ACCT_ID
, EXEMPTION_CONTROL_FLAG EXEMPTION_CONTROL_FLAG
, EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, INTERFACE_ENTITY_CODE INTERFACE_ENTITY_CODE
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, DEFAULTING_ATTRIBUTE1 DEFAULTING_ATTRIBUTE1
, DEFAULTING_ATTRIBUTE2 DEFAULTING_ATTRIBUTE2
, DEFAULTING_ATTRIBUTE3 DEFAULTING_ATTRIBUTE3
, DEFAULTING_ATTRIBUTE4 DEFAULTING_ATTRIBUTE4
, DEFAULTING_ATTRIBUTE5 DEFAULTING_ATTRIBUTE5
, DEFAULTING_ATTRIBUTE6 DEFAULTING_ATTRIBUTE6
, DEFAULTING_ATTRIBUTE7 DEFAULTING_ATTRIBUTE7
, DEFAULTING_ATTRIBUTE8 DEFAULTING_ATTRIBUTE8
, DEFAULTING_ATTRIBUTE9 DEFAULTING_ATTRIBUTE9
, DEFAULTING_ATTRIBUTE10 DEFAULTING_ATTRIBUTE10
, TRX_ID_LEVEL6 TRX_ID_LEVEL6
, HISTORICAL_TAX_CODE_ID HISTORICAL_TAX_CODE_ID
, ICX_SESSION_ID ICX_SESSION_ID
, TRX_LINE_CURRENCY_CODE TRX_LINE_CURRENCY_CODE
, TRX_LINE_CURRENCY_CONV_RATE TRX_LINE_CURRENCY_CONV_RATE
, TRX_LINE_CURRENCY_CONV_DATE TRX_LINE_CURRENCY_CONV_DATE
, TRX_LINE_PRECISION TRX_LINE_PRECISION
, TRX_LINE_MAU TRX_LINE_MAU
, TRX_LINE_CURRENCY_CONV_TYPE TRX_LINE_CURRENCY_CONV_TYPE
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, TOTAL_INC_TAX_AMT TOTAL_INC_TAX_AMT
FROM "ZX"."ZX_LINES_DET_FACTORS"