Таблица | Table: PCT1 - «PC VAT Transactions». Маска имени таблицы | Table Name Mask: «PCT1%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
PCT1001 NVARCHAR VSTRING 15 0 15 OrderLineNo Order Line Number   2 Да / Yes
PCT1002 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   3 Да / Yes
PCT1003 NVARCHAR VSTRING 1 0 1 TransType Transaction Type   4 Да / Yes
PCT1004 NVARCHAR VSTRING 2 0 2 TaxCode/TaxRate VAT Code   7 Да / Yes
PCT1005 NVARCHAR VSTRING 7 0 7 LineNo Line Number   8 Да / Yes
PCT1006 DATETIME DATE 0 0 8 TransDate Transaction Date   9 Да / Yes
PCT1007 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
PCT1008 NUMERIC MONEY 28 8 20 BaseAmountLCU Base Amount LCU      
PCT1009 NUMERIC MONEY 28 8 20 TaxAmountLCU Tax Amount LCU      
PCT1010 NVARCHAR VSTRING 4 0 4 Remark Remark      
PCT1011 NVARCHAR VSTRING 9 0 9 RefNo Invoice Reference Number      
PCT1012 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method      
PCT1013 NVARCHAR VSTRING 6 0 6 Deductable Deductable      
PCT1014 NVARCHAR VSTRING 1 0 1 ExpandedMacro Expanded Macro      
PCT1015 NVARCHAR VSTRING 1 0 1 Reported Reported      
PCT1016 NUMERIC MONEY 28 8 20 DeductibleAm Deductible Amount      
PCT1017 NUMERIC MONEY 28 8 20 BookedCostAmount Booked Cost Amount      
PCT1018 NUMERIC MONEY 28 8 20 VATDiffAmount VAT Difference Amount      
PCT1019 NVARCHAR VSTRING 9 0 9 TransactionNo Transaction Number   10 Да / Yes
PCT1020 NCHAR STRING 6 0 6 TaxType Tax Type   6 Да / Yes
PCT1021 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
PCT1022 NCHAR STRING 6 0 6 TaxCode Tax Code   5 Да / Yes
PCT1023 NCHAR STRING 3 0 3 DocumentType Document Type      
PCT1024 NCHAR STRING 2 0 2 TaxClassification Tax Classification      
PCT1025 NVARCHAR VSTRING 15 0 15 TaxCertificate Tax Certificate      
PCT1026 NCHAR STRING 1 0 1 TaxCertifFlag Tax Certificate Print Status      
PCT1027 NCHAR STRING 2 0 2 PaymentNumber Payment Number      
PCT1028 NCHAR STRING 2 0 2 PaymentSubNumber Payment Sub Number      
PCT1029 NVARCHAR VSTRING 35 0 35 StockItem Stock Item Code      
PCT1030 NVARCHAR VSTRING 12 0 12 OrigBatchNumber Original Batch Number      
PCT1031 NUMERIC X_NUMERIC 20 8 12 TaxRate Tax Rate      
PCT1032 INT INTEGER 0 0 2 TaxCalcMethod Tax Calculation Method      
PCT1033 NCHAR STRING 1 0 1 RateType Rate Type      
PCT1034 INT INTEGER 0 0 2 TaxBaseType Tax Base Type      
PCT1035 NCHAR STRING 1 0 1 TaxExemption Tax Exemption      
PCT1036 NUMERIC X_NUMERIC 20 8 12 TaxExemptionRate Tax Exemption Rate      
PCT1037 NVARCHAR VSTRING 10 0 10 PurchOrderNo Purch Order Number   1 Да / Yes
PCT1038 NVARCHAR VSTRING 10 0 10 FiscTextCode Fiscal Text Code      
PCT1039 NVARCHAR VSTRING 10 0 10 TributarySitCode Tributary Situation Code      
PCT1040 NVARCHAR VSTRING 10 0 10 CVFCode CVF Code      
PCT1041 NUMERIC MONEY 28 8 20 STBaseAmountLCU ST Base Amount LCU      
PCT1042 NUMERIC MONEY 28 8 20 STTaxAmountLCU Tributary Substitution Amount LCU      
PCT1043 NVARCHAR VSTRING 10 0 10 TaxCategory Tax Category      
PCT1044 NVARCHAR VSTRING 2 0 2 OriginalCompany Original Company      
PCT1045 NUMERIC X_NUMERIC 20 8 12 MarginPercent Margin Percent      
PCT1046 NUMERIC MONEY 28 8 20 FixedPrice Fixed Price LCU      
PCT1047 NUMERIC X_NUMERIC 20 8 12 AcceptedDifference Accepted Difference      
PCT1048 NVARCHAR VSTRING 40 0 40 ResolutionName Resolution Name      
PCT1049 DATETIME DATE 0 0 8 ResolutionDate Resolution Date      
PCT1050 NVARCHAR VSTRING 15 0 15 InvoiceRefer InvoiceRefer      
PCT1051 NVARCHAR VSTRING 2 0 2 OrigCurrCode Original Currency Code This field should contain the original currency code.    
PCT1052 NUMERIC MONEY 28 8 20 BaseAmountOCU Base Amount (Original Currency) This field should contain the tax base amount in original currency.    
PCT1053 NVARCHAR VSTRING 15 0 15 TaxSlipNo Tax Slip No This field should contain the purchase tax slip number.    
PCT1054 NVARCHAR VSTRING 6 0 6 TaxSlipLine Tax Slip Line This field should contain the purchase tax slip line.    
PCT1055 NVARCHAR VSTRING 50 0 50 Accounting Info Accounting Info      
PCT1056 NVARCHAR VSTRING 7 0 7 Line Reference Line Reference      
PCT1057 NVARCHAR VSTRING 4 0 4 Financial Year Financial Year      
PCT1058 NVARCHAR VSTRING 9 0 9 Ref GL06 Ref GL06      
PCT1059 NVARCHAR VSTRING 1 0 1 Direct from GL Direct from GL      
PCT1060 NCHAR STRING 6 0 6 IssuerCode Issuer Code Issuer Code    
PCT1061 NCHAR STRING 10 0 10 OrderLineNo Order Line Number Order Line Number    
PCT1062 NVARCHAR VSTRING 25 0 25 AAScode AAS code      
PCT1063 NVARCHAR VSTRING 10 0 10 ThirdPartySupplier ThirdPartySupplier ThirdPartySupplier    
PCT1064 NUMERIC MONEY 28 8 20 ProRataAmount ProRataAmount Italian functionality to story VAT deductible    
PCT1065 NVARCHAR VSTRING 15 0 15 ReferSLInvoice Reference to SL Invoice      
PCT1066 DATETIME DATE 0 0 8 CertificateDate Certificate Date      
PCT1067 NUMERIC MONEY 28 8 20 NonDeductAm Non Deductible Amount      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | PC VAT Transactions