One level Up / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Управление заказами на обслуживание» / Service Order Management tables structure changes

Название Таблицы / Table Name Описание Таблицы / Table Description Поле / Field Расширенный комментарий / Extended Comment Тип данных / Data Type Длина поля iScala 3.5/ iScala 3.5 Length Точность iScala 3.5/ iScala 3.5 Precision Длина поля iScala 2.2/ iScala 2.2 Length Точность iScala 2.2/ iScala 2.2 Precision Новое поле? / is a New Field?
SM01 Service Order Master File SM01005 Customer Purchase Order Number NVARCHAR 30   20   —
SM01 Service Order Master File SM01085 Delivery Note Number NCHAR 20   10   —
SM01 Service Order Master File SM01113 Accounting String NVARCHAR 120   50   —
SM01 Service Order Master File SM01138 Serial number selected warranty type NVARCHAR 3   2   —
SM01 Service Order Master File SM01146 OCU Exchange Rate 1 NUMERIC 10 8 15 8 —
SM01 Service Order Master File SM01147 OCU Exchange Rate 2 NUMERIC 10 8 15 8 —
SM01 Service Order Master File SM01159 Discount Schema Code INT 9   4   —
SM01 Service Order Master File SM01197 Value Component No NCHAR 10   — — +
SM01 Service Order Master File SM01198 Commission Distribution Method NCHAR 1   — — +
SM01 Service Order Master File SM01199 Execution Order flag NCHAR 1   — — +
SM01 Service Order Master File SM01200 WC Maintenance Task ID INT 4   — — +
SM01 Service Order Master File SM01201 PM Counter Qty Type NCHAR 2   — — +
SM01 Service Order Master File SM01202 Delivery Note Sort Order INT 1   — — +
SM01 Service Order Master File SM01203 Print Delivery Note at picking confirmation NCHAR 1   — — +
SM01 Service Order Master File SM01204 Send Delivery Note at picking confirmation NCHAR 1   — — +
SM01 Service Order Master File SM01205 Delivery blocked INT 1   — — +
SM01 Service Order Master File SM01206 E-Mail Address NVARCHAR 200   — — +
SM01 Service Order Master File SM01207 Partial Delivery Planning NVARCHAR 1   — — +
SM01 Service Order Master File SM01208 Customer for pricing INT 1   — — +
SM01 Service Order Master File SM01209 Credit Check Passed NCHAR 1   — — +
SM01 Service Order Master File SM01210 External ID NVARCHAR 36   — — +
SM01 Service Order Master File SM01211 Red Storno Default NCHAR 1   — — +
SM01 Service Order Master File SM01212 InvPlanLineNo NCHAR 6   — — +
SM01 Service Order Master File SM01213 Public Procurement Code 1 NVARCHAR 20   — — +
SM01 Service Order Master File SM01214 Public Procurement Code 2 NVARCHAR 20   — — +
SM01 Service Order Master File SM01215 OCU Exchange Algorithm NCHAR 3   — — +
SM01 Service Order Master File SM01216 Own Bank Code 1 NCHAR 2   — — +
SM01 Service Order Master File SM01217 Own Bank Code 2 NCHAR 2   — — +
SM01 Service Order Master File SM01218 Tax Registration Country NCHAR 3   — — +
SM03 Service Order Activity File I/O SM03005 Description NVARCHAR 35   25   —
SM03 Service Order Activity File I/O SM03034 Accounting String NVARCHAR 120   50   —
SM03 Service Order Activity File I/O SM03069 Operation Type Time NVARCHAR 10   — — +
SM03 Service Order Activity File I/O SM03070 Financial Operation CodeTime NVARCHAR 10   — — +
SM03 Service Order Activity File I/O SM03071 Line GUID NVARCHAR 36   — — +
SM03 Service Order Activity File I/O SM03072 Line Group NVARCHAR 6   — — +
SM03 Service Order Activity File I/O SM03073 JobID INT 9   — — +
SM03 Service Order Activity File I/O SM03074 Delivery Note Number NVARCHAR 20   — — +
SM03 Service Order Activity File I/O SM03075 Delivery blocked INT 1   — — +
SM03 Service Order Activity File I/O SM03076 Approved Credit Limit NCHAR 1   — — +
SM03 Service Order Activity File I/O SM03077 Confirmed Arrival Date DATETIME 8   — — +
SM03 Service Order Activity File I/O SM03078 InvPlanLineNo NCHAR 6   — — +
SM03 Service Order Activity File I/O SM03079 Taxation Reason Code NCHAR 3   — — +
SM04 Service Order Invoice Customer File SM04025 Accounting String NVARCHAR 120   50   —
SM04 Service Order Invoice Customer File SM04061 Invoice Issuer Code NVARCHAR 6   4   —
SM04 Service Order Invoice Customer File SM04069 Tax Code for Invoice Fee NCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04070 Fixed Price OCU NUMERIC 13 8 — — +
SM04 Service Order Invoice Customer File SM04071 Fixed Price ICU NUMERIC 13 8 — — +
SM04 Service Order Invoice Customer File SM04072 Fixed Price LCU NUMERIC 13 8 — — +
SM04 Service Order Invoice Customer File SM04073 Tax Code for Fixed Price NCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04074 Operation Type Order NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04075 Financial Operation Code Order NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04076 Operation Type Time NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04077 Financial Operation Code Time NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04078 Operation Type Cost NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04079 Financial Operation Code Cost NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04080 Operation Type Material NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04081 Financial Operation Code Material NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04082 Instalment NCHAR 1   — — +
SM04 Service Order Invoice Customer File SM04083 Interest% NUMERIC 12 8 — — +
SM04 Service Order Invoice Customer File SM04084 New Interest% NUMERIC 12 8 — — +
SM04 Service Order Invoice Customer File SM04085 Activate New Interest Date DATETIME 8   — — +
SM04 Service Order Invoice Customer File SM04086 Financial Charge NUMERIC 20 8 — — +
SM04 Service Order Invoice Customer File SM04087 Interest Tax Code NCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04088 Financial Tax Code NCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04089 Specification Printed Flag NCHAR 1   — — +
SM04 Service Order Invoice Customer File SM04090 Fixed Price Time Line Group NVARCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04091 Fixed Price Cost Line Group NVARCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04092 Fixed Price Mat Line Group NVARCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04093 ExternalCommissionAmount NUMERIC 20 8 — — +
SM04 Service Order Invoice Customer File SM04094 District NCHAR 2   — — +
SM04 Service Order Invoice Customer File SM04095 Advertising Code NCHAR 2   — — +
SM04 Service Order Invoice Customer File SM04096 City Code NCHAR 4   — — +
SM04 Service Order Invoice Customer File SM04097 SNI Code NCHAR 5   — — +
SM04 Service Order Invoice Customer File SM04098 Bank Code NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04099 Payment Address Code NVARCHAR 2   — — +
SM04 Service Order Invoice Customer File SM04100 Extended Commission Code NCHAR 2   — — +
SM04 Service Order Invoice Customer File SM04101 Invoice counter ID NVARCHAR 12   — — +
SM04 Service Order Invoice Customer File SM04102 Invoice Copy Number INT 4   — — +
SM04 Service Order Invoice Customer File SM04103 On-account Invoice Copy Number INT 4   — — +
SM04 Service Order Invoice Customer File SM04104 Original Order No NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04105 Original Invoice No NVARCHAR 15   — — +
SM04 Service Order Invoice Customer File SM04106 Flag Doc XML Invoice INT 1   — — +
SM04 Service Order Invoice Customer File SM04107 Last Invoice Time DATETIME 17   — — +
SM04 Service Order Invoice Customer File SM04108 Last Advance Invoice Time DATETIME 17   — — +
SM04 Service Order Invoice Customer File SM04109 Freight Amount, ICU NUMERIC 20 8 — — +
SM04 Service Order Invoice Customer File SM04110 Tax Code for Freight NCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04111 Freight Payer NCHAR 1   — — +
SM04 Service Order Invoice Customer File SM04112 Net Weight NUMERIC 10 8 — — +
SM04 Service Order Invoice Customer File SM04113 Gross Weight NUMERIC 10 8 — — +
SM04 Service Order Invoice Customer File SM04114 Volume NUMERIC 10 8 — — +
SM04 Service Order Invoice Customer File SM04115 No Of Units NUMERIC 10 8 — — +
SM04 Service Order Invoice Customer File SM04116 Kind Of Box NVARCHAR 15   — — +
SM04 Service Order Invoice Customer File SM04117 Box Numbering NVARCHAR 15   — — +
SM04 Service Order Invoice Customer File SM04118 Number Of Pallets NVARCHAR 15   — — +
SM04 Service Order Invoice Customer File SM04119 Transport Company Code NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04120 Vehicle State NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04121 Vehicle License Plate NVARCHAR 15   — — +
SM04 Service Order Invoice Customer File SM04122 Code ANTT NVARCHAR 10   — — +
SM04 Service Order Invoice Customer File SM04123 Taxes for Freight NCHAR 1   — — +
SM04 Service Order Invoice Customer File SM04124 Fiscal Key Reference NVARCHAR 50   — — +
SM04 Service Order Invoice Customer File SM04125 Spesometro Forms NVARCHAR 12   — — +
SM04 Service Order Invoice Customer File SM04126 Tax Point NCHAR 1   — — +
SM04 Service Order Invoice Customer File SM04127 InvPlanLineNo NCHAR 6   — — +
SM04 Service Order Invoice Customer File SM04128 Taxation Reason Code Fixed Price NCHAR 3   — — +
SM04 Service Order Invoice Customer File SM04129 Taxation Reason Code On-Account NCHAR 3   — — +
SM04 Service Order Invoice Customer File SM04130 ICU Exchange Rate 1 NUMERIC 10 8 — — +
SM04 Service Order Invoice Customer File SM04131 ICU Exchange Rate 2 NUMERIC 10 8 — — +
SM04 Service Order Invoice Customer File SM04132 ICU Exchange Algorithm NCHAR 3   — — +
SM04 Service Order Invoice Customer File SM04133 Credit Reason NVARCHAR 50   — — +
SM05 Service Order Cost File I/O SM05005 Description NVARCHAR 35   25   —
SM05 Service Order Cost File I/O SM05032 Accounting String NVARCHAR 120   50   —
SM05 Service Order Cost File I/O SM05057 Cost Invoice Number NCHAR 25   15   —
SM05 Service Order Cost File I/O SM05059 General Ledger Transaction Number NCHAR 9   6   —
SM05 Service Order Cost File I/O SM05070 GL Update Flag NCHAR 1   — — +
SM05 Service Order Cost File I/O SM05071 GL Transaction Text NVARCHAR 25   — — +
SM05 Service Order Cost File I/O SM05072 Operation Type Cost NVARCHAR 10   — — +
SM05 Service Order Cost File I/O SM05073 Financial Operation Code Cost NVARCHAR 10   — — +
SM05 Service Order Cost File I/O SM05074 Line Group NVARCHAR 6   — — +
SM05 Service Order Cost File I/O SM05075 Job ID INT 9   — — +
SM05 Service Order Cost File I/O SM05076 Delivery Note Number NVARCHAR 20   — — +
SM05 Service Order Cost File I/O SM05077 Delivery blocked INT 1   — — +
SM05 Service Order Cost File I/O SM05078 Line GUID NVARCHAR 36   — — +
SM05 Service Order Cost File I/O SM05079 Approved Credit Limit NCHAR 1   — — +
SM05 Service Order Cost File I/O SM05080 Confirmed Arrival Date DATETIME 8   — — +
SM05 Service Order Cost File I/O SM05081 InvPlanLineNo NCHAR 6   — — +
SM05 Service Order Cost File I/O SM05082 Planed Quantity 1 NUMERIC 12 8 — — +
SM05 Service Order Cost File I/O SM05083 Actual Quantity 1 NUMERIC 12 8 — — +
SM05 Service Order Cost File I/O SM05084 Planed Quantity 2 NUMERIC 12 8 — — +
SM05 Service Order Cost File I/O SM05085 Actual Quantity 2 NUMERIC 12 8 — — +
SM05 Service Order Cost File I/O SM05086 Planed Quantity 3 NUMERIC 12 8 — — +
SM05 Service Order Cost File I/O SM05087 Actual Quantity 3 NUMERIC 12 8 — — +
SM05 Service Order Cost File I/O SM05088 Taxation Reason Code NCHAR 3   — — +
SM06 Service Order Line Delivery Definition SM06039 Return Note Number NVARCHAR 20   10   —
SM06 Service Order Line Delivery Definition SM06049 Reason Code NCHAR 3   — — +
SM06 Service Order Line Delivery Definition SM06050 Dispatch Note NVARCHAR 20   — — +
SM06 Service Order Line Delivery Definition SM06051 Quantity Returned Good Items (Stock Unit) NUMERIC 13 8 — — +
SM06 Service Order Line Delivery Definition SM06052 Quantity Returned Bad Items (Stock Unit) NUMERIC 13 8 — — +
SM06 Service Order Line Delivery Definition SM06053 Parent Delivery Line Number NCHAR 4   — — +
SM06 Service Order Line Delivery Definition SM06054 Quantity Sold (Order Unit) NUMERIC 13 8 — — +
SM06 Service Order Line Delivery Definition SM06055 Quantity Sold (Stock Unit) NUMERIC 13 8 — — +
SM06 Service Order Line Delivery Definition SM06056 DNIssuerCode NCHAR 6   — — +
SM06 Service Order Line Delivery Definition SM06057 Confirmed Arrival Date DATETIME 8   — — +
SM06 Service Order Line Delivery Definition SM06058 InvPlanLineNo NCHAR 6   — — +
SM07 Service Order Material File I/O SM07015 Unit Code INT 4   2   —
SM07 Service Order Material File I/O SM07058 Accounting String NVARCHAR 120   50   —
SM07 Service Order Material File I/O SM07089 Return Note Number NVARCHAR 20   10   —
SM07 Service Order Material File I/O SM07123 Operation Type Material NVARCHAR 10   — — +
SM07 Service Order Material File I/O SM07124 Financial Operation Code Material NVARCHAR 10   — — +
SM07 Service Order Material File I/O SM07125 Line Group NVARCHAR 6   — — +
SM07 Service Order Material File I/O SM07126 Depreciation NCHAR 1   — — +
SM07 Service Order Material File I/O SM07127 Asset NVARCHAR 35   — — +
SM07 Service Order Material File I/O SM07128 ExecutionLineType INT 1   — — +
SM07 Service Order Material File I/O SM07129 Sold Qty NUMERIC 12 8 — — +
SM07 Service Order Material File I/O SM07130 Sold Qty SC NUMERIC 12 8 — — +
SM07 Service Order Material File I/O SM07131 Sales Date DATETIME 8   — — +
SM07 Service Order Material File I/O SM07132 Disposal Code NVARCHAR 6   — — +
SM07 Service Order Material File I/O SM07133 Reason Code NCHAR 3   — — +
SM07 Service Order Material File I/O SM07134 Dispatch Note NVARCHAR 20   — — +
SM07 Service Order Material File I/O SM07135 Quantity that has been Invoiced (Order Unit) for exec lines NUMERIC 12 8 — — +
SM07 Service Order Material File I/O SM07136 Spare NUMERIC 12 8 — — +
SM07 Service Order Material File I/O SM07137 Job ID INT 9   — — +
SM07 Service Order Material File I/O SM07138 Delivery blocked INT 1   — — +
SM07 Service Order Material File I/O SM07139 ItemType INT 1   — — +
SM07 Service Order Material File I/O SM07140 Line GUID NVARCHAR 36   — — +
SM07 Service Order Material File I/O SM07141 Approved Credit Limit NCHAR 1   — — +
SM07 Service Order Material File I/O SM07142 Nomenclature Number NVARCHAR 25   — — +
SM07 Service Order Material File I/O SM07143 Product Tax Type NVARCHAR 10   — — +
SM07 Service Order Material File I/O SM07144 Line Freight Amount OCU NUMERIC 20 8 — — +
SM07 Service Order Material File I/O SM07145 Line FreightAmount ICU NUMERIC 20 8 — — +
SM07 Service Order Material File I/O SM07146 Entry Invoice No NVARCHAR 15   — — +
SM07 Service Order Material File I/O SM07147 InvPlanLineNo NCHAR 6   — — +
SM07 Service Order Material File I/O SM07148 Return WH NVARCHAR 6   — — +
SM07 Service Order Material File I/O SM07149 Taxation Reason Code NCHAR 3   — — +
SM08 Service Order Internal Invoice Summary File SM08006 Description NVARCHAR 35   25   —
SM08 Service Order Internal Invoice Summary File SM08023 Accounting String NVARCHAR 120   50   —
SM09 Service Management Text File SM09008 Language Code NCHAR 3   — — +
SM09 Service Management Text File SM09009 Invoice Number NCHAR 15   — — +
SM10 Service Order Type Parameter File I/O SM10005 Option String 2 NCHAR 64   32   —
SM10 Service Order Type Parameter File I/O SM10006 Accounting String NVARCHAR 120   50   —
SM10 Service Order Type Parameter File I/O SM10010 Operation Type Time NVARCHAR 10   — — +
SM10 Service Order Type Parameter File I/O SM10011 Financial Operation Code Time NVARCHAR 10   — — +
SM10 Service Order Type Parameter File I/O SM10012 Operation Type Cost NVARCHAR 10   — — +
SM10 Service Order Type Parameter File I/O SM10013 Financial Operation Code Cost NVARCHAR 10   — — +
SM10 Service Order Type Parameter File I/O SM10014 Operation Type Material NVARCHAR 10   — — +
SM10 Service Order Type Parameter File I/O SM10015 Financial Operation Code Material NVARCHAR 10   — — +
SM10 Service Order Type Parameter File I/O SM10016 Order status for Closed NVARCHAR 2   — — +
SM10 Service Order Type Parameter File I/O SM10017 Overview Configuration NVARCHAR 50   — — +
SM10 Service Order Type Parameter File I/O SM10018 Execution Order NCHAR 1   — — +
SM10 Service Order Type Parameter File I/O SM10019 Extended Commission NCHAR 1   — — +
SM10 Service Order Type Parameter File I/O SM10020 Closing rule INT 1   — — +
SM10 Service Order Type Parameter File I/O SM10021 Reason Code NCHAR 3   — — +
SM10 Service Order Type Parameter File I/O SM10022 Deduction Rule INT 1   — — +
SM10 Service Order Type Parameter File I/O SM10023 Default Serial Number Transaction Type For ESC NCHAR 3   — — +
SM11 Service Contract Master File I/O SM11040 Customer Purchase Order Number NVARCHAR 30   20   —
SM11 Service Contract Master File I/O SM11101 Accounting String NVARCHAR 120   50   —
SM11 Service Contract Master File I/O SM11113 Salesman Contract Administrator NCHAR 6   3   —
SM11 Service Contract Master File I/O SM11151 Invoice Issuer Code NVARCHAR 6   4   —
SM11 Service Contract Master File I/O SM11168 Tax Code for Invoice Fee NCHAR 6   — — +
SM11 Service Contract Master File I/O SM11169 Reservation Time Out (Duration) INT 2   — — +
SM11 Service Contract Master File I/O SM11170 Reservation Time Out (Time unit) INT 2   — — +
SM11 Service Contract Master File I/O SM11171 Avoid Backorders NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11172 Accept Line Split NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11173 AcceptOrderSplit NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11174 Use LTM NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11175 Accepted Delivery Interval INT 2   — — +
SM11 Service Contract Master File I/O SM11176 Carrier Code NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11177 Carrier Name NVARCHAR 35   — — +
SM11 Service Contract Master File I/O SM11178 Delivery Note, sort INT 4   — — +
SM11 Service Contract Master File I/O SM11179 Auto print DN NVARCHAR 1   — — +
SM11 Service Contract Master File I/O SM11180 Auto send DN NVARCHAR 1   — — +
SM11 Service Contract Master File I/O SM11181 Operation Type NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11182 Financial Operation Code NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11183 Instalment NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11184 Interest% NUMERIC 12 8 — — +
SM11 Service Contract Master File I/O SM11185 New Interest% NUMERIC 12 8 — — +
SM11 Service Contract Master File I/O SM11186 Activate New Interest Date DATETIME 8   — — +
SM11 Service Contract Master File I/O SM11187 Financial Charge NUMERIC 20 8 — — +
SM11 Service Contract Master File I/O SM11188 Interest Tax Code NCHAR 6   — — +
SM11 Service Contract Master File I/O SM11189 Financial Tax Code NCHAR 6   — — +
SM11 Service Contract Master File I/O SM11190 Default Engineer NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11191 Reorder Customer NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11192 Delivery note printing INT 1   — — +
SM11 Service Contract Master File I/O SM11193 Invoice printing INT 1   — — +
SM11 Service Contract Master File I/O SM11194 Contract Pricing Date DATETIME 8   — — +
SM11 Service Contract Master File I/O SM11195 Contract Pricing Number NCHAR 10   — — +
SM11 Service Contract Master File I/O SM11196 Credit Note Closure Status INT 1   — — +
SM11 Service Contract Master File I/O SM11197 Execution Order No NCHAR 10   — — +
SM11 Service Contract Master File I/O SM11198 District NCHAR 2   — — +
SM11 Service Contract Master File I/O SM11199 Advertising Code NCHAR 2   — — +
SM11 Service Contract Master File I/O SM11200 City Code NCHAR 4   — — +
SM11 Service Contract Master File I/O SM11201 SNI Code NCHAR 5   — — +
SM11 Service Contract Master File I/O SM11202 Commission Distribution Method NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11203 Customer Account Code NCHAR 2   — — +
SM11 Service Contract Master File I/O SM11204 (obsolete) NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11205 Depot WH NVARCHAR 6   — — +
SM11 Service Contract Master File I/O SM11206 Price Type Asset INT 1   — — +
SM11 Service Contract Master File I/O SM11207 Price Type Accessory INT 1   — — +
SM11 Service Contract Master File I/O SM11208 Document Specification INT 1   — — +
SM11 Service Contract Master File I/O SM11209 Invoice Specification INT 1   — — +
SM11 Service Contract Master File I/O SM11210 Bank Code NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11211 Payment Address Code NVARCHAR 2   — — +
SM11 Service Contract Master File I/O SM11212 Spare NVARCHAR 12   — — +
SM11 Service Contract Master File I/O SM11213 Contract Interval Length INT 7   — — +
SM11 Service Contract Master File I/O SM11214 Contract Interval Time Unit INT 1   — — +
SM11 Service Contract Master File I/O SM11215 Delivery Date Milestone INT 1   — — +
SM11 Service Contract Master File I/O SM11216 Delivery Time Value NUMERIC 12 8 — — +
SM11 Service Contract Master File I/O SM11217 Delivery Time Unit INT 2   — — +
SM11 Service Contract Master File I/O SM11218 Invoice Copy Number INT 4   — — +
SM11 Service Contract Master File I/O SM11219 (obsolete) INT 1   — — +
SM11 Service Contract Master File I/O SM11220 E-Mail Address NVARCHAR 200   — — +
SM11 Service Contract Master File I/O SM11221 Invoice Time DATETIME 17   — — +
SM11 Service Contract Master File I/O SM11222 Invoicing Model INT 2   — — +
SM11 Service Contract Master File I/O SM11223 Fixed Price NUMERIC 20 8 — — +
SM11 Service Contract Master File I/O SM11224 Credit Check Passed NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11225 Linked Project Activity NVARCHAR 30   — — +
SM11 Service Contract Master File I/O SM11226 Invoice Plan Line Number NCHAR 6   — — +
SM11 Service Contract Master File I/O SM11227 Spesometro Forms NVARCHAR 12   — — +
SM11 Service Contract Master File I/O SM11228 Tax Point NCHAR 1   — — +
SM11 Service Contract Master File I/O SM11229 Public Procurement Code 1 NVARCHAR 20   — — +
SM11 Service Contract Master File I/O SM11230 Public Procurement Code 2 NVARCHAR 20   — — +
SM11 Service Contract Master File I/O SM11231 Operation Type (Service Contract Line or Asset Lease Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11232 Financial Operation Code (Service Contract Line or Asset Lease Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11233 Operation Type (Asset Maintenance Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11234 Financial Operation Code (Asset Maintenance Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11235 Operation Type (Accessory Lease Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11236 Financial Operation Code (Accessory Lease Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11237 Operation Type (Accessory Maintenance Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11238 Financial Operation Code (Accessory Maintenance Line) NVARCHAR 10   — — +
SM11 Service Contract Master File I/O SM11239 OCU Exchange Rate 1 NUMERIC 10 8 — — +
SM11 Service Contract Master File I/O SM11240 OCU Exchange Rate 2 NUMERIC 10 8 — — +
SM11 Service Contract Master File I/O SM11241 OCU Exchange Algorithm NCHAR 3   — — +
SM11 Service Contract Master File I/O SM11242 ICU Exchange Rate 1 NUMERIC 10 8 — — +
SM11 Service Contract Master File I/O SM11243 ICU Exchange Rate 2 NUMERIC 10 8 — — +
SM11 Service Contract Master File I/O SM11244 ICU Exchange Algorithm NCHAR 3   — — +
SM11 Service Contract Master File I/O SM11245 Tax Registration Country NCHAR 3   — — +
SM13 Service Contract Line File I/O SM13030 Accounting String NVARCHAR 120   50   —
SM13 Service Contract Line File I/O SM13047 Unit Code Quantity INT 4   2   —
SM13 Service Contract Line File I/O SM13051 Requested Date DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13052 Confirmed Date DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13053 Last Used Date DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13054 AcceptedDate DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13055 Spare NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13056 Default Engineer NVARCHAR 10   — — +
SM13 Service Contract Line File I/O SM13057 Reservation Expiry Date DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13058 Requested Delivery Time remark NVARCHAR 20   — — +
SM13 Service Contract Line File I/O SM13059 Accepted Delivery Time remark NVARCHAR 20   — — +
SM13 Service Contract Line File I/O SM13060 Contract Line Pricing Date DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13061 Contract Pricing Number NCHAR 10   — — +
SM13 Service Contract Line File I/O SM13062 InvoiceNo NCHAR 15   — — +
SM13 Service Contract Line File I/O SM13063 Execution Line No NCHAR 4   — — +
SM13 Service Contract Line File I/O SM13064 Lease Object Type NCHAR 1   — — +
SM13 Service Contract Line File I/O SM13065 Lease Line Nature INT 1   — — +
SM13 Service Contract Line File I/O SM13066 Line Group Code NVARCHAR 6   — — +
SM13 Service Contract Line File I/O SM13067 Value Component NVARCHAR 10   — — +
SM13 Service Contract Line File I/O SM13068 Index Clause NCHAR 1   — — +
SM13 Service Contract Line File I/O SM13069 Deposit NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13070 Capital Value NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13071 Residual Value NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13072 Interest Rate Code NVARCHAR 6   — — +
SM13 Service Contract Line File I/O SM13073 Interest Rate Percentage NUMERIC 7 8 — — +
SM13 Service Contract Line File I/O SM13074 Interest Rate Time INT 3   — — +
SM13 Service Contract Line File I/O SM13075 Interest Rate Time Unit INT 1   — — +
SM13 Service Contract Line File I/O SM13076 Total Number of Periods NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13077 Current number of Periods NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13078 Invoiced number of Periods NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13079 Lease Charge NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13080 Accumulated Depreciation NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13081 Execution Structure Line Number NCHAR 6   — — +
SM13 Service Contract Line File I/O SM13082 Execution Sub Structure Line Number NCHAR 6   — — +
SM13 Service Contract Line File I/O SM13083 Create Service Order on Return NCHAR 1   — — +
SM13 Service Contract Line File I/O SM13084 Days in Service INT 3   — — +
SM13 Service Contract Line File I/O SM13085 Linked Lease Contract No NVARCHAR 10   — — +
SM13 Service Contract Line File I/O SM13086 Linked Lease Contract Line No NVARCHAR 6   — — +
SM13 Service Contract Line File I/O SM13087 Linked Lease Contract Subline No NVARCHAR 6   — — +
SM13 Service Contract Line File I/O SM13088 Capital Charge NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13089 Interest Charge NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13090 Invoice Time Value NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13091 Invoice Time Unit INT 2   — — +
SM13 Service Contract Line File I/O SM13092 Prior Qty NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13093 Change Date DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13094 Use Best Price NCHAR 1   — — +
SM13 Service Contract Line File I/O SM13095 Job ID INT 9   — — +
SM13 Service Contract Line File I/O SM13096 Service Order Type NCHAR 6   — — +
SM13 Service Contract Line File I/O SM13097 Min Ordered Qty NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13098 Delivery Time NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13099 Delivery Time Unit INT 2   — — +
SM13 Service Contract Line File I/O SM13100 Subtype INT 1   — — +
SM13 Service Contract Line File I/O SM13101 Approved Credit Limit NCHAR 1   — — +
SM13 Service Contract Line File I/O SM13102 Variable Interest Rate Code 1 NCHAR 3   — — +
SM13 Service Contract Line File I/O SM13103 Variable Interest Rate Percent.1 NUMERIC 7 8 — — +
SM13 Service Contract Line File I/O SM13104 Variable Interest Rate Code 2 NCHAR 3   — — +
SM13 Service Contract Line File I/O SM13105 Variable Interest Rate Percent.2 NUMERIC 7 8 — — +
SM13 Service Contract Line File I/O SM13106 Invoice Plan Line Number NCHAR 6   — — +
SM13 Service Contract Line File I/O SM13107 Agreed Interval NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13108 Agreed Interval Unit INT 2   — — +
SM13 Service Contract Line File I/O SM13109 Agreed Qty NUMERIC 12 8 — — +
SM13 Service Contract Line File I/O SM13110 Qty Type NCHAR 2   — — +
SM13 Service Contract Line File I/O SM13111 Over Price/Qty NUMERIC 20 8 — — +
SM13 Service Contract Line File I/O SM13112 Cost Code NCHAR 8   — — +
SM13 Service Contract Line File I/O SM13113 Usage Billing From DATETIME 8   — — +
SM13 Service Contract Line File I/O SM13114 Return WH NVARCHAR 6   — — +
SM13 Service Contract Line File I/O SM13115 Operation Type NVARCHAR 10   — — +
SM13 Service Contract Line File I/O SM13116 Financial Operation Code NVARCHAR 10   — — +
SM13 Service Contract Line File I/O SM13117 NCM Code NVARCHAR 25   — — +
SM13 Service Contract Line File I/O SM13118 Taxation Reason Code NCHAR 3   — — +
SM13 Service Contract Line File I/O SM13119 Quantity Per Multiple NUMERIC 12 8 — — +
SM15 Service Contract Parameter File SM15136 Default Contract Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15137 Default Contract Nature NCHAR 1   — — +
SM15 Service Contract Parameter File SM15138 Service Entry Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15139 Service Contract Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15140 Sales Entry Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15141 Sales Contract Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15142 Purchase Entry Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15143 Purchase Contract Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15144 Lease Entry Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15145 Lease Contract Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15146 Rental Entry Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15147 Rental Contract Type NCHAR 3   — — +
SM15 Service Contract Parameter File SM15148 Create Electronic Contract INT 1   — — +
SM15 Service Contract Parameter File SM15149 Credit Check Service NCHAR 1   — — +
SM15 Service Contract Parameter File SM15150 Credit Check Lease NCHAR 1   — — +
SM15 Service Contract Parameter File SM15151 Credit Check Sales NCHAR 1   — — +
SM15 Service Contract Parameter File SM15152 Credit Check Line NCHAR 1   — — +
SM15 Service Contract Parameter File SM15153 Credit Check Skip Additional NCHAR 1   — — +
SM15 Service Contract Parameter File SM15154 Credit Check Exit NCHAR 1   — — +
SM15 Service Contract Parameter File SM15155 Credit Limit Block Quotation NCHAR 1   — — +
SM15 Service Contract Parameter File SM15156 Credit Limit Block Entry NCHAR 1   — — +
SM15 Service Contract Parameter File SM15157 Credit Limit Block Reservation NCHAR 1   — — +
SM15 Service Contract Parameter File SM15158 Credit Limit Block Allocation NCHAR 1   — — +
SM15 Service Contract Parameter File SM15159 Credit Limit Block Delivery NCHAR 1   — — +
SM15 Service Contract Parameter File SM15160 Credit Limit Block Service Order NCHAR 1   — — +
SM15 Service Contract Parameter File SM15161 Tax Point NCHAR 1   — — +
SM18 Contract Price Table SM18013 Object Type INT 2   — — +
SM18 Contract Price Table SM18014 Price Usage INT 2   — — +
SM18 Contract Price Table SM18015 Contract Category INT 2   — — +
SM1T Service Contract Line Text File I/O SM1T008 InvoiceNo NCHAR 15   — — +
SM1T Service Contract Line Text File I/O SM1T009 Invoice Plan Line Number NCHAR 6   — — +
SM20 Service Contract Automatic Accounting Coding Schedule SM20004 Customer Accounting Code NCHAR 2   — — +
SM20 Service Contract Automatic Accounting Coding Schedule SM20005 Contract Accounting Code NCHAR 2   — — +
SM20 Service Contract Automatic Accounting Coding Schedule SM20006 Auto Accounting Schedule Group NCHAR 2   — — +
SM24 Service Order Activity Files Descriptions SM24022 Accounting String NVARCHAR 120   50   —
SM24 Service Order Activity Files Descriptions SM24024 Extended Commission Code NCHAR 2   — — +
SM24 Service Order Activity Files Descriptions SM24025 Qty Number INT 1   — — +
SM24 Service Order Activity Files Descriptions SM24026 Lock Secondary Sub Dimensions INT 1   — — +
SM24 Service Order Activity Files Descriptions SM24027 Taxation Reason Code NCHAR 3   — — +
SM26 Service Order Parameter File SM26215 Order Number Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26216 Resource from Order header Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26217 Resource Group Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26218 Resource Manager Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26219 ETA date & time Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26220 ETR date & time Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26221 Order Delay Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26222 Escalation Level Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26223 Weighted Order Priority Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26224 Order Status Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26225 Service Customer Code Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26226 Service Customer Name Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26227 Service Object Code Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26228 Service Object Description Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26229 Serial Number of Service Object Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26230 Contract Number Flag NCHAR 1   — — +
SM26 Service Order Parameter File SM26231 Activity Start date & time NCHAR 1   — — +
SM26 Service Order Parameter File SM26232 Activity End date & time NCHAR 1   — — +
SM26 Service Order Parameter File SM26233 Actual Start date & time NCHAR 1   — — +
SM26 Service Order Parameter File SM26234 Actual End date & time NCHAR 1   — — +
SM26 Service Order Parameter File SM26235 Default Entry Type NCHAR 3   — — +
SM26 Service Order Parameter File SM26236 Profile for PM Order proposal line NVARCHAR 50   — — +
SM26 Service Order Parameter File SM26237 Mass Update Profile NVARCHAR 30   — — +
SM26 Service Order Parameter File SM26238 CheckCreditLimit NCHAR 1   — — +
SM26 Service Order Parameter File SM26239 Credit Limit Block Drop Shipment NCHAR 1   — — +
SM26 Service Order Parameter File SM26240 Red Storno Default NCHAR 1   — — +
SM26 Service Order Parameter File SM26241 Use prepayments/advances NCHAR 1   — — +
SM26 Service Order Parameter File SM26242 Tax Point NCHAR 1   — — +
SM26 Service Order Parameter File SM26243 Delivery Date for Tax Booking NCHAR 1   — — +
SM26 Service Order Parameter File SM26244 Restrict Order Adjustment after Prepayment NCHAR 1   — — +
SM29 Service Order Template SM29015 Accounting String NVARCHAR 120   50   —
SM29 Service Order Template SM29028 Partial Delivery Planning NVARCHAR 1   — — +
SM29 Service Order Template SM29029 Customer for pricing NVARCHAR 1   — — +
SM29 Service Order Template SM29030 Operation Type Order Header NVARCHAR 10   — — +
SM29 Service Order Template SM29031 Financial Operation Code Order Header NVARCHAR 10   — — +
SM29 Service Order Template SM29032 Operation Type Time Lines NVARCHAR 10   — — +
SM29 Service Order Template SM29033 Financial Operation Code Time Lines NVARCHAR 10   — — +
SM29 Service Order Template SM29034 Operation Type Cost Lines NVARCHAR 10   — — +
SM29 Service Order Template SM29035 Financial Operation Code Cost Lines NVARCHAR 10   — — +
SM29 Service Order Template SM29036 Operation Type Material Lines NVARCHAR 10   — — +
SM29 Service Order Template SM29037 Financial Operation Code Material Lines NVARCHAR 10   — — +
SM2A Extended order lines (SM History) SM2A017 Spare NCHAR 4   — — +
SM2A Extended order lines (SM History) SM2A018 UDMS Code NCHAR 6   — — +
SM2A Extended order lines (SM History) SM2A019 Status INT 1   — — +
SM2A Extended order lines (SM History) SM2A020 Original Start Date DATETIME 8   — — +
SM2A Extended order lines (SM History) SM2A021 Original Finish Date DATETIME 8   — — +
SM2D Service Order Activity Descriptions SM2D004 Unit Name Qty NVARCHAR 20   — — +
SM2D Service Order Activity Descriptions SM2D005 Unit Name 1 NVARCHAR 20   — — +
SM2D Service Order Activity Descriptions SM2D006 Unit Name 2 NVARCHAR 20   — — +
SM2D Service Order Activity Descriptions SM2D007 Unit Name 3 NVARCHAR 20   — — +
SM30 WIP Transaction Control file SM30001 Transaction Number NCHAR 9   6   —
SM30 WIP Transaction Control file SM30002 Line Number NCHAR 7   5   —
SM30 WIP Transaction Control file SM30004 Accounting String NVARCHAR 120   50   —
SM30 WIP Transaction Control file SM30011 AAS position NVARCHAR 25   — — +
SM31 WIP Transaction Journal SM31001 Record Counter NUMERIC 9   8   —
SM31 WIP Transaction Journal SM31002 Transaction Number NCHAR 9   6   —
SM31 WIP Transaction Journal SM31003 Line Number NCHAR 7   5   —
SM31 WIP Transaction Journal SM31006 Accounting String NVARCHAR 120   50   —
SM31 WIP Transaction Journal SM31009 Accounting String Line Currency NVARCHAR 120   50   —
SM31 WIP Transaction Journal SM31011 Transaction Line Text NVARCHAR 100   25   —
SM31 WIP Transaction Journal SM31013 Transaction Code 2 NVARCHAR 25   23   —
SM31 WIP Transaction Journal SM31024 Link Code NCHAR 8   5   —
SM31 WIP Transaction Journal SM31026 Unit Code INT 4   2   —
SM31 WIP Transaction Journal SM31030 PL Reference NCHAR 9   6   —
SM31 WIP Transaction Journal SM31037 Transaction Text Line Currency NVARCHAR 100   25   —
SM31 WIP Transaction Journal SM31038 Source Company NCHAR 2   — — +
SM31 WIP Transaction Journal SM31039 Source Module NCHAR 2   — — +
SM31 WIP Transaction Journal SM31040 Printed By NCHAR 8   — — +
SM31 WIP Transaction Journal SM31041 Date Printed DATETIME 8   — — +
SM31 WIP Transaction Journal SM31042 PrintedStatus NCHAR 1   — — +
SM31 WIP Transaction Journal SM31043 AAS code NVARCHAR 25   — — +
SM32 Service Job Description File I/O SM32025 Job ID INT 9   — — +
SM32 Service Job Description File I/O SM32026 Quantity 1 NUMERIC 12 8 — — +
SM32 Service Job Description File I/O SM32027 Quantity 2 NUMERIC 12 8 — — +
SM32 Service Job Description File I/O SM32028 Quantity 3 NUMERIC 12 8 — — +
SM33 WIP Transaction Journal SM33001 Transaction Number NCHAR 9   — — +
SM33 WIP Transaction Journal SM33002 Line Number NCHAR 7   — — +
SM33 WIP Transaction Journal SM33003 Service Order Number NCHAR 10   — — +
SM33 WIP Transaction Journal SM33004 Accounting String NVARCHAR 120   — — +
SM33 WIP Transaction Journal SM33005 WIP Amount (Local Currency) NUMERIC 20 8 — — +
SM33 WIP Transaction Journal SM33006 User NCHAR 8   — — +
SM33 WIP Transaction Journal SM33007 Date Entered DATETIME 8   — — +
SM33 WIP Transaction Journal SM33008 Transaction Date DATETIME 8   — — +
SM33 WIP Transaction Journal SM33009 Transaction Text NCHAR 100   — — +
SM33 WIP Transaction Journal SM33010 Line Printed INT 1   — — +
SM33 WIP Transaction Journal SM33011 Record Counter NUMERIC 8   — — +
SM33 WIP Transaction Journal SM33012 Currency Code INT 2   — — +
SM33 WIP Transaction Journal SM33013 Accounting String OCU NVARCHAR 120   — — +
SM33 WIP Transaction Journal SM33014 Amount OCU NUMERIC 20 8 — — +
SM33 WIP Transaction Journal SM33015 Transaction Text OCU NCHAR 100   — — +
SM33 WIP Transaction Journal SM33016 Customer/Supplier Code NCHAR 10   — — +
SM33 WIP Transaction Journal SM33017 Document Number NCHAR 23   — — +
SM33 WIP Transaction Journal SM33018 Journal Code NCHAR 6   — — +
SM33 WIP Transaction Journal SM33019 General Ledger Period NCHAR 2   — — +
SM33 WIP Transaction Journal SM33020 Foreign Amount (Currency Account) NCHAR 35   — — +
SM33 WIP Transaction Journal SM33021 Compound Allocation Switches NCHAR 8   — — +
SM33 WIP Transaction Journal SM33022 Period Allocation NCHAR 1   — — +
SM33 WIP Transaction Journal SM33023 Project Line Type NCHAR 1   — — +
SM33 WIP Transaction Journal SM33024 Transaction Flag NCHAR 1   — — +
SM33 WIP Transaction Journal SM33025 Transaction Line Type NCHAR 1   — — +
SM33 WIP Transaction Journal SM33026 Transaction Line Sign NCHAR 1   — — +
SM33 WIP Transaction Journal SM33027 Number of decimals NUMERIC 1   — — +
SM33 WIP Transaction Journal SM33028 Link Code NCHAR 8   — — +
SM33 WIP Transaction Journal SM33029 Quantity NUMERIC 20 8 — — +
SM33 WIP Transaction Journal SM33030 Unit Code INT 4   — — +
SM33 WIP Transaction Journal SM33031 Amount (Alternative Currency) NUMERIC 20 8 — — +
SM33 WIP Transaction Journal SM33032 Contra Account NCHAR 13   — — +
SM33 WIP Transaction Journal SM33033 Journal Number NUMERIC 6   — — +
SM33 WIP Transaction Journal SM33034 PL Reference NCHAR 6   — — +
SM33 WIP Transaction Journal SM33035 Sub Project Code NCHAR 6   — — +
SM33 WIP Transaction Journal SM33036 Activity Code NCHAR 6   — — +
SM33 WIP Transaction Journal SM33037 User Id Updated By NCHAR 8   — — +
SM33 WIP Transaction Journal SM33038 Update Date DATETIME 8   — — +
SM33 WIP Transaction Journal SM33039 Source Company NCHAR 2   — — +
SM33 WIP Transaction Journal SM33040 User Id Printed By NCHAR 8   — — +
SM33 WIP Transaction Journal SM33041 Date of Print DATETIME 8   — — +
SM33 WIP Transaction Journal SM33042 Source Module NCHAR 2   — — +
SM33 WIP Transaction Journal SM33043 AAS position NVARCHAR 25   — — +
SM39 Accounting Rules SM39008 On-Cost % NVARCHAR 7   3   —
SM39 Accounting Rules SM39010 Upload Type NCHAR 1   — — +
SM39 Accounting Rules SM39011 Upload Mode NCHAR 1   — — +
SM3H Service Job Header SM3H001 Job ID INT 9   — — +
SM3H Service Job Header SM3H002 Service Object Type NCHAR 1   — — +
SM3H Service Job Header SM3H003 Stock/Asset Code NCHAR 35   — — +
SM3H Service Job Header SM3H004 Job No NCHAR 6   — — +
SM3H Service Job Header SM3H005 Description1 NVARCHAR 4000   — — +
SM3H Service Job Header SM3H006 Description2 NVARCHAR 4000   — — +
SM3L Extended order lines (SM) SM3L017 Spare NCHAR 4   — — +
SM3L Extended order lines (SM) SM3L018 UDMS Code NCHAR 6   — — +
SM3L Extended order lines (SM) SM3L019 Status INT 1   — — +
SM3L Extended order lines (SM) SM3L020 Original Start Date DATETIME 8   — — +
SM3L Extended order lines (SM) SM3L021 Original Finish Date DATETIME 8   — — +
SM3T Service Job Description Text File I/O SM3T009 Job ID INT 9   — — +
SM41 Service Order Master History File SM41005 Customer Purchase Order Number NVARCHAR 30   20   —
SM41 Service Order Master History File SM41085 Delivery Note Number NCHAR 20   10   —
SM41 Service Order Master History File SM41113 Accounting String NVARCHAR 120   50   —
SM41 Service Order Master History File SM41138 Serial number selected warranty type NVARCHAR 3   2   —
SM41 Service Order Master History File SM41146 OCU Exchange Rate 1 NUMERIC 10 8 15 8 —
SM41 Service Order Master History File SM41147 OCU Exchange Rate 2 NUMERIC 10 8 15 8 —
SM41 Service Order Master History File SM41159 Discount Schema Code INT 9   4   —
SM41 Service Order Master History File SM41197 Value Component No NCHAR 10   — — +
SM41 Service Order Master History File SM41198 Commission Distribution Method NCHAR 1   — — +
SM41 Service Order Master History File SM41199 Execution Order flag NCHAR 1   — — +
SM41 Service Order Master History File SM41200 WC Maintenance Task ID INT 4   — — +
SM41 Service Order Master History File SM41201 PM Counter Qty Type NCHAR 2   — — +
SM41 Service Order Master History File SM41202 Delivery Note Sort Order INT 1   — — +
SM41 Service Order Master History File SM41203 Print Delivery Note at picking confirmation NCHAR 1   — — +
SM41 Service Order Master History File SM41204 Send Delivery Note at picking confirmation NCHAR 1   — — +
SM41 Service Order Master History File SM41205 Delivery blocked INT 1   — — +
SM41 Service Order Master History File SM41206 E-Mail Address NVARCHAR 200   — — +
SM41 Service Order Master History File SM41207 Partial Delivery Planning NVARCHAR 1   — — +
SM41 Service Order Master History File SM41208 Customer for pricing INT 1   — — +
SM41 Service Order Master History File SM41209 Credit Check Passed NCHAR 1   — — +
SM41 Service Order Master History File SM41210 External ID NVARCHAR 36   — — +
SM41 Service Order Master History File SM41211 Red Storno Default NCHAR 1   — — +
SM41 Service Order Master History File SM41212 InvPlanLineNo NCHAR 6   — — +
SM41 Service Order Master History File SM41213 Public Procurement Code 1 NVARCHAR 20   — — +
SM41 Service Order Master History File SM41214 Public Procurement Code 2 NVARCHAR 20   — — +
SM41 Service Order Master History File SM41215 OCU Exchange Algorithm NCHAR 3   — — +
SM41 Service Order Master History File SM41216 Own Bank Code 1 NCHAR 2   — — +
SM41 Service Order Master History File SM41217 Own Bank Code 2 NCHAR 2   — — +
SM41 Service Order Master History File SM41218 Tax Registration Country NCHAR 3   — — +
SM43 Service Order Activity History File I/O SM43005 Description NVARCHAR 35   25   —
SM43 Service Order Activity History File I/O SM43034 Accounting String NVARCHAR 120   50   —
SM43 Service Order Activity History File I/O SM43069 Operation Type Time NVARCHAR 10   — — +
SM43 Service Order Activity History File I/O SM43070 Financial Operation Code Time NVARCHAR 10   — — +
SM43 Service Order Activity History File I/O SM43071 Line GUID NVARCHAR 36   — — +
SM43 Service Order Activity History File I/O SM43072 Line Group NVARCHAR 6   — — +
SM43 Service Order Activity History File I/O SM43073 Job ID INT 9   — — +
SM43 Service Order Activity History File I/O SM43074 Delivery Note Number NVARCHAR 20   — — +
SM43 Service Order Activity History File I/O SM43075 Delivery blocked INT 1   — — +
SM43 Service Order Activity History File I/O SM43076 Approved Credit Limit NCHAR 1   — — +
SM43 Service Order Activity History File I/O SM43077 Confirmed Arrival Date DATETIME 8   — — +
SM43 Service Order Activity History File I/O SM43078 InvPlanLineNo NCHAR 6   — — +
SM43 Service Order Activity History File I/O SM43079 Taxation Reason Code NCHAR 3   — — +
SM44 Service Order Cost History File I/O SM44005 Description NVARCHAR 35   25   —
SM44 Service Order Cost History File I/O SM44032 Accounting String NVARCHAR 120   50   —
SM44 Service Order Cost History File I/O SM44057 Cost Invoice Number NCHAR 25   15   —
SM44 Service Order Cost History File I/O SM44059 General Ledger Transaction Number NCHAR 9   6   —
SM44 Service Order Cost History File I/O SM44070 GL Update Flag NCHAR 1   — — +
SM44 Service Order Cost History File I/O SM44071 GL Transaction Text NVARCHAR 25   — — +
SM44 Service Order Cost History File I/O SM44072 Operation Type Time NVARCHAR 10   — — +
SM44 Service Order Cost History File I/O SM44073 Financial Operation Code Time NVARCHAR 10   — — +
SM44 Service Order Cost History File I/O SM44074 Line Group NVARCHAR 6   — — +
SM44 Service Order Cost History File I/O SM44075 Job ID INT 9   — — +
SM44 Service Order Cost History File I/O SM44076 Delivery Note Number NVARCHAR 20   — — +
SM44 Service Order Cost History File I/O SM44077 Delivery blocked INT 1   — — +
SM44 Service Order Cost History File I/O SM44078 Line GUID NVARCHAR 36   — — +
SM44 Service Order Cost History File I/O SM44079 Approved Credit Limit NCHAR 1   — — +
SM44 Service Order Cost History File I/O SM44080 Confirmed Arrival Date DATETIME 8   — — +
SM44 Service Order Cost History File I/O SM44081 InvPlanLineNo NCHAR 6   — — +
SM44 Service Order Cost History File I/O SM44082 Planed Quantity 1 NUMERIC 12 8 — — +
SM44 Service Order Cost History File I/O SM44083 Actual Quantity 1 NUMERIC 12 8 — — +
SM44 Service Order Cost History File I/O SM44084 Planed Quantity 2 NUMERIC 12 8 — — +
SM44 Service Order Cost History File I/O SM44085 Actual Quantity 2 NUMERIC 12 8 — — +
SM44 Service Order Cost History File I/O SM44086 Planed Quantity 3 NUMERIC 12 8 — — +
SM44 Service Order Cost History File I/O SM44087 Actual Quantity 3 NUMERIC 12 8 — — +
SM44 Service Order Cost History File I/O SM44088 Taxation Reason Code NCHAR 3   — — +
SM45 Service Order Material History File I/O SM45015 Unit Code INT 4   2   —
SM45 Service Order Material History File I/O SM45058 Accounting String NVARCHAR 120   50   —
SM45 Service Order Material History File I/O SM45089 Return Note Number NVARCHAR 20   10   —
SM45 Service Order Material History File I/O SM45123 Operation Type Material NVARCHAR 10   — — +
SM45 Service Order Material History File I/O SM45124 Financial Operation Code Material NVARCHAR 10   — — +
SM45 Service Order Material History File I/O SM45125 Line Group NVARCHAR 6   — — +
SM45 Service Order Material History File I/O SM45126 Depreciation NCHAR 1   — — +
SM45 Service Order Material History File I/O SM45127 Asset NVARCHAR 35   — — +
SM45 Service Order Material History File I/O SM45128 ExecutionLineType INT 1   — — +
SM45 Service Order Material History File I/O SM45129 Sold Qty NUMERIC 12 8 — — +
SM45 Service Order Material History File I/O SM45130 Sold Qty SC NUMERIC 12 8 — — +
SM45 Service Order Material History File I/O SM45131 Sales Date DATETIME 8   — — +
SM45 Service Order Material History File I/O SM45132 Disposal Code NVARCHAR 6   — — +
SM45 Service Order Material History File I/O SM45133 Reason Code NCHAR 3   — — +
SM45 Service Order Material History File I/O SM45134 Dispatch Note NVARCHAR 20   — — +
SM45 Service Order Material History File I/O SM45135 Quantity that has been Invoiced (Order Unit) for exec lines NUMERIC 12 8 — — +
SM45 Service Order Material History File I/O SM45136 Spare NUMERIC 12 8 — — +
SM45 Service Order Material History File I/O SM45137 Job ID INT 9   — — +
SM45 Service Order Material History File I/O SM45138 Delivery blocked INT 1   — — +
SM45 Service Order Material History File I/O SM45139 ItemType INT 1   — — +
SM45 Service Order Material History File I/O SM45140 Line GUID NVARCHAR 36   — — +
SM45 Service Order Material History File I/O SM45141 Approved Credit Limit NCHAR 1   — — +
SM45 Service Order Material History File I/O SM45142 Nomenclature Number NVARCHAR 25   — — +
SM45 Service Order Material History File I/O SM45143 Product Tax Type NVARCHAR 10   — — +
SM45 Service Order Material History File I/O SM45144 Line Freight Amount OCU NUMERIC 20 8 — — +
SM45 Service Order Material History File I/O SM45145 Line Freight Amount ICU NUMERIC 20 8 — — +
SM45 Service Order Material History File I/O SM45146 Entry Invoice No NVARCHAR 15   — — +
SM45 Service Order Material History File I/O SM45147 InvPlanLineNo NCHAR 6   — — +
SM45 Service Order Material History File I/O SM45148 Return WH NVARCHAR 6   — — +
SM45 Service Order Material History File I/O SM45149 Taxation Reason Code NCHAR 3   — — +
SM46 Service Management Text History File SM46008 Language Code NCHAR 3   — — +
SM46 Service Management Text History File SM46009 Invoice Number NCHAR 15   — — +
SM47 Service Order Line Delivery History File SM47039 Return Note Number NVARCHAR 20   10   —
SM47 Service Order Line Delivery History File SM47049 Reason Code NCHAR 3   — — +
SM47 Service Order Line Delivery History File SM47050 Dispatch Note NVARCHAR 20   — — +
SM47 Service Order Line Delivery History File SM47051 Quantity Returned Good Items (Stock Unit) NUMERIC 13 8 — — +
SM47 Service Order Line Delivery History File SM47052 Quantity Returned Bad Items (Stock Unit) NUMERIC 13 8 — — +
SM47 Service Order Line Delivery History File SM47053 Parent Delivery Line Number NCHAR 4   — — +
SM47 Service Order Line Delivery History File SM47054 Quantity Sold (Order Unit) NUMERIC 13 8 — — +
SM47 Service Order Line Delivery History File SM47055 Quantity Sold (Stock Unit) NUMERIC 13 8 — — +
SM47 Service Order Line Delivery History File SM47056 DNIssuerCode NCHAR 6   — — +
SM47 Service Order Line Delivery History File SM47057 Confirmed Arrival Date DATETIME 8   — — +
SM47 Service Order Line Delivery History File SM47058 InvPlanLineNo NCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48025 Accounting String NVARCHAR 120   50   —
SM48 Service Order Invoice Customer File History SM48061 Invoice Issuer Code NVARCHAR 6   4   —
SM48 Service Order Invoice Customer File History SM48069 Tax Code for Invoice Fee NCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48070 Fixed Price OCU NUMERIC 13 8 — — +
SM48 Service Order Invoice Customer File History SM48071 Fixed Price ICU NUMERIC 13 8 — — +
SM48 Service Order Invoice Customer File History SM48072 Fixed Price LCU NUMERIC 13 8 — — +
SM48 Service Order Invoice Customer File History SM48073 Tax Code for Fixed Price NCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48074 Operation Type Order NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48075 Financial Operation Code Order NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48076 Operation Type Time NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48077 Financial Operation Code Time NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48078 Operation Type Cost NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48079 Financial Operation Code Cost NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48080 Operation Type Material NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48081 Financial Operation Code Material NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48082 Instalment NCHAR 1   — — +
SM48 Service Order Invoice Customer File History SM48083 Interest% NUMERIC 12 8 — — +
SM48 Service Order Invoice Customer File History SM48084 New Interest% NUMERIC 12 8 — — +
SM48 Service Order Invoice Customer File History SM48085 Activate New Interest Date DATETIME 8   — — +
SM48 Service Order Invoice Customer File History SM48086 Financial Charge NUMERIC 20 8 — — +
SM48 Service Order Invoice Customer File History SM48087 Interest Tax Code NCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48088 Financial Tax Code NCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48089 Specification Printed Flag NCHAR 1   — — +
SM48 Service Order Invoice Customer File History SM48090 Fixed Price Time Line Group NVARCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48091 Fixed Price Cost Line Group NVARCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48092 Fixed Price Mat Line Group NVARCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48093 External Commission Amount NUMERIC 20 8 — — +
SM48 Service Order Invoice Customer File History SM48094 District NCHAR 2   — — +
SM48 Service Order Invoice Customer File History SM48095 Advertising Code NCHAR 2   — — +
SM48 Service Order Invoice Customer File History SM48096 City Code NCHAR 4   — — +
SM48 Service Order Invoice Customer File History SM48097 SNI Code NCHAR 5   — — +
SM48 Service Order Invoice Customer File History SM48098 Bank Code NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48099 Payment Address Code NVARCHAR 2   — — +
SM48 Service Order Invoice Customer File History SM48100 Extended Commission Code NCHAR 2   — — +
SM48 Service Order Invoice Customer File History SM48101 Invoice counter ID NVARCHAR 12   — — +
SM48 Service Order Invoice Customer File History SM48102 Invoice Copy Number INT 4   — — +
SM48 Service Order Invoice Customer File History SM48103 On-account Invoice Copy Number INT 4   — — +
SM48 Service Order Invoice Customer File History SM48104 Original Order No NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48105 Original Invoice No NVARCHAR 15   — — +
SM48 Service Order Invoice Customer File History SM48106 Flag Doc XML Invoice INT 1   — — +
SM48 Service Order Invoice Customer File History SM48107 Last Invoice Time DATETIME 17   — — +
SM48 Service Order Invoice Customer File History SM48108 Last Advance Invoice Time DATETIME 17   — — +
SM48 Service Order Invoice Customer File History SM48109 Freight Amount, ICU NUMERIC 20 8 — — +
SM48 Service Order Invoice Customer File History SM48110 Tax Code for Freight NCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48111 Freight Payer NCHAR 1   — — +
SM48 Service Order Invoice Customer File History SM48112 Net Weight NUMERIC 10 8 — — +
SM48 Service Order Invoice Customer File History SM48113 Gross Weight NUMERIC 10 8 — — +
SM48 Service Order Invoice Customer File History SM48114 Volume NUMERIC 10 8 — — +
SM48 Service Order Invoice Customer File History SM48115 No Of Units NUMERIC 10 8 — — +
SM48 Service Order Invoice Customer File History SM48116 Kind Of Box NVARCHAR 15   — — +
SM48 Service Order Invoice Customer File History SM48117 Box Numbering NVARCHAR 15   — — +
SM48 Service Order Invoice Customer File History SM48118 Number Of Pallets NVARCHAR 15   — — +
SM48 Service Order Invoice Customer File History SM48119 Transport Company Code NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48120 Vehicle State NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48121 Vehicle License Plate NVARCHAR 15   — — +
SM48 Service Order Invoice Customer File History SM48122 Code ANTT NVARCHAR 10   — — +
SM48 Service Order Invoice Customer File History SM48123 Taxes for Freight NCHAR 1   — — +
SM48 Service Order Invoice Customer File History SM48124 Fiscal Key Reference NVARCHAR 50   — — +
SM48 Service Order Invoice Customer File History SM48125 Spesometro Forms NVARCHAR 12   — — +
SM48 Service Order Invoice Customer File History SM48126 Tax Point NCHAR 1   — — +
SM48 Service Order Invoice Customer File History SM48127 InvPlanLineNo NCHAR 6   — — +
SM48 Service Order Invoice Customer File History SM48128 Taxation Reason Code Fixed Price NCHAR 3   — — +
SM48 Service Order Invoice Customer File History SM48129 Taxation Reason Code On-Account NCHAR 3   — — +
SM48 Service Order Invoice Customer File History SM48130 ICU Exchange Rate 1 NUMERIC 10 8 — — +
SM48 Service Order Invoice Customer File History SM48131 ICU Exchange Rate 2 NUMERIC 10 8 — — +
SM48 Service Order Invoice Customer File History SM48132 ICU Exchange Algorithm NCHAR 3   — — +
SM48 Service Order Invoice Customer File History SM48133 Credit Reason NVARCHAR 50   — — +
SM51 Order Discount Lines SM51017 Parent Discount Line Number INT 9   — — +
SM52 History Service Order Discount Lines SM52017 Parent Discount Line Number INT 9   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64001 Customer Accounting Code NCHAR 2   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64002 Service Order Accounting Code NCHAR 2   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64003 Activity accounting code NCHAR 2   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64004 Activity type NCHAR 1   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64005 Resource type NCHAR 1   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64006 Group NCHAR 2   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64007 Meta-Account NCHAR 2   — — +
SM64 Service Management Automatic Accounting Coding Schedule SM64008 Account NVARCHAR 12   — — +
SM69 Contract Codes SM69039 Accounting String NVARCHAR 120   50   —
SM69 Contract Codes SM69040 Default Contract Period INT 4   2   —
SM69 Contract Codes SM69042 Default Invoice Interval INT 4   2   —
SM69 Contract Codes SM69051 Line Entry Mask NVARCHAR 150   70   —
SM69 Contract Codes SM69069 Use LTM NCHAR 1   — — +
SM69 Contract Codes SM69070 Reservation Type INT 2   — — +
SM69 Contract Codes SM69071 Reservation Time Out (Duration) INT 2   — — +
SM69 Contract Codes SM69072 Reservation Time Out (Time unit) INT 2   — — +
SM69 Contract Codes SM69073 Type of Pricing INT 2   — — +
SM69 Contract Codes SM69074 Generate Sales Statistics NCHAR 1   — — +
SM69 Contract Codes SM69075 Accepted Delivery Interval INT 2   — — +
SM69 Contract Codes SM69076 Warehouse Code NVARCHAR 6   — — +
SM69 Contract Codes SM69077 Apply Main Customer NCHAR 1   — — +
SM69 Contract Codes SM69078 Operation Type NVARCHAR 10   — — +
SM69 Contract Codes SM69079 Financial Operation Code NVARCHAR 10   — — +
SM69 Contract Codes SM69080 Spare NCHAR 1   — — +
SM69 Contract Codes SM69081 Default Contract term INT 1   — — +
SM69 Contract Codes SM69082 Copy To History NCHAR 1   — — +
SM69 Contract Codes SM69083 Discount validity calculation INT 2   — — +
SM69 Contract Codes SM69084 Overview Configuration NVARCHAR 50   — — +
SM69 Contract Codes SM69085 Create Execution Order NCHAR 1   — — +
SM69 Contract Codes SM69086 Execution Order Type NCHAR 6   — — +
SM69 Contract Codes SM69087 Mask for Lease Asset Lines NVARCHAR 150   — — +
SM69 Contract Codes SM69088 Mask for Lease Accessory Lines NVARCHAR 150   — — +
SM69 Contract Codes SM69089 Mask for Service Asset Lines NVARCHAR 150   — — +
SM69 Contract Codes SM69090 Price Type Accessory INT 1   — — +
SM69 Contract Codes SM69091 Document Specification INT 1   — — +
SM69 Contract Codes SM69092 Default Job Object Type NCHAR 1   — — +
SM69 Contract Codes SM69093 Default Job Object Code NCHAR 35   — — +
SM69 Contract Codes SM69094 Default Job Number NCHAR 6   — — +
SM69 Contract Codes SM69095 Contract Line Created NCHAR 3   — — +
SM69 Contract Codes SM69096 Asset Delivered NCHAR 3   — — +
SM69 Contract Codes SM69097 Asset Returned NCHAR 3   — — +
SM69 Contract Codes SM69098 Asset Sold NCHAR 3   — — +
SM69 Contract Codes SM69099 Asset Scrapped NCHAR 3   — — +
SM69 Contract Codes SM69100 Contract Line Invoiced NCHAR 3   — — +
SM69 Contract Codes SM69101 Contract Line Credited NCHAR 3   — — +
SM69 Contract Codes SM69102 Contract Line Closed NCHAR 3   — — +
SM69 Contract Codes SM69103 Extended Commission NCHAR 1   — — +
SM69 Contract Codes SM69104 Price Type Asset INT 1   — — +
SM69 Contract Codes SM69105 Invoice Specification INT 1   — — +
SM69 Contract Codes SM69106 Lease Statistics NCHAR 1   — — +
SM69 Contract Codes SM69107 Hide Lease Asset Lines NCHAR 1   — — +
SM69 Contract Codes SM69108 Hide Maintenance Asset Lines NCHAR 1   — — +
SM69 Contract Codes SM69109 Hide Lease Accessory Lines NCHAR 1   — — +
SM69 Contract Codes SM69110 Hide Maintenance Accessory Lines NCHAR 1   — — +
SM69 Contract Codes SM69111 Credit Mode INT 2   — — +
SM69 Contract Codes SM69112 Min Invoice Time Value NUMERIC 12 8 — — +
SM69 Contract Codes SM69113 Decimals in Invoice Time Value INT 2   — — +
SM69 Contract Codes SM69114 Line invoice interval unit INT 2   — — +
SM69 Contract Codes SM69115 Price Calculation Profile NVARCHAR 10   — — +
SM69 Contract Codes SM69116 Best Price Code NVARCHAR 3   — — +
SM69 Contract Codes SM69117 Consolidation Mode INT 2   — — +
SM69 Contract Codes SM69118 Best Price Type INT 1   — — +
SM69 Contract Codes SM69119 Spare NUMERIC 12 8 — — +
SM69 Contract Codes SM69120 Spare INT 4   — — +
SM69 Contract Codes SM69121 Spare INT 1   — — +
SM69 Contract Codes SM69122 Link with PO till INT 1   — — +
SM69 Contract Codes SM69123 Delivery Date Milestone INT 1   — — +
SM69 Contract Codes SM69124 Delivery Time Value NUMERIC 12 8 — — +
SM69 Contract Codes SM69125 Delivery Time Unit INT 2   — — +
SM69 Contract Codes SM69126 Update PO Statistics NCHAR 1   — — +
SM69 Contract Codes SM69127 Invoicing Model INT 2   — — +
SM69 Contract Codes SM69128 Closing Rule INT 2   — — +
SM69 Contract Codes SM69129 Revenue Recognition Model NCHAR 3   — — +
SM69 Contract Codes SM69130 Default Return WH NVARCHAR 6   — — +
SM69 Contract Codes SM69131 Operation Type (Asset Maintenance Line) NVARCHAR 10   — — +
SM69 Contract Codes SM69132 Financial Operation Code (Asset Maintenance Line) NVARCHAR 10   — — +
SM69 Contract Codes SM69133 Operation Type (Accessory Lease Line) NVARCHAR 10   — — +
SM69 Contract Codes SM69134 Financial Operation Code (Accessory Lease Line) NVARCHAR 10   — — +
SM69 Contract Codes SM69135 Operation Type (Accessory Maintenance Line) NVARCHAR 10   — — +
SM69 Contract Codes SM69136 Financial Operation Code (Accessory Maintenance Line) NVARCHAR 10   — — +
SM69 Contract Codes SM69137 Service Provision date for Tax INT 2   — — +
SM69 Contract Codes SM69138 Taxation Reason Code NCHAR 3   — — +
SM69 Contract Codes SM69139 Apply ATP For Sales Contracts NCHAR 1   — — +
SM70 Contract Invoicing History SM70020 Accounting String NVARCHAR 120   50   —
SM70 Contract Invoicing History SM70024 Invoice Fee Amount LCU NUMERIC 13 8 — — +
SM70 Contract Invoicing History SM70025 Invoice Fee Amount OCU NUMERIC 13 8 — — +
SM70 Contract Invoicing History SM70026 Tax Code for Invoice Fee NCHAR 6   — — +
SM70 Contract Invoicing History SM70027 Operation Type NVARCHAR 10   — — +
SM70 Contract Invoicing History SM70028 Financial Operation Code NVARCHAR 10   — — +
SM70 Contract Invoicing History SM70029 Plan Line Number NCHAR 6   — — +
SM70 Contract Invoicing History SM70030 Invoice Type INT 2   — — +
SM70 Contract Invoicing History SM70031 Event Type INT 2   — — +
SM70 Contract Invoicing History SM70032 Event Date DATETIME 8   — — +
SM70 Contract Invoicing History SM70033 Invoiced Amount CCU NUMERIC 20 8 — — +
SM70 Contract Invoicing History SM70034 Deducted Amount CCU NUMERIC 20 8 — — +
SM70 Contract Invoicing History SM70035 Tax Code NCHAR 6   — — +
SM70 Contract Invoicing History SM70036 Tax Liability NCHAR 6   — — +
SM70 Contract Invoicing History SM70037 Payment term NCHAR 2   — — +
SM70 Contract Invoicing History SM70038 Comment NVARCHAR 200   — — +
SM70 Contract Invoicing History SM70039 Invoiced Amount ICU NUMERIC 20 8 — — +
SM70 Contract Invoicing History SM70040 Invoiced Amount LCU NUMERIC 20 8 — — +
SM70 Contract Invoicing History SM70041 Deducted Amount ICU NUMERIC 20 8 — — +
SM70 Contract Invoicing History SM70042 Deducted Amount LCU NUMERIC 20 8 — — +
SM70 Contract Invoicing History SM70043 Accounting String NVARCHAR 120   — — +
SM70 Contract Invoicing History SM70044 AAS Code NCHAR 25   — — +
SM70 Contract Invoicing History SM70045 Line Sorting Number NCHAR 6   — — +
SM70 Contract Invoicing History SM70046 Invoice Plan Line Number NCHAR 6   — — +
SM71 Service Contract Deferrals History SM71018 Accounting string for sales/interest income NVARCHAR 120   50   —
SM71 Service Contract Deferrals History SM71019 Accounting string for deferred/accrued revenue NVARCHAR 120   50   —
SM71 Service Contract Deferrals History SM71023 AAS code for sales/interest income acc string NVARCHAR 25   20   —
SM71 Service Contract Deferrals History SM71024 AAS code for deferred/accrued revenue acc string NVARCHAR 25   — — +
SM71 Service Contract Deferrals History SM71025 Deferrals Type INT 1   — — +
SM71 Service Contract Deferrals History SM71026 Invoice Plan Line Number NCHAR 6   — — +
SM75 Delivery Schedule SM75015 Reservation End Date DATETIME 8   — — +
SM75 Delivery Schedule SM75016 UsedQty NUMERIC 20 8 — — +
SM75 Delivery Schedule SM75017 Last Used Date DATETIME 8   — — +
SM75 Delivery Schedule SM75018 Atp Promised Date DATETIME 8   — — +
SM75 Delivery Schedule SM75019 Requested Qty Stock Units NUMERIC 20 8 — — +
SM75 Delivery Schedule SM75020 Confirmed Qty Stock Units NUMERIC 20 8 — — +
SM75 Delivery Schedule SM75021 Used Qty Stock Units NUMERIC 20 8 — — +
SM75 Delivery Schedule SM75022 InvoiceNo NCHAR 15   — — +
SM75 Delivery Schedule SM75023 Ordered Date DATETIME 8   — — +
SM75 Delivery Schedule SM75024 Schedule subtype INT 1   — — +
SM75 Delivery Schedule SM75025 Warehouse NCHAR 6   — — +
SM85 SM85 Contract Line Act SM85016 InvoiceNo NCHAR 15   — — +
SM85 SM85 Contract Line Act SM85017 Invoice Plan Line Number NCHAR 6   — — +
SM91 WIP Labour History SM91010 WIP debit accounting string NVARCHAR 120   — — +
SM91 WIP Labour History SM91011 Wip credit accounting string NVARCHAR 120   — — +
SM91 WIP Labour History SM91012 WIP reallocation debit accounting string NVARCHAR 120   — — +
SM91 WIP Labour History SM91013 WIP reallocation credit accounting string NVARCHAR 120   — — +
SM91 WIP Labour History SM91014 WIP Debit AAS Code NVARCHAR 25   — — +
SM91 WIP Labour History SM91015 WIP Credit AAS Code NVARCHAR 25   — — +
SM91 WIP Labour History SM91016 WIP Realloc Debit AAS Code NVARCHAR 25   — — +
SM91 WIP Labour History SM91017 WIP Realloc Credit AAS Code NVARCHAR 25   — — +
SM92 WIP Cost History SM92010 WIP debit accounitng string NVARCHAR 120   — — +
SM92 WIP Cost History SM92011 WIP credit accounting string NVARCHAR 120   — — +
SM92 WIP Cost History SM92012 WIP Debit AAS Code NVARCHAR 25   — — +
SM92 WIP Cost History SM92013 WIP Credit AAS Code NVARCHAR 25   — — +
SM93 WIP Material History SM93012 WIP debit accounting string NVARCHAR 120   — — +
SM93 WIP Material History SM93013 WIP credit accounting string NVARCHAR 120   — — +
SM93 WIP Material History SM93014 WIP Debit AAS Code NVARCHAR 25   — — +
SM93 WIP Material History SM93015 WIP Credit AAS Code NVARCHAR 25   — — +
SMAC Work file for accounting summary SMAC003 AccntString NVARCHAR 120   50   —
SMB4 BOM Branch SMB4017 Unit Code INT 4   2   —
SMD2 Drop Shipment Extended Order Line SMD2014 Purchaser Code NVARCHAR 6   3   —
SMH4 BOM Branch SMH4017 Unit Code INT 4   2   —
SMHA Service Order Cost and Time History Transactions SMHA001 Service Order Number NVARCHAR 10   — — +
SMHA Service Order Cost and Time History Transactions SMHA002 Activity Line Number NVARCHAR 4   — — +
SMHA Service Order Cost and Time History Transactions SMHA003 Activity Line Type NVARCHAR 1   — — +
SMHA Service Order Cost and Time History Transactions SMHA004 Transaction Line Number NVARCHAR 9   — — +
SMHA Service Order Cost and Time History Transactions SMHA005 Engineer NVARCHAR 10   — — +
SMHA Service Order Cost and Time History Transactions SMHA006 Reported Qty\Hours NUMERIC 12 8 — — +
SMHA Service Order Cost and Time History Transactions SMHA007 Reported Start Date DATETIME 17   — — +
SMHA Service Order Cost and Time History Transactions SMHA008 Reported (End) Date DATETIME 17   — — +
SMHA Service Order Cost and Time History Transactions SMHA009 Reported Cost NUMERIC 20 8 — — +
SMHA Service Order Cost and Time History Transactions SMHA010 Scala Date DATETIME 8   — — +
SMHA Service Order Cost and Time History Transactions SMHA011 System Date and Time DATETIME 17   — — +
SMHA Service Order Cost and Time History Transactions SMHA012 Entered by User NVARCHAR 10   — — +
SMHA Service Order Cost and Time History Transactions SMHA013 GL Transaction Number NVARCHAR 9   — — +
SMHA Service Order Cost and Time History Transactions SMHA014 Invoice Number NVARCHAR 15   — — +
SMHA Service Order Cost and Time History Transactions SMHA015 Reported Qty 1 NUMERIC 12 8 — — +
SMHA Service Order Cost and Time History Transactions SMHA016 Reported Qty 2 NUMERIC 12 8 — — +
SMHA Service Order Cost and Time History Transactions SMHA017 Reported Qty 3 NUMERIC 12 8 — — +
SMHA Service Order Cost and Time History Transactions SMHA018 Delivery Note Number NVARCHAR 20   — — +
SMHA Service Order Cost and Time History Transactions SMHA019 Printed In Delivery Note 1 INT 1   — — +
SMHA Service Order Cost and Time History Transactions SMHA020 Printed In Delivery Note 2 INT 1   — — +
SMHA Service Order Cost and Time History Transactions SMHA021 Printed In Delivery Note 3 INT 1   — — +
SMHA Service Order Cost and Time History Transactions SMHA022 Delivery Note Issuer NVARCHAR 6   — — +
SMHM Service Order Material History Transactions SMHM001 Service Order Number NVARCHAR 10   — — +
SMHM Service Order Material History Transactions SMHM002 Material Line Number NVARCHAR 4   — — +
SMHM Service Order Material History Transactions SMHM003 Material Struct Line Number NVARCHAR 6   — — +
SMHM Service Order Material History Transactions SMHM004 Material SubStruct Line Number NVARCHAR 6   — — +
SMHM Service Order Material History Transactions SMHM005 Transaction Line Number NVARCHAR 9   — — +
SMHM Service Order Material History Transactions SMHM006 Engineer NVARCHAR 10   — — +
SMHM Service Order Material History Transactions SMHM007 Action Type NVARCHAR 1   — — +
SMHM Service Order Material History Transactions SMHM008 Qty NUMERIC 12 8 — — +
SMHM Service Order Material History Transactions SMHM009 Date DATETIME 8   — — +
SMHM Service Order Material History Transactions SMHM010 Serial Number NVARCHAR 20   — — +
SMHM Service Order Material History Transactions SMHM011 Batch ID NVARCHAR 12   — — +
SMHM Service Order Material History Transactions SMHM012 Batch Number NVARCHAR 12   — — +
SMHM Service Order Material History Transactions SMHM013 Reported Cost NUMERIC 20 8 — — +
SMHM Service Order Material History Transactions SMHM014 Scala Date DATETIME 8   — — +
SMHM Service Order Material History Transactions SMHM015 System Date and Time DATETIME 17   — — +
SMHM Service Order Material History Transactions SMHM016 Entered by User NVARCHAR 10   — — +
SMHM Service Order Material History Transactions SMHM017 Invoice Number NVARCHAR 15   — — +
SMHM Service Order Material History Transactions SMHM018 Delivery Note Number NVARCHAR 20   — — +
SMHS Service order material lines SMHS001 Dangerous Level NVARCHAR 1   — — +
SMHS Service order material lines SMHS002 Font Colour INT 8   — — +
SMHS Service order material lines SMHS003 Background Colour NVARCHAR 8   — — +
SMI2 Service Order Instalment Lines SMI2001 Service Order No NCHAR 10   — — +
SMI2 Service Order Instalment Lines SMI2002 Customer Code NVARCHAR 10   — — +
SMI2 Service Order Instalment Lines SMI2003 Instalment Number INT 3   — — +
SMI2 Service Order Instalment Lines SMI2004 Due Date Shift INT 3   — — +
SMI2 Service Order Instalment Lines SMI2005 Percentage% NUMERIC 11 8 — — +
SMI2 Service Order Instalment Lines SMI2006 Invoice Number NCHAR 15   — — +
SMI2 Service Order Instalment Lines SMI2007 Way of Payment NVARCHAR 2   — — +
SMI4 Service Order Instalment Lines History SMI4001 Service Order No NCHAR 10   — — +
SMI4 Service Order Instalment Lines History SMI4002 Customer Code NVARCHAR 10   — — +
SMI4 Service Order Instalment Lines History SMI4003 Instalment Number INT 3   — — +
SMI4 Service Order Instalment Lines History SMI4004 Due Date Shift INT 3   — — +
SMI4 Service Order Instalment Lines History SMI4005 Percentage% NUMERIC 11 8 — — +
SMI4 Service Order Instalment Lines History SMI4006 Invoice Number NCHAR 15   — — +
SMI4 Service Order Instalment Lines History SMI4007 Way of Payment NVARCHAR 2   — — +
SMMT Business Transaction Type Service Order Mapping SMMT001 Order Type NCHAR 6   1   —
SMP1 Peventative Maintenance Plan SMP1007 Quantity Cycle NUMERIC 12 8 8 8 —
SMP1 Peventative Maintenance Plan SMP1022 Default Engineer NVARCHAR 10   — — +
SMP1 Peventative Maintenance Plan SMP1023 Template Description NVARCHAR 200   — — +
SMP1 Peventative Maintenance Plan SMP1024 Service Object Type NCHAR 1   — — +
SMP1 Peventative Maintenance Plan SMP1025 Value Component No NCHAR 10   — — +
SMP1 Peventative Maintenance Plan SMP1026 Job ID INT 9   — — +
SMP1 Peventative Maintenance Plan SMP1027 Order Type NCHAR 6   — — +
SMP1 Peventative Maintenance Plan SMP1028 Use of End Date INT 9   — — +
SMP3 Actual Usage SMP3005 Quantity NUMERIC 12 8 8 8 —
SMP3 Actual Usage SMP3007 Service Object Type NCHAR 1   — — +
SMP3 Actual Usage SMP3008 Value Component No NCHAR 10   — — +
SMP4 Preventive Maintenance Proposal SMP4012 Planned Quantity NUMERIC 12 8 8 8 —
SMP4 Preventive Maintenance Proposal SMP4018 Default Engineer NVARCHAR 10   — — +
SMP4 Preventive Maintenance Proposal SMP4019 Service Object Type NCHAR 1   — — +
SMP4 Preventive Maintenance Proposal SMP4020 Value Component No NCHAR 10   — — +
SMP4 Preventive Maintenance Proposal SMP4021 Job ID INT 9   — — +
SMP5 Exceptional Invoicing Proposal SMP5007 Variance Quantity NUMERIC 12 8 8 8 —
SMP5 Exceptional Invoicing Proposal SMP5012 Invoice Number NCHAR 15   10   —
SMP6 Conflicting Jobs SMP6006 Primary Job ID INT 9   — — +
SMP6 Conflicting Jobs SMP6007 Secondary Job ID INT 9   — — +
SMTA Service Order Cost and Time Transactions SMTA001 Service Order Number NVARCHAR 10   — — +
SMTA Service Order Cost and Time Transactions SMTA002 Activity Line Number NVARCHAR 4   — — +
SMTA Service Order Cost and Time Transactions SMTA003 Activity Line Type NVARCHAR 1   — — +
SMTA Service Order Cost and Time Transactions SMTA004 Transaction Line Number NVARCHAR 9   — — +
SMTA Service Order Cost and Time Transactions SMTA005 Engineer NVARCHAR 10   — — +
SMTA Service Order Cost and Time Transactions SMTA006 Reported Qty\Hours NUMERIC 12 8 — — +
SMTA Service Order Cost and Time Transactions SMTA007 Reported Start Date DATETIME 17   — — +
SMTA Service Order Cost and Time Transactions SMTA008 Reported (End) Date DATETIME 17   — — +
SMTA Service Order Cost and Time Transactions SMTA009 Reported Cost NUMERIC 20 8 — — +
SMTA Service Order Cost and Time Transactions SMTA010 Scala Date DATETIME 8   — — +
SMTA Service Order Cost and Time Transactions SMTA011 System Date and Time DATETIME 17   — — +
SMTA Service Order Cost and Time Transactions SMTA012 Entered by User NVARCHAR 10   — — +
SMTA Service Order Cost and Time Transactions SMTA013 GL Transaction Number NVARCHAR 9   — — +
SMTA Service Order Cost and Time Transactions SMTA014 Invoice Number NVARCHAR 15   — — +
SMTA Service Order Cost and Time Transactions SMTA015 Reported Qty 1 NUMERIC 12 8 — — +
SMTA Service Order Cost and Time Transactions SMTA016 Reported Qty 2 NUMERIC 12 8 — — +
SMTA Service Order Cost and Time Transactions SMTA017 Reported Qty 3 NUMERIC 12 8 — — +
SMTA Service Order Cost and Time Transactions SMTA018 Delivery Note Number NVARCHAR 20   — — +
SMTA Service Order Cost and Time Transactions SMTA019 Printed in Delivery Note 1 INT 1   — — +
SMTA Service Order Cost and Time Transactions SMTA020 Printed in Delivery Note 2 INT 1   — — +
SMTA Service Order Cost and Time Transactions SMTA021 Printed in Delivery Note 3 INT 1   — — +
SMTA Service Order Cost and Time Transactions SMTA022 Delivery Note Issuer NVARCHAR 6   — — +
SMTM Service Order Material Transactions SMTM001 Service Order Number NVARCHAR 10   — — +
SMTM Service Order Material Transactions SMTM002 Material Line Number NVARCHAR 4   — — +
SMTM Service Order Material Transactions SMTM003 Material Struct Line Number NVARCHAR 6   — — +
SMTM Service Order Material Transactions SMTM004 Material SubStruct Line Number NVARCHAR 6   — — +
SMTM Service Order Material Transactions SMTM005 Transaction Line Number NVARCHAR 9   — — +
SMTM Service Order Material Transactions SMTM006 Engineer NVARCHAR 10   — — +
SMTM Service Order Material Transactions SMTM007 Action Type NVARCHAR 1   — — +
SMTM Service Order Material Transactions SMTM008 Qty NUMERIC 12 8 — — +
SMTM Service Order Material Transactions SMTM009 Date DATETIME 8   — — +
SMTM Service Order Material Transactions SMTM010 Serial Number NVARCHAR 20   — — +
SMTM Service Order Material Transactions SMTM011 Batch ID NVARCHAR 12   — — +
SMTM Service Order Material Transactions SMTM012 Batch Number NVARCHAR 12   — — +
SMTM Service Order Material Transactions SMTM013 Reported Cost NUMERIC 20 8 — — +
SMTM Service Order Material Transactions SMTM014 Scala Date DATETIME 8   — — +
SMTM Service Order Material Transactions SMTM015 System Date and Time DATETIME 17   — — +
SMTM Service Order Material Transactions SMTM016 Entered by User NVARCHAR 10   — — +
SMTM Service Order Material Transactions SMTM017 Invoice Number NVARCHAR 15   — — +
SMTM Service Order Material Transactions SMTM018 Delivery Note Number NVARCHAR 20   — — +
SMX3 Work File for Closing Service Invoices SMX3001 AccntString NVARCHAR 120   50   —