Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PL56 - «Imported Executed Supplier Payments». Маска имени таблицы: «PL56%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PL56001 | NCHAR | STRING | 10 | 0 | 10 | Supplier Code | Supplier Code | Supplier Code | ||
PL56002 | NCHAR | STRING | 15 | 0 | 15 | Invoice Number | Invoice Number | Invoice Number | ||
PL56003 | NCHAR | STRING | 10 | 0 | 10 | Payment ID | Payment ID | Payment ID | 1 | Да |
PL56004 | NCHAR | STRING | 8 | 0 | 8 | Received Payment Date | Received Payment Date | Received Payment Date | ||
PL56005 | NCHAR | STRING | 8 | 0 | 8 | Executed Payment Date | Executed Payment Date | Executed Payment Date | ||
PL56006 | NCHAR | STRING | 10 | 0 | 10 | Supplier's account | Supplier's account | Supplier's account | ||
PL56007 | NCHAR | STRING | 25 | 0 | 25 | Reference | Reference | Reference | ||
PL56008 | NUMERIC | MONEY | 28 | 8 | 20 | Amount | Amount | Amount | ||
PL56009 | INT | INTEGER | 0 | 0 | 2 | Source of Import | Source of Import | Source of Import | ||
PL56010 | NCHAR | STRING | 3 | 0 | 3 | Currency Code | Currency Code | Currency Code | ||
PL56011 | INT | INTEGER | 0 | 0 | 1 | Status | Status | Status | ||
PL56012 | INT | INTEGER | 0 | 0 | 1 | Blocked for reconciliation | Blocked for reconciliation | Blocked for reconciliation |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Ledger | Swedish BankGiro, PlusGiro services