One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / 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 ID   1 Да / Yes
PL08002 NUMERIC X_NUMERIC 14 8 6 InterIntRate Internal Interest Rate %      
PL08003 NUMERIC X_NUMERIC 9 8 1 ALvEntNewSup Access Level Required to Enter New Suppliers      
PL08004 NUMERIC X_NUMERIC 10 8 2 FinYrCommLedger Financial Year for Common Ledger      
PL08005 NUMERIC X_NUMERIC 10 8 2 AgeingInDays Period for Ageing Analysis      
PL08006 NUMERIC X_NUMERIC 11 8 3 InfoSupQuery Info on Supplier Query      
PL08007 NUMERIC X_NUMERIC 14 8 6 WHoldTaxRate Withholding Tax Rate      
PL08008 INT INTEGER 0 0 1 CashMethoVAT Cash Method for Tax Accounting      
PL08009 INT INTEGER 0 0 1 CodiAutoPaym Accounting on Automatic Payment      
PL08010 INT INTEGER 0 0 1 UpdateGLPaym Update GL with Payments Journal Total      
PL08011 INT INTEGER 0 0 1 UpdateGLInv Update GL with Invoices Journal Total      
PL08012 INT INTEGER 0 0 1 AutoTransInv Automatic Transaction Numbers for Invoices      
PL08013 INT INTEGER 0 0 1 IntegratedNL Integrated to General Ledger      
PL08014 INT INTEGER 0 0 1 TrnsNoFromGL Use Transaction Numbers from GL      
PL08015 INT INTEGER 0 0 1 CodPrelEntry Booking of Preliminary Entry      
PL08016 INT INTEGER 0 0 1 SupplInvText Supplier + Invoice Number as Transaction Text      
PL08017 INT INTEGER 0 0 1 CommPurchLedger Common Purchase Ledger      
PL08018 INT INTEGER 0 0 1 SaveVATTrans Save Tax transactions      
PL08019 INT INTEGER 0 0 1 DetaiPaymTrn Detailed Payment Transactions      
PL08020 INT INTEGER 0 0 1 SepTransNo Separate Transaction Numbers for Credit Notes      
PL08021 INT INTEGER 0 0 1 SepRefNo Separate Reference Numbers for Credit Notes      
PL08022 INT INTEGER 0 0 1 OverwriRefNo Overwrite Reference Numbers      
PL08023 INT INTEGER 0 0 1 VATSpecExRate Special Exchange Rate for Tax      
PL08024 INT INTEGER 0 0 1 VATExRateDiff Account for Tax Exchange Rate Difference      
PL08025 INT INTEGER 0 0 1 ExtPaymInfo Extended Payment Info      
PL08026 INT INTEGER 0 0 1 TaxPoint Point for Cash Method of Tax Accounting      
PL08027 INT INTEGER 0 0 1 TransNoReverseInvoices Transaction No for Reverse Invoices      
PL08028 INT INTEGER 0 0 1 ReferNoReverseInvoices Reference No for Reverse Invoices      
PL08029 INT INTEGER 0 0 1 supsw22 Supsw22      
PL08030 INT INTEGER 0 0 1 supsw23 Supsw23      
PL08031 INT INTEGER 0 0 1 supsw24 Supsw24      
PL08032 NVARCHAR VSTRING 6 0 6 JournCodeInv Invoices Journal Code      
PL08033 NVARCHAR VSTRING 6 0 6 JournCodeCre Credit Notes Journal Code      
PL08034 NVARCHAR VSTRING 6 0 6 JournCodePer Periodical Transactions Journal Code      
PL08035 NVARCHAR VSTRING 6 0 6 JournCodePay Payments Journal Code      
PL08036 INT INTEGER 0 0 3 DaysPerYear Days per Year (Interest Calculation)      
PL08037 NUMERIC MONEY 28 8 20 RoundOffTolerance Rounding Tolerance Amount      
PL08038 NVARCHAR VSTRING 12 0 12 RoundOffProfitAcc Rounding Tolerance Profit Account      
PL08039 NVARCHAR VSTRING 12 0 12 RoundOffLossAcc Rounding Tolerance 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 Print Tax Code and Base Amount      
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 of Unauthorized Invoice Switch      
PL08045 INT INTEGER 0 0 1 PurchaseInvoicesCurrencyDate Currency Exchange Rate Date      
PL08046 NCHAR SWITCH 1 0 1 LateAssignmentOfTransactionNumber Late Assignment Of Transaction Number      
PL08047 NCHAR SWITCH 1 0 1 DefaultSuppLCStatus Default Supplier Life Cycle Status      
PL08048 NCHAR STRING 4 0 4 DefaultCentralBankCode Default Central Bank Code      

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