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 SLB1 — Bank Note Records

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLB1001 NVARCHAR VSTRING 2 0 2 ModuleType Module Type This field should contain the module code (OR, DI, SM, PR, CM) (2 characters) 1 Да / Yes
SLB1002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice No This field should contain the invoice number (15 characters). 2 Да / Yes
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 Да / Yes
SLB1004 NVARCHAR VSTRING 20 0 20 BankNoteNo Bank Note No This field should contain the bank note number (20 characters) 4 Да / Yes
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)    

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