Таблица: PL56 - «Imported Executed Supplier Payments». Маска имени таблицы: «PL56%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PL56001 | NCHAR | STRING | 10 | 0 | 10 | SupplierCode | Supplier Code | Supplier Code | ||
PL56002 | NCHAR | STRING | 25 | 0 | 25 | InvoiceNumber | Invoice Number | Invoice Number | ||
PL56003 | NCHAR | STRING | 10 | 0 | 10 | PaymentID | Payment ID | Payment ID | 1 | Да |
PL56004 | NCHAR | STRING | 8 | 0 | 8 | ReceivedPaymentDate | Received Payment Date | Received Payment Date | ||
PL56005 | NCHAR | STRING | 8 | 0 | 8 | ExecutedPaymentDate | Executed Payment Date | Executed Payment Date | ||
PL56006 | NCHAR | STRING | 10 | 0 | 10 | SuppAccount | 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 | SourceOfImport | Source of Import | Source of Import | ||
PL56010 | NCHAR | STRING | 3 | 0 | 3 | CurrencyCode | Currency Code | Currency Code | ||
PL56011 | INT | INTEGER | 0 | 0 | 1 | Status | Status | Status | ||
PL56012 | INT | INTEGER | 0 | 0 | 1 | BlockForReconciliation | Blocked for reconciliation | Blocked for reconciliation |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | Swedish BankGiro, PlusGiro services