Accounts Receivable measures
| Measure name | Table name | Source field |
|---|---|---|
| AR Applied Amount | ARPAYMENT | ORIG_APP_AMT |
| AR Base Adjust Amount | AROITEMS | ADJ_AMT |
| AR Base Amount | AROITEMS | TRAN_AMT |
| AR Base Credit Applied Amount | ARPAYMENT | CREDIT_APPLD |
| AR Base Open Amount | AROITEMS | TRAN_AMT - (APPLD_AMT + ADJ_AMT) |
| AR Gain Loss Amount | AROITEMS | GAINLOS_AMT |
| AR Order Limit | ARCUSTOMER | ORDER_LIM |
| AR Signed Applied Amount | AROITEMS |
CASE TRANS_TYPE WHEN 'C' THEN ORIG_APP_AMT * -1 ELSE ORIG_APP_AMT |
| AR Signed Base Amount | AROITEMS |
CASE TRANS_TYPE WHEN 'C' THEN TRAN_AMT * -1 ELSE TRAN_AMT |
| AR Signed Base Open Amount | AROITEMS |
CASE TRANS_TYPE WHEN 'C' THEN (TRAN_AMT - (APPLD_AMT + ADJ_AMT)) * -1 ELSE TRAN_AMT - (APPLD_AMT + ADJ_AMT) |
| AR Trans Amount | ARPAYMENT | ORIG_AMT |
| AR Transfer Amount | ARPAYMENT | TRANSFER_AMT |
| Credit Limit | ARCUSTOMER | CREDIT_LIM |
| Credit Review Days | ARCUSTOMER | CREDIT_REVDAYS |
| Current Balace | ARCUSTOMER | CURR_BAL |
| Disputed Invoice Amount | ARCUSTOMER | DISP_AMT |
| Disputed Invoices | ARCUSTOMER | DISP_NBR |
| Last Dunning Letter amount | ARCUSTOMER | LAST_DUN_AMT |
| Last Dunning Letter Number | ARCUSTOMER | LAST_DUNN |
| Last Payment Amount | ARCUSTOMER | LAST_PMT_AMT |
| Open AR Order Amount | ARCUSTOMER | OPEN_ORDS |
| Prepayment | ARPAYMENT | PREPAY_FLAG |
| Receivable Payment Amount | ARPAYMENT | TRAN_AMT |
| Total Unapplied Amount | ARPAYMENT | TRAN_AMT - ORIG_APP_AMT |
| Used Percentage | ARCUSTOMER | CURR_BAL,CREDIT_LIM |