Payment Information
One record for every payment linked to the bill.
Field Name |
Format |
Source/Value/Description |
PAY_DT |
Date |
CI_PAY_EVENT |
FT_TYPE_FLG |
A2 |
Pay or Pay Cancel ('PS' or 'PX') |
CAN_RSN_CD |
A4 |
CI_PAY |
CURRENCY_CD |
A3 |
CI_FT. |
CUR_AMT |
S15.2 |
Derived from CI_FT. Sum of CUR_AMT for the bill with FT Type Flag = (PS or PX) and Show on Bill Switch = 'Yes' |
TOT_AMT |
S15.2 |
Derived from CI_FT. Sum of CUR_AMT for the bill with FT Type Flag = (PS or PX) and Show on Bill Switch = 'Yes' |
TOT_PREV_BAL |
S15.2 |
Calculated as Previous Balance = Ending Balance - (current charges + payments + adjustments + corrections) |
PAY_CAN_RSN_DESCR |
A60 |
Description of cancel reason code. (Note, that this is retrieved in a special stored procedure that retrieves all the cancel reason codes and descriptions.) |