| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BKKRS | Bank Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | EVENT_ID | ID of Generating Event for Mandate Limit | varbinary | 16 | 0 | | | | |
| 5 | TMSTMP | Time Stamp for Object Creation | decimal | 21 | 7 | | | | |
| 6 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | POSNO | Position in Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | DATE_POST | Posting date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | UCI | Creditor Identification | nvarchar | 35 | 0 | | | | Allow NULL? |
| 10 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | | | Allow NULL? |
| 11 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | | | |
| 12 | A_CUR | Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | XCRED | Indicator: Credit | char | 1 | 0 | | | | Allow NULL? |
| 14 | EVENT_NUMBER | Increase/Reduction of Utilization Number for Mandate Limit | smallint | 5 | 0 | | | | |
| 15 | EVENT_CATG | Event Category of Mandate Limit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | REF_DOCNO | Reversal no. | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | REF_POSNO | Reversal Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | CRUSR | User Who Created Events for Mandate Limits | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | TIMESTAMP_CREATE | Time Stamp for Object Creation | decimal | 21 | 7 | | | | |