VIEW: JA.JAI_CMN_RG_PLA_TRXS#

Source

View Text - Preformatted

select REGISTER_ID REGISTER_ID, FIN_YEAR FIN_YEAR, SLNO SLNO, TR6_CHALLAN_NO TR6_CHALLAN_NO, TR6_CHALLAN_DATE TR6_CHALLAN_DATE, CR_BASIC_ED CR_BASIC_ED, CR_ADDITIONAL_ED CR_ADDITIONAL_ED, CR_OTHER_ED CR_OTHER_ED, REF_DOCUMENT_ID REF_DOCUMENT_ID, REF_DOCUMENT_DATE REF_DOCUMENT_DATE, DR_INVOICE_DATE DR_INVOICE_DATE, DR_BASIC_ED DR_BASIC_ED, DR_ADDITIONAL_ED DR_ADDITIONAL_ED, DR_OTHER_ED DR_OTHER_ED, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, BANK_BRANCH_ID BANK_BRANCH_ID, ENTRY_DATE ENTRY_DATE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, VENDOR_CUST_FLAG VENDOR_CUST_FLAG, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, RANGE_NO RANGE_NO, DIVISION_NO DIVISION_NO, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, REMARKS REMARKS, TRANSACTION_DATE TRANSACTION_DATE, OPENING_BALANCE OPENING_BALANCE, CLOSING_BALANCE CLOSING_BALANCE, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_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, BASIC_OPENING_BALANCE BASIC_OPENING_BALANCE, BASIC_CLOSING_BALANCE BASIC_CLOSING_BALANCE, ADDITIONAL_OPENING_BALANCE ADDITIONAL_OPENING_BALANCE, ADDITIONAL_CLOSING_BALANCE ADDITIONAL_CLOSING_BALANCE, OTHER_OPENING_BALANCE OTHER_OPENING_BALANCE, OTHER_CLOSING_BALANCE OTHER_CLOSING_BALANCE, BOL_ID BOL_ID, BOLLINE_NO BOLLINE_NO, OTHER_TAX_CREDIT OTHER_TAX_CREDIT, OTHER_TAX_DEBIT OTHER_TAX_DEBIT, ROUNDING_ID ROUNDING_ID, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM, DR_INVOICE_NO DR_INVOICE_NO, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TR6_SOURCE TR6_SOURCE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ISSUE_TYPE ISSUE_TYPE from "JA"."JAI_CMN_RG_PLA_TRXS"

View Text - HTML Formatted

SELECT REGISTER_ID REGISTER_ID
, FIN_YEAR FIN_YEAR
, SLNO SLNO
, TR6_CHALLAN_NO TR6_CHALLAN_NO
, TR6_CHALLAN_DATE TR6_CHALLAN_DATE
, CR_BASIC_ED CR_BASIC_ED
, CR_ADDITIONAL_ED CR_ADDITIONAL_ED
, CR_OTHER_ED CR_OTHER_ED
, REF_DOCUMENT_ID REF_DOCUMENT_ID
, REF_DOCUMENT_DATE REF_DOCUMENT_DATE
, DR_INVOICE_DATE DR_INVOICE_DATE
, DR_BASIC_ED DR_BASIC_ED
, DR_ADDITIONAL_ED DR_ADDITIONAL_ED
, DR_OTHER_ED DR_OTHER_ED
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, ENTRY_DATE ENTRY_DATE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, VENDOR_CUST_FLAG VENDOR_CUST_FLAG
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, RANGE_NO RANGE_NO
, DIVISION_NO DIVISION_NO
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, REMARKS REMARKS
, TRANSACTION_DATE TRANSACTION_DATE
, OPENING_BALANCE OPENING_BALANCE
, CLOSING_BALANCE CLOSING_BALANCE
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_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
, BASIC_OPENING_BALANCE BASIC_OPENING_BALANCE
, BASIC_CLOSING_BALANCE BASIC_CLOSING_BALANCE
, ADDITIONAL_OPENING_BALANCE ADDITIONAL_OPENING_BALANCE
, ADDITIONAL_CLOSING_BALANCE ADDITIONAL_CLOSING_BALANCE
, OTHER_OPENING_BALANCE OTHER_OPENING_BALANCE
, OTHER_CLOSING_BALANCE OTHER_CLOSING_BALANCE
, BOL_ID BOL_ID
, BOLLINE_NO BOLLINE_NO
, OTHER_TAX_CREDIT OTHER_TAX_CREDIT
, OTHER_TAX_DEBIT OTHER_TAX_DEBIT
, ROUNDING_ID ROUNDING_ID
, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM
, DR_INVOICE_NO DR_INVOICE_NO
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TR6_SOURCE TR6_SOURCE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ISSUE_TYPE ISSUE_TYPE
FROM "JA"."JAI_CMN_RG_PLA_TRXS"