One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PN06 — Portfolios

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PN06001 NCHAR STRING 1 0 1 PortfoliType Portfolio Type R — Receivable

P — Payable
1 Да / Yes
PN06002 NCHAR STRING 2 0 2 PortfolioNo Portfolio Number   2 Да / Yes
PN06003 NVARCHAR VSTRING 32 0 32 PortfoliName Portfolio Name      
PN06004 NVARCHAR VSTRING 32 0 32 PortfolDescr Portfolio Description      
PN06005 NCHAR STRING 10 0 10 StamDutyProc Stamp Duty %      
PN06006 NUMERIC X_NUMERIC 28 8 20 StaDutyMinAmnt Stamp Duty Minimum Amount      
PN06007 NVARCHAR VSTRING 2 0 2 StaDutyMinCurr Currency Code Stamp Duty Minimum Amount      
PN06008 NCHAR STRING 10 0 10 ColleFeeProc Collection Fee %      
PN06009 NUMERIC X_NUMERIC 28 8 20 CollFeeMinAm Collection Fee Minimum Amount      
PN06010 NCHAR STRING 2 0 2 CollFeeMinCur Currency Code Collection Fee Minimum Amount      
PN06011 NVARCHAR ACCSTR 50 0 50 PortfContrSt Accounting String Portfolio      
PN06012 NVARCHAR ACCSTR 50 0 50 StamDutyCoSt Accounting String Stamp Duty      
PN06013 NVARCHAR ACCSTR 50 0 50 CollFeeConSt Accounting String Collection Fee      
PN06014 NVARCHAR ACCSTR 50 0 50 ProtContrStr Accounting String Protested      
PN06015 NVARCHAR ACCSTR 50 0 50 ReseContrStr Accounting String Reserved      
PN06016 NVARCHAR ACCSTR 50 0 50 BankContrString Accounting String Bank      
PN06017 NVARCHAR ACCSTR 50 0 50 SettRateProf Accounting String Settlement Profit      
PN06018 NVARCHAR ACCSTR 50 0 50 SettRateLoss Accounting String Settlement Loss      
PN06019 NVARCHAR ACCSTR 50 0 50 RevalProfit Accounting String Revaluation Profit      
PN06020 NVARCHAR ACCSTR 50 0 50 RevalueLoss Accounting String Revaluation Loss      
PN06021 NCHAR STRING 8 0 8 UserGroup User Group      
PN06022 NCHAR STRING 10 0 10 GracePerLen Grace Period      
PN06023 NCHAR STRING 10 0 10 GracePerUnit Grace Period Unit      
PN06024 NCHAR STRING 10 0 10 AcceptPerLen Acceptance Period      
PN06025 NCHAR STRING 10 0 10 AcceptPerUni Acceptance Period Unit      
PN06026 NCHAR STRING 10 0 10 ProtestPerLn Protest Period      
PN06027 NCHAR STRING 10 0 10 ProtestPerUn Protest Period Unit      
PN06028 NCHAR STRING 10 0 10 ContingLiabLen Contingent Liability Margin Period      
PN06029 NCHAR STRING 10 0 10 ContingLiabUnit Contingent Liability Margin Period Unit      
PN06030 NCHAR STRING 10 0 10 BankCode Bank Code      
PN06031 NCHAR STRING 1 0 1 ProfLossMode Profit/Loss Mode      
PN06032 NCHAR STRING 2 0 2 PortfCurCode Currency Code Portfolio      
PN06033 NCHAR STRING 1 0 1 RevaluatMode Revaluate Mode      
PN06034 NVARCHAR VSTRING 15 0 15 SpcExRateReval Special Exchange Rate for Revaluation      
PN06035 NVARCHAR ACCSTR 50 0 50 OtherContrStr Accounting String Other      

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