| 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 | PLVAR | Plan Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | OTYPE | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | OBJID | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | CDESK | Cash Desk in Agency Collections | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | CDMODE | Mode | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | CONTSTATUS | Status of Cash Desk Container | char | 1 | 0 | | | | Allow NULL? |
| 9 | INV_FR | Invoicing Period From (Broker Report) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | INV_TO | Invoicing Period to (Broker Report) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | FIKEY | Reconciliation Key for General Ledger | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | PAYLINK | Payment ID | varbinary | 16 | 0 | | | | |
| 13 | PLVAR_TP | Plan Version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | OTYPE_TP | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | OBJID_TP | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | XNETPRINC | Flag: Report Using Net Principle | char | 1 | 0 | | | | Allow NULL? |
| 17 | XPOSREV | Flag: Individual Items Reversed | char | 1 | 0 | | | | Allow NULL? |
| 18 | POSTDATE | Posting Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | SRCHTERM | Search Term for Container | nvarchar | 30 | 0 | | | | Allow NULL? |
| 20 | GRPKEY | Grouping Characteristic | nvarchar | 35 | 0 | | | | Allow NULL? |
| 21 | MAXPOS | Maximum Assigned Item Number for a Container | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | AMOUNT_WTAX | Reported Withholding Tax | decimal | 13 | 2 | | | | |
| 23 | CONTROL_POS | Sequence Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | CONTROL_PREM | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 25 | CONTROL_COMM | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 26 | AMOUNT_DIFF | Difference Amount in Clearing Processing | decimal | 13 | 2 | | | | |
| 27 | DIFFRULE | Rules for Handling Differences | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | CONTTYPE | Container Category | char | 1 | 0 | | | | Allow NULL? |
| 29 | XPRINTREC | Flag: Receipt Print | char | 1 | 0 | | | | Allow NULL? |
| 30 | CLCOMPCODE | Clearing Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | COMPCODE | Selection Company Code in Container | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | TRCURRENCY | Transaction Currency for a Container | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | CURRENCY | Selection Currency for a Container | nvarchar | 5 | 0 | | | | Allow NULL? |
| 34 | XNO_PAYMETHOD | Flag: Do Not Use Any Payment Methods | char | 1 | 0 | | | | Allow NULL? |
| 35 | XNO_REPAMOUNT | Flag: No Reported Amount | char | 1 | 0 | | | | Allow NULL? |
| 36 | DET_PAYAMOUNT | Determination of Payment Amount if No Payt Methods Are Used | char | 1 | 0 | | | | Allow NULL? |
| 37 | XHIERCOLL | Indicator: Hierarchy-Collections Is Active | char | 1 | 0 | | | | Allow NULL? |
| 38 | CRDATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | CRTIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | | | Allow NULL? |
| 40 | CRNAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 41 | CHNGDATE | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | CHNGTIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 43 | CHNGNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
