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

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SLH6 — Invoice Lines Details History

Таблица / Table: SLH6 — «Invoice Lines Details History». Маска имени таблицы / Table name mask: «SLH6%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLH6001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SLH6002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice No   2 Да / Yes
SLH6003 NVARCHAR VSTRING 6 0 6 InvoiceLineNo Invoice Line No   3 Да / Yes
SLH6004 INT INTEGER 0 0 4 ObjectType Object Type as per SAFT object types    
SLH6005 NVARCHAR VSTRING 12 0 12 ObjectNo Object No      
SLH6006 NVARCHAR VSTRING 6 0 6 SubObjectNo Sub-Object No Subproject code (used for projects only)    
SLH6007 NVARCHAR VSTRING 6 0 6 InvoicePlanLineNo Invoice Plan Line No      
SLH6008 INT INTEGER 0 0 4 LineType Line Type as per SAFT line types    
SLH6009 NVARCHAR VSTRING 6 0 6 LineNumber Line Number      
SLH6010 NVARCHAR VSTRING 50 0 50 Extended Line number Extended Line number      
SLH6011 NVARCHAR VSTRING 35 0 35 StockActivityCode Stock/Activity Code      
SLH6012 NVARCHAR VSTRING 50 0 50 Description1 Description 1      
SLH6013 NVARCHAR VSTRING 50 0 50 Description2 Description 2      
SLH6014 NUMERIC X_NUMERIC 20 8 12 Qty Qty      
SLH6015 INT INTEGER 0 0 4 UnitOfMeasure_Code Unit Of Measure (Code)      
SLH6016 NVARCHAR VSTRING 25 0 25 UnitOfMeasure_Description Unit Of Measure (Description)      
SLH6017 NUMERIC MONEY 28 8 20 Price per Unit OCU Price per Unit OCU      
SLH6018 NUMERIC MONEY 28 8 20 Price per Unit LCU Price per Unit LCU      
SLH6019 NUMERIC MONEY 28 8 20 GrossLineDiscountOCU Gross Line Discount OCU      
SLH6020 NUMERIC MONEY 28 8 20 GrossLineDiscountLCU Gross Line Discount LCU      
SLH6021 NUMERIC MONEY 28 8 20 NetLineAmountOCU Net Line Amount OCU      
SLH6022 NUMERIC MONEY 28 8 20 NetLineAmountLCU Net Line Amount LCU      
SLH6023 NUMERIC MONEY 28 8 20 GrossLineAmountOCU Gross Line Amount OCU      
SLH6024 NUMERIC MONEY 28 8 20 GrossLineAmountLCU Gross Line Amount LCU      
SLH6025 NVARCHAR VSTRING 6 0 6 TaxCode Tax Code      
SLH6026 NVARCHAR VSTRING 6 0 6 TaxPercentage Tax Percentage      
SLH6027 NUMERIC MONEY 28 8 20 TaxAmountOCU Tax Amount OCU      
SLH6028 NUMERIC MONEY 28 8 20 TaxAmountLCU Tax Amount LCU      
SLH6029 NVARCHAR VSTRING 120 0 120 UserDefined1 User Defined 1      
SLH6030 NVARCHAR VSTRING 120 0 120 UserDefined2 User Defined 2      
SLH6031 NVARCHAR VSTRING 120 0 120 UserDefined3 User Defined 3      
SLH6032 NVARCHAR VSTRING 120 0 120 UserDefined4 User Defined 4      
SLH6033 NVARCHAR VSTRING 120 0 120 UserDefined5 User Defined 5      
SLH6034 NVARCHAR VSTRING 120 0 120 UserDefined6 User Defined 6      
SLH6035 NVARCHAR VSTRING 120 0 120 UserDefined7 User Defined 7      
SLH6036 NVARCHAR VSTRING 120 0 120 UserDefined8 User Defined 8      
SLH6037 NVARCHAR VSTRING 120 0 120 UserDefined9 User Defined 9      
SLH6038 NVARCHAR VSTRING 120 0 120 UserDefined10 User Defined 10      
SLH6039 NVARCHAR VSTRING 120 0 120 UserDefined11 User Defined 11      
SLH6040 NVARCHAR VSTRING 120 0 120 UserDefined12 User Defined 12      
SLH6041 NVARCHAR VSTRING 120 0 120 UserDefined13 User Defined 13      
SLH6042 NVARCHAR VSTRING 120 0 120 UserDefined14 User Defined 14      
SLH6043 NVARCHAR VSTRING 120 0 120 UserDefined15 User Defined 15      
SLH6044 NVARCHAR VSTRING 120 0 120 UserDefined16 User Defined 16      
SLH6045 NVARCHAR VSTRING 120 0 120 UserDefined17 User Defined 17      
SLH6046 NVARCHAR VSTRING 120 0 120 UserDefined18 User Defined 18      
SLH6047 NVARCHAR VSTRING 120 0 120 UserDefined19 User Defined 19      
SLH6048 NVARCHAR VSTRING 120 0 120 UserDefined20 User Defined 20      
SLH6049 NUMERIC MONEY 28 8 20 WithholdingTaxAmountOCU Withholding Tax Amount OCU      
SLH6050 NUMERIC MONEY 28 8 20 WithholdingTaxAmountLCU Withholding Tax Amount LCU      
SLH6051 DATETIME DATE 0 0 8 DeliveryDateFrom Delivery Date From      
SLH6052 DATETIME DATE 0 0 8 DeliveryDateTo Delivery Date To      
SLH6053 DATETIME DATE 0 0 8 TaxBEDate Tax BE Date      
SLH6054 NCHAR STRING 6 0 6 TaxLiability Tax Liability      
SLH6055 NVARCHAR VSTRING 10 0 10 FinancialOperationType Financial Operation Type      
SLH6056 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
SLH6057 NVARCHAR VSTRING 10 0 10 SourceCityCode Source City Code      
SLH6058 NVARCHAR VSTRING 10 0 10 DestinationCityCode Destination City Code      
SLH6059 NVARCHAR VSTRING 120 0 120 UserDefined21 User Defined 21      
SLH6060 NVARCHAR VSTRING 120 0 120 UserDefined22 User Defined 22      
SLH6061 NVARCHAR VSTRING 120 0 120 UserDefined23 User Defined 23      
SLH6062 NVARCHAR VSTRING 120 0 120 UserDefined24 User Defined 24      
SLH6063 NVARCHAR VSTRING 120 0 120 UserDefined25 User Defined 25      
SLH6064 NVARCHAR VSTRING 120 0 120 UserDefined26 User Defined 26      
SLH6065 NVARCHAR VSTRING 120 0 120 UserDefined27 User Defined 27      
SLH6066 NVARCHAR VSTRING 120 0 120 UserDefined28 User Defined 28      
SLH6067 NVARCHAR VSTRING 120 0 120 UserDefined29 User Defined 29      
SLH6068 NVARCHAR VSTRING 120 0 120 UserDefined30 User Defined 30      
SLH6069 NVARCHAR VSTRING 15 0 15 DeductByInvNo Deducted by Invoice No      
SLH6070 NVARCHAR VSTRING 10 0 10 Spare Spare      
SLH6071 NVARCHAR VSTRING 10 0 10 Spare Spare      
SLH6072 NUMERIC MONEY 28 8 20 NetLineDiscountOCU Net Line Discount OCU      
SLH6073 NUMERIC MONEY 28 8 20 NetLineDiscountLCU Net Line Discount LCU      

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