VIEW: JA.JAI_CMN_RG_I_TRXS#

Source

View Text - Preformatted

select REGISTER_ID REGISTER_ID, REGISTER_ID_PART_II REGISTER_ID_PART_II, FIN_YEAR FIN_YEAR, SLNO SLNO, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, TRANSACTION_DATE TRANSACTION_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TRANSACTION_TYPE TRANSACTION_TYPE, MANUFACTURED_QTY MANUFACTURED_QTY, MANUFACTURED_PACKED_QTY MANUFACTURED_PACKED_QTY, MANUFACTURED_LOOSE_QTY MANUFACTURED_LOOSE_QTY, FOR_HOME_USE_PAY_ED_QTY FOR_HOME_USE_PAY_ED_QTY, FOR_HOME_USE_PAY_ED_VAL FOR_HOME_USE_PAY_ED_VAL, FOR_EXPORT_PAY_ED_QTY FOR_EXPORT_PAY_ED_QTY, FOR_EXPORT_PAY_ED_VAL FOR_EXPORT_PAY_ED_VAL, FOR_EXPORT_N_PAY_ED_QTY FOR_EXPORT_N_PAY_ED_QTY, FOR_EXPORT_N_PAY_ED_VAL FOR_EXPORT_N_PAY_ED_VAL, OTHER_PURPOSE OTHER_PURPOSE, TO_OTHER_FACTORY_N_PAY_ED_QTY TO_OTHER_FACTORY_N_PAY_ED_QTY, TO_OTHER_FACTORY_N_PAY_ED_VAL TO_OTHER_FACTORY_N_PAY_ED_VAL, OTHER_PURPOSE_N_PAY_ED_QTY OTHER_PURPOSE_N_PAY_ED_QTY, OTHER_PURPOSE_N_PAY_ED_VAL OTHER_PURPOSE_N_PAY_ED_VAL, OTHER_PURPOSE_PAY_ED_QTY OTHER_PURPOSE_PAY_ED_QTY, OTHER_PURPOSE_PAY_ED_VAL OTHER_PURPOSE_PAY_ED_VAL, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE, BALANCE_PACKED BALANCE_PACKED, BALANCE_LOOSE BALANCE_LOOSE, ISSUE_TYPE ISSUE_TYPE, EXCISE_DUTY_AMOUNT EXCISE_DUTY_AMOUNT, EXCISE_INVOICE_NUMBER EXCISE_INVOICE_NUMBER, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE, PAYMENT_REGISTER PAYMENT_REGISTER, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, RANGE_NO RANGE_NO, DIVISION_NO DIVISION_NO, REMARKS REMARKS, BASIC_ED BASIC_ED, ADDITIONAL_ED ADDITIONAL_ED, OTHER_ED OTHER_ED, EXCISE_DUTY_RATE EXCISE_DUTY_RATE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_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, POSTED_FLAG POSTED_FLAG, MASTER_FLAG MASTER_FLAG, BOL_ID BOL_ID, BOLLINE_NO BOLLINE_NO, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM, REF_DOC_NO REF_DOC_NO, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CESS_AMT CESS_AMT, SOURCE SOURCE, SH_CESS_AMT SH_CESS_AMT from "JA"."JAI_CMN_RG_I_TRXS"

View Text - HTML Formatted

SELECT REGISTER_ID REGISTER_ID
, REGISTER_ID_PART_II REGISTER_ID_PART_II
, FIN_YEAR FIN_YEAR
, SLNO SLNO
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, MANUFACTURED_QTY MANUFACTURED_QTY
, MANUFACTURED_PACKED_QTY MANUFACTURED_PACKED_QTY
, MANUFACTURED_LOOSE_QTY MANUFACTURED_LOOSE_QTY
, FOR_HOME_USE_PAY_ED_QTY FOR_HOME_USE_PAY_ED_QTY
, FOR_HOME_USE_PAY_ED_VAL FOR_HOME_USE_PAY_ED_VAL
, FOR_EXPORT_PAY_ED_QTY FOR_EXPORT_PAY_ED_QTY
, FOR_EXPORT_PAY_ED_VAL FOR_EXPORT_PAY_ED_VAL
, FOR_EXPORT_N_PAY_ED_QTY FOR_EXPORT_N_PAY_ED_QTY
, FOR_EXPORT_N_PAY_ED_VAL FOR_EXPORT_N_PAY_ED_VAL
, OTHER_PURPOSE OTHER_PURPOSE
, TO_OTHER_FACTORY_N_PAY_ED_QTY TO_OTHER_FACTORY_N_PAY_ED_QTY
, TO_OTHER_FACTORY_N_PAY_ED_VAL TO_OTHER_FACTORY_N_PAY_ED_VAL
, OTHER_PURPOSE_N_PAY_ED_QTY OTHER_PURPOSE_N_PAY_ED_QTY
, OTHER_PURPOSE_N_PAY_ED_VAL OTHER_PURPOSE_N_PAY_ED_VAL
, OTHER_PURPOSE_PAY_ED_QTY OTHER_PURPOSE_PAY_ED_QTY
, OTHER_PURPOSE_PAY_ED_VAL OTHER_PURPOSE_PAY_ED_VAL
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE
, BALANCE_PACKED BALANCE_PACKED
, BALANCE_LOOSE BALANCE_LOOSE
, ISSUE_TYPE ISSUE_TYPE
, EXCISE_DUTY_AMOUNT EXCISE_DUTY_AMOUNT
, EXCISE_INVOICE_NUMBER EXCISE_INVOICE_NUMBER
, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, PAYMENT_REGISTER PAYMENT_REGISTER
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, RANGE_NO RANGE_NO
, DIVISION_NO DIVISION_NO
, REMARKS REMARKS
, BASIC_ED BASIC_ED
, ADDITIONAL_ED ADDITIONAL_ED
, OTHER_ED OTHER_ED
, EXCISE_DUTY_RATE EXCISE_DUTY_RATE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_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
, POSTED_FLAG POSTED_FLAG
, MASTER_FLAG MASTER_FLAG
, BOL_ID BOL_ID
, BOLLINE_NO BOLLINE_NO
, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM
, REF_DOC_NO REF_DOC_NO
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CESS_AMT CESS_AMT
, SOURCE SOURCE
, SH_CESS_AMT SH_CESS_AMT
FROM "JA"."JAI_CMN_RG_I_TRXS"