Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: PL04 - «Invoice Journal» («Журнал Счетов-Фактур»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PL04001 | NUMBER | 8 | Reccounter | |
| PL04002 | STRING | 6 | Transactno | Да |
| PL04003 | STRING | 5 | Linenumber | Да |
| PL04004 | DATE | 8 | TranDate | |
| PL04005 | SWITCH | 1 | Flag | |
| PL04006 | ACCSTR | 50 | Accstring | |
| PL04007 | MONEY | 20 | Amountlcu | |
| PL04008 | INTEGER | 2 | Currcode | |
| PL04009 | ACCSTR | 50 | Accstringocu | |
| PL04010 | MONEY | 20 | Amountocu | |
| PL04011 | VSTRING | 25 | Trantext | |
| PL04012 | STRING | 10 | Code1 | |
| PL04013 | VSTRING | 23 | Code2 | |
| PL04014 | STRING | 6 | Code3 | |
| PL04015 | STRING | 2 | code4 | |
| PL04016 | VSTRING | 35 | Code5 | |
| PL04017 | STRING | 8 | Code6 | |
| PL04018 | STRING | 1 | Tag1 | |
| PL04019 | STRING | 1 | Tag2 | |
| PL04020 | STRING | 1 | Tag3 | |
| PL04021 | STRING | 1 | Tranlinetype | |
| PL04022 | STRING | 1 | Tranlinesign | |
| PL04023 | NUMBER | 1 | Noofdecimals | |
| PL04024 | STRING | 5 | Linkcode | |
| PL04025 | X_NUMERIC | 20 | Quantity | |
| PL04026 | STRING | 2 | Unitcode | |
| PL04027 | MONEY | 20 | Amountccu | |
| PL04028 | STRING | 13 | Contraacc | |
| PL04029 | NUMBER | 6 | Journalno | |
| PL04030 | STRING | 6 | Plreference | |
| PL04031 | STRING | 6 | Subprjcode | |
| PL04032 | STRING | 6 | Activitycode | |
| PL04033 | STRING | 8 | Usridentby | |
| PL04034 | DATE | 8 | Dateofentry | |
| PL04035 | STRING | 8 | Usridupdby | |
| PL04036 | DATE | 8 | Dateofupd | |
| PL04037 | VSTRING | 25 | Trantext |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Purchase Ledger (Книга Закупок) | Invoice Journal (Журнал Счетов-Фактур)
/* */