One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SLH6 — Invoice Lines Details History

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLH6001 NVARCHAR VSTRING 10 0 10 Customer Code Customer Code   1 Да
SLH6002 NVARCHAR VSTRING 15 0 15 Invoice No Invoice No   2 Да
SLH6003 NVARCHAR VSTRING 6 0 6 Invoice Line No Invoice Line No   3 Да
SLH6004 INT INTEGER 0 0 4 Object Type Object Type as per SAFT object types    
SLH6005 NVARCHAR VSTRING 12 0 12 Object No Object No      
SLH6006 NVARCHAR VSTRING 6 0 6 Sub-Object No Sub-Object No Subproject code (used for projects only)    
SLH6007 NVARCHAR VSTRING 6 0 6 Invoice Plan Line No Invoice Plan Line No      
SLH6008 INT INTEGER 0 0 4 Line Type Line Type as per SAFT line types    
SLH6009 NVARCHAR VSTRING 6 0 6 Line Number Line Number      
SLH6010 NVARCHAR VSTRING 50 0 50 Extended Line number Extended Line number      
SLH6011 NVARCHAR VSTRING 35 0 35 Stock/Activity Code Stock/Activity Code      
SLH6012 NVARCHAR VSTRING 50 0 50 Description 1 Description 1      
SLH6013 NVARCHAR VSTRING 50 0 50 Description 2 Description 2      
SLH6014 NUMERIC X_NUMERIC 20 8 12 Qty Qty      
SLH6015 INT INTEGER 0 0 4 Unit Of Measure (Code) Unit Of Measure (Code)      
SLH6016 NVARCHAR VSTRING 25 0 25 Unit Of Measure (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 Line Discount OCU Line Discount OCU      
SLH6020 NUMERIC MONEY 28 8 20 Line Discount LCU Line Discount LCU      
SLH6021 NUMERIC MONEY 28 8 20 Net Line Amount OCU Net Line Amount OCU      
SLH6022 NUMERIC MONEY 28 8 20 Net Line Amount LCU Net Line Amount LCU      
SLH6023 NUMERIC MONEY 28 8 20 Gross Line Amount OCU Gross Line Amount OCU      
SLH6024 NUMERIC MONEY 28 8 20 Gross Line Amount LCU Gross Line Amount LCU      
SLH6025 NVARCHAR VSTRING 6 0 6 Tax Code Tax Code      
SLH6026 NVARCHAR VSTRING 6 0 6 Tax Percentage Tax Percentage      
SLH6027 NUMERIC MONEY 28 8 20 Tax Amount OCU Tax Amount OCU      
SLH6028 NUMERIC MONEY 28 8 20 Tax Amount LCU Tax Amount LCU      
SLH6029 NVARCHAR VSTRING 50 0 50 User Defined 1 User Defined 1      
SLH6030 NVARCHAR VSTRING 50 0 50 User Defined 2 User Defined 2      
SLH6031 NVARCHAR VSTRING 50 0 50 User Defined 3 User Defined 3      
SLH6032 NVARCHAR VSTRING 50 0 50 User Defined 4 User Defined 4      
SLH6033 NVARCHAR VSTRING 50 0 50 User Defined 5 User Defined 5      
SLH6034 NVARCHAR VSTRING 50 0 50 User Defined 6 User Defined 6      
SLH6035 NVARCHAR VSTRING 50 0 50 User Defined 7 User Defined 7      
SLH6036 NVARCHAR VSTRING 50 0 50 User Defined 8 User Defined 8      
SLH6037 NVARCHAR VSTRING 50 0 50 User Defined 9 User Defined 9      
SLH6038 NVARCHAR VSTRING 50 0 50 User Defined 10 User Defined 10      
SLH6039 NVARCHAR VSTRING 50 0 50 User Defined 11 User Defined 11      
SLH6040 NVARCHAR VSTRING 50 0 50 User Defined 12 User Defined 12      
SLH6041 NVARCHAR VSTRING 50 0 50 User Defined 13 User Defined 13      
SLH6042 NVARCHAR VSTRING 50 0 50 User Defined 14 User Defined 14      
SLH6043 NVARCHAR VSTRING 50 0 50 User Defined 15 User Defined 15      
SLH6044 NVARCHAR VSTRING 50 0 50 User Defined 16 User Defined 16      
SLH6045 NVARCHAR VSTRING 50 0 50 User Defined 17 User Defined 17      
SLH6046 NVARCHAR VSTRING 50 0 50 User Defined 18 User Defined 18      
SLH6047 NVARCHAR VSTRING 50 0 50 User Defined 19 User Defined 19      
SLH6048 NVARCHAR VSTRING 50 0 50 User Defined 20 User Defined 20      
SLH6049 NUMERIC MONEY 28 8 20 Withholding Tax Amount OCU Withholding Tax Amount OCU      
SLH6050 NUMERIC MONEY 28 8 20 Withholding Tax Amount LCU Withholding Tax Amount LCU      
SLH6051 DATETIME DATE 0 0 8 Delivery Date From Delivery Date From      
SLH6052 DATETIME DATE 0 0 8 Delivery Date To Delivery Date To      
SLH6053 DATETIME DATE 0 0 8 Tax BE Date Tax BE Date      
SLH6054 NCHAR STRING 6 0 6 Tax Liability Tax Liability      
SLH6055 NVARCHAR VSTRING 10 0 10 Financial Operation Type Financial Operation Type      
SLH6056 NVARCHAR VSTRING 10 0 10 Financial Operation Code Financial Operation Code      
SLH6057 NVARCHAR VSTRING 10 0 10 Source City Code Source City Code      
SLH6058 NVARCHAR VSTRING 10 0 10 Destination City Code Destination City Code      
SLH6059 NVARCHAR VSTRING 50 0 50 User Defined 21 User Defined 21      
SLH6060 NVARCHAR VSTRING 50 0 50 User Defined 22 User Defined 22      
SLH6061 NVARCHAR VSTRING 50 0 50 User Defined 23 User Defined 23      
SLH6062 NVARCHAR VSTRING 50 0 50 User Defined 24 User Defined 24      
SLH6063 NVARCHAR VSTRING 50 0 50 User Defined 25 User Defined 25      
SLH6064 NVARCHAR VSTRING 50 0 50 User Defined 26 User Defined 26      
SLH6065 NVARCHAR VSTRING 50 0 50 User Defined 27 User Defined 27      
SLH6066 NVARCHAR VSTRING 50 0 50 User Defined 28 User Defined 28      
SLH6067 NVARCHAR VSTRING 50 0 50 User Defined 29 User Defined 29      
SLH6068 NVARCHAR VSTRING 50 0 50 User Defined 30 User Defined 30      
SLH6069 NVARCHAR VSTRING 15 0 15 DeductByInvNo Deducted by Invoice No      

Навигация: