На один уровень вверх / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Purchase Order»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PCT1 — PC VAT Transactions

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PCT1001 NVARCHAR VSTRING 25 0 25 OrderLineNo Order Line Number   2 Да
PCT1002 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   3 Да
PCT1003 NVARCHAR VSTRING 1 0 1 TransType Transaction Type   4 Да
PCT1004 NVARCHAR VSTRING 2 0 2 VATCode Tax Code/Tax Rate   7 Да
PCT1005 NVARCHAR VSTRING 7 0 7 LineNo Line Number   8 Да
PCT1006 DATETIME DATE 0 0 8 TransDate Transaction Date   9 Да
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 Да
PCT1020 NCHAR STRING 6 0 6 TaxType Tax Type   6 Да
PCT1021 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
PCT1022 NCHAR STRING 6 0 6 TaxCode Tax Code   5 Да
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 2 0 2 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 Да
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 AccountingInfo Accounting Info      
PCT1056 NVARCHAR VSTRING 7 0 7 LineReference Line Reference      
PCT1057 NVARCHAR VSTRING 4 0 4 FinYear Financial Year      
PCT1058 NVARCHAR VSTRING 9 0 9 RefGL06 Ref GL06      
PCT1059 NVARCHAR VSTRING 1 0 1 DirectfromGL Direct from GL      
PCT1060 NCHAR STRING 6 0 6 IssuerCode Issuer Code Issuer Code    
PCT1061 NCHAR STRING 10 0 10 OrderLineNum 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      
PCT1068 NVARCHAR VSTRING 6 0 6 OrderSubLineNo OrderSubLineNo OrderSubLineNo    
PCT1069 NUMERIC MONEY 28 8 20 ActualTaxBase Actual Tax Base      
PCT1070 NUMERIC X_NUMERIC 20 8 12 ActualTaxRate Actual Tax Rate      
PCT1071 NUMERIC X_NUMERIC 16 8 8 Destination Rate Destination Rate      
PCT1072 NCHAR STRING 2 0 2 CostType Cost Type      

Навигация: