Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SM29 - «Service Order Template». Маска имени таблицы: «SM29%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM29001 | NCHAR | STRING | 3 | 0 | 3 | TemplateNo | Template Number | 1 | Да | |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Service Order Templates