Таблица: SL10 - «Payment Ledger». Маска имени таблицы: «SL10%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL10001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 1 | Да | |
SL10002 | NVARCHAR | VSTRING | 10 | 0 | 10 | InvoiceNo | Invoice Number | 2 | Да | |
SL10003 | NVARCHAR | VSTRING | 9 | 0 | 9 | TransactioNo | Transaction Number | |||
SL10004 | DATETIME | DATE | 0 | 0 | 8 | BEDateToPL | Book-Entry Date to SL | |||
SL10005 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
SL10006 | NUMERIC | MONEY | 28 | 8 | 20 | PaiAmoLocCur | Paid Amount (Local Currency) | |||
SL10007 | NUMERIC | MONEY | 28 | 8 | 20 | PaiAmoOriCur | Paid Amount (Payment Currency) | |||
SL10008 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code Payment | |||
SL10009 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | Accounting String | |||
SL10010 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL10011 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL10012 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SL10013 | NVARCHAR | VSTRING | 1 | 0 | 1 | PaymLedgerNo | Payment Ledger Number | |||
SL10014 | NVARCHAR | VSTRING | 15 | 0 | 15 | Remarks | Remarks | |||
SL10015 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Payment Ledger (not used)