На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SM29 — Service Order Templates

Таблица / Table: SM29 — «Service Order Template». Маска имени таблицы / Table name mask: «SM29%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM29001 NCHAR STRING 3 0 3 TemplateNo Template Number   1 Да / Yes
SM29002 NCHAR STRING 2 0 2 PricelistNo Price List      
SM29003 NUMERIC MONEY 28 8 20 FixPriceHours Fixed Price Hours      
SM29004 NUMERIC MONEY 28 8 20 FixPriceCosts Fixed Price Costs      
SM29005 NUMERIC MONEY 28 8 20 FixPriceMat Fixed Price Material      
SM29006 NCHAR STRING 1 0 1 InvSpecHours Invoice Details for Hours 0 — The sum of work, cost and material is printed as a single total amount

1 — All activity lines are printed as a single total amount.

2 — Each activity transaction is printed on the invoice		    
SM29007 NCHAR STRING 1 0 1 InvSpecCosts Invoice Details for Cost 1 — All cost lines are printed as a single total amount.

2 — Each cost transaction is printed on the invoice		    
SM29008 NCHAR STRING 1 0 1 InvSpecMat Invoice Details for Material 1 — All material lines are printed as a single total amount.

2 — Each material transaction is printed on the invoice		    
SM29009 NUMERIC MONEY 28 8 20 HandlingFee Invoice Fee      
SM29010 NCHAR STRING 2 0 2 Spare (obsolete)      
SM29011 NCHAR STRING 1 0 1 InvMergeOpt Invoice Merge Option Invoice merge option (invoices will be consolidated in sales ledger).

0 — No consolidated invoice

1 — Consolidate invoice per week

2 — Consolidate invoice per month		    
SM29012 NCHAR STRING 2 0 2 DeliveryCode Delivery Terms      
SM29013 NCHAR STRING 2 0 2 DeliveryMethod Delivery Method      
SM29014 NCHAR STRING 1 0 1 MasterOrderPr Master Delivery Note      
SM29015 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM29016 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
SM29017 NCHAR STRING 1 0 1 DocumLayout Document Layout      
SM29018 NVARCHAR VSTRING 35 0 35 TemplateDescr Template Description      
SM29019 NCHAR STRING 2 0 2 AccountingCode Accounting Code Service Order      
SM29020 NCHAR STRING 2 0 2 CurrencyCode Currency Code      
SM29021 NUMERIC X_NUMERIC 14 8 6 OrderDiscount Order Discount %      
SM29022 NUMERIC X_NUMERIC 14 8 6 ExtCommissionPer External Commission %      
SM29023 NCHAR STRING 10 0 10 ExtCommissionCode External Commission Code      
SM29024 NCHAR STRING 2 0 2 InvoiceCurrencyCode Currency Code Invoice      
SM29025 NCHAR STRING 1 0 1 DocSpecHrs Documents Specification Hours 0 — The sum of work, cost and material is printed as a single total amount

1 — All activity lines are printed as a single total amount.

2 — Each activity transaction is printed on the document		    
SM29026 NCHAR STRING 1 0 1 DocSpecCost Documents Specification Costs 1 — All cost lines are printed as a single total amount.

2 — Each cost transaction is printed on the document		    
SM29027 NCHAR STRING 1 0 1 DocSpecMat Documents Specification Material 1 — All material lines are printed as a single total amount.

2 — Each material transaction is printed on the document		    
SM29028 NVARCHAR VSTRING 1 0 1 PartialDeliveryPlanning Partial Delivery Planning = – not used

0 – allowed

1 – prohibited		    
SM29029 NVARCHAR VSTRING 1 0 1 CustomerForPricing Customer for pricing      
SM29030 NVARCHAR VSTRING 10 0 10 OperationTypeOrderHeader Operation Type Order Header      
SM29031 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeOrderHeader Financial Operation Code Order Header      
SM29032 NVARCHAR VSTRING 10 0 10 OperationTypeTimeLines Operation Type Time Lines      
SM29033 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeTimeLines Financial Operation Code Time Lines      
SM29034 NVARCHAR VSTRING 10 0 10 OperationTypeCostLines Operation Type Cost Lines      
SM29035 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeCostLines Financial Operation Code Cost Lines      
SM29036 NVARCHAR VSTRING 10 0 10 OperationTypeMaterialLines Operation Type Material Lines      
SM29037 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeMaterialLines Financial Operation Code Material Lines      

Навигация / Navigation: