VIEW: GMF.GL_SUBR_LED#

Source

View Text - Preformatted

select SUBLEDGER_ID SUBLEDGER_ID, DOC_TYPE DOC_TYPE, DOC_ID DOC_ID, LINE_ID LINE_ID, BATCH_NAME BATCH_NAME, TAXAUTH_ID TAXAUTH_ID, SUB_EVENT_TYPE SUB_EVENT_TYPE, CO_CODE CO_CODE, TRANS_SOURCE_TYPE TRANS_SOURCE_TYPE, LEDGER_CODE LEDGER_CODE, CURRENCY_BASE CURRENCY_BASE, CURRENCY_TRANS CURRENCY_TRANS, FISCAL_YEAR FISCAL_YEAR, PERIOD PERIOD, VOUCHER_ID VOUCHER_ID, ACCT_ID ACCT_ID, ACCTG_UNIT_ID ACCTG_UNIT_ID, AMOUNT_BASE AMOUNT_BASE, AMOUNT_TRANS AMOUNT_TRANS, TAXABLE_BASE TAXABLE_BASE, TAXABLE_TRANS TAXABLE_TRANS, DEBIT_CREDIT_SIGN DEBIT_CREDIT_SIGN, PROJECT_NO PROJECT_NO, QUANTITY QUANTITY, QUANTITY_UM QUANTITY_UM, EXCHANGE_RATE EXCHANGE_RATE, MUL_DIV_SIGN MUL_DIV_SIGN, GL_TRANS_DATE GL_TRANS_DATE, REVERSAL_FLAG REVERSAL_FLAG, FRONT_CURR_IND FRONT_CURR_IND, REFERENCE_NO REFERENCE_NO, EXPORTED_DATE EXPORTED_DATE, 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, TRANS_CNT TRANS_CNT, ACCT_TTL_TYPE ACCT_TTL_TYPE, GL_DOC_DATE GL_DOC_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID from "GMF"."GL_SUBR_LED"

View Text - HTML Formatted

SELECT SUBLEDGER_ID SUBLEDGER_ID
, DOC_TYPE DOC_TYPE
, DOC_ID DOC_ID
, LINE_ID LINE_ID
, BATCH_NAME BATCH_NAME
, TAXAUTH_ID TAXAUTH_ID
, SUB_EVENT_TYPE SUB_EVENT_TYPE
, CO_CODE CO_CODE
, TRANS_SOURCE_TYPE TRANS_SOURCE_TYPE
, LEDGER_CODE LEDGER_CODE
, CURRENCY_BASE CURRENCY_BASE
, CURRENCY_TRANS CURRENCY_TRANS
, FISCAL_YEAR FISCAL_YEAR
, PERIOD PERIOD
, VOUCHER_ID VOUCHER_ID
, ACCT_ID ACCT_ID
, ACCTG_UNIT_ID ACCTG_UNIT_ID
, AMOUNT_BASE AMOUNT_BASE
, AMOUNT_TRANS AMOUNT_TRANS
, TAXABLE_BASE TAXABLE_BASE
, TAXABLE_TRANS TAXABLE_TRANS
, DEBIT_CREDIT_SIGN DEBIT_CREDIT_SIGN
, PROJECT_NO PROJECT_NO
, QUANTITY QUANTITY
, QUANTITY_UM QUANTITY_UM
, EXCHANGE_RATE EXCHANGE_RATE
, MUL_DIV_SIGN MUL_DIV_SIGN
, GL_TRANS_DATE GL_TRANS_DATE
, REVERSAL_FLAG REVERSAL_FLAG
, FRONT_CURR_IND FRONT_CURR_IND
, REFERENCE_NO REFERENCE_NO
, EXPORTED_DATE EXPORTED_DATE
, 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
, TRANS_CNT TRANS_CNT
, ACCT_TTL_TYPE ACCT_TTL_TYPE
, GL_DOC_DATE GL_DOC_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
FROM "GMF"."GL_SUBR_LED"