Payment Table Names
Data Model Name
Table Name
Generated Keys
Referential Integrity Validation Batch Control
Key Assignment Batch Control
Insertion Batch Control
Payment
CI_​PAY
Yes (CI_​PAY_​K)
CIPVPAYV
CIPVPAYK
CIPVPAYI
Payment Event
CI_​PAY_​EVENT
Yes (CI_​PAY_​EVENT_​K)
CIPVPYEK
CIPVPYEI
Payment Event Characteristic
CI_​PAY_​EVT_​CHAR
No. The key is PAY_​EVENT_​ID and a char type.
CIPVBLCV
CIPVBLCI
Payment Tender
CI_​PAY_​TNDR
Yes (CI_​PAY_​TNDR_​K)
CIPVTNDV
CIPVTNDK
CIPVTNDI
Payment Segment
CI_​PAY_​SEG
Yes (CI_​PAY_​SEG_​K)
CIPVPSGV
CIPVPSGK
CIPVPSGI
FT (financial transaction)
CI_​FT
Yes (CI_​FT_​K)
CIPVFTFV
CIPVFTXK
CIPVFTFI
FT GL (FT general ledger)
CI_​FT_​GL
No. The key is FT id and a GL sequence number
CIPVFTGV
CIPVFTGI
Payment Tender Characteristic
CI_​PAY_​TNDR_​CHAR
No. The key is PAY_​TENDER_​ID, plus a sequence number and a char type
CIPVTNCV
CIPVTNCI
Payment Characteristic
CI_​PAY_​CHAR
No. The key is PAY_​ID, plus a sequence number and a char type
CIPVPYCV
CIPVPYCI