| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ZCRDNUM | Credit card number | nvarchar | 19 | 0 | | | | Allow NULL? |
| 3 | ZCDCRCODE | Credit card company code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ZBLDAT | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | ZCOUPON | Coupon number or Aknolege number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | ZCOUNT | Number of checks | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | BELNR | Accounting document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | HKONT | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | ZKUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | ZBUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | ZBELNR | Accounting document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | ZGJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | ZBUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | ZAMOUNT | Amount in document currency | decimal | 13 | 2 | | | | |
| 20 | ZFIRSTPM | First Payment in Credit Card | decimal | 13 | 2 | | | | |
| 21 | ZRESTPM | Rest of Payment_amount for Credit Card | decimal | 13 | 2 | | | | |
| 22 | ZVALDAT | Validity date of Credit card (yymm) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | ZCRDPAY | Number of payments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | ZCRDVDT | Starting from | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | ZCRDATE | Baseline date for due date calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ZCREDIND | credit indicator | char | 1 | 0 | | | | Allow NULL? |
| 27 | BUKRS2 | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | BELNR2 | Accounting document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | GJAHR2 | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | BUZEI2 | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | ZBLDAT2 | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | ZCRDNAM | Credit card company name | nvarchar | 15 | 0 | | | | Allow NULL? |
| 33 | ZCRCDID | Credit Card Id | nvarchar | 7 | 0 | | | | Allow NULL? |
| 34 | ZCRDTYPE | Deal Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 35 | ZAKNNO | Aknolege Number | nvarchar | 7 | 0 | | | | Allow NULL? |
| 36 | ZAKNRES | Acknowledge Request Reason | char | 1 | 0 | | | | Allow NULL? |
| 37 | ZAKNBY | AKNOLEGED BY | nvarchar | 4 | 0 | | | | Allow NULL? |
| 38 | ZDOTYPE | Credit Card Deal Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | ZCRDTYP | Credit Type | char | 1 | 0 | | | | Allow NULL? |
| 40 | ZCRCDID1 | Credit Card Id | nvarchar | 7 | 0 | | | | Allow NULL? |
| 41 | ZCRDTYPE1 | Deal Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | ZAKNNO1 | Aknolege Number | nvarchar | 7 | 0 | | | | Allow NULL? |
| 43 | ZAKNRES1 | Acknowledge Request Reason | char | 1 | 0 | | | | Allow NULL? |
| 44 | ZAKNBY1 | AKNOLEGED BY | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | ZDOTYPE1 | Credit Card Deal Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | ZCRDTYP1 | Credit Type | char | 1 | 0 | | | | Allow NULL? |
| 47 | ZYMSGNO | Reference | nvarchar | 19 | 0 | | | | Allow NULL? |
| 48 | ZYMSGNO1 | Reference | nvarchar | 19 | 0 | | | | Allow NULL? |
| 49 | ZFIRSTPM1 | First Payment in Credit Card | decimal | 13 | 2 | | | | |
| 50 | ZRESTPM1 | Rest of Payment_amount for Credit Card | decimal | 13 | 2 | | | | |
| 51 | IDNUM_9 | Credit Card owner ID number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 52 | CVVCVC | CVV/CVC from the Credit Card | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | CRDNUML4 | Last 4 position of Credit card number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 54 | CVVCVCOK | CVV/CVC Status | char | 1 | 0 | | | | Allow NULL? |
| 55 | TURISTFL | Credit Card belonging to turist | char | 1 | 0 | | | | Allow NULL? |
| 56 | TURISTVISA | Turist Visa Flag | char | 1 | 0 | | | | Allow NULL? |
| 57 | STARUSAGE | Star usage in credit card deal | char | 1 | 0 | | | | Allow NULL? |
| 58 | CCBRAND | Credit Card brand | char | 1 | 0 | | | | Allow NULL? |
| 59 | CLEARID | Clearing Credit Card Company | char | 1 | 0 | | | | Allow NULL? |
| 60 | IDNUM_9ST | Status of Credit Card owner ID number | char | 1 | 0 | | | | Allow NULL? |
| 61 | CVVCVCST | Status of CVV/CVC | char | 1 | 0 | | | | Allow NULL? |
| 62 | IDNUM_9ST1 | Status of Credit Card owner ID number | char | 1 | 0 | | | | Allow NULL? |
| 63 | CVVCVCST1 | Status of CVV/CVC | char | 1 | 0 | | | | Allow NULL? |
| 64 | IDNUM_91 | Credit Card owner ID number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 65 | CVVCVC1 | CVV/CVC from the Credit Card | nvarchar | 4 | 0 | | | | Allow NULL? |
| 66 | CRDNUML41 | Last 4 position of Credit card number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 67 | CVVCVCOK1 | CVV/CVC Status | char | 1 | 0 | | | | Allow NULL? |
| 68 | TURISTFL1 | Credit Card belonging to turist | char | 1 | 0 | | | | Allow NULL? |
| 69 | TURISTVISA1 | Turist Visa Flag | char | 1 | 0 | | | | Allow NULL? |
| 70 | STARUSAGE1 | Star usage in credit card deal | char | 1 | 0 | | | | Allow NULL? |
| 71 | CCBRAND1 | Credit Card brand | char | 1 | 0 | | | | Allow NULL? |
| 72 | CLEARID1 | Clearing Credit Card Company | char | 1 | 0 | | | | Allow NULL? |
| 73 | UMSKZ | Special G/L Indicator | char | 1 | 0 | | | | Allow NULL? |
