[Home] [Help]
| Product: | FII - Financial Intelligence (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TIME_ID
, PERIOD_TYPE_ID
, PARENT_PARTY_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, COLLECTOR_ID
, ORG_ID
, CLASS_CODE
, CLASS_CATEGORY
, HEADER_FILTER_DATE
, CURRENT_BUCKET_1_AMOUNT_PRIM
, CURRENT_BUCKET_1_COUNT
, CURRENT_BUCKET_2_AMOUNT_PRIM
, CURRENT_BUCKET_2_COUNT
, CURRENT_BUCKET_3_AMOUNT_PRIM
, CURRENT_BUCKET_3_COUNT
, PAST_DUE_BUCKET_1_AMOUNT_PRIM
, PAST_DUE_BUCKET_1_COUNT
, PAST_DUE_BUCKET_2_AMOUNT_PRIM
, PAST_DUE_BUCKET_2_COUNT
, PAST_DUE_BUCKET_3_AMOUNT_PRIM
, PAST_DUE_BUCKET_3_COUNT
, PAST_DUE_BUCKET_4_AMOUNT_PRIM
, PAST_DUE_BUCKET_4_COUNT
, PAST_DUE_BUCKET_5_AMOUNT_PRIM
, PAST_DUE_BUCKET_5_COUNT
, PAST_DUE_BUCKET_6_AMOUNT_PRIM
, PAST_DUE_BUCKET_6_COUNT
, PAST_DUE_BUCKET_7_AMOUNT_PRIM
, PAST_DUE_BUCKET_7_COUNT
, CURRENT_OPEN_AMOUNT_PRIM
, CURRENT_OPEN_COUNT
, PAST_DUE_OPEN_AMOUNT_PRIM
, PAST_DUE_COUNT
, WTD_TERMS_OUT_OPEN_NUM_PRIM
, WTD_TERMS_OUT_CURRENT_NUM_PRIM
, WTD_DDSO_DUE_NUM_PRIM
, TOTAL_OPEN_AMOUNT_PRIM
, TOTAL_OPEN_COUNT
, INV_AMOUNT_PRIM
, DM_AMOUNT_PRIM
, CB_AMOUNT_PRIM
, BR_AMOUNT_PRIM
, DEP_AMOUNT_PRIM
, ON_ACCOUNT_CREDIT_AMOUNT_PRIM
, UNAPP_DEP_AMOUNT_PRIM
, APP_AMOUNT_PRIM
, APP_COUNT
, ON_ACCOUNT_CASH_AMOUNT_PRIM
, PREPAYMENT_AMOUNT_PRIM
, CLAIM_AMOUNT_PRIM
, REV_AMOUNT_PRIM
, REV_COUNT
, TOTAL_RECEIPT_AMOUNT_PRIM
, TOTAL_RECEIPT_COUNT
, EARNED_DISCOUNT_AMOUNT_PRIM
, UNEARNED_DISCOUNT_AMOUNT_PRIM
, AVG_DD_NUM_PRIM
, WTD_DAYS_PAID_NUM_PRIM
, WTD_TERMS_PAID_NUM_PRIM
, BILLED_AMOUNT_PRIM
, BILLING_ACTIVITY_AMOUNT_PRIM
, BILLING_ACTIVITY_COUNT
, GID
, UMARKER
FROM FII_AR_NET_REC_BASE_MV