Таблица: PLHD - «Recharge Invoice Tax amount». Маска имени таблицы: «PLHD0000»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PLHD001 | NCHAR | STRING | 2 | 0 | 2 | OrigCompCode | Originating Company | 1 | Да | |
PLHD002 | NCHAR | STRING | 10 | 0 | 10 | MainInvSupplCode | Main Invoice Supplier Code | 2 | Да | |
PLHD003 | NCHAR | STRING | 25 | 0 | 25 | MainInvNumber | Main Invoice Number | 3 | Да | |
PLHD004 | NCHAR | STRING | 10 | 0 | 10 | TargetEntity | Target Entity | 4 | Да | |
PLHD005 | NCHAR | STRING | 1 | 0 | 1 | TaxLine | Tax Line 0-9,S | Either a line number from 0 to 9 for each tax transaction line or 'S' for the service fee. | 5 | Да |
PLHD006 | NCHAR | SWITCH | 1 | 0 | 1 | UpdatedFlag | Is Updated | |||
PLHD007 | NCHAR | SWITCH | 1 | 0 | 1 | CreatedFlag | Is Created | |||
PLHD008 | NCHAR | STRING | 2 | 0 | 2 | TargetCompanyTaxCd | Target Company VAT Code | |||
PLHD009 | NCHAR | SWITCH | 1 | 0 | 1 | MultiEntity | Multi Entity | |||
PLHD010 | NCHAR | STRING | 2 | 0 | 2 | TaxCode | VAT Code | |||
PLHD011 | NUMERIC | MONEY | 28 | 8 | 20 | TaxBaseAmount | Tax Base Amount | |||
PLHD012 | NUMERIC | MONEY | 28 | 8 | 20 | TaxAmount | Tax Amount | |||
PLHD013 | NUMERIC | MONEY | 28 | 8 | 20 | NonDeductTaxAmnt | Non-deductible Tax Amount | |||
PLHD014 | NUMERIC | MONEY | 28 | 8 | 20 | DeductAmnt | Deductible Amount | |||
PLHD015 | NUMERIC | MONEY | 28 | 8 | 20 | BookedCostAmnt | Booked Cost Amount | |||
PLHD016 | NUMERIC | MONEY | 28 | 8 | 20 | VATDiffAmnt | VAT Difference Amount | |||
PLHD017 | NCHAR | SWITCH | 1 | 0 | 1 | Flag1 | Flag 1 | |||
PLHD018 | NCHAR | SWITCH | 1 | 0 | 1 | Flag2 | Flag 2 | |||
PLHD019 | NUMERIC | MONEY | 28 | 8 | 20 | Amount1 | Amount 1 | |||
PLHD020 | NUMERIC | MONEY | 28 | 8 | 20 | Amount2 | Amount 2 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | Recharge Invoice Tax amount