пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PCT1001 NVARCHAR VSTRING 15 0 15 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 TaxCode/TaxRate VAT Code   7 Да
PCT1005 NVARCHAR VSTRING 5 0 5 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 6 0 6 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 6 0 6 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 INT INTEGER 0 0 2 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 Да
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 5 0 5 Line Reference Line Reference      
PCT1057 NVARCHAR VSTRING 4 0 4 Financial Year Financial Year      
PCT1058 NVARCHAR VSTRING 8 0 8 Ref GL06 Ref GL06      
PCT1059 NVARCHAR VSTRING 1 0 1 Direct from GL Direct from GL      
PCT1060 NCHAR STRING 4 0 4 IssuerCode Issuer Code Issuer Code    
PCT1061 NCHAR STRING 4 0 4 SiteCode Site Code SiteCode    

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Order | PC VAT Transactions

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.