| API Base discount amount 1 |
APINVOICE |
BASE_DISC_AMT1 |
| API Base discount amount 2 |
APINVOICE |
BASE_DISC_AMT2 |
| API Base discount amount 3 |
APINVOICE |
BASE_DISC_AMT3 |
| API Custom Total |
APINVOICE |
CSTMS_TOT |
| API Discount Amount |
APINVOICE |
TRAN_DISC_AMT |
| API Discount Amount 1 |
APINVOICE |
TRAN_DISC_AMT1 |
| API Discount Amount 2 |
APINVOICE |
TRAN_DISC_AMT2 |
| API Discount Amount 3 |
APINVOICE |
TRAN_DISC_AMT3 |
| API Discount Rate 1 |
APINVOICE |
DISCOUNT_RT1 |
| API Discount Rate 2 |
APINVOICE |
DISCOUNT_RT2 |
| API Discount Rate 3 |
APINVOICE |
DISCOUNT_RT3 |
| API Invoice Amount |
APINVOICE |
TRAN_INV_AMT |
| API Invoice Count |
APINVOICE |
1 for each Record |
| API Invoiced Electronically Count |
APINVOICE |
CASE WHEN API.INVOICE_SOURCE = 'E' THEN 1 ELSE 0 END |
| API Match Amount |
APINVOICE |
MATCH_AMT |
| API Match AOC Amount |
APINVOICE |
MATCH_AOC |
| API Open InvoiceAmount |
APINVOICE |
CASE WHEN API.REC_STATUS IN (0,1,2,3,5) THEN API.BASE_ACT_AMT ELSE 0 END |
| API Open Invoice count |
APINVOICE |
CASE WHEN API.REC_STATUS IN (0,1,2,3,5) THEN 1 ELSE 0 END |
| API Operator |
APINVOICE |
OPERATOR |
| API Other AOC Total |
APINVOICE |
OTHER_AOC_TOT |
| API Paid Amount |
APINVOICE |
TRAN_PAID_AMT |
| API Paid Invoice Count |
APINVOICE |
CASE WHEN (API.REC_STATUS = 8 or API.REC_STATUS=9) THEN 1 ELSE 0 END |
| API PO Invoice Tax |
APINVOICE |
PO_INV_TAX |
| API Released Invoice count |
APINVOICE |
CASE WHEN API.REC_STATUS = 1 THEN 1 ELSE 0 END |
| API Retain Transaction Amount |
APINVOICE |
RET_TRAN_AMT |
| API Retain Transaction Payment |
APINVOICE |
RET_TRAN_PMT |
| API Service Amount |
APINVOICE |
SERVICE_AMT |
| API Tax Amount |
APINVOICE |
TRAN_TAX_AMT |
| API Taxable Amount |
APINVOICE |
TRAN_TXBL_AMT |
| API Total Payment |
APINVOICE |
TRAN_TOT_PMT |
| API Total Tax Amount |
APINVOICE |
TRAN_TOT_TAX |
| API Total Taxable Amount |
APINVOICE |
TRAN_TOT_TXBL |
| API Unreleased invoice Count |
APINVOICE |
CASE WHEN API.REC_STATUS = 0 THEN 1 ELSE 0 END |