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

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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLH1001 NVARCHAR VSTRING 10 0 10 Customer Code Customer Code   1 Да
SLH1002 NVARCHAR VSTRING 15 0 15 Invoice No Invoice No   2 Да
SLH1003 DATETIME DATE 0 0 8 Invoice Date Invoice Date      
SLH1004 NCHAR STRING 2 0 2 Invoice Currency Code Invoice Currency Code      
SLH1005 NVARCHAR VSTRING 3 0 3 Invoice Currency Name Invoice Currency Name      
SLH1006 NVARCHAR VSTRING 6 0 6 Issuer Code Issuer Code      
SLH1007 NUMERIC MONEY 28 8 20 Invoice Net Total OCU Invoice Net Total OCU      
SLH1008 NUMERIC MONEY 28 8 20 Invoice Net Total LCU Invoice Net Total LCU      
SLH1009 NUMERIC MONEY 28 8 20 Invoice Grand Total Amount OCU Invoice Grand Total Amount OCU      
SLH1010 NUMERIC MONEY 28 8 20 Invoice Grand Total Amount LCU Invoice Grand Total Amount LCU      
SLH1011 NVARCHAR VSTRING 50 0 50 User Defined 1 User Defined 1      
SLH1012 NVARCHAR VSTRING 50 0 50 User Defined 2 User Defined 2      
SLH1013 NVARCHAR VSTRING 50 0 50 User Defined 3 User Defined 3      
SLH1014 NVARCHAR VSTRING 50 0 50 User Defined 4 User Defined 4      
SLH1015 NVARCHAR VSTRING 50 0 50 User Defined 5 User Defined 5      
SLH1016 NVARCHAR VSTRING 50 0 50 User Defined 6 User Defined 6      
SLH1017 NVARCHAR VSTRING 50 0 50 User Defined 7 User Defined 7      
SLH1018 NVARCHAR VSTRING 50 0 50 User Defined 8 User Defined 8      
SLH1019 NVARCHAR VSTRING 50 0 50 User Defined 9 User Defined 9      
SLH1020 NVARCHAR VSTRING 50 0 50 User Defined 10 User Defined 10      
SLH1021 NVARCHAR VSTRING 50 0 50 UserDefined 11 UserDefined 11      
SLH1022 NVARCHAR VSTRING 50 0 50 UserDefined 12 UserDefined 12      
SLH1023 NVARCHAR VSTRING 50 0 50 UserDefined 13 UserDefined 13      
SLH1024 NVARCHAR VSTRING 50 0 50 UserDefined 14 UserDefined 14      
SLH1025 NVARCHAR VSTRING 50 0 50 UserDefined 15 UserDefined 15      
SLH1026 NVARCHAR VSTRING 50 0 50 UserDefined 16 UserDefined 16      
SLH1027 NVARCHAR VSTRING 50 0 50 UserDefined 17 UserDefined 17      
SLH1028 NVARCHAR VSTRING 50 0 50 UserDefined 18 UserDefined 18      
SLH1029 NVARCHAR VSTRING 50 0 50 UserDefined 19 UserDefined 19      
SLH1030 NVARCHAR VSTRING 50 0 50 UserDefined 20 UserDefined 20      
SLH1031 NUMERIC MONEY 28 8 20 Net Total Before Charges OCU Net Total Before Charges OCU      
SLH1032 NUMERIC MONEY 28 8 20 Net Total Before Charges LCU Net Total Before Charges LCU      
SLH1033 NUMERIC MONEY 28 8 20 Tax Total Amount OCU Tax Total Amount OCU      
SLH1034 NUMERIC MONEY 28 8 20 Tax Total Amount LCU Tax Total Amount LCU      
SLH1035 NUMERIC MONEY 28 8 20 Rounding Amount OCU Rounding Amount OCU      
SLH1036 NUMERIC MONEY 28 8 20 Rounding Amount LCU Rounding Amount LCU      
SLH1037 NCHAR SWITCH 1 0 1 Specification Printed Specification Printed      
SLH1038 INT INTEGER 0 0 1 Paper Printed Flag Paper Printed Flag      
SLH1039 INT INTEGER 0 0 4 Number of Copies Number of Copies      
SLH1040 INT INTEGER 0 0 1 XML Sent flag XML Sent flag      
SLH1041 NCHAR STRING 8 0 8 Created User ID Created User ID      
SLH1042 DATETIME DATE 0 0 8 Created Time Stamp Created Time Stamp      
SLH1043 INT INTEGER 0 0 4 Template Version Template Version      
SLH1044 DATETIME X_DATETIME 0 0 17 Printed Time Stamp Printed Time Stamp      
SLH1045 NVARCHAR VSTRING 3 0 3 Language Code Language Code      
SLH1046 NCHAR STRING 1 0 1 Document Layout Code Document Layout Code      
SLH1047 NUMERIC MONEY 28 8 20 Withholding Tax Amount OCU Withholding Tax Amount OCU      
SLH1048 NUMERIC MONEY 28 8 20 Withholding Tax Amount LCU Withholding Tax Amount LCU      
SLH1049 NVARCHAR VSTRING 50 0 50 User Defined 21 User Defined 21      
SLH1050 NVARCHAR VSTRING 50 0 50 User Defined 22 User Defined 22      
SLH1051 NVARCHAR VSTRING 50 0 50 User Defined 23 User Defined 23      
SLH1052 NVARCHAR VSTRING 50 0 50 User Defined 24 User Defined 24      
SLH1053 NVARCHAR VSTRING 50 0 50 User Defined 25 User Defined 25      
SLH1054 NVARCHAR VSTRING 50 0 50 User Defined 26 User Defined 26      
SLH1055 NVARCHAR VSTRING 50 0 50 User Defined 27 User Defined 27      
SLH1056 NVARCHAR VSTRING 50 0 50 User Defined 28 User Defined 28      
SLH1057 NVARCHAR VSTRING 50 0 50 User Defined 29 User Defined 29      
SLH1058 NVARCHAR VSTRING 50 0 50 User Defined 30 User Defined 30      

Навигация: