| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VBELN | IS-M/SD: Billing Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | CCACT | G/L Account Number for Payment Card Receivables | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | CCINS | Payment cards: Card type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 6 | CCFOL | Payment cards: Payment card suffix | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | DATAB | Payment cards: Valid from | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | DATBI | Payment Cards: Valid To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | CCNAME | Payment cards: Name of cardholder | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | CSOUR | Payment cards: Entry mode | char | 1 | 0 | | | | Allow NULL? |
| 11 | AUTWR | Payment cards: Authorized amount | decimal | 15 | 2 | | | | |
| 12 | CCWAE | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | SETTL | Payment cards: Settlement carried out | char | 1 | 0 | | | | Allow NULL? |
| 14 | AUNUM | Payment cards: Authorization number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | | | | Allow NULL? |
| 16 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | AUTIM | Payment cards: Authorization time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | MERCH | Payment cards: Merchant ID at the clearing house | nvarchar | 15 | 0 | | | | Allow NULL? |
| 19 | LOCID | Payment cards: Point of receipt for the transaction | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | TRMID | Payment cards: Terminal | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | CCTYP | Payment cards: Card category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | CCARD_GUID | Reference to Encrypted Payment Card Data | nvarchar | 32 | 0 | | | | Allow NULL? |
| 24 | CCAUA | Payment cards: Authorization type | char | 1 | 0 | | | | Allow NULL? |
| 25 | CCALL | Payment cards: Status when external system is called? | char | 1 | 0 | | | | Allow NULL? |
| 26 | REACT | Payment cards: Response to authorization checks | char | 1 | 0 | | | | Allow NULL? |
| 27 | AUTWV | Payment cards: Amount to be authorized | decimal | 15 | 2 | | | | |
| 28 | CCOLD | Payment cards: Authorization has expired | char | 1 | 0 | | | | Allow NULL? |
| 29 | CCVAL | Payment cards: Amount changed | char | 1 | 0 | | | | Allow NULL? |
| 30 | CCPRE | Payment cards: Preauthorization | char | 1 | 0 | | | | Allow NULL? |
| 31 | UELTR_A | Higher-level authorization for billing plan | nvarchar | 6 | 0 | | | | Allow NULL? |
| 32 | RCAVR | Payment Cards: Result of Address Check (Address Result) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | RCAVA | Payment Cards: Result of Address Check (Address Approval) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | RCAVZ | Payment Cards: Result of Address Check (ZIP Code Result) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | RCRSP | Payment cards: Result of card check (response code) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | RTEXT | Payment cards: Result text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 37 | ISM_CVVAL | Card Verification Value | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | ISM_CVVCT | Control Field for Card Verification Value | char | 1 | 0 | | | | Allow NULL? |
| 39 | ISM_CVVST | Usage Status of Card Verification Value | char | 1 | 0 | | | | Allow NULL? |
| 40 | ISM_RCCVV | Results Check for Card Verification Value | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | CGUID | GUID of a Payment Card | varbinary | 16 | 0 | | | | |
| 42 | ENCTP | Type of Encryption | char | 1 | 0 | | | | Allow NULL? |
