Таблица: 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      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Purchase Ledger | VAT Transactions