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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL08001 NVARCHAR VSTRING 1 0 1 Index_ID 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 10 8 2 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 sup_sw_20 (obsolete)      
PL08028 INT INTEGER 0 0 1 sup_sw_21 (obsolete)      
PL08029 INT INTEGER 0 0 1 sup_sw_22 (obsolete)      
PL08030 INT INTEGER 0 0 1 sup_sw_23 (obsolete)      
PL08031 INT INTEGER 0 0 1 sup_sw_24 (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    

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Ledger | Purchase Ledger Parameters