Название Таблицы / 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 |
|
— |