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 SL32 — Prepayment Tax Base Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL32001 NVARCHAR VSTRING 2 0 2 ObjectType Object Type Relation to SL31001 1 Да / Yes
SL32002 NVARCHAR VSTRING 15 0 15 ObjectNumber Object Number Relation to SL31002 2 Да / Yes
SL32003 NVARCHAR VSTRING 6 0 6 SubProjectCode Sub-Project Code Relation to SL31003 3 Да / Yes
SL32004 NCHAR STRING 6 0 6 LineNumber Line Number Relation to SL32004 4 Да / Yes
SL32005 NCHAR STRING 6 0 6 TaxBaseLineNumber Tax Base Line Number   5 Да / Yes
SL32006 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code      
SL32007 NVARCHAR VSTRING 6 0 6 TaxCode Tax Code      
SL32008 NUMERIC MONEY 28 8 20 TaxBaseGrossPCU Tax Base Gross PCU Base Amnt including Tax    
SL32009 NUMERIC MONEY 28 8 20 TaxBaseNetPCU Tax Base Net PCU Base Amnt excluding Tax    
SL32010 NUMERIC MONEY 28 8 20 TaxAmountPCU Tax Amount PCU      
SL32011 NVARCHAR VSTRING 6 0 6 LineType LineType      
SL32012 NVARCHAR VSTRING 25 0 25 InvoiceNoPayment InvoiceNoPayment      
SL32013 NCHAR STRING 6 0 6 OrderLineNo OrderLineNo Order Line No    
SL32014 NUMERIC MONEY 28 8 20 TaxBaseGrossICU Tax Base Gross ICU      
SL32015 NUMERIC MONEY 28 8 20 TaxBaseNetICU Tax Base Net ICU      
SL32016 NUMERIC MONEY 28 8 20 TaxAmountICU Tax Amount ICU      
SL32017 NUMERIC MONEY 28 8 20 TaxBaseGrossLCU Tax Base Gross LCU      
SL32018 NUMERIC MONEY 28 8 20 TaxBaseNetLCU Tax Base Net LCU      
SL32019 NUMERIC MONEY 28 8 20 TaxAmountLCU Tax Amount LCU      
SL32020 NCHAR STRING 6 0 6 TaxLiability Tax Liability      
SL32021 NUMERIC MONEY 28 8 20 LineDiscountICU Line Discount ICU      

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