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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SL34 — Prepayment Deductions

Таблица / Table: SL34 — «Prepayment Deductions». Маска имени таблицы / Table name mask: «SL34%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL34001 NVARCHAR VSTRING 2 0 2 ObjectType Object Type Relation to SL32001 1 Да / Yes
SL34002 NVARCHAR VSTRING 15 0 15 ObjectNumber Object Number Relation to SL32002 2 Да / Yes
SL34003 NVARCHAR VSTRING 6 0 6 SubProjectCode Sub-Project Code Relation to SL32003 3 Да / Yes
SL34004 NCHAR STRING 6 0 6 LineNumber Line Number Relation to SL32004 4 Да / Yes
SL34005 NCHAR STRING 6 0 6 TaxBaseLineNumber Tax Base Line Number Relation to SL32005 5 Да / Yes
SL34006 NVARCHAR VSTRING 15 0 15 InvoiceNumber Invoice Number Inv Num where amnt was deducted 6 Да / Yes
SL34007 NUMERIC MONEY 28 8 20 DeductedAmountICU Deducted Amount ICU      
SL34008 NUMERIC MONEY 28 8 20 DeductedTaxAmountICU Deducted Tax Amount ICU      
SL34009 NUMERIC MONEY 28 8 20 DeductedAmountPCU Deducted Amount PCU      
SL34010 NUMERIC MONEY 28 8 20 DeductedTaxAmountPCU Deducted Tax Amount PCU      
SL34011 NUMERIC MONEY 28 8 20 DeductedAmountLCU Deducted Amount LCU      
SL34012 NUMERIC MONEY 28 8 20 DeductedTaxAmountLCU Deducted Tax Amount LCU      

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