| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | XGUID | Key for Payment Card Supplement | varbinary | 16 | 0 | | | | |
| 3 | CCINS | Payment card type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 5 | CCFOL | Payment cards: Payment card suffix | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | DATAB | Payment cards: Valid from | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | DATBI | Payment Cards: Valid To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | CCNAME | Payment cards: Name of cardholder | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 10 | AUTRA | Payment Cards: Authorization Reference Number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 11 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | AUTIM | Payment cards: Authorization time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | AUART | Payment cards: Authorization type | char | 1 | 0 | | | | Allow NULL? |
| 14 | AUTWR | Payment cards: Authorized amount | decimal | 15 | 2 | | | | |
| 15 | CCWAE | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | MERCH | Payment cards: Merchant ID at the clearing house | nvarchar | 15 | 0 | | | | Allow NULL? |
| 17 | CGUID | GUID of a Payment Card | varbinary | 16 | 0 | | | | |
| 18 | ENCTP | Type of Encryption | char | 1 | 0 | | | | Allow NULL? |
| 19 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 20 | ORIGN | Origin of Payment Card Supplement | nvarchar | 2 | 0 | | | | Allow NULL? |