One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Contract Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица CMH1 — Contract History Master File

Таблица: 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 Spare (obsolete)      
CMH1011 NCHAR STRING 2 0 2 PaymentTerm Payment Term      
CMH1012 DATETIME DATE 0 0 8 ContractDate Contract Date      
CMH1013 DATETIME DATE 0 0 8 Spare Spare      
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 InvoiceCurrencyCode 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 PriceListDefault Price List      
CMH1034 NCHAR STRING 3 0 3 ContractCode Contract Type      
CMH1035 INT INTEGER 0 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 LabourHoursIncluded Labour Hours Included      
CMH1075 NCHAR STRING 2 0 2 CostPriceCode Cost Price Code      
CMH1076 NUMERIC MONEY 28 8 20 CostPriceOCU Cost Unit Price (Contract Currency)      
CMH1077 NUMERIC X_NUMERIC 20 8 12 CostHoursIncluded Cost Quantity Included      
CMH1078 NCHAR STRING 2 0 2 MtrlPriceCode Material Price Code      
CMH1079 NUMERIC MONEY 28 8 20 MtrlPriceOCU Material Unit Price (Contract Currency)      
CMH1080 NUMERIC X_NUMERIC 20 8 12 MtrlHoursIncluded 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 Invoice1No Invoice 1 Number      
CMH1087 DATETIME DATE 0 0 8 DueDateInv1 Invoice 1 Due Date      
CMH1088 NCHAR STRING 15 0 15 Invoice2No Invoice 2 Number      
CMH1089 DATETIME DATE 0 0 8 DueDateInv2 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 FlagCreateCreditNote Generate Credit Note/Invoice      
CMH1109 NCHAR STRING 1 0 1 Spare Spare      
CMH1110 NCHAR STRING 1 0 1 Spare Spare      
CMH1111 NCHAR STRING 1 0 1 Spare Spare      
CMH1112 NCHAR SWITCH 1 0 1 FlagForText Has Extended Text      
CMH1113 NCHAR STRING 6 0 6 Manager Salesman Contract Administrator      
CMH1114 NCHAR STRING 10 0 10 MasterContract Master Contract      
CMH1115 NCHAR STRING 4 0 4 Spare Spare      
CMH1116 NUMERIC X_NUMERIC 15 8 7 OrderDisc2 Order Discount Period 2 %      
CMH1117 NCHAR STRING 4 0 4 Spare Spare      
CMH1118 NUMERIC X_NUMERIC 15 8 7 OrderDisc3 Order Discount Period 3 %      
CMH1119 NCHAR STRING 4 0 4 Spare Spare      
CMH1120 NUMERIC X_NUMERIC 15 8 7 OrderDisc4 Order Discount Period 4 %      
CMH1121 NCHAR STRING 4 0 4 Spare 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 DefaultInvoiceIntervalTimeUnit Unit Code Invoice Interval      
CMH1135 INT INTEGER 0 0 20 DiscountInterval1 Discount Interval Period 1      
CMH1136 INT INTEGER 0 0 10 DiscountInterval2 Discount Interval Period 2      
CMH1137 INT INTEGER 0 0 10 DiscountInterval3 Discount Interval Period 3      
CMH1138 INT INTEGER 0 0 10 DiscountInterval4 Discount Interval Period 4      
CMH1139 INT INTEGER 0 0 10 Discount1TimeUnit Discount Time Unit Period 1      
CMH1140 INT INTEGER 0 0 10 Discount2TimeUnit Discount Time Unit Period 2      
CMH1141 INT INTEGER 0 0 10 Discount3TimeUnit Discount Time Unit Period 3      
CMH1142 INT INTEGER 0 0 10 Discount4TimeUnit Discount Time Unit Period 4      
CMH1143 NCHAR STRING 2 0 2 AccountingCode 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 6 0 6 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 Spare Spare      
CMH1156 DATETIME DATE 0 0 8 Spare Spare      
CMH1157 NCHAR STRING 10 0 10 SupplierCode Supplier Code      
CMH1158 NVARCHAR VSTRING 35 0 35 CustomerName Customer Name      
CMH1159 NVARCHAR VSTRING 35 0 35 ShippingAddress Shipping Address      
CMH1160 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
CMH1161 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
CMH1162 NVARCHAR VSTRING 35 0 35 Spare (obsolete)      
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 AvoidBackorders 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 DelNoteSort Delivery Note, sort      
CMH1179 NVARCHAR VSTRING 1 0 1 AutoprintDN Auto print DN      
CMH1180 NVARCHAR VSTRING 1 0 1 AutosendDN Auto send DN      
CMH1181 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
CMH1182 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
CMH1183 NCHAR SWITCH 1 0 1 Instalment Instalment      
CMH1184 NUMERIC X_NUMERIC 20 8 12 InterestPercent Interest%      
CMH1185 NUMERIC X_NUMERIC 20 8 12 NewInterestPercent New Interest%      
CMH1186 DATETIME DATE 0 0 8 ActivateNewInterestDate Activate New Interest Date      
CMH1187 NUMERIC MONEY 28 8 20 FinancialCharge Financial Charge      
CMH1188 NCHAR STRING 6 0 6 InterestTaxCode Interest Tax Code      
CMH1189 NCHAR STRING 6 0 6 FinancialTaxCode Financial Tax Code      
CMH1190 NVARCHAR VSTRING 10 0 10 DefaultEngineer Default Engineer      
CMH1191 NCHAR SWITCH 1 0 1 ReorderCustomer Reorder Customer      
CMH1192 INT INTEGER 0 0 1 DelNotePrinting Delivery note printing      
CMH1193 INT INTEGER 0 0 1 InvPrinting Invoice printing      
CMH1194 DATETIME DATE 0 0 8 ContractPricingDate Contract Pricing Date      
CMH1195 NCHAR STRING 10 0 10 ContractPricingNumber Contract Pricing Number      
CMH1196 INT INTEGER 0 0 1 CreditNoteClosureStatus Credit Note Closure Status      
CMH1197 NCHAR STRING 10 0 10 ExecutionOrderNo Execution Order No      
CMH1198 NCHAR STRING 2 0 2 District District      
CMH1199 NCHAR STRING 2 0 2 AdvertisingCode Advertising Code      
CMH1200 NCHAR STRING 4 0 4 CityCode City Code      
CMH1201 NCHAR STRING 5 0 5 SNICode SNI Code      
CMH1202 NCHAR STRING 1 0 1 CommissionDistributionMethod Commission Distribution Method      
CMH1203 NCHAR STRING 2 0 2 CustomerAccountCode Customer Account Code      
CMH1204 NCHAR SWITCH 1 0 1 Spare (obsolete)      
CMH1205 NVARCHAR VSTRING 6 0 6 DepotWH Depot WH      
CMH1206 INT INTEGER 0 0 1 PriceTypeAsset Price Type Asset      
CMH1207 INT INTEGER 0 0 1 PriceTypeAccessory Price Type Accessory      
CMH1208 INT INTEGER 0 0 1 DocumentSpecification Document Specification      
CMH1209 INT INTEGER 0 0 1 InvoiceSpecification Invoice Specification      
CMH1210 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
CMH1211 NVARCHAR VSTRING 2 0 2 PaymentAddressCode Payment Address Code      
CMH1212 NVARCHAR VSTRING 12 0 12 Spare Spare Previously it was «Invoice Counter ID»    
CMH1213 INT INTEGER 0 0 7 ContrIntervalLength Contract Interval Length      
CMH1214 INT INTEGER 0 0 1 ContrIntervalTimeUnit Contract Interval Time Unit 1 — Years
2 — Month
3 — Weeks
4 — Days		    
CMH1215 INT INTEGER 0 0 1 DeliveryDateMilestone Delivery Date Milestone      
CMH1216 NUMERIC X_NUMERIC 20 8 12 DeliveryTimeValue Delivery Time Value      
CMH1217 INT INTEGER 0 0 2 DeliveryTimeUnit Delivery Time Unit      
CMH1218 INT INTEGER 0 0 4 InvoiceCopyNumber Invoice Copy Number      
CMH1219 INT INTEGER 0 0 1 Spare (obsolete)      
CMH1220 NVARCHAR VSTRING 200 0 200 EmailAddress E-Mail Address      
CMH1221 DATETIME X_DATETIME 0 0 17 InvoiceTime Invoice Time      
CMH1222 INT INTEGER 0 0 2 InvoicingModel Invoicing Model      
CMH1223 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price      
CMH1224 NCHAR SWITCH 1 0 1 CreditCheckPassed Credit Check Passed      
CMH1225 NVARCHAR VSTRING 30 0 30 LinkedProjectActivity Linked Project Activity      
CMH1226 NCHAR STRING 6 0 6 InvoicePlanLineNumber Invoice Plan Line Number   3 Да
CMH1227 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
CMH1228 NCHAR STRING 1 0 1 Tax Point Tax Point      
CMH1229 NVARCHAR VSTRING 20 0 20 Public Procurement Code 1 Public Procurement Code 1      
CMH1230 NVARCHAR VSTRING 20 0 20 Public Procurement Code 2 Public Procurement Code 2      
CMH1231 NVARCHAR VSTRING 10 0 10 Operation Type (Service Contract Line or Asset Lease Line) Operation Type (Service Contract Line or Asset Lease Line)      
CMH1232 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Service Contract Line or Asset Lease Line) Financial Operation Code (Service Contract Line or Asset Lease Line)      
CMH1233 NVARCHAR VSTRING 10 0 10 Operation Type (Asset Maintenance Line) Operation Type (Asset Maintenance Line)      
CMH1234 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Asset Maintenance Line) Financial Operation Code (Asset Maintenance Line)      
CMH1235 NVARCHAR VSTRING 10 0 10 Operation Type (Accessory Lease Line) Operation Type (Accessory Lease Line)      
CMH1236 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Accessory Lease Line) Financial Operation Code (Accessory Lease Line)      
CMH1237 NVARCHAR VSTRING 10 0 10 Operation Type (Accessory Maintenance Line) Operation Type (Accessory Maintenance Line)      
CMH1238 NVARCHAR VSTRING 10 0 10 Financial Operation Code (Accessory Maintenance Line) Financial Operation Code (Accessory Maintenance Line)      

Навигация: