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: FII_AR_BILLING_ACT_AGRT_MV_S_V

Product:	FII - Financial Intelligence (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TIME_ID
, PERIOD_TYPE_ID
, PARENT_PARTY_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, COLLECTOR_ID
, ORG_ID
, INV_BA_AMOUNT_SEC
, INV_BA_COUNT
, DM_BA_AMOUNT_SEC
, DM_BA_COUNT
, CB_BA_AMOUNT_SEC
, CB_BA_COUNT
, BR_BA_AMOUNT_SEC
, BR_BA_COUNT
, DEP_BA_AMOUNT_SEC
, DEP_BA_COUNT
, CM_BA_AMOUNT_SEC
, CM_BA_COUNT
FROM FII_AR_BILLING_ACT_AGRT_MV

Columns

Name
TIME_ID
PERIOD_TYPE_ID
PARENT_PARTY_ID
PARTY_ID
CUST_ACCOUNT_ID
COLLECTOR_ID
ORG_ID
INV_BA_AMOUNT
INV_BA_COUNT
DM_BA_AMOUNT
DM_BA_COUNT
CB_BA_AMOUNT
CB_BA_COUNT
BR_BA_AMOUNT
BR_BA_COUNT
DEP_BA_AMOUNT
DEP_BA_COUNT
CM_BA_AMOUNT
CM_BA_COUNT