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

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

Название Таблицы / Table Name Описание Таблицы / Table Description Поле / Field Расширенный комментарий / Extended Comment Тип данных / Data Type Длина поля iScala 3.5/ iScala 3.5 Length Точность iScala 3.5/ iScala 3.5 Precision Длина поля iScala 2.2/ iScala 2.2 Length Точность iScala 2.2/ iScala 2.2 Precision Новое поле? / is a New Field?
CM3L table Extended Contract Lines CM3L001 Contract Number NCHAR 10   — — +
CM3L table Extended Contract Lines CM3L002 Contract Line Number NCHAR 6   — — +
CM3L table Extended Contract Lines CM3L003 Delivery Schedule Line Number NCHAR 6   — — +
CM3L table Extended Contract Lines CM3L004 BTT Code NCHAR 6   — — +
CM3L table Extended Contract Lines CM3L005 LTE Number INT 4   — — +
CM3L table Extended Contract Lines CM3L006 LTR Number INT 4   — — +
CM3L table Extended Contract Lines CM3L007 Variation Code NCHAR 10   — — +
CM3L table Extended Contract Lines CM3L008 Milestone Type INT 4   — — +
CM3L table Extended Contract Lines CM3L009 Calendar ID NCHAR 10   — — +
CM3L table Extended Contract Lines CM3L010 Duration NUMERIC 13 8 — — +
CM3L table Extended Contract Lines CM3L011 Owner Type NCHAR 4   — — +
CM3L table Extended Contract Lines CM3L012 Owner ID NVARCHAR 35   — — +
CM3L table Extended Contract Lines CM3L013 Time Unit NCHAR 1   — — +
CM3L table Extended Contract Lines CM3L014 UDMS Code NCHAR 6   — — +
CM3L table Extended Contract Lines CM3L015 Status INT 4   — — +
CM3L table Extended Contract Lines CM3L016 Original Start Date DATETIME 8   — — +
CM3L table Extended Contract Lines CM3L017 Original Finish Date DATETIME 8   — — +
CM3L table Extended Contract Lines CM3L018 Actual Start DATETIME 8   — — +
CM3L table Extended Contract Lines CM3L019 Actual Date DATETIME 8   — — +
CM3L table Extended Contract Lines CM3L020 InvoiceNo NCHAR 15   — — +
CMBP Best Price Table CMBP001 Best Price Code NVARCHAR 3   — — +
CMBP Best Price Table CMBP002 Time Value INT 3   — — +
CMBP Best Price Table CMBP003 Months INT 2   — — +
CMBP Best Price Table CMBP004 Weeks INT 2   — — +
CMBP Best Price Table CMBP005 Days INT 2   — — +
CMBP Best Price Table CMBP006 Prorated NCHAR 1   — — +
CMH1 Contract History Master File CMH1001 Service Contract Number NCHAR 10   — — +
CMH1 Contract History Master File CMH1002 Customer Code Invoice (Contract) NCHAR 10   — — +
CMH1 Contract History Master File CMH1003 Customer Code Service Address NCHAR 10   — — +
CMH1 Contract History Master File CMH1004 Customer Reference NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1005 Remark Line 1 NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1006 Remark Line 2 NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1007 Contract Print Status INT 1   — — +
CMH1 Contract History Master File CMH1008 Document 1 Print Status INT 1   — — +
CMH1 Contract History Master File CMH1009 Document 2 Print Status INT 1   — — +
CMH1 Contract History Master File CMH1010 (obsolete) INT 1   — — +
CMH1 Contract History Master File CMH1011 Payment Term NCHAR 2   — — +
CMH1 Contract History Master File CMH1012 Contract Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1013 Spare DATETIME 8   — — +
CMH1 Contract History Master File CMH1014 Invoicing Interval INT 4   — — +
CMH1 Contract History Master File CMH1015 Contract Start Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1016 Contract End Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1017 Salesman NCHAR 3   — — +
CMH1 Contract History Master File CMH1018 Our Reference NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1019 Order Discount Period 1 % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1020 Invoice Number NCHAR 15   — — +
CMH1 Contract History Master File CMH1021 Invoice Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1022 Contract Value (Contract Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1023 Currency Code Invoice INT 6   — — +
CMH1 Contract History Master File CMH1024 (obsolete) NCHAR 6   — — +
CMH1 Contract History Master File CMH1025 Tax Liability Code NCHAR 6   — — +
CMH1 Contract History Master File CMH1026 Language NVARCHAR 3   — — +
CMH1 Contract History Master File CMH1027 Currency Code Contract NCHAR 2   — — +
CMH1 Contract History Master File CMH1028 Is Export Contract NCHAR 1   — — +
CMH1 Contract History Master File CMH1029 Has Index Clause NCHAR 1   — — +
CMH1 Contract History Master File CMH1030 Minimum Service Charge (Local Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1031 Accumulated Invoiced Amount (Contract Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1032 Invoice Fee (Local Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1033 Price List NCHAR 2   — — +
CMH1 Contract History Master File CMH1034 Contract Type NCHAR 3   — — +
CMH1 Contract History Master File CMH1035 Price Type INT 1   — — +
CMH1 Contract History Master File CMH1036 External Commission % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1037 External Commission Code NCHAR 10   — — +
CMH1 Contract History Master File CMH1038 Document Layout NCHAR 1   — — +
CMH1 Contract History Master File CMH1039 Invoice Rounding Model NCHAR 1   — — +
CMH1 Contract History Master File CMH1040 Customer Purchase Order Number NVARCHAR 30   — — +
CMH1 Contract History Master File CMH1041 Last Invoicing Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1042 Last Invoice Number NCHAR 15   — — +
CMH1 Contract History Master File CMH1043 Order Merge Option INT 1   — — +
CMH1 Contract History Master File CMH1044 Site Code NCHAR 4   — — +
CMH1 Contract History Master File CMH1045 Index Month 1 INT 2   — — +
CMH1 Contract History Master File CMH1046 Index Month 2 INT 2   — — +
CMH1 Contract History Master File CMH1047 Index Month 3 INT 2   — — +
CMH1 Contract History Master File CMH1048 Index Month 4 INT 2   — — +
CMH1 Contract History Master File CMH1049 Index 1 Number INT 1   — — +
CMH1 Contract History Master File CMH1050 Index 1 Base Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1051 Index 1 Value NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1052 Index 1 Weighting NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1053 Index 2 Number INT 1   — — +
CMH1 Contract History Master File CMH1054 Index 2 Base Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1055 Index 2 Value NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1056 Index 2 Weighting NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1057 Index 3 Number INT 1   — — +
CMH1 Contract History Master File CMH1058 Index 3 Base Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1059 Index 3 Value NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1060 Index 3 Weighting NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1061 Index 4 Number INT 1   — — +
CMH1 Contract History Master File CMH1062 Index 4 Base Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1063 Index 4 Value NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1064 Index 4 Weighting NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1065 Cancellation Document Print Status INT 1   — — +
CMH1 Contract History Master File CMH1066 Credit When Cancel NCHAR 1   — — +
CMH1 Contract History Master File CMH1067 Has Fixed Prices NCHAR 1   — — +
CMH1 Contract History Master File CMH1068 Contract Code NCHAR 2   — — +
CMH1 Contract History Master File CMH1069 Discount on Labour % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1070 Discount on Costs % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1071 Discount on Parts % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1072 Labour Price Code NCHAR 2   — — +
CMH1 Contract History Master File CMH1073 Labour Price per Hour (Contract Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1074 Labour Hours Included NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1075 Cost Price Code NCHAR 2   — — +
CMH1 Contract History Master File CMH1076 Cost Unit Price (Contract Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1077 Cost Quantity Included NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1078 Material Price Code NCHAR 2   — — +
CMH1 Contract History Master File CMH1079 Material Unit Price (Contract Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1080 Material Quantity Included NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1081 Type of Time Bank NCHAR 1   — — +
CMH1 Contract History Master File CMH1082 Hours Included NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1083 Hours Worked NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1084 Labels Print Status INT 1   — — +
CMH1 Contract History Master File CMH1085 Latest Index Adjustment NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1086 Invoice 1 Number NCHAR 15   — — +
CMH1 Contract History Master File CMH1087 Invoice 1 Due Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1088 Invoice 2 Number NCHAR 15   — — +
CMH1 Contract History Master File CMH1089 Invoice 2 Due Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1090 Invoice is Due for Payment NCHAR 1   — — +
CMH1 Contract History Master File CMH1091 Contract Status INT 1   — — +
CMH1 Contract History Master File CMH1092 Quotation Print Status INT 1   — — +
CMH1 Contract History Master File CMH1093 Customer Search Key NCHAR 20   — — +
CMH1 Contract History Master File CMH1094 Site Name NVARCHAR 20   — — +
CMH1 Contract History Master File CMH1095 Invoice is Blocked NCHAR 1   — — +
CMH1 Contract History Master File CMH1096 Contract Terms INT 1   — — +
CMH1 Contract History Master File CMH1097 Date Changed DATETIME 8   — — +
CMH1 Contract History Master File CMH1098 Date Index Changed DATETIME 8   — — +
CMH1 Contract History Master File CMH1099 Changes are Made NCHAR 1   — — +
CMH1 Contract History Master File CMH1100 Latest Index Table Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1101 Accounting String NVARCHAR 120   — — +
CMH1 Contract History Master File CMH1102 Customer Code Invoice (Contractual Service) NCHAR 10   — — +
CMH1 Contract History Master File CMH1103 Standard Contract Type NCHAR 1   — — +
CMH1 Contract History Master File CMH1104 Response Time NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1105 Call-back Time (ETA) NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1106 Invoice Rounding Model NCHAR 1   — — +
CMH1 Contract History Master File CMH1107 Has Currency Contract NCHAR 1   — — +
CMH1 Contract History Master File CMH1108 Generate Credit Note/Invoice NCHAR 1   — — +
CMH1 Contract History Master File CMH1109 Spare NCHAR 1   — — +
CMH1 Contract History Master File CMH1110 Spare NCHAR 1   — — +
CMH1 Contract History Master File CMH1111 Spare NCHAR 1   — — +
CMH1 Contract History Master File CMH1112 Has Extended Text NCHAR 1   — — +
CMH1 Contract History Master File CMH1113 Salesman Contract Administrator NCHAR 6   — — +
CMH1 Contract History Master File CMH1114 Master Contract NCHAR 10   — — +
CMH1 Contract History Master File CMH1115 Spare NCHAR 4   — — +
CMH1 Contract History Master File CMH1116 Order Discount Period 2 % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1117 Spare NCHAR 4   — — +
CMH1 Contract History Master File CMH1118 Order Discount Period 3 % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1119 Spare NCHAR 4   — — +
CMH1 Contract History Master File CMH1120 Order Discount Period 4 % NUMERIC 7 8 — — +
CMH1 Contract History Master File CMH1121 Spare NCHAR 4   — — +
CMH1 Contract History Master File CMH1122 Customer Code Invoice (Warranty Service) NCHAR 10   — — +
CMH1 Contract History Master File CMH1123 Contract Type Warranty NCHAR 3   — — +
CMH1 Contract History Master File CMH1124 Contract Value (Local Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1125 Accumulated Invoiced Amount (Local Currency) NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1126 Fixed Exchange Rate 1 NUMERIC 15 8 — — +
CMH1 Contract History Master File CMH1127 Fixed Exchange Rate 2 NUMERIC 15 8 — — +
CMH1 Contract History Master File CMH1128 Fixed Exchange Rate Algorithm NCHAR 3   — — +
CMH1 Contract History Master File CMH1129 Currency Contract Number NCHAR 15   — — +
CMH1 Contract History Master File CMH1130 Campaign Code NCHAR 8   — — +
CMH1 Contract History Master File CMH1131 Invoice In Advance NCHAR 1   — — +
CMH1 Contract History Master File CMH1132 Customer Request Number NCHAR 10   — — +
CMH1 Contract History Master File CMH1133 Calendar ID NCHAR 10   — — +
CMH1 Contract History Master File CMH1134 Unit Code Invoice Interval INT 2   — — +
CMH1 Contract History Master File CMH1135 Discount Interval Period 1 INT 20   — — +
CMH1 Contract History Master File CMH1136 Discount Interval Period 2 INT 10   — — +
CMH1 Contract History Master File CMH1137 Discount Interval Period 3 INT 10   — — +
CMH1 Contract History Master File CMH1138 Discount Interval Period 4 INT 10   — — +
CMH1 Contract History Master File CMH1139 Discount Time Unit Period 1 INT 10   — — +
CMH1 Contract History Master File CMH1140 Discount Time Unit Period 2 INT 10   — — +
CMH1 Contract History Master File CMH1141 Discount Time Unit Period 3 INT 10   — — +
CMH1 Contract History Master File CMH1142 Discount Time Unit Period 4 INT 10   — — +
CMH1 Contract History Master File CMH1143 Accounting Code NCHAR 2   — — +
CMH1 Contract History Master File CMH1144 Has Electronic Contract NCHAR 1   — — +
CMH1 Contract History Master File CMH1145 EDI/XML Contract Status INT 1   — — +
CMH1 Contract History Master File CMH1146 EDI/XML Document 1 INT 1   — — +
CMH1 Contract History Master File CMH1147 EDI/XML Document 2 INT 1   — — +
CMH1 Contract History Master File CMH1148 EDI/XML Cancellation Document INT 1   — — +
CMH1 Contract History Master File CMH1149 EDI/XML Labels INT 1   — — +
CMH1 Contract History Master File CMH1150 EDI/XML Quotation INT 1   — — +
CMH1 Contract History Master File CMH1151 Invoice Issuer Code NVARCHAR 6   — — +
CMH1 Contract History Master File CMH1152 Invoice Category NCHAR 1   — — +
CMH1 Contract History Master File CMH1153 Invoice Type NCHAR 1   — — +
CMH1 Contract History Master File CMH1154 Contract Cancellation Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1155 Spare DATETIME 8   — — +
CMH1 Contract History Master File CMH1156 Spare DATETIME 8   — — +
CMH1 Contract History Master File CMH1157 Supplier Code NCHAR 10   — — +
CMH1 Contract History Master File CMH1158 Customer Name NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1159 Shipping Address NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1160 (obsolete) NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1161 (obsolete) NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1162 (obsolete) NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1163 Purchaser NVARCHAR 6   — — +
CMH1 Contract History Master File CMH1164 PaymentTerms NVARCHAR 2   — — +
CMH1 Contract History Master File CMH1165 Delivery Method NVARCHAR 2   — — +
CMH1 Contract History Master File CMH1166 Delivery Terms NVARCHAR 2   — — +
CMH1 Contract History Master File CMH1167 Book Entry Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1168 TaxCodeForInvFee NCHAR 6   — — +
CMH1 Contract History Master File CMH1169 Reservation Time Out (Duration) INT 2   — — +
CMH1 Contract History Master File CMH1170 Reservation Time Out (Time unit) INT 2   — — +
CMH1 Contract History Master File CMH1171 Avoid Backorders NCHAR 1   — — +
CMH1 Contract History Master File CMH1172 Accept Line Split NCHAR 1   — — +
CMH1 Contract History Master File CMH1173 Accept Order Split NCHAR 1   — — +
CMH1 Contract History Master File CMH1174 UseLTM NCHAR 1   — — +
CMH1 Contract History Master File CMH1175 Accepted Delivery Interval INT 2   — — +
CMH1 Contract History Master File CMH1176 Carrier Code NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1177 Carrier Name NVARCHAR 35   — — +
CMH1 Contract History Master File CMH1178 Delivery Note, sort INT 4   — — +
CMH1 Contract History Master File CMH1179 Auto print DN NVARCHAR 1   — — +
CMH1 Contract History Master File CMH1180 Auto send DN NVARCHAR 1   — — +
CMH1 Contract History Master File CMH1181 Operation Type NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1182 Financial Operation Code NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1183 Instalment NCHAR 1   — — +
CMH1 Contract History Master File CMH1184 Interest% NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1185 New Interest% NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1186 Activate New Interest Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1187 Financial Charge NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1188 Interest Tax Code NCHAR 6   — — +
CMH1 Contract History Master File CMH1189 Financial Tax Code NCHAR 6   — — +
CMH1 Contract History Master File CMH1190 Default Engineer NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1191 Reorder Customer NCHAR 1   — — +
CMH1 Contract History Master File CMH1192 Delivery note printing INT 1   — — +
CMH1 Contract History Master File CMH1193 Invoice printing INT 1   — — +
CMH1 Contract History Master File CMH1194 Contract Pricing Date DATETIME 8   — — +
CMH1 Contract History Master File CMH1195 Contract Pricing Number NCHAR 10   — — +
CMH1 Contract History Master File CMH1196 Credit Note Closure Status INT 1   — — +
CMH1 Contract History Master File CMH1197 Execution Order No NCHAR 10   — — +
CMH1 Contract History Master File CMH1198 District NCHAR 2   — — +
CMH1 Contract History Master File CMH1199 Advertising Code NCHAR 2   — — +
CMH1 Contract History Master File CMH1200 City Code NCHAR 4   — — +
CMH1 Contract History Master File CMH1201 SNI Code NCHAR 5   — — +
CMH1 Contract History Master File CMH1202 Commission Distribution Method NCHAR 1   — — +
CMH1 Contract History Master File CMH1203 Customer Account Code NCHAR 2   — — +
CMH1 Contract History Master File CMH1204 (obsolete) NCHAR 1   — — +
CMH1 Contract History Master File CMH1205 Depot WH NVARCHAR 6   — — +
CMH1 Contract History Master File CMH1206 Price Type Asset INT 1   — — +
CMH1 Contract History Master File CMH1207 Price Type Accessory INT 1   — — +
CMH1 Contract History Master File CMH1208 Document Specification INT 1   — — +
CMH1 Contract History Master File CMH1209 Invoice Specification INT 1   — — +
CMH1 Contract History Master File CMH1210 Bank Code NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1211 Payment Address Code NVARCHAR 2   — — +
CMH1 Contract History Master File CMH1212 Spare NVARCHAR 12   — — +
CMH1 Contract History Master File CMH1213 Contract Interval Length INT 7   — — +
CMH1 Contract History Master File CMH1214 Contract Interval Time Unit INT 1   — — +
CMH1 Contract History Master File CMH1215 Delivery Date Milestone INT 1   — — +
CMH1 Contract History Master File CMH1216 Delivery Time Value NUMERIC 12 8 — — +
CMH1 Contract History Master File CMH1217 Delivery Time Unit INT 2   — — +
CMH1 Contract History Master File CMH1218 Invoice Copy Number INT 4   — — +
CMH1 Contract History Master File CMH1219 (obsolete) INT 1   — — +
CMH1 Contract History Master File CMH1220 E-Mail Address NVARCHAR 200   — — +
CMH1 Contract History Master File CMH1221 Invoice Time DATETIME 17   — — +
CMH1 Contract History Master File CMH1222 Invoicing Model INT 2   — — +
CMH1 Contract History Master File CMH1223 Fixed Price NUMERIC 20 8 — — +
CMH1 Contract History Master File CMH1224 Credit Check Passed NCHAR 1   — — +
CMH1 Contract History Master File CMH1225 Linked Project Activity NVARCHAR 30   — — +
CMH1 Contract History Master File CMH1226 Invoice Plan Line Number NCHAR 6   — — +
CMH1 Contract History Master File CMH1227 Spesometro Forms NVARCHAR 12   — — +
CMH1 Contract History Master File CMH1228 Tax Point NCHAR 1   — — +
CMH1 Contract History Master File CMH1229 Public Procurement Code 1 NVARCHAR 20   — — +
CMH1 Contract History Master File CMH1230 Public Procurement Code 2 NVARCHAR 20   — — +
CMH1 Contract History Master File CMH1231 Operation Type (Service Contract Line or Asset Lease Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1232 Financial Operation Code (Service Contract Line or Asset Lease Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1233 Operation Type (Asset Maintenance Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1234 Financial Operation Code (Asset Maintenance Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1235 Operation Type (Accessory Lease Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1236 Financial Operation Code (Accessory Lease Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1237 Operation Type (Accessory Maintenance Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1238 Financial Operation Code (Accessory Maintenance Line) NVARCHAR 10   — — +
CMH1 Contract History Master File CMH1239 OCU Exchange Rate 1 NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1240 OCU Exchange Rate 2 NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1241 OCU Exchange Algorithm NCHAR 3   — — +
CMH1 Contract History Master File CMH1242 ICU Exchange Rate 1 NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1243 ICU Exchange Rate 2 NUMERIC 10 8 — — +
CMH1 Contract History Master File CMH1244 ICU Exchange Algorithm NCHAR 3   — — +
CMH1 Contract History Master File CMH1245 Tax Registration Country NCHAR 3   — — +
CMH3 Contract Line History File CMH3001 Service Contract Number NCHAR 10   — — +
CMH3 Contract Line History File CMH3002 Contract Line Number NCHAR 6   — — +
CMH3 Contract Line History File CMH3003 Line Type NCHAR 1   — — +
CMH3 Contract Line History File CMH3004 Stock Item Code NCHAR 35   — — +
CMH3 Contract Line History File CMH3005 SerialNo NCHAR 20   — — +
CMH3 Contract Line History File CMH3006 Description Line 1 NVARCHAR 25   — — +
CMH3 Contract Line History File CMH3007 Description Line 2 NVARCHAR 25   — — +
CMH3 Contract Line History File CMH3008 Unit Price (Contract Currency) NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3009 Spare NCHAR 1   — — +
CMH3 Contract Line History File CMH3010 Discount % NUMERIC 7 8 — — +
CMH3 Contract Line History File CMH3011 Date_EntryLine DATETIME 8   — — +
CMH3 Contract Line History File CMH3012 Contract_Type NCHAR 3   — — +
CMH3 Contract Line History File CMH3013 PriceType INT 1   — — +
CMH3 Contract Line History File CMH3014 Accounting Code NCHAR 2   — — +
CMH3 Contract Line History File CMH3015 JobCode NCHAR 6   — — +
CMH3 Contract Line History File CMH3016 Warehouse NCHAR 6   — — +
CMH3 Contract Line History File CMH3017 Spare NCHAR 7   — — +
CMH3 Contract Line History File CMH3018 Spare NCHAR 6   — — +
CMH3 Contract Line History File CMH3019 VAT Code NCHAR 6   — — +
CMH3 Contract Line History File CMH3020 VAT Code 2 NCHAR 7   — — +
CMH3 Contract Line History File CMH3021 Next Invoice Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3022 Site Code NCHAR 4   — — +
CMH3 Contract Line History File CMH3023 Contract Line Start Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3024 Contract Line End Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3025 Response Time Override NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3026 Line Status INT 1   — — +
CMH3 Contract Line History File CMH3027 Change Value (Contract Currency) NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3028 Change Reason NCHAR 20   — — +
CMH3 Contract Line History File CMH3029 Change Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3030 Accounting String NVARCHAR 120   — — +
CMH3 Contract Line History File CMH3031 Discount End Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3032 Customer Code Installation Address NCHAR 10   — — +
CMH3 Contract Line History File CMH3033 Currency Code Contract NCHAR 2   — — +
CMH3 Contract Line History File CMH3034 Previous Accrual Unit Price (Local Currency) NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3035 Date Accruals Created DATETIME 8   — — +
CMH3 Contract Line History File CMH3036 Date Contract Closed DATETIME 8   — — +
CMH3 Contract Line History File CMH3037 Accumulated Accrual Amount (Local Currency) NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3038 Previous Accrual Start Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3039 Previous Accrual End Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3040 Contract Sub-line Number NCHAR 6   — — +
CMH3 Contract Line History File CMH3041 Price List NCHAR 2   — — +
CMH3 Contract Line History File CMH3042 Price_UnitCode INT 2   — — +
CMH3 Contract Line History File CMH3043 CalendarID NCHAR 10   — — +
CMH3 Contract Line History File CMH3044 Qty_Planned NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3045 Qty_Actual NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3046 Quantity Actual Rental NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3047 UnitCode_Qty INT 4   — — +
CMH3 Contract Line History File CMH3048 Contract Line Start Time NCHAR 4   — — +
CMH3 Contract Line History File CMH3049 Contract Line End Time NCHAR 4   — — +
CMH3 Contract Line History File CMH3050 InvoiceQty NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3051 RequestedDate DATETIME 8   — — +
CMH3 Contract Line History File CMH3052 ConfirmedDate DATETIME 8   — — +
CMH3 Contract Line History File CMH3053 LastUsedDate DATETIME 8   — — +
CMH3 Contract Line History File CMH3054 AcceptedDate DATETIME 8   — — +
CMH3 Contract Line History File CMH3055 Spare NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3056 Default Engineer NVARCHAR 10   — — +
CMH3 Contract Line History File CMH3057 Reservation Expiry Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3058 Requested Delivery Time remark NVARCHAR 20   — — +
CMH3 Contract Line History File CMH3059 Accepted Delivery Time remark NVARCHAR 20   — — +
CMH3 Contract Line History File CMH3060 Contract Line Pricing Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3061 Contract Pricing Number NCHAR 10   — — +
CMH3 Contract Line History File CMH3062 InvoiceNo NCHAR 15   — — +
CMH3 Contract Line History File CMH3063 Execution Line No NCHAR 4   — — +
CMH3 Contract Line History File CMH3064 Lease Object Type NCHAR 1   — — +
CMH3 Contract Line History File CMH3065 Lease Line Nature INT 1   — — +
CMH3 Contract Line History File CMH3066 Group Code NVARCHAR 6   — — +
CMH3 Contract Line History File CMH3067 Value Component NVARCHAR 10   — — +
CMH3 Contract Line History File CMH3068 Index Clause NCHAR 1   — — +
CMH3 Contract Line History File CMH3069 Deposit NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3070 Capital Value NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3071 Residual Value NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3072 Interest Rate Code NVARCHAR 6   — — +
CMH3 Contract Line History File CMH3073 Interest Rate Percentage NUMERIC 7 8 — — +
CMH3 Contract Line History File CMH3074 Interest Rate Time INT 3   — — +
CMH3 Contract Line History File CMH3075 Interest Rate Time Unit INT 1   — — +
CMH3 Contract Line History File CMH3076 Total Number of Periods NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3077 Current number of Periods NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3078 Invoiced number of Periods NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3079 Lease Charge NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3080 Accumulated Depreciation NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3081 Execution Structure Line Number NCHAR 6   — — +
CMH3 Contract Line History File CMH3082 Execution Sub Structure Line Number NCHAR 6   — — +
CMH3 Contract Line History File CMH3083 Create Service Order on Return NCHAR 1   — — +
CMH3 Contract Line History File CMH3084 Days in Service INT 3   — — +
CMH3 Contract Line History File CMH3085 Linked Lease Contract No NVARCHAR 10   — — +
CMH3 Contract Line History File CMH3086 Linked Lease Contract Line No NVARCHAR 6   — — +
CMH3 Contract Line History File CMH3087 Linked Lease Contract Subline No NVARCHAR 6   — — +
CMH3 Contract Line History File CMH3088 Capital Charge NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3089 Interest Charge NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3090 Invoice Time Value NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3091 Invoice Time Unit INT 2   — — +
CMH3 Contract Line History File CMH3092 Prior Qty NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3093 Change Date DATETIME 8   — — +
CMH3 Contract Line History File CMH3094 Use Best Price NCHAR 1   — — +
CMH3 Contract Line History File CMH3095 Job ID INT 9   — — +
CMH3 Contract Line History File CMH3096 Service Order Type NCHAR 6   — — +
CMH3 Contract Line History File CMH3097 Min Ordered Qty NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3098 Delivery Time NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3099 Delivery Time Unit INT 2   — — +
CMH3 Contract Line History File CMH3100 Subtype INT 1   — — +
CMH3 Contract Line History File CMH3101 Approved Credit Limit NCHAR 1   — — +
CMH3 Contract Line History File CMH3102 Variable Interest Rate Code 1 NCHAR 3   — — +
CMH3 Contract Line History File CMH3103 Variable Interest Rate Percent.1 NUMERIC 7 8 — — +
CMH3 Contract Line History File CMH3104 Variable Interest Rate Code 2 NCHAR 3   — — +
CMH3 Contract Line History File CMH3105 Variable Interest Rate Percent.2 NUMERIC 7 8 — — +
CMH3 Contract Line History File CMH3106 Invoice Plan Line Number NCHAR 6   — — +
CMH3 Contract Line History File CMH3107 Agreed Interval NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3108 Agreed Interval Unit INT 2   — — +
CMH3 Contract Line History File CMH3109 Agreed Qty NUMERIC 12 8 — — +
CMH3 Contract Line History File CMH3110 Qty Type NCHAR 2   — — +
CMH3 Contract Line History File CMH3111 Over Price/Qty NUMERIC 20 8 — — +
CMH3 Contract Line History File CMH3112 Cost Code NCHAR 8   — — +
CMH3 Contract Line History File CMH3113 Usage Billing From DATETIME 8   — — +
CMH3 Contract Line History File CMH3114 Return WH NVARCHAR 6   — — +
CMH3 Contract Line History File CMH3115 Operation Type NVARCHAR 10   — — +
CMH3 Contract Line History File CMH3116 Financial Operation Code NVARCHAR 10   — — +
CMH3 Contract Line History File CMH3117 NCM Code NVARCHAR 25   — — +
CMH3 Contract Line History File CMH3118 Taxation Reason Code NCHAR 3   — — +
CMH3 Contract Line History File CMH3119 Quantity Per Multiple NUMERIC 12 8 — — +
CMH4 Delivery Schedule History CMH4001 ContractNumber NCHAR 10   — — +
CMH4 Delivery Schedule History CMH4002 ContractLineNumber NCHAR 6   — — +
CMH4 Delivery Schedule History CMH4003 ScheduleLineNumber NCHAR 6   — — +
CMH4 Delivery Schedule History CMH4004 OrderedQty NUMERIC 20 8 — — +
CMH4 Delivery Schedule History CMH4005 RequestedDeliveryDate DATETIME 8   — — +
CMH4 Delivery Schedule History CMH4006 ConfirmedDeliveryDate DATETIME 8   — — +
CMH4 Delivery Schedule History CMH4007 Spare NVARCHAR 25   — — +
CMH4 Delivery Schedule History CMH4008 Spare NVARCHAR 25   — — +
CMH4 Delivery Schedule History CMH4009 PurchaseOrderNumber NCHAR 10   — — +
CMH4 Delivery Schedule History CMH4010 PurchaseOrderLine NCHAR 6   — — +
CMH4 Delivery Schedule History CMH4011 PurchaseOrderSubLine NCHAR 6   — — +
CMH4 Delivery Schedule History CMH4012 ActualDeliveryDate DATETIME 8   — — +
CMH4 Delivery Schedule History CMH4013 ActualQty NUMERIC 20 8 — — +
CMH4 Delivery Schedule History CMH4014 InvoicedQty NUMERIC 20 8 — — +
CMH4 Delivery Schedule History CMH4015 ReservationEndDate DATETIME 8   — — +
CMH4 Delivery Schedule History CMH4016 UsedQty NUMERIC 20 8 — — +
CMH4 Delivery Schedule History CMH4017 LastUsedDate DATETIME 8   — — +
CMH4 Delivery Schedule History CMH4018 Atp Promised Date DATETIME 8   — — +
CMH4 Delivery Schedule History CMH4019 Requested Qty SCU NUMERIC 20 8 — — +
CMH4 Delivery Schedule History CMH4020 Confirmed Qty SCU NUMERIC 20 8 — — +
CMH4 Delivery Schedule History CMH4021 Used Qty SCU NUMERIC 20 8 — — +
CMH4 Delivery Schedule History CMH4022 InvoiceNo NCHAR 15   — — +
CMH4 Delivery Schedule History CMH4023 Ordered Date DATETIME 8   — — +
CMH4 Delivery Schedule History CMH4024 Schedule subtype INT 1   — — +
CMH4 Delivery Schedule History CMH4025 Warehouse NCHAR 6   — — +
CMH5 Contract Line Act History CMH5001 ContractNo NCHAR 10   — — +
CMH5 Contract Line Act History CMH5002 LineNo NCHAR 6   — — +
CMH5 Contract Line Act History CMH5003 LineType NCHAR 1   — — +
CMH5 Contract Line Act History CMH5004 SubLineNo NCHAR 6   — — +
CMH5 Contract Line Act History CMH5005 StockCode NVARCHAR 35   — — +
CMH5 Contract Line Act History CMH5006 ActivityCode NCHAR 8   — — +
CMH5 Contract Line Act History CMH5007 ActualHrs NUMERIC 5 8 — — +
CMH5 Contract Line Act History CMH5008 Cost Activity Code NCHAR 8   — — +
CMH5 Contract Line Act History CMH5009 ActualQty NUMERIC 12 8 — — +
CMH5 Contract Line Act History CMH5010 Stock Item Code Spare Parts NVARCHAR 35   — — +
CMH5 Contract Line Act History CMH5011 Actual Quantity NUMERIC 12 8 — — +
CMH5 Contract Line Act History CMH5012 ActivityDisc NUMERIC 7 8 — — +
CMH5 Contract Line Act History CMH5013 CostDisc NUMERIC 7 8 — — +
CMH5 Contract Line Act History CMH5014 Material Discount NUMERIC 7 8 — — +
CMH5 Contract Line Act History CMH5015 ExtendedLineNumber INT 6   — — +
CMH5 Contract Line Act History CMH5016 InvoiceNo NCHAR 15   — — +
CMH5 Contract Line Act History CMH5017 Invoice Plan Line Number NCHAR 6   — — +
CMHD Advance Invoice Deduction History CMHD001 Contract Number NCHAR 10   — — +
CMHD Advance Invoice Deduction History CMHD002 Invoice Number NCHAR 15   — — +
CMHD Advance Invoice Deduction History CMHD003 Original Invoice Number NVARCHAR 15   — — +
CMHD Advance Invoice Deduction History CMHD004 Amount ICU NUMERIC 20 8 — — +
CMHD Advance Invoice Deduction History CMHD005 Amount LCU NUMERIC 20 8 — — +
CMHD Advance Invoice Deduction History CMHD006 Amount CCU NUMERIC 20 8 — — +
CMHD Advance Invoice Deduction History CMHD007 Invoice Plan Line No NCHAR 6   — — +
CMHI Invoicing Plan History CMHI001 Contract Number NVARCHAR 10   — — +
CMHI Invoicing Plan History CMHI002 Plan Line Number NCHAR 6   — — +
CMHI Invoicing Plan History CMHI003 Invoice Type INT 2   — — +
CMHI Invoicing Plan History CMHI004 Event Type INT 2   — — +
CMHI Invoicing Plan History CMHI005 Event Date DATETIME 8   — — +
CMHI Invoicing Plan History CMHI006 Invoice Amount CCU NUMERIC 20 8 — — +
CMHI Invoicing Plan History CMHI007 Amount to deduct CCU NUMERIC 20 8 — — +
CMHI Invoicing Plan History CMHI008 Tax Code NCHAR 6   — — +
CMHI Invoicing Plan History CMHI009 Tax Liability NCHAR 6   — — +
CMHI Invoicing Plan History CMHI010 Payment Term NCHAR 2   — — +
CMHI Invoicing Plan History CMHI011 Invoice From DATETIME 8   — — +
CMHI Invoicing Plan History CMHI012 Invoice To DATETIME 8   — — +
CMHI Invoicing Plan History CMHI013 Comment NVARCHAR 200   — — +
CMHI Invoicing Plan History CMHI014 Status INT 2   — — +
CMHI Invoicing Plan History CMHI015 Invoice Number NVARCHAR 15   — — +
CMHI Invoicing Plan History CMHI016 Line Sorting Number NCHAR 6   — — +
CMHI Invoicing Plan History CMHI017 Original Invoice Number NVARCHAR 15   — — +
CMHI Invoicing Plan History CMHI018 Invoice Date DATETIME 8   — — +
CMHI Invoicing Plan History CMHI019 XML Invoice Flag INT 1   — — +
CMHI Invoicing Plan History CMHI020 Specification flag NCHAR 1   — — +
CMHI Invoicing Plan History CMHI021 Restore contract state NCHAR 1   — — +
CMHI Invoicing Plan History CMHI022 Original Plan Line Number NCHAR 6   — — +
CMHI Invoicing Plan History CMHI023 Invoice Counter ID NVARCHAR 12   — — +
CMHI Invoicing Plan History CMHI024 Taxation Reason Code NCHAR 3   — — +
CMHL Extended Contract Lines LTM History CMHL001 Contract Number NCHAR 10   — — +
CMHL Extended Contract Lines LTM History CMHL002 Contract Line Number NCHAR 6   — — +
CMHL Extended Contract Lines LTM History CMHL003 DS Line Number NCHAR 6   — — +
CMHL Extended Contract Lines LTM History CMHL004 BTT Code NCHAR 6   — — +
CMHL Extended Contract Lines LTM History CMHL005 LTE Number INT 4   — — +
CMHL Extended Contract Lines LTM History CMHL006 LTR Number INT 4   — — +
CMHL Extended Contract Lines LTM History CMHL007 Variation Code NCHAR 10   — — +
CMHL Extended Contract Lines LTM History CMHL008 Milestone Type INT 4   — — +
CMHL Extended Contract Lines LTM History CMHL009 Calendar ID NCHAR 10   — — +
CMHL Extended Contract Lines LTM History CMHL010 Duration NUMERIC 13 8 — — +
CMHL Extended Contract Lines LTM History CMHL011 Owner Type NCHAR 4   — — +
CMHL Extended Contract Lines LTM History CMHL012 Owner ID NVARCHAR 35   — — +
CMHL Extended Contract Lines LTM History CMHL013 Time Unit NCHAR 1   — — +
CMHL Extended Contract Lines LTM History CMHL014 UDMS Code NCHAR 6   — — +
CMHL Extended Contract Lines LTM History CMHL015 Status INT 4   — — +
CMHL Extended Contract Lines LTM History CMHL016 Original Start Date DATETIME 8   — — +
CMHL Extended Contract Lines LTM History CMHL017 Original Finish Date DATETIME 8   — — +
CMHL Extended Contract Lines LTM History CMHL018 Actual Start DATETIME 8   — — +
CMHL Extended Contract Lines LTM History CMHL019 Actual Date DATETIME 8   — — +
CMHL Extended Contract Lines LTM History CMHL020 InvoiceNo NCHAR 15   — — +
CMHT Contract Line Text History CMHT001 Service Contract Number NCHAR 10   — — +
CMHT Contract Line Text History CMHT002 Contract Line Number NCHAR 6   — — +
CMHT Contract Line Text History CMHT003 LineType NCHAR 1   — — +
CMHT Contract Line Text History CMHT004 Text Line 1 NVARCHAR 70   — — +
CMHT Contract Line Text History CMHT005 Text Line 2 NVARCHAR 70   — — +
CMHT Contract Line Text History CMHT006 Document Options NCHAR 30   — — +
CMHT Contract Line Text History CMHT007 Contract Sub-line Number NCHAR 6   — — +
CMHT Contract Line Text History CMHT008 InvoiceNo NCHAR 15   — — +
CMHT Contract Line Text History CMHT009 Invoice Plan Line Number NCHAR 6   — — +
CMI2 Contract Instalment Lines CMI2001 Contract No NCHAR 10   — — +
CMI2 Contract Instalment Lines CMI2002 Instalment Number INT 3   — — +
CMI2 Contract Instalment Lines CMI2003 Due Date Shift INT 3   — — +
CMI2 Contract Instalment Lines CMI2004 Percentage% NUMERIC 11 8 — — +
CMI2 Contract Instalment Lines CMI2005 InvoiceNo NCHAR 15   — — +
CMI2 Contract Instalment Lines CMI2006 Way of Payment NVARCHAR 2   — — +
CMI2 Contract Instalment Lines CMI2007 Invoice Plan Line Number NCHAR 6   — — +
CMI4 Contract Instalment Lines History CMI4001 Contract No NCHAR 10   — — +
CMI4 Contract Instalment Lines History CMI4002 Instalment Number INT 3   — — +
CMI4 Contract Instalment Lines History CMI4003 Due Date Shift INT 3   — — +
CMI4 Contract Instalment Lines History CMI4004 Percentage% NUMERIC 11 8 — — +
CMI4 Contract Instalment Lines History CMI4005 InvoiceNo NCHAR 15   — — +
CMI4 Contract Instalment Lines History CMI4006 Way of Payment NVARCHAR 2   — — +
CMI4 Contract Instalment Lines History CMI4007 Invoice Plan Line Number NCHAR 6   — — +
CMIP Invoicing Plan CMIP001 Contract Number NVARCHAR 10   — — +
CMIP Invoicing Plan CMIP002 Plan Line Number NCHAR 6   — — +
CMIP Invoicing Plan CMIP003 Invoice Type INT 2   — — +
CMIP Invoicing Plan CMIP004 Event Type INT 2   — — +
CMIP Invoicing Plan CMIP005 Event Date DATETIME 8   — — +
CMIP Invoicing Plan CMIP006 Invoice Amount CCU NUMERIC 20 8 — — +
CMIP Invoicing Plan CMIP007 Amount to deduct CCU NUMERIC 20 8 — — +
CMIP Invoicing Plan CMIP008 Tax Code NCHAR 6   — — +
CMIP Invoicing Plan CMIP009 Tax Liability NCHAR 6   — — +
CMIP Invoicing Plan CMIP010 Payment Term NCHAR 2   — — +
CMIP Invoicing Plan CMIP011 Invoice From DATETIME 8   — — +
CMIP Invoicing Plan CMIP012 Invoice To DATETIME 8   — — +
CMIP Invoicing Plan CMIP013 Comment NVARCHAR 200   — — +
CMIP Invoicing Plan CMIP014 Status INT 2   — — +
CMIP Invoicing Plan CMIP015 Invoice Number NVARCHAR 15   — — +
CMIP Invoicing Plan CMIP016 Line Sorting Number NCHAR 6   — — +
CMIP Invoicing Plan CMIP017 Original Invoice Number NVARCHAR 15   — — +
CMIP Invoicing Plan CMIP018 Invoice Date DATETIME 8   — — +
CMIP Invoicing Plan CMIP019 XML Invoice Flag INT 1   — — +
CMIP Invoicing Plan CMIP020 Specification flag NCHAR 1   — — +
CMIP Invoicing Plan CMIP021 Restore contract state NCHAR 1   — — +
CMIP Invoicing Plan CMIP022 Original Plan Line Number NCHAR 6   — — +
CMIP Invoicing Plan CMIP023 Invoice Counter ID NVARCHAR 12   — — +
CMIP Invoicing Plan CMIP024 Taxation Reason Code NCHAR 3   — — +
CMMT BTT Contract Mapping CMMT001 Contract Type NCHAR 3   — — +
CMMT BTT Contract Mapping CMMT002 Sign of Quantity NCHAR 1   — — +
CMMT BTT Contract Mapping CMMT003 BTT Code Type NCHAR 6   — — +
CMVV Variable Values CMVV001 Variable Code NCHAR 3   — — +
CMVV Variable Values CMVV002 Valid From DATETIME 8   — — +
CMVV Variable Values CMVV003 Type INT 1   — — +
CMVV Variable Values CMVV004 Time Value INT 3   — — +
CMVV Variable Values CMVV005 Time Unit INT 1   — — +
CMVV Variable Values CMVV006 Variable Value NUMERIC 7 8 — — +