Таблица: PL17 - «VAT Transactions». Маска имени таблицы: «PL17%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL17001 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   1 Да
PL17002 NVARCHAR VSTRING 10 0 10 CustomerCode Supplier Code   2 Да
PL17003 NVARCHAR VSTRING 1 0 1 TransType Transaction Type X - Tax transaction created at the time of invoice (To be used for non cash tax method).
Y - Tax transaction created at the time of payment. (To be used for cash tax method).
Z - Tax transaction for tax portion of discount for early payments.
(Note that both X and Y transaction type are created regardless if you use cash method or not).
3 Да
PL17004 NVARCHAR VSTRING 2 0 2 TaxCode/TaxRate VAT Code   6 Да
PL17005 NVARCHAR VSTRING 5 0 5 LineNo Line Number   7 Да
PL17006 DATETIME DATE 0 0 8 TransDate Transaction Date   8 Да
PL17007 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
PL17008 NUMERIC MONEY 28 8 20 BaseAmount Base Amount (Local Currency)      
PL17009 NUMERIC MONEY 28 8 20 TaxAmount Tax Amount (Local Currency)      
PL17010 NVARCHAR VSTRING 4 0 4 Remark Remark      
PL17011 NVARCHAR VSTRING 6 0 6 TransNo Invoice Reference Number      
PL17012 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method      
PL17013 NVARCHAR VSTRING 6 0 6 Deductable Deductible      
PL17014 NVARCHAR VSTRING 1 0 1 ExpandedMacro Expanded Macro      
PL17015 NVARCHAR VSTRING 1 0 1 Reported Reported      
PL17016 NUMERIC MONEY 28 8 20 DeductibleAm Deductible Amount      
PL17017 NUMERIC MONEY 28 8 20 BookedCostAmount Booked Cost Amount      
PL17018 NUMERIC MONEY 28 8 20 VATDiffAmount VAT Difference Amount      
PL17019 NVARCHAR VSTRING 6 0 6 TransactionNo/LineNo Transaction Number   9 Да
PL17020 NCHAR STRING 6 0 6 TaxType Tax Type   5 Да
PL17021 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
PL17022 NCHAR STRING 6 0 6 TaxCode Tax Code   4 Да
PL17023 INT INTEGER 0 0 2 DocumentType Document Type      
PL17024 NCHAR STRING 2 0 2 TaxClassification Tax Classification      
PL17025 NVARCHAR VSTRING 15 0 15 TaxCertificate Tax Certificate      
PL17026 NCHAR STRING 1 0 1 TaxCertifFlag Tax Certificate Print Status      
PL17027 NCHAR STRING 2 0 2 PaymentNumber Payment Number      
PL17028 NCHAR STRING 2 0 2 PaymentSubNumber Payment Sub Number      
PL17029 NVARCHAR VSTRING 35 0 35 StockItem Stock Item Code      
PL17030 NVARCHAR VSTRING 12 0 12 OrigBatchNumber Batch Number      
PL17031 NUMERIC X_NUMERIC 20 8 12 TaxRate Tax Rate      
PL17032 INT INTEGER 0 0 2 TaxCalcMethod Tax Calculation Method Used for tax engine 1 and 2 (see SYL1003 for details)    
PL17033 NCHAR STRING 1 0 1 RateType Rate Type Used for tax engine 1 and 2 (see SYL1006 for details)    
PL17034 INT INTEGER 0 0 2 TaxBaseType Tax Base Type Used for tax engine 1 and 2 (see SYL1004 for details)    
PL17035 NCHAR STRING 1 0 1 TaxExemption Tax Exemption Used for tax engine 1 and 2 (see PLL1006 for details)    
PL17036 NUMERIC X_NUMERIC 20 8 12 TaxExemptionRate Tax Exemption Rate      
PL17037 NVARCHAR VSTRING 10 0 10 PurchOrderNo Purchase Order Number      
PL17038 NVARCHAR VSTRING 10 0 10 FiscTextCode Fiscal Text Code      
PL17039 NVARCHAR VSTRING 10 0 10 TributarySitCode Tributary Situation Code      
PL17040 NVARCHAR VSTRING 10 0 10 CVFCode CVF Code      
PL17041 NUMERIC MONEY 28 8 20 STBaseAmount Exemption Amount (Local Currency)      
PL17042 NUMERIC MONEY 28 8 20 STTaxAmount Tributary Substitution Amount (Local Currency)      
PL17043 NVARCHAR VSTRING 10 0 10 TaxCategory Tax Category      
PL17044 NVARCHAR VSTRING 2 0 2 OriginalCompany Original Company      
PL17045 NUMERIC X_NUMERIC 20 8 12 MarginPercent Margin %      
PL17046 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price (Local Currency)      
PL17047 NUMERIC X_NUMERIC 20 8 12 AcceptedDifference Accepted Difference %      
PL17048 NVARCHAR VSTRING 40 0 40 ResolutionName Resolution Name      
PL17049 DATETIME DATE 0 0 8 ResolutionDate Resolution Date      
PL17050 NVARCHAR VSTRING 15 0 15 InvoiceRefer InvoiceRefer This field can be filled in the records related to the Prepayments.
The reference to Invoice for the same customer code must be added for all ?compensative? prepayment tax records.
   

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Ledger | VAT Transactions