пользователям программных продуктов 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 :: Список таблиц модуля «Promissory Notes»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PN06 — Portfolios

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PN06001 NCHAR STRING 1 0 1 PortfoliType Portfolio Type R — Receivable
P — Payable
1 Да
PN06002 NCHAR STRING 2 0 2 PortfolioNo Portfolio Number   2 Да
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      

Навигация: