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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SLH1 — Invoice Header History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLH1001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SLH1002 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice No   2 Да / Yes
SLH1003 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SLH1004 NCHAR STRING 2 0 2 InvoiceCurrencyCode Invoice Currency Code      
SLH1005 NVARCHAR VSTRING 3 0 3 InvoiceCurrencyName Invoice Currency Name      
SLH1006 NVARCHAR VSTRING 6 0 6 IssuerCode Issuer Code      
SLH1007 NUMERIC MONEY 28 8 20 InvoiceNetTotalOCU Invoice Net Total OCU      
SLH1008 NUMERIC MONEY 28 8 20 InvoiceNetTotalLCU Invoice Net Total LCU      
SLH1009 NUMERIC MONEY 28 8 20 InvoiceGrandTotalAmountOCU Invoice Grand Total Amount OCU      
SLH1010 NUMERIC MONEY 28 8 20 InvoiceGrandTotalAmountLCU Invoice Grand Total Amount LCU      
SLH1011 NVARCHAR VSTRING 120 0 120 UserDefined1 User Defined 1      
SLH1012 NVARCHAR VSTRING 120 0 120 UserDefined2 User Defined 2      
SLH1013 NVARCHAR VSTRING 120 0 120 UserDefined3 User Defined 3      
SLH1014 NVARCHAR VSTRING 120 0 120 UserDefined4 User Defined 4      
SLH1015 NVARCHAR VSTRING 120 0 120 UserDefined5 User Defined 5      
SLH1016 NVARCHAR VSTRING 120 0 120 UserDefined6 User Defined 6      
SLH1017 NVARCHAR VSTRING 120 0 120 UserDefined7 User Defined 7      
SLH1018 NVARCHAR VSTRING 120 0 120 UserDefined8 User Defined 8      
SLH1019 NVARCHAR VSTRING 120 0 120 UserDefined9 User Defined 9      
SLH1020 NVARCHAR VSTRING 120 0 120 UserDefined10 User Defined 10      
SLH1021 NVARCHAR VSTRING 120 0 120 UserDefined11 UserDefined 11      
SLH1022 NVARCHAR VSTRING 120 0 120 UserDefined12 UserDefined 12      
SLH1023 NVARCHAR VSTRING 120 0 120 UserDefined13 UserDefined 13      
SLH1024 NVARCHAR VSTRING 120 0 120 UserDefined14 UserDefined 14      
SLH1025 NVARCHAR VSTRING 120 0 120 UserDefined15 UserDefined 15      
SLH1026 NVARCHAR VSTRING 120 0 120 UserDefined16 UserDefined 16      
SLH1027 NVARCHAR VSTRING 120 0 120 UserDefined17 UserDefined 17      
SLH1028 NVARCHAR VSTRING 120 0 120 UserDefined18 UserDefined 18      
SLH1029 NVARCHAR VSTRING 120 0 120 UserDefined19 UserDefined 19      
SLH1030 NVARCHAR VSTRING 120 0 120 UserDefined20 UserDefined 20      
SLH1031 NUMERIC MONEY 28 8 20 NetTotalBeforeChargesOCU Net Total Before Charges OCU      
SLH1032 NUMERIC MONEY 28 8 20 NetTotalBeforeChargesLCU Net Total Before Charges LCU      
SLH1033 NUMERIC MONEY 28 8 20 TaxTotalAmountOCU Tax Total Amount OCU      
SLH1034 NUMERIC MONEY 28 8 20 TaxTotalAmountLCU Tax Total Amount LCU      
SLH1035 NUMERIC MONEY 28 8 20 RoundingAmountOCU Rounding Amount OCU      
SLH1036 NUMERIC MONEY 28 8 20 RoundingAmountLCU Rounding Amount LCU      
SLH1037 NCHAR SWITCH 1 0 1 SpecificationPrinted Specification Printed      
SLH1038 INT INTEGER 0 0 1 PaperPrintedFlag Paper Printed Flag      
SLH1039 INT INTEGER 0 0 4 NumberOfPrintouts Number of printouts Number of printouts    
SLH1040 INT INTEGER 0 0 1 XML Sent flag XML Sent flag      
SLH1041 NCHAR STRING 8 0 8 CreatedUserID Created User ID      
SLH1042 DATETIME DATE 0 0 8 CreatedTimeStamp Created Time Stamp      
SLH1043 INT INTEGER 0 0 4 TemplateVersion Template Version      
SLH1044 DATETIME X_DATETIME 0 0 17 PrintedTimeStamp Printed Time Stamp      
SLH1045 NVARCHAR VSTRING 3 0 3 LanguageCode Language Code      
SLH1046 NCHAR STRING 1 0 1 DocumentLayoutCode Document Layout Code      
SLH1047 NUMERIC MONEY 28 8 20 WithholdingTaxAmountOCU Withholding Tax Amount OCU      
SLH1048 NUMERIC MONEY 28 8 20 WithholdingTaxAmountLCU Withholding Tax Amount LCU      
SLH1049 NVARCHAR VSTRING 120 0 120 UserDefined21 User Defined 21      
SLH1050 NVARCHAR VSTRING 120 0 120 UserDefined22 User Defined 22      
SLH1051 NVARCHAR VSTRING 120 0 120 UserDefined23 User Defined 23      
SLH1052 NVARCHAR VSTRING 120 0 120 UserDefined24 User Defined 24      
SLH1053 NVARCHAR VSTRING 120 0 120 UserDefined25 User Defined 25      
SLH1054 NVARCHAR VSTRING 120 0 120 UserDefined26 User Defined 26      
SLH1055 NVARCHAR VSTRING 120 0 120 UserDefined27 User Defined 27      
SLH1056 NVARCHAR VSTRING 120 0 120 UserDefined28 User Defined 28      
SLH1057 NVARCHAR VSTRING 120 0 120 UserDefined29 User Defined 29      
SLH1058 NVARCHAR VSTRING 120 0 120 UserDefined30 User Defined 30      
SLH1059 NVARCHAR VSTRING 200 0 200 EmailTo Email To      
SLH1060 NVARCHAR VSTRING 200 0 200 EmailCc Email CC      
SLH1061 NVARCHAR VSTRING 200 0 200 EmailBcc Email BCC      
SLH1062 NVARCHAR VSTRING 200 0 200 EmailFrom Email From Email From    
SLH1063 NVARCHAR VSTRING 250 0 250 FileName File Name File Name    
SLH1064 INT INTEGER 0 0 4 PaperCopiesToPrint Paper copies to print      
SLH1065 INT INTEGER 0 0 4 NumberOfXMLSendings Number of XML sendings Number of XML sendings    
SLH1066 DATETIME X_DATETIME 0 0 17 LatestXMLSending Latest XML sending timestamp Latest XML sending timestamp    
SLH1067 DATETIME X_DATETIME 0 0 17 LatestReprint Latest reprint timestamp Latest reprint timestamp    
SLH1068 NVARCHAR VSTRING 30 0 30 CustPONum Customer PO number      
SLH1069 INT INTEGER 0 0 2 DocumentID Document ID      
SLH1070 DATETIME DATE 0 0 8 TaxRegDate Tax Registration Date      
SLH1071 NVARCHAR VSTRING 50 0 50 CreditReason Credit Reason      
SLH1072 NVARCHAR VSTRING 25 0 25 OriginalInvoice Original Invoice      

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