Таблица: PL08 - «Purchase Parameters». Маска имени таблицы: «PL08%cc%yy»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL08001 NVARCHAR VSTRING 1 0 1 IndexID Index Key   1 Да
PL08002 NUMERIC X_NUMERIC 14 8 6 InterIntRate Internal Interest Rate      
PL08003 NUMERIC X_NUMERIC 9 8 1 ALvEntNewSup (obsolete)      
PL08004 NUMERIC X_NUMERIC 10 8 2 FinYrCommLedger Financial Year Common Purchase Ledger      
PL08005 NUMERIC X_NUMERIC 10 8 2 AgeingInDays Ageing in Days      
PL08006 NUMERIC X_NUMERIC 11 8 3 InfoSupQuery Information in Supplier Query      
PL08007 NUMERIC X_NUMERIC 14 8 6 WHoldTaxRate With-holding Tax Rate      
PL08008 INT INTEGER 0 0 1 CashMethoVAT Use Cash Method for VAT      
PL08009 INT INTEGER 0 0 1 CodiAutoPaym Accounting for Automatic Payments      
PL08010 INT INTEGER 0 0 1 UpdateGLPaym Update General Ledger with Journal Summary for Payments      
PL08011 INT INTEGER 0 0 1 UpdateGLInv Update General Ledger with Journal Summary for Invoice      
PL08012 INT INTEGER 0 0 1 AutoTransInv Automatic Transaction Number for Invoices      
PL08013 INT INTEGER 0 0 1 IntegratedNL Integrated with General Ledger      
PL08014 INT INTEGER 0 0 1 TrnsNoFromGL Use Transaction Numbers from General Ledger      
PL08015 INT INTEGER 0 0 1 CodPrelEntry Account for Unauthorized Invoice      
PL08016 INT INTEGER 0 0 1 SupplInvText Supplier Code + Invoice Number as Transaction Line Text      
PL08017 INT INTEGER 0 0 1 CommPurchLedger Use Common Purchase Ledger      
PL08018 INT INTEGER 0 0 1 SaveVATTrans Save VAT Transactions      
PL08019 INT INTEGER 0 0 1 DetaiPaymTrn Detailed Payment Transactions      
PL08020 INT INTEGER 0 0 1 SepTransNo Separate Transaction Number for Credit Notes      
PL08021 INT INTEGER 0 0 1 SepRefNo Separate Reference Number for Credit Notes      
PL08022 INT INTEGER 0 0 1 OverwriRefNo Allow Manual Override of Reference Number      
PL08023 INT INTEGER 0 0 1 VATSpecExRate Tax Special Exchange Rate      
PL08024 INT INTEGER 0 0 1 VATExRateDiff Account for VAT Exchange Difference      
PL08025 INT INTEGER 0 0 1 ExtPaymInfo (obsolete)      
PL08026 INT INTEGER 0 0 1 TaxPoint (obsolete)      
PL08027 INT INTEGER 0 0 1 supsw20 (obsolete)      
PL08028 INT INTEGER 0 0 1 supsw21 (obsolete)      
PL08029 INT INTEGER 0 0 1 supsw22 (obsolete)      
PL08030 INT INTEGER 0 0 1 supsw23 (obsolete)      
PL08031 INT INTEGER 0 0 1 supsw24 (obsolete)      
PL08032 NVARCHAR VSTRING 6 0 6 JournCodeInv Journal Code Invoices      
PL08033 NVARCHAR VSTRING 6 0 6 JournCodeCre Journal Code Credit Notes      
PL08034 NVARCHAR VSTRING 6 0 6 JournCodePer Journal Code Periodical Transaction      
PL08035 NVARCHAR VSTRING 6 0 6 JournCodePay Journal Code Payments      
PL08036 INT INTEGER 0 0 3 DaysPerYear Days per Year      
PL08037 NUMERIC MONEY 28 8 20 RoundOffTolerance Rounding Tolerance      
PL08038 NVARCHAR VSTRING 12 0 12 RoundOffProfitAcc Rounding Profit Account      
PL08039 NVARCHAR VSTRING 12 0 12 RoundOffLossAcc Rounding Loss Account      
PL08040 INT INTEGER 0 0 1 AccGainsLosses Accounting of Currency Gains/Losses 0 = Only recognise gains/losses when invoices are fully settled, using current value
1 = Only recognise gains/losses when invoices are fully settled, using original value
2 = Recognise gains/losses on partial payment as unrealized.
3 = Recognise gains/losses on partial payment as realized.
   
PL08041 INT INTEGER 0 0 1 TaxInfoInTransText Tax Information in Transaction Text      
PL08042 NVARCHAR VSTRING 6 0 6 DefaultTaxCode Default Tax Code      
PL08043 NVARCHAR VSTRING 50 0 50 ReportTaxCodes Report Tax Codes Report Tax Codes    
PL08044 INT INTEGER 0 0 1 RenumberSwitch Renumbering Switch      
PL08045 INT INTEGER 0 0 1 PurchaseInvoicesCurrencyDate Purchase Invoices Currency Date      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | Purchase Ledger Parameters