Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

На один уровень вверх / 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