Таблица: PL30 - «Check Register». Маска имени таблицы: «PL30%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PL30001 | NVARCHAR | VSTRING | 15 | 0 | 15 | CheckNo | Check Number | 1 | Да | |
PL30002 | NVARCHAR | VSTRING | 25 | 0 | 25 | InvoiceNo | Invoice Number | 2 | Да | |
PL30003 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
PL30004 | NVARCHAR | VSTRING | 9 | 0 | 9 | 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 | 50 | 0 | 50 | AccountString | AccountString | bank accounting
string |
||
PL30009 | NVARCHAR | VSTRING | 15 | 0 | 15 | CommentText | Text | |||
PL30010 | NVARCHAR | VSTRING | 36 | 0 | 36 | 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 | ||
PL30017 | NCHAR | SWITCH | 1 | 0 | 1 | Voided | Voided | Voiding flag
0-Normal 1-Voided |
||
PL30018 | INT | INTEGER | 0 | 0 | 3 | InstalmentNumber | Instalment Number | 3 | Да | |
PL30019 | NVARCHAR | VSTRING | 6 | 0 | 6 | PaymentOrdNum | Payment order number | |||
PL30020 | NVARCHAR | VSTRING | 1 | 0 | 1 | Type | Type | Type | ||
PL30021 | NVARCHAR | VSTRING | 10 | 0 | 10 | BankCode | Bank Code | Bank Code | ||
PL30022 | NVARCHAR | VSTRING | 7 | 0 | 7 | ChequeNumber | Cheque Number | Cheque Number (Spain) | ||
PL30023 | NVARCHAR | VSTRING | 1 | 0 | 1 | ChequeNumberControlDigit | Cheque Number Control Digit | Cheque Number Control Digit | ||
PL30024 | DATETIME | DATE | 0 | 0 | 8 | DateEmission | Date Emission | Date Emission | ||
PL30025 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | Due Date | ||
PL30026 | NVARCHAR | VSTRING | 1 | 0 | 1 | Printed | Printed | Printed | ||
PL30027 | NVARCHAR | VSTRING | 2 | 0 | 2 | ChequeSeries | Cheque Series | Cheque Series | ||
PL30028 | NVARCHAR | VSTRING | 25 | 0 | 25 | AASCode | AAS code |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | Check Register