| 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 | VBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | No | JKAK | AVNR | Allow NULL? |
| 3 | POSNR | Sales Order Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JKAP | APNR | Allow NULL? |
| 4 | ETENR | Sales Order Schedule Line | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | JAENR | Allow NULL? |
| 5 | GUELTIGVON | Date from Which Schedule Line in Sales Order is Valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JKEPVON | Allow NULL? |
| 6 | GUELTIGBIS | Date to Which Schedule Line in Sales Order is Valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JKEPBIS | Allow NULL? |
| 7 | ETEEX | IS-M: External Schedule Line Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | ETEEX_ISP | Allow NULL? |
| 8 | BEZPER | Service Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TJD09 | BEZPER | Allow NULL? |
| 9 | ETART | Schedule Line Type for Internal Sales Order Schedule Line | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJEP | ETART_ISP | Allow NULL? |
| 10 | ZSKLS | Time slice classification for sales order | char | 1 | 0 | CHAR | (N' ') | Yes | | JZSKLS | Allow NULL? |
| 11 | AEART | Order Change Type | char | 1 | 0 | CHAR | (N' ') | Yes | | AEART_JSDK | Allow NULL? |
| 12 | XUREINT | Original schedule line in publishing sales order | char | 1 | 0 | CHAR | (N' ') | Yes | | XUREINT | Allow NULL? |
| 13 | XTAGESBEZ | IS-M: Limited change relating to a specific date | char | 1 | 0 | CHAR | (N' ') | Yes | | XTAGESBEZ | Allow NULL? |
| 14 | ETENR_UR | Source Schedule Line | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JKEP | AENR_UR | Allow NULL? |
| 15 | ETENR_VG | Preceding Schedule Line | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JKEP | AENR_VG | Allow NULL? |
| 16 | ETMENGE | IS-M: Sales Order Schedule Line Quantity | decimal | 10 | 0 | QUAN | ((0)) | Yes | | ETMENGE | |
| 17 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ETMEINS | Allow NULL? |
| 18 | UNTMENGE | IS-M: Suspension quantity | decimal | 10 | 0 | QUAN | ((0)) | Yes | | UNTMENGE | |
| 19 | RKMENGE | Number of complaint copies | decimal | 10 | 0 | QUAN | ((0)) | Yes | | RKMENGE | |
| 20 | NLMENGE | Number of Copies for Subsequent Delivery | decimal | 10 | 0 | QUAN | ((0)) | Yes | | NLMENGE | |
| 21 | ETVORZEI | Plus/Minus Sign for Schedule Line Quantity in Sales Order | char | 1 | 0 | CHAR | (N' ') | Yes | | ETVORZEI | Allow NULL? |
| 22 | REMMG_PLAN | Expected returns | decimal | 10 | 0 | QUAN | ((0)) | Yes | | REMMG_PLAN | |
| 23 | REMME_PLAN | IS-M: Unit of measure of expected returns | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | REMME_PLAN | Allow NULL? |
| 24 | KPOSN | Condition item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KPOSN_ISP | Allow NULL? |
| 25 | NETWR | IS-M: Net price in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | NETWR_ISP | |
| 26 | MWSBP | Tax amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MWSBP | |
| 27 | NETPR | Net price | decimal | 11 | 2 | CURR | ((0)) | Yes | | NETPR | |
| 28 | KPEIN | Condition pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | KPEIN | |
| 29 | KMEIN | Condition unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | KMEIN | Allow NULL? |
| 30 | SKTOF | Cash discount indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SKTOF | Allow NULL? |
| 31 | PRSOK | Pricing is OK | char | 1 | 0 | CHAR | (N' ') | Yes | | PRSOK | Allow NULL? |
| 32 | PRSBINDDAT | To-date for price fixing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRSBINDDAT | Allow NULL? |
| 33 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRSDT | Allow NULL? |
| 34 | PRSPER | IS-M: Price Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJK03 | PRSPER | Allow NULL? |
| 35 | BZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TJD09 | BEZPERFAKT | Allow NULL? |
| 36 | PRSMLT | IS-M: Numerator in conversion factor for frequencies | decimal | 5 | 0 | DEC | ((0)) | Yes | | PRSMLT | |
| 37 | PRSDIV | IS-M: Denominator for frequency conversion factor | decimal | 5 | 0 | DEC | ((0)) | Yes | | PRSDIV | |
| 38 | KZWI1 | Subtotal 1 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI1 | |
| 39 | KZWI2 | Subtotal 2 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI2 | |
| 40 | KZWI3 | Subtotal 3 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI3 | |
| 41 | KZWI4 | Subtotal 4 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI4 | |
| 42 | KZWI5 | Subtotal 5 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI5 | |
| 43 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI6 | |
| 44 | XSTORNO | Indicator: Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | XJSTORNO | Allow NULL? |
| 45 | ANZET | Number of Publication Dates | decimal | 5 | 0 | DEC | ((0)) | Yes | | ANZET | |
| 46 | VAUSGB | Issue | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JDTVAUSGB | VAUSGB | Allow NULL? |
| 47 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 48 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 49 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 50 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 51 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 52 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
| 53 | LFARTLOG | Logistical delivery type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV01 | LFARTLOG | Allow NULL? |
| 54 | XAMOCREDIT | Complaint order - amount credited to liability account | char | 1 | 0 | CHAR | (N' ') | No | | XAMOCREDIT | Allow NULL? |
| 55 | XAMO_ARCHIVED | IS-M/SD: Amortization Data on Cycle Activated | char | 1 | 0 | CHAR | (N' ') | Yes | | XAMO_ARCHIVED | Allow NULL? |
| 56 | XFAKT_ARC | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
