Таблица: PLHE - «Recharge expense amounts». Маска имени таблицы: «PLHE0000»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PLHE001 | NCHAR | STRING | 2 | 0 | 2 | OrigCompCode | Originating Company | 1 | Да | |
PLHE002 | NCHAR | STRING | 10 | 0 | 10 | MainInvSupplCode | Main Invoice Supplier Code | 2 | Да | |
PLHE003 | NCHAR | STRING | 25 | 0 | 25 | MainInvNumber | Main Invoice Number | 3 | Да | |
PLHE004 | NCHAR | STRING | 4 | 0 | 4 | LineNumber | Line Number | 4 | Да | |
PLHE005 | NCHAR | STRING | 10 | 0 | 10 | TargetEntity | Target Entity | Used for target company code | ||
PLHE006 | NCHAR | SWITCH | 1 | 0 | 1 | UpdatedFlag | Is Updated | |||
PLHE007 | NCHAR | SWITCH | 1 | 0 | 1 | CreatedFlag | Is Created | |||
PLHE008 | NUMERIC | MONEY | 28 | 8 | 20 | ExpenseAmountExTax | Expense Amount (Exclusive Tax) | |||
PLHE009 | NUMERIC | MONEY | 28 | 8 | 20 | ExprenseTaxAmount | Expense Tax Amount | |||
PLHE010 | INT | INTEGER | 0 | 0 | 2 | ExpenseTaxCode | Expense Tax Code | |||
PLHE011 | NUMERIC | MONEY | 28 | 8 | 20 | RechargeServiceFee | Recharge Service Fee | |||
PLHE012 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
PLHE013 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccountingString2 | Accounting String 2 | |||
PLHE014 | NCHAR | STRING | 25 | 0 | 25 | Remark | Remark | |||
PLHE015 | NUMERIC | MONEY | 28 | 8 | 20 | ExpenseAmountInTax | Expense Amount (Including Tax) | |||
PLHE016 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | (obsolete) | |||
PLHE017 | NCHAR | STRING | 2 | 0 | 2 | CurrencyCode | Currency Code | |||
PLHE018 | NCHAR | STRING | 20 | 0 | 20 | Spare | (obsolete) | |||
PLHE019 | NCHAR | STRING | 1 | 0 | 1 | MultiEntity | Multi Entity | |||
PLHE020 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PLHE021 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PLHE022 | NCHAR | STRING | 10 | 0 | 10 | Spare | (obsolete) | |||
PLHE023 | NCHAR | STRING | 10 | 0 | 10 | Spare | (obsolete) |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | Recharge expense amounts