DBA Data[Home] [Help]

VIEW: AX.AX_BALANCES#

Source

View Text - Preformatted

select LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, APPLICATION_ID APPLICATION_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, THIRD_PARTY_ID THIRD_PARTY_ID, SUB_ID SUB_ID, PERIOD_NAME PERIOD_NAME, PERIOD_NET_DR PERIOD_NET_DR, PERIOD_NET_CR PERIOD_NET_CR, END_BALANCE_DR END_BALANCE_DR, END_BALANCE_CR END_BALANCE_CR, ORG_ID ORG_ID, PERIOD_HISTORY_NUM PERIOD_HISTORY_NUM, UPDATED_FLAG UPDATED_FLAG, HISTORIC_BALANCE HISTORIC_BALANCE, BALANCE_SEGMENT BALANCE_SEGMENT, ACCOUNT_SEGMENT ACCOUNT_SEGMENT from "AX"."AX_BALANCES"
View Text - HTML Formatted

SELECT LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, APPLICATION_ID APPLICATION_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, THIRD_PARTY_ID THIRD_PARTY_ID
, SUB_ID SUB_ID
, PERIOD_NAME PERIOD_NAME
, PERIOD_NET_DR PERIOD_NET_DR
, PERIOD_NET_CR PERIOD_NET_CR
, END_BALANCE_DR END_BALANCE_DR
, END_BALANCE_CR END_BALANCE_CR
, ORG_ID ORG_ID
, PERIOD_HISTORY_NUM PERIOD_HISTORY_NUM
, UPDATED_FLAG UPDATED_FLAG
, HISTORIC_BALANCE HISTORIC_BALANCE
, BALANCE_SEGMENT BALANCE_SEGMENT
, ACCOUNT_SEGMENT ACCOUNT_SEGMENT
FROM "AX"."AX_BALANCES"