Название Таблицы / 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 | — | — | + |
Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2