VIEW: GMI.IC_ADJS_JNL#

Source

View Text - Preformatted

select TRANS_TYPE TRANS_TYPE, TRANS_FLAG TRANS_FLAG, DOC_ID DOC_ID, DOC_LINE DOC_LINE, JOURNAL_ID JOURNAL_ID, COMPLETED_IND COMPLETED_IND, WHSE_CODE WHSE_CODE, REASON_CODE REASON_CODE, DOC_DATE DOC_DATE, ITEM_ID ITEM_ID, ITEM_UM ITEM_UM, ITEM_UM2 ITEM_UM2, LOT_ID LOT_ID, LOCATION LOCATION, QTY QTY, QTY2 QTY2, QC_GRADE QC_GRADE, LOT_STATUS LOT_STATUS, LINE_TYPE LINE_TYPE, LINE_ID LINE_ID, CO_CODE CO_CODE, ORGN_CODE ORGN_CODE, NO_INV NO_INV, NO_TRANS NO_TRANS, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, TRANS_CNT TRANS_CNT, LAST_UPDATED_BY LAST_UPDATED_BY, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACCTG_UNIT_ID ACCTG_UNIT_ID, ACCT_ID ACCT_ID, TEXT_CODE TEXT_CODE from "GMI"."IC_ADJS_JNL"

View Text - HTML Formatted

SELECT TRANS_TYPE TRANS_TYPE
, TRANS_FLAG TRANS_FLAG
, DOC_ID DOC_ID
, DOC_LINE DOC_LINE
, JOURNAL_ID JOURNAL_ID
, COMPLETED_IND COMPLETED_IND
, WHSE_CODE WHSE_CODE
, REASON_CODE REASON_CODE
, DOC_DATE DOC_DATE
, ITEM_ID ITEM_ID
, ITEM_UM ITEM_UM
, ITEM_UM2 ITEM_UM2
, LOT_ID LOT_ID
, LOCATION LOCATION
, QTY QTY
, QTY2 QTY2
, QC_GRADE QC_GRADE
, LOT_STATUS LOT_STATUS
, LINE_TYPE LINE_TYPE
, LINE_ID LINE_ID
, CO_CODE CO_CODE
, ORGN_CODE ORGN_CODE
, NO_INV NO_INV
, NO_TRANS NO_TRANS
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, TRANS_CNT TRANS_CNT
, LAST_UPDATED_BY LAST_UPDATED_BY
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ACCTG_UNIT_ID ACCTG_UNIT_ID
, ACCT_ID ACCT_ID
, TEXT_CODE TEXT_CODE
FROM "GMI"."IC_ADJS_JNL"