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.) |