| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DOCNUMB | Number of Contract Accts Rec. & Payable Doc. | 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 | CALLER | Agency Collections: Caller Acct Maint. Application | char | 1 | 0 | | | | Allow NULL? |
| 8 | SUBORG | Object ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | PAYM | Agency Collections: Payment Methods Acct Maint. Application | char | 1 | 0 | | | | Allow NULL? |
| 10 | AMOUNT | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 11 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | CRNAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | CRDATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | CRTIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | STATUS | Agency Collections: Status Posted Documents Acct Maint. | char | 1 | 0 | | | | Allow NULL? |
