eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AX_TRIAL_BALANCE_FORM_V

Product:	AX - Global Accounting Engine
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.ROWID ROW_ID
, B.PERIOD_NAME
, B.APPLICATION_ID
, B.SET_OF_BOOKS_ID
, B.THIRD_PARTY_ID
, THIRD_PARTY_NAME
, THIRD_PARTY_NUMBER
, B.SUB_ID
, SUB_NAME
, CODE_COMBINATION_ID
, BALANCE_SEGMENT
, ACCOUNT_SEGMENT
, PERIOD_NET_DR
, PERIOD_NET_CR
, END_BALANCE_DR
, END_BALANCE_CR
, (END_BALANCE_DR-PERIOD_NET_DR)
, (END_BALANCE_CR-PERIOD_NET_CR)
, (END_BALANCE_DR - PERIOD_NET_DR + PERIOD_NET_CR - END_BALANCE_CR)
, (PERIOD_NET_DR - PERIOD_NET_CR)
, (END_BALANCE_DR - END_BALANCE_CR)
, PERIOD_HISTORY_NUM
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, P.EFFECTIVE_PERIOD_NUM
FROM AX_BALANCES B
, AX_THIRD_PARTIES_V TP
, AX_SUBS_V S
, GL_PERIOD_STATUSES P
WHERE B.APPLICATION_ID = TP.APPLICATION_ID
AND B.APPLICATION_ID = S.APPLICATION_ID
AND B.THIRD_PARTY_ID = TP.THIRD_PARTY_ID
AND B.THIRD_PARTY_ID = S.THIRD_PARTY_ID
AND B.SUB_ID = S.SUB_ID
AND B.PERIOD_NAME = P.PERIOD_NAME
AND B.APPLICATION_ID = P.APPLICATION_ID
AND B.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID

Columns

Name
ROW_ID
PERIOD_NAME
APPLICATION_ID
SET_OF_BOOKS_ID
THIRD_PARTY_ID
THIRD_PARTY_NAME
THIRD_PARTY_NUMBER
SUB_ID
SUB_NAME
CODE_COMBINATION_ID
BALANCE_SEGMENT
ACCOUNT_SEGMENT
PERIOD_NET_DR
PERIOD_NET_CR
END_BALANCE_DR
END_BALANCE_CR
BEGIN_BALANCE_DR
BEGIN_BALANCE_CR
BEGIN_BALANCE
PERIOD_NET
END_BALANCE
PERIOD_HISTORY_NUM
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PERIOD_NUM