eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: JA.JAI_CMN_RG_23AC_II_TRXS#

Source

View Text - Preformatted


select REGISTER_ID REGISTER_ID, FIN_YEAR FIN_YEAR, SLNO SLNO, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, RECEIPT_DATE RECEIPT_DATE, RANGE_NO RANGE_NO, DIVISION_NO DIVISION_NO, CR_BASIC_ED CR_BASIC_ED, CR_ADDITIONAL_ED CR_ADDITIONAL_ED, CR_OTHER_ED CR_OTHER_ED, DR_BASIC_ED DR_BASIC_ED, DR_ADDITIONAL_ED DR_ADDITIONAL_ED, DR_OTHER_ED DR_OTHER_ED, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE, REGISTER_TYPE REGISTER_TYPE, REMARKS REMARKS, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, LOCATION_ID LOCATION_ID, TRANSACTION_DATE TRANSACTION_DATE, OPENING_BALANCE OPENING_BALANCE, CLOSING_BALANCE CLOSING_BALANCE, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, REGISTER_ID_PART_I REGISTER_ID_PART_I, 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, REFERENCE_NUM REFERENCE_NUM, BOL_ID BOL_ID, BOLLINE_NO BOLLINE_NO, PERIOD_BALANCE_ID PERIOD_BALANCE_ID, ROUNDING_ID ROUNDING_ID, OTHER_TAX_CREDIT OTHER_TAX_CREDIT, OTHER_TAX_DEBIT OTHER_TAX_DEBIT, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM, RECEIPT_REF RECEIPT_REF, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ADDITIONAL_CVD_AMT ADDITIONAL_CVD_AMT, CR_ADDITIONAL_CVD CR_ADDITIONAL_CVD, DR_ADDITIONAL_CVD DR_ADDITIONAL_CVD from "JA"."JAI_CMN_RG_23AC_II_TRXS"

View Text - HTML Formatted

SELECT REGISTER_ID REGISTER_ID
, FIN_YEAR FIN_YEAR
, SLNO SLNO
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, RECEIPT_DATE RECEIPT_DATE
, RANGE_NO RANGE_NO
, DIVISION_NO DIVISION_NO
, CR_BASIC_ED CR_BASIC_ED
, CR_ADDITIONAL_ED CR_ADDITIONAL_ED
, CR_OTHER_ED CR_OTHER_ED
, DR_BASIC_ED DR_BASIC_ED
, DR_ADDITIONAL_ED DR_ADDITIONAL_ED
, DR_OTHER_ED DR_OTHER_ED
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, REGISTER_TYPE REGISTER_TYPE
, REMARKS REMARKS
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, LOCATION_ID LOCATION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, OPENING_BALANCE OPENING_BALANCE
, CLOSING_BALANCE CLOSING_BALANCE
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, REGISTER_ID_PART_I REGISTER_ID_PART_I
, 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
, REFERENCE_NUM REFERENCE_NUM
, BOL_ID BOL_ID
, BOLLINE_NO BOLLINE_NO
, PERIOD_BALANCE_ID PERIOD_BALANCE_ID
, ROUNDING_ID ROUNDING_ID
, OTHER_TAX_CREDIT OTHER_TAX_CREDIT
, OTHER_TAX_DEBIT OTHER_TAX_DEBIT
, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM
, RECEIPT_REF RECEIPT_REF
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ADDITIONAL_CVD_AMT ADDITIONAL_CVD_AMT
, CR_ADDITIONAL_CVD CR_ADDITIONAL_CVD
, DR_ADDITIONAL_CVD DR_ADDITIONAL_CVD
FROM "JA"."JAI_CMN_RG_23AC_II_TRXS"