пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SLB1 — Bank Note Records

Таблица: SLB1 — «Bank Note Records». Маска имени таблицы: «SLB1%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLB1001 NVARCHAR VSTRING 2 0 2 ModuleType Module Type This field should contain the module code (OR, DI, SM, PR, CM) (2 characters) 1 Да
SLB1002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice No This field should contain the invoice number (15 characters). 2 Да
SLB1003 NVARCHAR VSTRING 3 0 3 InstallmentNo Installment No This field should contain the installment number or 0 if there are not installments (2 characters). 3 Да
SLB1004 NVARCHAR VSTRING 20 0 20 BankNoteNo Bank Note No This field should contain the bank note number (20 characters) 4 Да
SLB1005 NVARCHAR VSTRING 10 0 10 OrderNo Order No This field should contain the order number (10 characters)    
SLB1006 DATETIME DATE 0 0 8 BankNoteDate Bank Note Date This field should contain the date of bank note printing (8 character)    
SLB1007 INT INTEGER 0 0 2 InvCurrCode Inv Curr Code This field should contain the code of invoice currency (2 characters)    
SLB1008 NUMERIC MONEY 28 8 20 InvAmntLCU Inv Amnt LCU This field should contain the invoice amount in local currency (20 characters)    
SLB1009 NUMERIC MONEY 28 8 20 InvAmntICU Inv Amnt ICU This field should contain the invoice amount in invoice currency (20 characters)    
SLB1010 NVARCHAR VSTRING 6 0 6 CashDiscount Cash Discount This field should contain the cash discount per cent (6 characters)    
SLB1011 DATETIME DATE 0 0 8 CashDiscDate Cash Disc Date This field should contain the last date for cash discount (8 characters)    
SLB1012 NUMERIC MONEY 28 8 20 IntrstPerDayICU Intrst Per Day ICU This field should contain the interest amount per day in invoice currency (20 characters)    
SLB1013 NVARCHAR VSTRING 50 0 50 InterestTxt InterestTxt This field should contain the text for payment interest (50 characters)    
SLB1014 NCHAR STRING 1 0 1 BankNoteStatus Bank Note Status This field should contain the bank note status (1 character)    

Навигация: