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