Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: PN04 - «PN04 Transactions». Маска имени таблицы: «PN04%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PN04001 | NCHAR | STRING | 2 | 0 | 2 | JournalCode | Journal Type | SL - Sales Ledger Transaction
PL - Purchase Ledger Transaction GL - General Ledger Transaction NO - Internal Promissory Note Transaction |
1 | Да |
PN04002 | NCHAR | STRING | 9 | 0 | 9 | TransactNumb | Transaction Number | 2 | Да | |
PN04003 | NCHAR | STRING | 3 | 0 | 3 | TransactLine | Transaction Line Number | 3 | Да | |
PN04004 | NCHAR | STRING | 2 | 0 | 2 | OperatioCode | Operation Code | |||
PN04005 | NCHAR | STRING | 6 | 0 | 6 | PNPDCInterNumb | PN/PDC Internal Number | |||
PN04006 | DATETIME | DATE | 0 | 0 | 8 | BEDate | Book-Entry Date | |||
PN04007 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
PN04008 | NCHAR | STRING | 2 | 0 | 2 | SourceStatus | Source Status | |||
PN04009 | NCHAR | STRING | 2 | 0 | 2 | PortfolioNo | Portfolio Number | |||
PN04010 | NVARCHAR | ACCSTR | 50 | 0 | 50 | ControlString | Accounting String | |||
PN04011 | NCHAR | STRING | 12 | 0 | 12 | LinkedAccount | Linked Account | |||
PN04012 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | LocalCurAmnt | Amount (Local Currency) | |||
PN04013 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | ForeiCurAmnt | Amount (Document Currency) | |||
PN04014 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code | |||
PN04015 | NCHAR | STRING | 1 | 0 | 1 | Printed | Printed | |||
PN04016 | NCHAR | STRING | 2 | 0 | 2 | TargetStatus | Target Status | |||
PN04017 | NCHAR | STRING | 1 | 0 | 1 | PartnTypeOut | Partner Type (Out) | |||
PN04018 | NCHAR | STRING | 10 | 0 | 10 | PartnCodeOut | Partner Code (Out) | |||
PN04019 | NCHAR | STRING | 1 | 0 | 1 | PartnTypeIn | Partner Type (In) | |||
PN04020 | NCHAR | STRING | 10 | 0 | 10 | PartnCodeIn | Partner Code (In) | |||
PN04021 | NCHAR | STRING | 10 | 0 | 10 | DrawBankCode | Drawee/Bank Code | |||
PN04022 | NCHAR | STRING | 1 | 0 | 1 | DraweeType | Drawee Type | |||
PN04023 | NCHAR | STRING | 2 | 0 | 2 | NoteCheqType | Document Type | |||
PN04024 | NCHAR | STRING | 1 | 0 | 1 | PortfoliType | Portfolio Type | |||
PN04025 | DATETIME | DATE | 0 | 0 | 8 | SavedDueDate | Saved Due Date |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Promissory Notes | Promissory Notes Transactions