[Home] [Help]
View: IGSBV_PARTY_BALANCES
Product: | IGS - Student System (Obsolete) |
Description: | In context of an account, gives balance amount for a party |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BAL.BALANCE_ID
, BAL.PARTY_ID
, BAL.BALANCE_DATE
, BAL.STANDARD_BALANCE
, BAL.FEE_BALANCE
, BAL.HOLDS_BALANCE
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, BAL.FEE_BALANCE_RULE_ID
, BAL.HOLDS_BALANCE_RULE_ID
, BAL.CREATED_BY
, BAL.CREATION_DATE
, BAL.LAST_UPDATED_BY
, BAL.LAST_UPDATE_DATE
FROM IGS_FI_BALANCES BAL
, HZ_PARTIES HZ
WHERE BAL.PARTY_ID = HZ.PARTY_ID WITH READ ONLY
Columns
Name |
BALANCE_IDENTIFIER |
PARTY_IDENTIFIER |
BALANCE_DATE |
STANDARD_BALANCE |
FEE_BALANCE |
HOLDS_BALANCE |
PARTY_NUMBER |
PARTY_NAME |
FEE_BALANCE_RULE_IDENTIFIER |
HOLDS_BALANCE_RULE_IDENTIFIER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |