One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PL08 — Purchase Ledger Parameters

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PL08001 NVARCHAR VSTRING 1 0 1 IndexID Index Key   1 Да / Yes
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      

Навигация / Navigation: