Field Name | Format | Source/Value/Description |
SORT_KEY | A12 | Primary sort for the report - currently sorted by Bill Id |
BILL_ID | A12 | CI_BILL |
SEQNO | N5 | CI_BILL_ROUTING |
PER_ID | A10 | CI_BILL_ROUTING |
NBR_BILL_COPIES | N1 | CI_BILL_ROUTING |
ENTITY_NAME1 | A64 | CI_BILL_ROUTING. Mailing Entity Name 1. |
ENTITY_NAME2 | A64 | CI_BILL_ROUTING. Mailing Entity Name 2. |
ENTITY_NAME3 | A64 | CI_BILL_ROUTING. Mailing Entity Name 3. |
COUNTRY | A3 | CI_BILL_ROUTING |
ADDRESS1 | A254 | CI_BILL_ROUTING |
ADDRESS2 | A254 | CI_BILL_ROUTING |
ADDRESS3 | A254 | CI_BILL_ROUTING |
ADDRESS4 | A254 | CI_BILL_ROUTING |
CITY | A30 | CI_BILL_ROUTING |
COUNTY | A30 | CI_BILL_ROUTING |
STATE | A6 | CI_BILL_ROUTING |
POSTAL | A12 | CI_BILL_ROUTING |
IN_CITY_LIMIT | A1 | CI_BILL_ROUTING |
BATCH_CD | A8 | CI_BILL_ROUTING |
BATCH_NBR | N10 | CI_BILL_ROUTING |
NO_BATCH_PRT_SW | A1 | CI_BILL_ROUTING |
ACCT_ID | A10 | CI_BILL |
BILL_STAT_FLG | A2 | CI_BILL |
BILL_DT | Date | CI_BILL |
DUE_DT | Date | CI_BILL |
ACCT_ENTITY_NAME | A64 | Get Main Person from CI_PER_NAME. Account Entity Name |
LANGUAGE_CD | A3 | Person's Language from CI_PER |
CURRENCY_CD | A3 | CI_ACCT |
CUR_SYMBOL | A4 | CI_CURRENCY_CD |
DECIMAL_POSITIONS | N1 | CI_CURRENCY_CD |
CUR_POS_FLG | A2 | CI_CURRENCY_CD |
OPEN_ITEM_SW | A1 | CI_CUST_CL |
BILL_COPY | A1 | Bill copy number |