| 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 | J_1S_AVNR | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | AVNR | Allow NULL? |
| 3 | VBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AVNR | Allow NULL? |
| 4 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VRSNDDATUM | Allow NULL? |
| 5 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 6 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 7 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 8 | FKUNNR | IS-M: Customer Number in Non-SAP System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | JFKUNNR | Allow NULL? |
| 9 | REFBELEG | IS-M/SD: Reference Document in Legacy System | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | REMELD_ISP | Allow NULL? |
| 10 | ANRED | Form of Address Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | JANRED | Allow NULL? |
| 11 | TITEL | IS-M: Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TITEL_ISP | Allow NULL? |
| 12 | NAME1 | IS-M: Business Partner Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_ISP | Allow NULL? |
| 13 | NAME2 | IS-M: First Name of Business Partner | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME2_ISP | Allow NULL? |
| 14 | NAME3 | IS-M: Further Name Field for Business Partner | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME3_ISP | Allow NULL? |
| 15 | NAME4 | IS-M: Further Name Field for Business Partner | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME4_ISP | Allow NULL? |
| 16 | STRAS | Street Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | STRAS_ISP | Allow NULL? |
| 17 | HAUSN | IS-M: House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | HSNMR1 | Allow NULL? |
| 18 | HSNMR2 | IS-M: House Number Affix | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | HSNMR2 | Allow NULL? |
| 19 | PFACH | IS-M: Post Office Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PFACH_ISP | Allow NULL? |
| 20 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 21 | PSTLZ | IS-M: Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PLZ_ISP | Allow NULL? |
| 22 | ORT01 | IS-M: City | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ORT01_ISP | Allow NULL? |
| 23 | ORT02 | IS-M: City District | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ORT02_ISP | Allow NULL? |
| 24 | BOTENBEZ | IS-M: Carrier Route (CH) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | J_1SBOTBEZ | Allow NULL? |
| 25 | POSTEINORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JSTORTPRO | JALORT | Allow NULL? |
| 26 | POSTEINSTR | IS-M: Street Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JSTSTRPRO | STRASSENNR | Allow NULL? |
| 27 | ETMENGE | IS-M: Sales Order Schedule Line Quantity | decimal | 10 | 0 | QUAN | ((0)) | Yes | | ETMENGE | |
| 28 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ETMEINS | Allow NULL? |
| 29 | KANTON | IS-M: CH: Canton | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_1SKANTON | Allow NULL? |
