Таблица: SM13 - «Service Contract Line File I/O». Маска имени таблицы: «SM13%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SM13001 NCHAR STRING 10 0 10 ServContrNo Service Contract Number   1 Да
SM13002 NCHAR STRING 6 0 6 LineNo Contract Line Number   2 Да
SM13003 NCHAR STRING 1 0 1 LineType Line Type 0 - Normal contract line
9 - Text line		    
SM13004 NCHAR STRING 35 0 35 StockCode Stock Item Code      
SM13005 NCHAR STRING 20 0 20 SerialNo Serial Number      
SM13006 NVARCHAR VSTRING 25 0 25 DescrLine1 Description Line 1      
SM13007 NVARCHAR VSTRING 25 0 25 DescrLine2 Description Line 2      
SM13008 NUMERIC MONEY 28 8 20 PricePerUnitOCU Unit Price (Contract Currency)      
SM13009 NCHAR STRING 1 0 1 Spare (obsolete)      
SM13010 NUMERIC X_NUMERIC 15 8 7 Discount Discount %      
SM13011 DATETIME DATE 0 0 8 Date_EntryLine Date Entered      
SM13012 NCHAR STRING 3 0 3 Contract_Type Contract Type      
SM13013 NCHAR SWITCH 1 0 1 PriceType Price Type 0 - The prices entered on the contract lines are used, index can be used to restate the prices at invoice time.
1 - Current price from price list will be used at the time of invoice.		    
SM13014 NCHAR STRING 2 0 2 AccCode Accounting Code      
SM13015 NCHAR STRING 6 0 6 JobCode Job Number      
SM13016 NCHAR STRING 6 0 6 WH Warehouse      
SM13017 NCHAR STRING 7 0 7 Spare (obsolete)      
SM13018 NCHAR STRING 6 0 6 Spare (obsolete)      
SM13019 NCHAR STRING 6 0 6 SalesTaxCode VAT Code      
SM13020 NCHAR STRING 7 0 7 LineTax2 VAT Code 2      
SM13021 DATETIME DATE 0 0 8 NextInvDate Next Invoice Date      
SM13022 NCHAR STRING 4 0 4 InstallatSite Site Code      
SM13023 DATETIME DATE 0 0 8 Date_LineStart Contract Line Start Date      
SM13024 DATETIME DATE 0 0 8 Date_LineEnd Contract Line End Date      
SM13025 NUMERIC X_NUMERIC 20 8 12 OverRespTime Response Time Override      
SM13026 INT INTEGER 0 0 1 Status Line Status 0 - Normal contract line
1 - Changed invoice amount
2 - Cancelled line, by date
3 - Switched of line		    
SM13027 NUMERIC MONEY 28 8 20 ChangeValueOCU Change Value (Contract Currency)      
SM13028 NCHAR STRING 20 0 20 ReasChngText Change Reason      
SM13029 DATETIME DATE 0 0 8 ChangeDate Change Date      
SM13030 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM13031 DATETIME DATE 0 0 8 DiscEndDate Discount End Date      
SM13032 NCHAR STRING 10 0 10 CustCodeSite Customer Code Installation Address      
SM13033 NCHAR STRING 2 0 2 ContactCurrency Currency Code Contract      
SM13034 NUMERIC MONEY 28 8 20 PrevAccPrice Previous Accrual Unit Price (Local Currency)      
SM13035 DATETIME DATE 0 0 8 DateAcCreated Date Accruals Created      
SM13036 DATETIME DATE 0 0 8 DateContrClosed Date Contract Closed      
SM13037 NUMERIC MONEY 28 8 20 AccumAccrAcount Accumulated Accrual Amount (Local Currency)      
SM13038 DATETIME DATE 0 0 8 PrevAccrStartDate Previous Accrual Start Date      
SM13039 DATETIME DATE 0 0 8 PrevAccrEndDate Previous Accrual End Date      
SM13040 NCHAR STRING 6 0 6 SubLineNo Contract Sub-line Number   3 Да
SM13041 NCHAR STRING 2 0 2 PriceList Price List      
SM13042 INT INTEGER 0 0 2 Price_UnitCode Unit Code Price      
SM13043 NCHAR STRING 10 0 10 CalendarID Calendar ID      
SM13044 NUMERIC X_NUMERIC 20 8 12 Qty_Planned Quantity Planned      
SM13045 NUMERIC X_NUMERIC 20 8 12 Qty_Actual Quantity Actual      
SM13046 NUMERIC X_NUMERIC 20 8 12 RentalUnits_Actual Quantity Actual Rental      
SM13047 INT INTEGER 0 0 2 UnitCode_Qty Unit Code Quantity      
SM13048 NCHAR STRING 4 0 4 CntrLineStartTime Contract Line Start Time      
SM13049 NCHAR STRING 4 0 4 CntrLineEndTime Contract Line End Time      
SM13050 NUMERIC X_NUMERIC 28 8 20 InvoiceQty Invoice Qty      
SM13051 DATETIME DATE 0 0 8 RequestedDate Requested Date      
SM13052 DATETIME DATE 0 0 8 ConfirmedDate Confirmed Date      
SM13053 DATETIME DATE 0 0 8 LastUsedDate Last Used Date      
SM13054 DATETIME DATE 0 0 8 AcceptedDate AcceptedDate      
SM13055 NUMERIC X_NUMERIC 20 8 12 Qty Unit Factor Qty Unit Factor      
SM13056 NVARCHAR VSTRING 10 0 10 Default Engineer Default Engineer      
SM13057 DATETIME DATE 0 0 8 Expiry Date Reservation Expiry Date      
SM13058 NVARCHAR VSTRING 20 0 20 ReqDelTimeRem Requested Delivery Time remark      
SM13059 NVARCHAR VSTRING 20 0 20 AccDelTimeRem Accepted Delivery Time remark      
SM13060 DATETIME DATE 0 0 8 Contract Line Pricing Date Contract Line Pricing Date      
SM13061 NCHAR STRING 10 0 10 Contract Pricing Number Contract Pricing Number      
SM13062 NCHAR STRING 15 0 15 InvoiceNo InvoiceNo      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Contract Lines