Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PN08 - «PN08 Operations». Маска имени таблицы: «PN08%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PN08001 | NCHAR | STRING | 2 | 0 | 2 | TransactCode | Transaction Code | 1 | Да | |
PN08002 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransactName | Transaction Name | |||
PN08003 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransactDes1 | Transaction Description Line 1 | |||
PN08004 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransactDes2 | Transaction Description Line 2 | |||
PN08005 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransactText | Transaction Text | |||
PN08006 | NCHAR | STRING | 2 | 0 | 2 | InitialStat1 | Initial Status 1 | |||
PN08007 | NCHAR | STRING | 2 | 0 | 2 | InitialStat2 | Initial Status 2 | |||
PN08008 | NCHAR | STRING | 2 | 0 | 2 | InitialStat3 | Initial Status 3 | |||
PN08009 | NCHAR | STRING | 2 | 0 | 2 | Final_Status | Final Status | |||
PN08010 | NCHAR | STRING | 7 | 0 | 7 | PortfContAcc | Portfolio Account Fraction | |||
PN08011 | NCHAR | STRING | 7 | 0 | 7 | StampDutyAccount | Stamp Duty Account Fraction | |||
PN08012 | NCHAR | STRING | 7 | 0 | 7 | CollecFeeAcc | Collection Fee Account Fraction | |||
PN08013 | NCHAR | STRING | 7 | 0 | 7 | DepositAccnt | Deposit Account Fraction | |||
PN08014 | NCHAR | STRING | 7 | 0 | 7 | ProtestAccnt | Protest Account Fraction | |||
PN08015 | NCHAR | STRING | 7 | 0 | 7 | BankAccount | Bank Account Fraction | |||
PN08016 | NCHAR | STRING | 1 | 0 | 1 | SetExRatProf | Settlement Exchange Rate Profit | |||
PN08017 | NCHAR | STRING | 1 | 0 | 1 | SetExRatLoss | Settlement Exchange Rate Loss | |||
PN08018 | NCHAR | STRING | 12 | 0 | 12 | OtherAccNo | Other Account Number | |||
PN08019 | NCHAR | STRING | 7 | 0 | 7 | OtherAccount | Other Account Fraction | |||
PN08020 | NCHAR | STRING | 1 | 0 | 1 | InpuOutpSign | Input/Output Sign | 0 - Internal
1 - Input 2 - Output |
||
PN08021 | NCHAR | STRING | 1 | 0 | 1 | SettlmntFlag | Settlement PN/PDC | |||
PN08022 | NCHAR | STRING | 1 | 0 | 1 | Type | Type | 0 - Undefined
1 - Reception 2 - Collection 3 - Return from supplier 4 - Protest 5 - Internal portfolio 6 - Returned to customer with reversal of payment 7 - Lost note 8 - Jumped note 9 - Returned from supplier with reversal of payment |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Promissory Notes | Operations