Таблица: CMH1 - «Contract History Master File». Маска имени таблицы: «CMH1%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
CMH1001 | NCHAR | STRING | 10 | 0 | 10 | ServContrNo | Service Contract Number | 1 | Да | |
CMH1002 | NCHAR | STRING | 10 | 0 | 10 | ICusCodeBuyer | Customer Code Invoice (Contract) | |||
CMH1003 | NCHAR | STRING | 10 | 0 | 10 | CustCodeCont | Customer Code Service Address | |||
CMH1004 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerRef | Customer Reference | |||
CMH1005 | NVARCHAR | VSTRING | 35 | 0 | 35 | Remarks1 | Remark Line 1 | |||
CMH1006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Remarks2 | Remark Line 2 | |||
CMH1007 | INT | INTEGER | 0 | 0 | 1 | FLAGContract | Contract Print Status | |||
CMH1008 | INT | INTEGER | 0 | 0 | 1 | FLAGDoc2 | Document 1 Print Status | |||
CMH1009 | INT | INTEGER | 0 | 0 | 1 | FLAGDoc3 | Document 2 Print Status | |||
CMH1010 | INT | INTEGER | 0 | 0 | 1 | FLAGInvoice | Invoice Print Status | |||
CMH1011 | NCHAR | STRING | 2 | 0 | 2 | PaymentTerm | Payment Term | |||
CMH1012 | DATETIME | DATE | 0 | 0 | 8 | ContractDate | Contract Date | |||
CMH1013 | DATETIME | DATE | 0 | 0 | 8 | NextInvDate | Next Invoicing Date | |||
CMH1014 | INT | INTEGER | 0 | 0 | 4 | InvIntervall | Invoicing Interval | |||
CMH1015 | DATETIME | DATE | 0 | 0 | 8 | ContrStrDate | Contract Start Date | |||
CMH1016 | DATETIME | DATE | 0 | 0 | 8 | ContrEndDate | Contract End Date | |||
CMH1017 | NCHAR | STRING | 3 | 0 | 3 | SalesmanNo | Salesman | |||
CMH1018 | NVARCHAR | VSTRING | 35 | 0 | 35 | OurReference | Our Reference | |||
CMH1019 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrdDiscount | Order Discount Period 1 % | |||
CMH1020 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 2 | Да | |
CMH1021 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
CMH1022 | NUMERIC | MONEY | 28 | 8 | 20 | ContractValueOCU | Contract Value (Contract Currency) | |||
CMH1023 | INT | INTEGER | 0 | 0 | 6 | Spare | Currency Code Invoice | |||
CMH1024 | NCHAR | STRING | 6 | 0 | 6 | Spare | (obsolete) | |||
CMH1025 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | Tax Liability Code | |||
CMH1026 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | |||
CMH1027 | NCHAR | STRING | 2 | 0 | 2 | ContractCurrencyCode | Currency Code Contract | |||
CMH1028 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGExpOrder | Is Export Contract | |||
CMH1029 | NCHAR | SWITCH | 1 | 0 | 1 | IndexClause | Has Index Clause | |||
CMH1030 | NUMERIC | MONEY | 28 | 8 | 20 | MinServCharLCU | Minimum Service Charge (Local Currency) | |||
CMH1031 | NUMERIC | MONEY | 28 | 8 | 20 | AccInvAmntOCU | Accumulated Invoiced Amount (Contract Currency) | |||
CMH1032 | NUMERIC | MONEY | 28 | 8 | 20 | HandlingFeeLCU | Invoice Fee (Local Currency) | |||
CMH1033 | NCHAR | STRING | 2 | 0 | 2 | PriceList_Default | Price List | |||
CMH1034 | NCHAR | STRING | 3 | 0 | 3 | ContractCode | Contract Type | |||
CMH1035 | NCHAR | SWITCH | 1 | 0 | 1 | PriceType | Price Type | |||
CMH1036 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | ExternalComm | External Commission % | |||
CMH1037 | NCHAR | STRING | 10 | 0 | 10 | ExternComCode | External Commission Code | |||
CMH1038 | NCHAR | STRING | 1 | 0 | 1 | DocumLayout | Document Layout | |||
CMH1039 | NCHAR | STRING | 1 | 0 | 1 | InvRoundMod | Invoice Rounding Model | |||
CMH1040 | NCHAR | STRING | 20 | 0 | 20 | CustPONo | Customer Purchase Order Number | |||
CMH1041 | DATETIME | DATE | 0 | 0 | 8 | LastInvDate | Last Invoicing Date | |||
CMH1042 | NCHAR | STRING | 15 | 0 | 15 | LastInvoicNo | Last Invoice Number | |||
CMH1043 | INT | INTEGER | 0 | 0 | 1 | OrdMergeOption | Order Merge Option | |||
CMH1044 | NCHAR | STRING | 4 | 0 | 4 | CustSiteNo | Site Code | |||
CMH1045 | INT | INTEGER | 0 | 0 | 2 | IndexSched1 | Index Month 1 | |||
CMH1046 | INT | INTEGER | 0 | 0 | 2 | IndexSched2 | Index Month 2 | |||
CMH1047 | INT | INTEGER | 0 | 0 | 2 | IndexSched3 | Index Month 3 | |||
CMH1048 | INT | INTEGER | 0 | 0 | 2 | IndexSched4 | Index Month 4 | |||
CMH1049 | INT | INTEGER | 0 | 0 | 1 | Index1No | Index 1 Number | |||
CMH1050 | DATETIME | DATE | 0 | 0 | 8 | Idx1BaseDate | Index 1 Base Date | |||
CMH1051 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx1Value | Index 1 Value | |||
CMH1052 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx1Weighting | Index 1 Weighting | |||
CMH1053 | INT | INTEGER | 0 | 0 | 1 | Index2No | Index 2 Number | |||
CMH1054 | DATETIME | DATE | 0 | 0 | 8 | Idx2BaseDate | Index 2 Base Date | |||
CMH1055 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx2Value | Index 2 Value | |||
CMH1056 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx2Weighting | Index 2 Weighting | |||
CMH1057 | INT | INTEGER | 0 | 0 | 1 | Index3No | Index 3 Number | |||
CMH1058 | DATETIME | DATE | 0 | 0 | 8 | Idx3BaseDate | Index 3 Base Date | |||
CMH1059 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx3Value | Index 3 Value | |||
CMH1060 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx3Weighting | Index 3 Weighting | |||
CMH1061 | INT | INTEGER | 0 | 0 | 1 | Index4No | Index 4 Number | |||
CMH1062 | DATETIME | DATE | 0 | 0 | 8 | Idx4BaseDate | Index 4 Base Date | |||
CMH1063 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx4Value | Index 4 Value | |||
CMH1064 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx4Weighting | Index 4 Weighting | |||
CMH1065 | INT | INTEGER | 0 | 0 | 1 | FLContrCancel | Cancellation Document Print Status | |||
CMH1066 | NCHAR | SWITCH | 1 | 0 | 1 | FLCreditInv | Credit When Cancel | |||
CMH1067 | NCHAR | SWITCH | 1 | 0 | 1 | FLFixPrices | Has Fixed Prices | |||
CMH1068 | NCHAR | STRING | 2 | 0 | 2 | ContractType | Contract Code | |||
CMH1069 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | DiscntLabour | Discount on Labour % | |||
CMH1070 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | DiscntCosts | Discount on Costs % | |||
CMH1071 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | DiscntParts | Discount on Parts % | |||
CMH1072 | NCHAR | STRING | 2 | 0 | 2 | LabPricCode | Labour Price Code | |||
CMH1073 | NUMERIC | MONEY | 28 | 8 | 20 | PricehourOCU | Labour Price per Hour (Contract Currency) | |||
CMH1074 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Labour Hours Included | |||
CMH1075 | NCHAR | STRING | 2 | 0 | 2 | LabPricCode | Cost Price Code | |||
CMH1076 | NUMERIC | MONEY | 28 | 8 | 20 | PricehourOCU | Cost Unit Price (Contract Currency) | |||
CMH1077 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Cost Quantity Included | |||
CMH1078 | NCHAR | STRING | 2 | 0 | 2 | LabPricCode | Material Price Code | |||
CMH1079 | NUMERIC | MONEY | 28 | 8 | 20 | PricehourOCU | Material Unit Price (Contract Currency) | |||
CMH1080 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Material Quantity Included | |||
CMH1081 | NCHAR | STRING | 1 | 0 | 1 | TypeOfTimeBank | Type of Time Bank | |||
CMH1082 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Hours Included | |||
CMH1083 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursWorked | Hours Worked | |||
CMH1084 | INT | INTEGER | 0 | 0 | 1 | FLAGLabels | Labels Print Status | |||
CMH1085 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | LatestIdxAdjust | Latest Index Adjustment | |||
CMH1086 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice 1 Number | |||
CMH1087 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Invoice 1 Due Date | |||
CMH1088 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice 2 Number | |||
CMH1089 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Invoice 2 Due Date | |||
CMH1090 | NCHAR | SWITCH | 1 | 0 | 1 | FLInvDuePmt | Invoice is Due for Payment | |||
CMH1091 | INT | INTEGER | 0 | 0 | 1 | QuotationStatus | Contract Status | |||
CMH1092 | INT | INTEGER | 0 | 0 | 1 | FLQuotation | Quotation Print Status | |||
CMH1093 | NCHAR | STRING | 20 | 0 | 20 | CustAlphaKey | Customer Search Key | |||
CMH1094 | NVARCHAR | VSTRING | 20 | 0 | 20 | SiteName | Site Name | |||
CMH1095 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGTempInv | Invoice is Blocked | |||
CMH1096 | INT | INTEGER | 0 | 0 | 1 | ExtensStatus | Contract Terms | |||
CMH1097 | DATETIME | DATE | 0 | 0 | 8 | LastChngDate | Date Changed | |||
CMH1098 | DATETIME | DATE | 0 | 0 | 8 | LastChngIdx | Date Index Changed | |||
CMH1099 | NCHAR | SWITCH | 1 | 0 | 1 | FlagChanging | Changes are Made | |||
CMH1100 | DATETIME | DATE | 0 | 0 | 8 | LateIdxTabDt | Latest Index Table Date | |||
CMH1101 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
CMH1102 | NCHAR | STRING | 10 | 0 | 10 | ICusCodeCont | Customer Code Invoice (Contractual Service) | |||
CMH1103 | NCHAR | SWITCH | 1 | 0 | 1 | StdContCode | Standard Contract Type | |||
CMH1104 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ResponceTime | Response Time | |||
CMH1105 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ETATime | Call-back Time (ETA) | |||
CMH1106 | NCHAR | STRING | 1 | 0 | 1 | InvoiceRoundModel | Invoice Rounding Model | |||
CMH1107 | NCHAR | STRING | 1 | 0 | 1 | CurrencyContract | Has Currency Contract | |||
CMH1108 | NCHAR | STRING | 1 | 0 | 1 | Flag_Create_CreditNote | Generate Credit Note/Invoice | |||
CMH1109 | NCHAR | STRING | 1 | 0 | 1 | Spare | ||||
CMH1110 | NCHAR | STRING | 1 | 0 | 1 | Spare | ||||
CMH1111 | NCHAR | STRING | 1 | 0 | 1 | Spare | ||||
CMH1112 | NCHAR | SWITCH | 1 | 0 | 1 | FlagForText | Has Extended Text | |||
CMH1113 | NCHAR | STRING | 3 | 0 | 3 | Manager | Salesman Contract Administrator | |||
CMH1114 | NCHAR | STRING | 10 | 0 | 10 | MasterContract | Master Contract | |||
CMH1115 | NCHAR | STRING | 4 | 0 | 4 | Spare | ||||
CMH1116 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrderDisc2 | Order Discount Period 2 % | |||
CMH1117 | NCHAR | STRING | 4 | 0 | 4 | Spare | ||||
CMH1118 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrderDisc3 | Order Discount Period 3 % | |||
CMH1119 | NCHAR | STRING | 4 | 0 | 4 | Spare | ||||
CMH1120 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrderDisc4 | Order Discount Period 4 % | |||
CMH1121 | NCHAR | STRING | 4 | 0 | 4 | Spare | ||||
CMH1122 | NCHAR | STRING | 10 | 0 | 10 | ICustGaranti | Customer Code Invoice (Warranty Service) | |||
CMH1123 | NCHAR | STRING | 3 | 0 | 3 | ContCodeGuarantee | Contract Type Warranty | |||
CMH1124 | NUMERIC | MONEY | 28 | 8 | 20 | ContractValueLCU | Contract Value (Local Currency) | |||
CMH1125 | NUMERIC | MONEY | 28 | 8 | 20 | ActInvAmountLCU | Accumulated Invoiced Amount (Local Currency) | |||
CMH1126 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | FixExchRate1 | Fixed Exchange Rate 1 | |||
CMH1127 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | FixExchRate2 | Fixed Exchange Rate 2 | |||
CMH1128 | NCHAR | STRING | 3 | 0 | 3 | FixExchAlgorithm | Fixed Exchange Rate Algorithm | |||
CMH1129 | NCHAR | STRING | 15 | 0 | 15 | CurrencyContractNr | Currency Contract Number | |||
CMH1130 | NCHAR | STRING | 8 | 0 | 8 | CampaignCode | Campaign Code | |||
CMH1131 | NCHAR | SWITCH | 1 | 0 | 1 | InvInAdvance | Invoice In Advance | |||
CMH1132 | NCHAR | STRING | 10 | 0 | 10 | RequestNo | Customer Request Number | |||
CMH1133 | NCHAR | STRING | 10 | 0 | 10 | CalendarID | Calendar ID | |||
CMH1134 | INT | INTEGER | 0 | 0 | 2 | Default_InvoiceIntervalTimeUnit | Unit Code Invoice Interval | |||
CMH1135 | INT | INTEGER | 0 | 0 | 20 | Discount interval 1 | Discount Interval Period 1 | |||
CMH1136 | INT | INTEGER | 0 | 0 | 10 | Discount interval 2 | Discount Interval Period 2 | |||
CMH1137 | INT | INTEGER | 0 | 0 | 10 | Discount interval 3 | Discount Interval Period 3 | |||
CMH1138 | INT | INTEGER | 0 | 0 | 10 | Discount interval 4 | Discount Interval Period 4 | |||
CMH1139 | INT | INTEGER | 0 | 0 | 10 | Discount 1 Time Unit | Discount Time Unit Period 1 | |||
CMH1140 | INT | INTEGER | 0 | 0 | 10 | Discount 2 Time Unit | Discount Time Unit Period 2 | |||
CMH1141 | INT | INTEGER | 0 | 0 | 10 | Discount 3 Time Unit | Discount Time Unit Period 3 | |||
CMH1142 | INT | INTEGER | 0 | 0 | 10 | Discount 4 Time Unit | Discount Time Unit Period 4 | |||
CMH1143 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code | Accounting Code | |||
CMH1144 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGElectronicContract | Has Electronic Contract | |||
CMH1145 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLContract | EDI/XML Contract Status | |||
CMH1146 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLDoc2 | EDI/XML Document 1 | |||
CMH1147 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLDoc3 | EDI/XML Document 2 | |||
CMH1148 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLCancel | EDI/XML Cancellation Document | |||
CMH1149 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLLabels | EDI/XML Labels | |||
CMH1150 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLQuotation | EDI/XML Quotation | |||
CMH1151 | NVARCHAR | VSTRING | 4 | 0 | 4 | InvIssuer | Invoice Issuer Code | |||
CMH1152 | NCHAR | SWITCH | 1 | 0 | 1 | InvCategory | Invoice Category | |||
CMH1153 | NCHAR | SWITCH | 1 | 0 | 1 | InvType | Invoice Type | |||
CMH1154 | DATETIME | DATE | 0 | 0 | 8 | CancellationDate | Contract Cancellation Date | |||
CMH1155 | DATETIME | DATE | 0 | 0 | 8 | InvoiceFrom | Invoice From Date | |||
CMH1156 | DATETIME | DATE | 0 | 0 | 8 | InvoiceTo | Invoice To Date | |||
CMH1157 | NCHAR | STRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
CMH1158 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerName | Customer Name | |||
CMH1159 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress1 | Shipping Address Line 1 | |||
CMH1160 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress2 | Shipping Address Line 2 | |||
CMH1161 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress3 | Shipping Address Line 3 | |||
CMH1162 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress4 | Shipping Address Line 4 | |||
CMH1163 | NVARCHAR | VSTRING | 6 | 0 | 6 | Purchaser | Purchaser | |||
CMH1164 | NVARCHAR | VSTRING | 2 | 0 | 2 | PaymentTerms | PaymentTerms | |||
CMH1165 | NVARCHAR | VSTRING | 2 | 0 | 2 | DeliveryMethod | Delivery Method | |||
CMH1166 | NVARCHAR | VSTRING | 2 | 0 | 2 | DeliveryTerms | Delivery Terms | |||
CMH1167 | DATETIME | DATE | 0 | 0 | 8 | BookEntryDate | Book Entry Date | |||
CMH1168 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeForInvFee | TaxCodeForInvFee | |||
CMH1169 | INT | INTEGER | 0 | 0 | 2 | ReservationDuration | Reservation Time Out (Duration) | |||
CMH1170 | INT | INTEGER | 0 | 0 | 2 | ReservationTimeUnit | Reservation Time Out (Time unit) | |||
CMH1171 | NCHAR | SWITCH | 1 | 0 | 1 | Avoid Backorders | Avoid Backorders | |||
CMH1172 | NCHAR | SWITCH | 1 | 0 | 1 | AcceptLineSplit | Accept Line Split | |||
CMH1173 | NCHAR | SWITCH | 1 | 0 | 1 | AcceptOrderSplit | Accept Order Split | |||
CMH1174 | NCHAR | SWITCH | 1 | 0 | 1 | UseLTM | UseLTM | |||
CMH1175 | INT | INTEGER | 0 | 0 | 2 | AcceptedDeliveryInterval | Accepted Delivery Interval | |||
CMH1176 | NVARCHAR | VSTRING | 10 | 0 | 10 | CarrierCode | Carrier Code | |||
CMH1177 | NVARCHAR | VSTRING | 35 | 0 | 35 | CarrierName | Carrier Name | |||
CMH1178 | INT | INTEGER | 0 | 0 | 4 | Delivery Note, sort | Delivery Note, sort | |||
CMH1179 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto print DN | Auto print DN | |||
CMH1180 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto send DN | Auto send DN | |||
CMH1181 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type | Operation Type | |||
CMH1182 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code | Financial Operation Code | |||
CMH1183 | NCHAR | SWITCH | 1 | 0 | 1 | Instalment | Instalment | |||
CMH1184 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Interest% | Interest% | |||
CMH1185 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | New Interest% | New Interest% | |||
CMH1186 | DATETIME | DATE | 0 | 0 | 8 | Activate New Interest Date | Activate New Interest Date | |||
CMH1187 | NUMERIC | MONEY | 28 | 8 | 20 | Financial Charge | Financial Charge | |||
CMH1188 | NCHAR | STRING | 6 | 0 | 6 | Interest Tax Code | Interest Tax Code | |||
CMH1189 | NCHAR | STRING | 6 | 0 | 6 | Financial Tax Code | Financial Tax Code | |||
CMH1190 | NVARCHAR | VSTRING | 10 | 0 | 10 | Default Engineer | Default Engineer | |||
CMH1191 | NCHAR | SWITCH | 1 | 0 | 1 | Reorder Customer | Reorder Customer | |||
CMH1192 | INT | INTEGER | 0 | 0 | 1 | Delivery note printing | Delivery note printing | |||
CMH1193 | INT | INTEGER | 0 | 0 | 1 | Invoice printing | Invoice printing | |||
CMH1194 | DATETIME | DATE | 0 | 0 | 8 | Contract Pricing Date | Contract Pricing Date | |||
CMH1195 | NCHAR | STRING | 10 | 0 | 10 | Contract Pricing Number | Contract Pricing Number | |||
CMH1196 | INT | INTEGER | 0 | 0 | 1 | Invoice Status | Invoice Status |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Contract Management | Contract History Master File