Таблица: PLHE - «Recharge expense amounts». Маска имени таблицы: «PLHE0000»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PLHE001 | NCHAR | STRING | 2 | 0 | 2 | OrigCompCode | Originating Company | 1 | Да | |
PLHE002 | NCHAR | STRING | 10 | 0 | 10 | Main Inv Suppl Code | Main Invoice Supplier Code | 2 | Да | |
PLHE003 | NCHAR | STRING | 15 | 0 | 15 | Main Inv Number | Main Invoice Number | 3 | Да | |
PLHE004 | NCHAR | STRING | 4 | 0 | 4 | Line Number | Line Number | 4 | Да | |
PLHE005 | NCHAR | STRING | 10 | 0 | 10 | Target Entity | Target Entity | Used for target company code | ||
PLHE006 | NCHAR | SWITCH | 1 | 0 | 1 | Updated Flag | Is Updated | |||
PLHE007 | NCHAR | SWITCH | 1 | 0 | 1 | Created Flag | Is Created | |||
PLHE008 | NUMERIC | MONEY | 28 | 8 | 20 | Expense Amount ExTax | Expense Amount (Exclusive Tax) | |||
PLHE009 | NUMERIC | MONEY | 28 | 8 | 20 | Exprense Tax Amount | Expense Tax Amount | |||
PLHE010 | INT | INTEGER | 0 | 0 | 2 | Expense Tax Code | Expense Tax Code | |||
PLHE011 | NUMERIC | MONEY | 28 | 8 | 20 | Recharge Service Fee | Recharge Service Fee | |||
PLHE012 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accounting String | Accounting String | |||
PLHE013 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accounting String2 | Accounting String 2 | |||
PLHE014 | NCHAR | STRING | 25 | 0 | 25 | Remark | Remark | |||
PLHE015 | NUMERIC | MONEY | 28 | 8 | 20 | Expense Amount InTax | 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 | Multi Entity | 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 | iScala 2.2 HF 2.3318 - 2.02.3318 | Purchase Ledger | Recharge expense amounts