| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CONT | Cash Desk Container ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | SEQNO | Sequence Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | TYPE | Item Category for Container Item | char | 1 | 0 | | | | Allow NULL? |
| 5 | POSSTATUS | Item Status | char | 1 | 0 | | | | Allow NULL? |
| 6 | CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | PAYMENTAMOUNT | Payment Amount | decimal | 13 | 2 | | | | |
| 8 | CLEARINGAMOUNT | Total Clearing Amount for Open Items | decimal | 13 | 2 | | | | |
| 9 | WITHHTAXAMOUNT | Proportional Withholding Tax Amount In Transaction Currency | decimal | 13 | 2 | | | | |
| 10 | INTERESTAMOUNT | Surcharges for Late Payment | decimal | 13 | 2 | | | | |
| 11 | DIFFERENCEAMOUNT | Difference Amount in Clearing Processing | decimal | 13 | 2 | | | | |
| 12 | DIFFRULE | Rules for Handling Differences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | COLLDATE | Broker Collections: Date of Collection | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | PAYLINK | Payment ID | varbinary | 16 | 0 | | | | |
| 15 | CRDATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | CRTIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | CRNAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |