Bill Information
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 |