One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SM72 — Service Invoice Sort File

Таблица / Table: SM72 — «Service Invoice Sort File I/O». Маска имени таблицы / Table name mask: «SM72%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM72001 NCHAR STRING 10 0 10 Icustomer Invoice Customer   1 Да / Yes
SM72002 NCHAR STRING 10 0 10 ServOrderNo Service Order Number   2 Да / Yes
SM72003 NCHAR STRING 15 0 15 InvoicingNo Invoice Number      
SM72004 NCHAR STRING 2 0 2 PaymentTerms Payment Terms      
SM72005 NCHAR STRING 10 0 10 Spare (obsolete)      
SM72006 NCHAR STRING 1 0 1 MergeCode Invoice Merge Option      
SM72007 DATETIME DATE 0 0 8 InvoicingDate Invoice Date      
SM72008 NUMERIC MONEY 28 8 20 TotLabPrFixICU Total Fixed Price Time (Invoice Currency)      
SM72009 NUMERIC MONEY 28 8 20 TotLabourPriceICU Total Price Time (Invoice Currency)      
SM72010 NUMERIC MONEY 28 8 20 TotCstPriFixICU Total Fixed Price Cost (Invoice Currency)      
SM72011 NUMERIC MONEY 28 8 20 TotCostPriceICU Total Price Cost (Invoice Currency)      
SM72012 NUMERIC MONEY 28 8 20 TotMatPriFixICU Total Fixed Price Material (Invoice Currency)      
SM72013 NUMERIC MONEY 28 8 20 TotMaterPriceICU Total Price Material (Invoice Currency)      
SM72014 NCHAR SWITCH 1 0 1 Cred1Debit Is Debit Order      
SM72015 INT INTEGER 0 0 1 UpdStatus Update Status      
SM72016 NCHAR STRING 3 0 3 UserSalsCode Invoice Responsible      
SM72017 NVARCHAR VSTRING 77 0 77 Space (obsolete)      
SM72018 NCHAR STRING 2 0 2 CurrencyCode Currency Code      

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