Таблица: SL21 - «Sales Ledger Payments». Маска имени таблицы: «SL21%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SL21001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | 1 | Да | |
SL21002 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 2 | Да | |
SL21003 | NVARCHAR | VSTRING | 2 | 0 | 2 | LineNumber | Line Number | 3 | Да | |
SL21004 | NVARCHAR | VSTRING | 9 | 0 | 9 | TransactNo | Transaction Number | |||
SL21005 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
SL21006 | DATETIME | DATE | 0 | 0 | 8 | BookEntryDate | Book Entry Date | |||
SL21007 | NUMERIC | MONEY | 28 | 8 | 20 | AmountLocCur | Amount (Local Currency) | |||
SL21008 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOriCur | Amount (Invoice Currency) | |||
SL21009 | NVARCHAR | VSTRING | 1 | 0 | 1 | RecFlag | Receipt Document Status | 0 - Not printed
1 - Receipt printed |
||
SL21010 | NVARCHAR | VSTRING | 15 | 0 | 15 | CheckNumber | Check Number | |||
SL21011 | NVARCHAR | VSTRING | 2 | 0 | 2 | PayTransCode | Payment Transaction Code | |||
SL21012 | NVARCHAR | VSTRING | 10 | 0 | 10 | PayRemark | Payment Remark | |||
SL21013 | NUMERIC | MONEY | 28 | 8 | 20 | DiscountTaken | Discount Taken (Local Currency) | |||
SL21014 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate1 | Exchange Rate 1 | |||
SL21015 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate2 | Exchange Rate 2 | |||
SL21016 | NCHAR | STRING | 3 | 0 | 3 | ExchgAlgtm | Exchange Algorithm | |||
SL21017 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | Currency Code Invoice | |||
SL21018 | NUMERIC | MONEY | 28 | 8 | 20 | DiscountTakenICU | Discount Taken (Invoice Currency) | |||
SL21019 | NUMERIC | MONEY | 28 | 8 | 20 | PaymentCurrAmo | Amount (Payment Currency) | |||
SL21020 | NUMERIC | MONEY | 28 | 8 | 20 | DiscInPaymCurr | Discount Taken (Payment Currency) | |||
SL21021 | INT | INTEGER | 0 | 0 | 2 | PaymCurrCode | Currency Code Payment | |||
SL21022 | NUMERIC | MONEY | 28 | 8 | 20 | AmPaidPNLoc | Amount Paid by PN/PDC (Local Currency) | |||
SL21023 | NUMERIC | MONEY | 28 | 8 | 20 | AmPaidPNOrig | Amount Paid by PN/PDC (Document Currency) | |||
SL21024 | INT | INTEGER | 0 | 0 | 1 | PaymentType | Payment Type | 0=Payment
1=Revaluation 2=Withholding Tax |
||
SL21025 | NUMERIC | MONEY | 28 | 8 | 20 | RealisedGainsLosses | Realised Gains/Losses | |||
SL21026 | NUMERIC | MONEY | 28 | 8 | 20 | UnrealizedGains | Unrealized Gains | |||
SL21027 | NUMERIC | MONEY | 28 | 8 | 20 | UnrealizedLosses | Unrealized Losses | |||
SL21028 | NVARCHAR | VSTRING | 15 | 0 | 15 | ReceiptNum | Receipt number | |||
SL21029 | NVARCHAR | VSTRING | 6 | 0 | 6 | IssuerCode | Issuer code | |||
SL21030 | NVARCHAR | VSTRING | 8 | 0 | 8 | FormNumber | Form number | |||
SL21031 | INT | INTEGER | 0 | 0 | 3 | InstalmentNumber | InstalmentNumber | |||
SL21032 | INT | INTEGER | 0 | 0 | 1 | LockPaymentsInvoices | Lock Payments Invoices | 0 – Default. Payment can be matched against invoices or Sales Orders.
1 – Payment is ‘locked’ for linking to Sales Order or to matching against invoices. |
||
SL21033 | NCHAR | SWITCH | 1 | 0 | 1 | Reconciled | Reconciled |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Sales Ledger Payments