Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
T_CHILD_CT_ID | NUMBER | 22 | Y | Technical identifier of child contact | |
T_CONNECTION_ID | NUMBER | 22 | N | Technical identifier of this record (for SecuTix internal use) | |
T_PARENT_CT_ID | NUMBER | 22 | Y | Technical identifier of parent contact | |
T_TYPE | VARCHAR2 | 25 | Y | Type of payment method. Possible values are: - PAY_TYPE/AVR: Payment involving credit note - PAY_TYPE/BVR: Payment by ESR - PAY_TYPE/CA: Payment involving suspense account - PAY_TYPE/CC: Credit card - PAY_TYPE/CCCANCEL: Cancel credit card - PAY_TYPE/CC_WITH_VALIDATION: Credit card with manual validation - PAY_TYPE/CHEQ: Cheque - PAY_TYPE/CHEQCANCEL: Cancel cheque - PAY_TYPE/COUPON: Coupon - PAY_TYPE/DEPOSIT: Deposit - PAY_TYPE/DIRECT_DEBIT: Direct debit - PAY_TYPE/DISCOUNT: Discount voucher - PAY_TYPE/EXT: External - PAY_TYPE/LOYALTY_POINT: Loyalty points - PAY_TYPE/CSH: Cash - PAY_TYPE/PREPAY: Bank withdrawal - PAY_TYPE/TRF: Bank transfer - PAY_TYPE/VOUCHER: Voucher |