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 |