Таблица | Table: PLHE - «Recharge expense amounts». Маска имени таблицы | Table Name Mask: «PLHE0000»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
PLHE001 NCHAR STRING 2 0 2 OrigCompCode Originating Company   1 Да / Yes
PLHE002 NCHAR STRING 10 0 10 Main Inv Suppl Code Main Invoice Supplier Code   2 Да / Yes
PLHE003 NCHAR STRING 15 0 15 Main Inv Number Main Invoice Number   3 Да / Yes
PLHE004 NCHAR STRING 4 0 4 Line Number Line Number   4 Да / Yes
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)      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Ledger | Recharge expense amounts