| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | /NAM/TJFCAPAYMT | BUKRS | Allow NULL? |
| 3 | ASSIGNMENT | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | | DZUONR | Allow NULL? |
| 4 | ENTRY_DATE | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATUM | Allow NULL? |
| 5 | ENTRY_TIME | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | UZEIT | Allow NULL? |
| 6 | PAYMENT_AMOUNT | IS-M/SD: Payment Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRZ | |
| 7 | TIP_AMOUNT | Tip Amount | decimal | 9 | 2 | CURR | ((0)) | Yes | | /NAM/TIP_AMOUNT | |
| 8 | NIE_AMOUNT | Donation Amount | decimal | 9 | 2 | CURR | ((0)) | Yes | | /NAM/NIE_AMOUNT | |
| 9 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 10 | XPOSTED | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 11 | KEYZ1 | Payment Lot | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | DFKKZK | KEYZ1_KK | Allow NULL? |
| 12 | CCINS | Payment cards: Card type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVCIN | CCINS | Allow NULL? |
| 13 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | VCNUM | CCNUM | Allow NULL? |
| 14 | DATAB | Payment cards: Valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAB_CC | Allow NULL? |
| 15 | DATBI | Payment Cards: Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATBI_CC | Allow NULL? |
| 16 | CCNAME | Payment cards: Name of cardholder | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CCNAME | Allow NULL? |
| 17 | ISM_CVVAL | Card Verification Value | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ISM_CVVAL | Allow NULL? |
| 18 | ISM_CVVCT | Control Field for Card Verification Value | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_CVVCT | Allow NULL? |
| 19 | ISM_CVVST | Usage Status of Card Verification Value | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_CVVST | Allow NULL? |
| 20 | ISM_RCCVV | Results Check for Card Verification Value | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCCRC | ISM_RCCVV_CC | Allow NULL? |
| 21 | ENTRY_USER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 22 | AUNUM | Payment cards: Previous authorization number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AUNUM_P | Allow NULL? |
| 23 | AUDAT | Payment cards: Previous date of authorization | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUDAT_P | Allow NULL? |
| 24 | AUTIM | Payment cards: Previous authorization time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AUTIM_P | Allow NULL? |
| 25 | CGUID | GUID of a Payment Card | varbinary | 16 | 0 | RAW | | Yes | | CARD_GUID | |
| 26 | ENCTP | Type of Encryption | char | 1 | 0 | CHAR | (N' ') | Yes | | CCSECA_ENCTYPE | Allow NULL? |
| 27 | MERCH | Payment cards: Merchant ID at the clearing house | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | MERCH | Allow NULL? |
| 28 | AUTRA | Payment cards: Authoriz. reference code of clearing house | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AUTRA | Allow NULL? |
