Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: 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