Таблица: PL30 - «Check Register». Маска имени таблицы: «PL30%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PL30001 | NVARCHAR | VSTRING | 6 | 0 | 6 | CheckNo | Check Number | 1 | Да | |
PL30002 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 2 | Да | |
PL30003 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
PL30004 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactNo | Transaction Number | |||
PL30005 | DATETIME | DATE | 0 | 0 | 8 | PaymentDate | Payment Date | |||
PL30006 | NUMERIC | MONEY | 28 | 8 | 20 | PaidAmount | Paid Amount (Invoice Currency) | |||
PL30007 | NUMERIC | MONEY | 28 | 8 | 20 | InvoiceAmount | Invoice Amount (Invoice Currency) | |||
PL30008 | NVARCHAR | VSTRING | 12 | 0 | 12 | AccountNo | Account | |||
PL30009 | NVARCHAR | VSTRING | 15 | 0 | 15 | CommentText | Text | |||
PL30010 | NVARCHAR | VSTRING | 25 | 0 | 25 | TransText | Transaction Text | |||
PL30011 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code Invoice | |||
PL30012 | NUMERIC | MONEY | 28 | 8 | 20 | DiscountAmnt | Discount Amount (Invoice Currency) | |||
PL30013 | NUMERIC | MONEY | 28 | 8 | 20 | AmountPaid | Amount Paid (Payment Currency) | |||
PL30014 | NUMERIC | MONEY | 28 | 8 | 20 | DiscountAmount | Discount Amount (Payment Currency) | |||
PL30015 | INT | INTEGER | 0 | 0 | 2 | PaymentCurrencyCode | Currency Code Payment | |||
PL30016 | NVARCHAR | VSTRING | 1 | 0 | 1 | ReconciliationFlag | Flag of Cheque Reconciliation | 0-no reconciliated (ready) 1-reconciliated |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Purchase Ledger | Check Register