Таблица: PN06 - «PN06 Portfolios». Маска имени таблицы: «PN06%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Promissory Notes | Portfolios