| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RZNR | IS-M: WBZ, Computer Center Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | DATUM | IS-M: Date in file name of WBZ file | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | FILE_IN | Logical file name | nvarchar | 60 | 0 | | | | Allow NULL? |
| 5 | ZAEHLER | IS-M: Consecutive Counter for Transfer of External Data | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | STATUS | IS-M: Status of data record in WBZ inbound file | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | XFLGDIALOG | Checkbox | char | 1 | 0 | | | | Allow NULL? |
| 8 | VBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | POSNR | Sales Order Item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | POSEX | External Item Number (Purchase Order Item) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | MSGID | Message Class | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | MSGNO | Message Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | MSGTY | Message Type | char | 1 | 0 | | | | Allow NULL? |
| 14 | MSGV1 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 15 | MSGV2 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 16 | MSGV3 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 17 | MSGV4 | Message Variable | nvarchar | 50 | 0 | | | | Allow NULL? |
| 18 | WBZSATZART | IS-M: WBZ, Record Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | VERLAGSNR | IS-M: VDZ Publisher Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | WBZKUNNR | IS-M: WBZ, VDZ Number of WBZ Company | nvarchar | 6 | 0 | | | | Allow NULL? |
| 21 | VERTRKENNZ | IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | RECHZENTNR | IS-M: WBZ, Computer Center Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | WBZVORGART | IS-M: WBZ, Operation Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | ABONR | IS-M: WBZ, Subscription Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | WBZTERMIN | IS-M: WBZ, Date (Format: MMYYYYCCCC) | nvarchar | 9 | 0 | | | | Allow NULL? |
| 26 | EXEMPLARE | IS-M: WBZ, Number of Copies | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | HEFTANZAHL | IS-M: WBZ, Number of Copies | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | ABOART | IS-M: WBZ, Subscriber Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | WERBKZSCHL | IS-M: WBZ, Promotion Rebate Key | char | 1 | 0 | | | | Allow NULL? |
| 30 | WERBKZBETR | IS-M: WBZ, Promotion Rebate Amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 31 | PLZ | IS-M: WBZ, Postal Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | FILLER_15 | IS-M: WBZ, data transfer structure field 15 (remains blank) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | LAND | Vehicle country key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | ANREDE | IS-M: WBZ, Form-of-Address Key | char | 1 | 0 | | | | Allow NULL? |
| 35 | NAME | IS-M: WBZ, Last and First Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 36 | ANSCHZUS | IS-M: WBZ, Address Affix | nvarchar | 30 | 0 | | | | Allow NULL? |
| 37 | ANSCHZUSKZ | IS-M: WBZ, indicator for address affix | char | 1 | 0 | | | | Allow NULL? |
| 38 | STRASSE | IS-M: WBZ, street | nvarchar | 30 | 0 | | | | Allow NULL? |
| 39 | ORT | IS-M: WBZ, city | nvarchar | 25 | 0 | | | | Allow NULL? |
| 40 | VERSANDART | IS-M: WBZ, Shipping Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | VERTRETER | IS-M: WBZ, representative indicator | nvarchar | 7 | 0 | | | | Allow NULL? |
| 42 | FEHLERNR | IS-M: WBZ, error number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 43 | JAHR_HEFT | IS-M: Year and Copy Number | nvarchar | 7 | 0 | | | | Allow NULL? |
| 44 | FILLER_27 | Character Field with Length 5 | nvarchar | 5 | 0 | | | | Allow NULL? |
| 45 | VERTRBEGIN | IS-M: WBZ, Contract Date (DDMMYY) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 46 | PLZ_NEU | IS-M: WBZ, new postal code (to July 1st 1994) | nvarchar | 5 | 0 | | | | Allow NULL? |
| 47 | WBZABOKUNR | IS-M: Subscription Customer Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 48 | FILLER_31 | IS-M: Character Field 7 Chars in Length | nvarchar | 7 | 0 | | | | Allow NULL? |
| 49 | AKTION | IS-M/SD: WBZ, Sales Promotion/Condition Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 50 | ANZ_MONATE | IS-M/SD: WBZ, Number of Months for Scaled Promotion Rebate | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | WBZTERMIN_2 | IS-M/SD: WBZ, Second Date Field (YYYYNNN) | nvarchar | 7 | 0 | | | | Allow NULL? |
| 52 | NAMENSZUSATZ | IS-M/SD: WBZ, Name Affix | nvarchar | 30 | 0 | | | | Allow NULL? |
| 53 | WAEHRUNG | IS-M/SD: WBZ, Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 54 | TITEL | IS-M/SD: WBZ, Title | nvarchar | 15 | 0 | | | | Allow NULL? |
| 55 | VORNAME | IS-M: WBZ, First Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 56 | NACHNAME | IS-M: WBZ, Last Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 57 | NAME_2 | IS-M: WBZ, Second Line for Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 58 | NAME_3 | IS-M: WBZ, Third Line for Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 59 | STRASSE_ZUSATZ | IS-M/SD: WBZ, Additional Data for Street | nvarchar | 30 | 0 | | | | Allow NULL? |
| 60 | ORT_ZUSATZ | IS-M/SD: WBZ, Affix for City | nvarchar | 30 | 0 | | | | Allow NULL? |
| 61 | EMAIL | IS-M/SD: WBZ, E-Mail Address | nvarchar | 50 | 0 | | | | Allow NULL? |
| 62 | WBZVERSION | IS-M/SD: WBZ, WBZ Version | nvarchar | 3 | 0 | | | | Allow NULL? |
