| 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 | RZNR | IS-M: WBZ, Computer Center Number | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJKW0 | JWBZRZNR | Allow NULL? |
| 3 | DATUM | IS-M: Date in file name of WBZ file | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | JWBZDATUM | Allow NULL? |
| 4 | FILE_IN | Logical file name | nvarchar | 60 | 0 | CHAR | (N' ') | No | FILENAMECI | FILEINTERN | Allow NULL? |
| 5 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | JFILE_CNT | Allow NULL? |
| 6 | WBZSATZART | IS-M: WBZ, Record Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TJKW1 | JWBZSTZART | Allow NULL? |
| 7 | VERLAGSNR | IS-M: VDZ Publisher Number | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | JWBZVRLGNR | Allow NULL? |
| 8 | WBZKUNNR | IS-M: WBZ, VDZ Number of WBZ Company | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | JWBZKUNNR | Allow NULL? |
| 9 | VERTRKENNZ | IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TJKWE | JWBZVKENNZ | Allow NULL? |
| 10 | RECHZENTNR | IS-M: WBZ, Computer Center Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJKW0 | JWBZRZNR | Allow NULL? |
| 11 | WBZVORGART | IS-M: WBZ, Operation Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TJKW3 | JWBZVORART | Allow NULL? |
| 12 | ABONR | IS-M: WBZ, Subscription Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | JWBZABONR | Allow NULL? |
| 13 | WBZTERMIN | IS-M: WBZ, Date (Format: MMYYYYCCCC) | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | JWBZTERMIN | Allow NULL? |
| 14 | EXEMPLARE | IS-M: WBZ, Number of Copies | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | JWBZEXEMPL | Allow NULL? |
| 15 | HEFTANZAHL | IS-M: WBZ, Number of Copies | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JWBZHFTANZ | Allow NULL? |
| 16 | ABOART | IS-M: WBZ, Subscriber Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | JWBZABOART | Allow NULL? |
| 17 | WERBKZSCHL | IS-M: WBZ, Promotion Rebate Key | char | 1 | 0 | CHAR | (N' ') | Yes | TJKW9 | JWBZWKZSCH | Allow NULL? |
| 18 | WERBKZBETR | IS-M: WBZ, Promotion Rebate Amount | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | JWBZWKZBTR | Allow NULL? |
| 19 | PLZ | IS-M: WBZ, Postal Code | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | JWBZPLZ | Allow NULL? |
| 20 | FILLER_15 | IS-M: WBZ, data transfer structure field 15 (remains blank) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | JWBZFELD15 | Allow NULL? |
| 21 | LAND | Vehicle country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | LANDK | Allow NULL? |
| 22 | ANREDE | IS-M: WBZ, Form-of-Address Key | char | 1 | 0 | CHAR | (N' ') | Yes | TJKW5 | JWBZANREDE | Allow NULL? |
| 23 | NAME | IS-M: WBZ, Last and First Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZNAME | Allow NULL? |
| 24 | ANSCHZUS | IS-M: WBZ, Address Affix | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZANSZUS | Allow NULL? |
| 25 | ANSCHZUSKZ | IS-M: WBZ, indicator for address affix | char | 1 | 0 | CHAR | (N' ') | Yes | | JWBZANSZKZ | Allow NULL? |
| 26 | STRASSE | IS-M: WBZ, street | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZSTRASS | Allow NULL? |
| 27 | ORT | IS-M: WBZ, city | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | JWBZORT | Allow NULL? |
| 28 | VERSANDART | IS-M: WBZ, Shipping Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JWBZVSART | Allow NULL? |
| 29 | VERTRETER | IS-M: WBZ, representative indicator | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | JWBZVERTR | Allow NULL? |
| 30 | FEHLERNR | IS-M: WBZ, error number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TJKW7 | JWBZFEHLNR | Allow NULL? |
| 31 | JAHR_HEFT | IS-M: Year and Copy Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | JWBZJHRHFT | Allow NULL? |
| 32 | FILLER_27 | Character Field with Length 5 | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | CHAR05 | Allow NULL? |
| 33 | VERTRBEGIN | IS-M: WBZ, Contract Date (DDMMYY) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | JWBZVERTBG | Allow NULL? |
| 34 | PLZ_NEU | IS-M: WBZ, new postal code (to July 1st 1994) | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | JWBZPLZNEU | Allow NULL? |
| 35 | WBZABOKUNR | IS-M: Subscription Customer Number | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | JWBZABOKNR | Allow NULL? |
| 36 | FILLER_31 | IS-M: Character Field 7 Chars in Length | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | CHAR007 | Allow NULL? |
| 37 | AKTION | IS-M/SD: WBZ, Sales Promotion/Condition Key | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | JWBZAKTION | Allow NULL? |
| 38 | ANZ_MONATE | IS-M/SD: WBZ, Number of Months for Scaled Promotion Rebate | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | JWBZANZ_MONATE | Allow NULL? |
| 39 | WBZTERMIN_2 | IS-M/SD: WBZ, Second Date Field (YYYYNNN) | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | JWBZTERMIN_2 | Allow NULL? |
| 40 | NAMENSZUSATZ | IS-M/SD: WBZ, Name Affix | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZNAMENSZUSATZ | Allow NULL? |
| 41 | WAEHRUNG | IS-M/SD: WBZ, Currency | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | JWBZWAEHRUNG | Allow NULL? |
| 42 | TITEL | IS-M/SD: WBZ, Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | JWBZTITEL | Allow NULL? |
| 43 | VORNAME | IS-M: WBZ, First Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZVORNAME | Allow NULL? |
| 44 | NACHNAME | IS-M: WBZ, Last Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZNACHNAME | Allow NULL? |
| 45 | NAME_2 | IS-M: WBZ, Second Line for Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZNAME_2 | Allow NULL? |
| 46 | NAME_3 | IS-M: WBZ, Third Line for Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZNAME_3 | Allow NULL? |
| 47 | STRASSE_ZUSATZ | IS-M/SD: WBZ, Additional Data for Street | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZSTRASS_ZUSATZ | Allow NULL? |
| 48 | ORT_ZUSATZ | IS-M/SD: WBZ, Affix for City | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | JWBZORT_ZUSATZ | Allow NULL? |
| 49 | EMAIL | IS-M/SD: WBZ, E-Mail Address | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | JWBZEMAIL | Allow NULL? |
| 50 | WBZVERSION | IS-M/SD: WBZ, WBZ Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | JWBZVERSION | Allow NULL? |