VIEW: JA.JAI_CMN_RG_23D_TRXS#

Source

View Text - Preformatted

select REGISTER_ID REGISTER_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, SLNO SLNO, FIN_YEAR FIN_YEAR, TRANSACTION_TYPE TRANSACTION_TYPE, QUANTITY_RECEIVED QUANTITY_RECEIVED, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SUBINVENTORY SUBINVENTORY, REFERENCE_LINE_ID REFERENCE_LINE_ID, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE, CUSTOMER_ID CUSTOMER_ID, BILL_TO_SITE_ID BILL_TO_SITE_ID, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, QUANTITY_ISSUED QUANTITY_ISSUED, REGISTER_CODE REGISTER_CODE, RELEASED_DATE RELEASED_DATE, COMM_INVOICE_NO COMM_INVOICE_NO, COMM_INVOICE_DATE COMM_INVOICE_DATE, RECEIPT_BOE_NUM RECEIPT_BOE_NUM, OTH_RECEIPT_DATE OTH_RECEIPT_DATE, OTH_RECEIPT_QUANTITY OTH_RECEIPT_QUANTITY, REMARKS REMARKS, QTY_TO_ADJUST QTY_TO_ADJUST, RATE_PER_UNIT RATE_PER_UNIT, EXCISE_DUTY_RATE EXCISE_DUTY_RATE, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, DUTY_AMOUNT DUTY_AMOUNT, RECEIPT_DATE RECEIPT_DATE, GOODS_ISSUE_ID GOODS_ISSUE_ID, GOODS_ISSUE_DATE GOODS_ISSUE_DATE, GOODS_ISSUE_QUANTITY GOODS_ISSUE_QUANTITY, TRANSACTION_DATE TRANSACTION_DATE, OPENING_BALANCE_QTY OPENING_BALANCE_QTY, CLOSING_BALANCE_QTY CLOSING_BALANCE_QTY, BASIC_ED BASIC_ED, ADDITIONAL_ED ADDITIONAL_ED, OTHER_ED OTHER_ED, CVD CVD, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, RECEIPT_NUM RECEIPT_NUM, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, CONSIGNEE CONSIGNEE, MANUFACTURER_NAME MANUFACTURER_NAME, MANUFACTURER_ADDRESS MANUFACTURER_ADDRESS, MANUFACTURER_RATE_AMT_PER_UNIT MANUFACTURER_RATE_AMT_PER_UNIT, QTY_RECEIVED_FROM_MANUFACTURER QTY_RECEIVED_FROM_MANUFACTURER, TOT_AMT_PAID_TO_MANUFACTURER TOT_AMT_PAID_TO_MANUFACTURER, REF_LINE_NO REF_LINE_NO, BOL_ID BOL_ID, BOLLINE_NO BOLLINE_NO, OTHER_TAX_CREDIT OTHER_TAX_CREDIT, OTHER_TAX_DEBIT OTHER_TAX_DEBIT, RECEIPT_REF RECEIPT_REF, OTH_RECEIPT_ID_REF OTH_RECEIPT_ID_REF, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ADDITIONAL_CVD ADDITIONAL_CVD from "JA"."JAI_CMN_RG_23D_TRXS"

View Text - HTML Formatted

SELECT REGISTER_ID REGISTER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, SLNO SLNO
, FIN_YEAR FIN_YEAR
, TRANSACTION_TYPE TRANSACTION_TYPE
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SUBINVENTORY SUBINVENTORY
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE
, CUSTOMER_ID CUSTOMER_ID
, BILL_TO_SITE_ID BILL_TO_SITE_ID
, SHIP_TO_SITE_ID SHIP_TO_SITE_ID
, QUANTITY_ISSUED QUANTITY_ISSUED
, REGISTER_CODE REGISTER_CODE
, RELEASED_DATE RELEASED_DATE
, COMM_INVOICE_NO COMM_INVOICE_NO
, COMM_INVOICE_DATE COMM_INVOICE_DATE
, RECEIPT_BOE_NUM RECEIPT_BOE_NUM
, OTH_RECEIPT_DATE OTH_RECEIPT_DATE
, OTH_RECEIPT_QUANTITY OTH_RECEIPT_QUANTITY
, REMARKS REMARKS
, QTY_TO_ADJUST QTY_TO_ADJUST
, RATE_PER_UNIT RATE_PER_UNIT
, EXCISE_DUTY_RATE EXCISE_DUTY_RATE
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, DUTY_AMOUNT DUTY_AMOUNT
, RECEIPT_DATE RECEIPT_DATE
, GOODS_ISSUE_ID GOODS_ISSUE_ID
, GOODS_ISSUE_DATE GOODS_ISSUE_DATE
, GOODS_ISSUE_QUANTITY GOODS_ISSUE_QUANTITY
, TRANSACTION_DATE TRANSACTION_DATE
, OPENING_BALANCE_QTY OPENING_BALANCE_QTY
, CLOSING_BALANCE_QTY CLOSING_BALANCE_QTY
, BASIC_ED BASIC_ED
, ADDITIONAL_ED ADDITIONAL_ED
, OTHER_ED OTHER_ED
, CVD CVD
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, RECEIPT_NUM RECEIPT_NUM
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, CONSIGNEE CONSIGNEE
, MANUFACTURER_NAME MANUFACTURER_NAME
, MANUFACTURER_ADDRESS MANUFACTURER_ADDRESS
, MANUFACTURER_RATE_AMT_PER_UNIT MANUFACTURER_RATE_AMT_PER_UNIT
, QTY_RECEIVED_FROM_MANUFACTURER QTY_RECEIVED_FROM_MANUFACTURER
, TOT_AMT_PAID_TO_MANUFACTURER TOT_AMT_PAID_TO_MANUFACTURER
, REF_LINE_NO REF_LINE_NO
, BOL_ID BOL_ID
, BOLLINE_NO BOLLINE_NO
, OTHER_TAX_CREDIT OTHER_TAX_CREDIT
, OTHER_TAX_DEBIT OTHER_TAX_DEBIT
, RECEIPT_REF RECEIPT_REF
, OTH_RECEIPT_ID_REF OTH_RECEIPT_ID_REF
, TRANSACTION_SOURCE_NUM TRANSACTION_SOURCE_NUM
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ADDITIONAL_CVD ADDITIONAL_CVD
FROM "JA"."JAI_CMN_RG_23D_TRXS"