Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SM04 - «Service Order Invoice Customer File». Маска имени таблицы: «SM04%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM04001 | NCHAR | STRING | 10 | 0 | 10 | ServOrder | Service Order | 1 | Да | |
SM04002 | NCHAR | STRING | 10 | 0 | 10 | ICustCode | Customer Code Invoice | 2 | Да | |
SM04003 | INT | INTEGER | 0 | 0 | 1 | InvUpdStat | Invoice Status | 0 - Invoice is not ready for printing
1 - Print invoice 2 - Invoice sent 3 - On-account invoice is ready for printing 4 - On-account invoice sent (waiting to be closed) |
||
SM04004 | NCHAR | STRING | 2 | 0 | 2 | ICusPriceList | Price List | |||
SM04005 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriHrsOCU | Fixed Price Work (Order Currency) | |||
SM04006 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriCostOCU | Fixed Price Cost (Order Currency) | |||
SM04007 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriMatOCU | Fixed Price Material (Order Currency) | |||
SM04008 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriHrsICU | Fixed Price Work (Invoice Currency) | |||
SM04009 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriCostICU | Fixed Price Cost (Invoice Currency) | |||
SM04010 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriMatICU | Fixed Price Material (Invoice Currency) | |||
SM04011 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriHrsLCU | Fixed Price Work (Local Currency) | |||
SM04012 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriCostLCU | Fixed Price Cost (Local Currency) | |||
SM04013 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriMatLCU | Fixed Price Material (Local Currency) | |||
SM04014 | INT | INTEGER | 0 | 0 | 1 | InvSpecHrs | Invoice Details for Hours | 0 - The sum of work, cost and material is printed as a single total amount
1 - All activity lines are printed as a single total amount. 2 - Each activity transaction is printed on the invoice |
||
SM04015 | INT | INTEGER | 0 | 0 | 1 | InvSpecCost | Invoice Details for Cost | 1 - All cost lines are printed as a single total amount.
2 - Each cost transaction is printed on the invoice |
||
SM04016 | INT | INTEGER | 0 | 0 | 1 | InvSpecMat | Invoice Details for Material | 1 - All material lines are printed as a single total amount.
2 - Each material transaction is printed on the invoice |
||
SM04017 | NUMERIC | MONEY | 28 | 8 | 20 | HandFeeOCU | Invoice Fee (Order Currency) | |||
SM04018 | NUMERIC | MONEY | 28 | 8 | 20 | HandFeeICU | Invoice Fee (Invoice Currency) | |||
SM04019 | NUMERIC | MONEY | 28 | 8 | 20 | HandFeeLCU | Invoice Fee (Local Currency) | |||
SM04020 | NCHAR | STRING | 2 | 0 | 2 | TermOfPay | Payment Terms | |||
SM04021 | NCHAR | STRING | 1 | 0 | 1 | InvoiceMergeFlag | Invoice Merge Option | Invoice merge option:
0 - No consolidated invoice 1 - Consolidate invoice per week 2 - Consolidate invoice per month |
||
SM04022 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | ExtCommis | External Commission % | |||
SM04023 | NVARCHAR | VSTRING | 10 | 0 | 10 | ExtCommCode | External Commission Code | |||
SM04024 | NCHAR | STRING | 2 | 0 | 2 | SOAccCode | Accounting Code Service Order | |||
SM04025 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SM04026 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | |||
SM04027 | NCHAR | STRING | 1 | 0 | 1 | DocLayout | Document Layout | |||
SM04028 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvAmountOCU | On-account Amount (Order Currency) | |||
SM04029 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvAmountICU | On-account Amount (Invoice Currency) | |||
SM04030 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvAmountLCU | On-account Amount (Local Currency) | |||
SM04031 | NUMERIC | MONEY | 28 | 8 | 20 | CeilingAmountOCU | Ceiling Amount (Order Currency) | |||
SM04032 | NUMERIC | MONEY | 28 | 8 | 20 | CeilingAmountICU | Ceiling Amount (Invoice Currency) | |||
SM04033 | NUMERIC | MONEY | 28 | 8 | 20 | CeilingAmountLCU | Ceiling Amount (Local Currency) | |||
SM04034 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvPaidAmountOCU | On-account Invoice Amount (Order Currency) | |||
SM04035 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvPaidAmountICU | On-account Invoice Amount (Invoice Currency) | |||
SM04036 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvPaidAmountLCU | On-account Invoice Amount (Local Currency) | |||
SM04037 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvUsedAmountOCU | On-account Deducted Amount (Order Currency) | |||
SM04038 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvUsedAmountICU | On-account Deducted Amount (Invoice Currency) | |||
SM04039 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvUsedAmountLCU | On-account Deducted Amount (Local Currency) | |||
SM04040 | NCHAR | STRING | 6 | 0 | 6 | AdvInvoiceTaxCode | On-account VAT Code | |||
SM04041 | NCHAR | SWITCH | 1 | 0 | 1 | DeductAdvInvoice | Deduct On-account Invoice | |||
SM04042 | NCHAR | STRING | 25 | 0 | 25 | AdvInvoiceText1 | Advance Invoice Text Line 1 | |||
SM04043 | NCHAR | STRING | 25 | 0 | 25 | AdvInvoiceText2 | Advance Invoice Text Line 2 | |||
SM04044 | DATETIME | DATE | 0 | 0 | 8 | ExchngDate | Currency Exchange Date | |||
SM04045 | NCHAR | STRING | 1 | 0 | 1 | UsageFlag | Usage Flag | |||
SM04046 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvTotalAmountOCU | On-account Total Amount (Order Currency) | |||
SM04047 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvTotalAmountICU | On-account Total Amount (Invoice Currency) | |||
SM04048 | NUMERIC | MONEY | 28 | 8 | 20 | AdvInvTotalAmountLCU | On-account Total Amount (Local Currency) | |||
SM04049 | NCHAR | STRING | 2 | 0 | 2 | InvCurrencyCode | Currency Code Invoice | |||
SM04050 | NCHAR | STRING | 15 | 0 | 15 | LastInvoiceNumber | Last Invoice Number | |||
SM04051 | DATETIME | DATE | 0 | 0 | 8 | LastInvoiceDate | Last Invoice Date | |||
SM04052 | NCHAR | STRING | 15 | 0 | 15 | LastAdvInvoiceNumber | Last Advance Invoice Number | |||
SM04053 | DATETIME | DATE | 0 | 0 | 8 | LastAdvInvoiceDate | Last Advance Invoice Date | |||
SM04054 | NUMERIC | MONEY | 28 | 8 | 20 | CoveredAmountOCU | Covered Amount (Order Currency) | |||
SM04055 | NUMERIC | MONEY | 28 | 8 | 20 | CoveredAmountICU | Covered Amount (Invoice Currency) | |||
SM04056 | NUMERIC | MONEY | 28 | 8 | 20 | CoveredAmountLCU | Covered Amount (Local Currency) | |||
SM04057 | NUMERIC | MONEY | 28 | 8 | 20 | CoveredTotAmountOCU | Covered Total Amount (Order Currency) | |||
SM04058 | NUMERIC | MONEY | 28 | 8 | 20 | CoveredTotAmountICU | Covered Total Amount (Invoice Currency) | |||
SM04059 | NUMERIC | MONEY | 28 | 8 | 20 | CoveredTotAmountLCU | Covered Total Amount (Local Currency) | |||
SM04060 | INT | INTEGER | 0 | 0 | 4 | Mark_Up | Mark-up % | |||
SM04061 | NVARCHAR | VSTRING | 4 | 0 | 4 | InvIssuer | Invoice Issuer Code | |||
SM04062 | NCHAR | SWITCH | 1 | 0 | 1 | InvCategory | Invoice Category | |||
SM04063 | NCHAR | SWITCH | 1 | 0 | 1 | InvType | Invoice Type | 0 - Invoice (day to day business)
1 - Debit note 2 - Credit note |
||
SM04064 | NCHAR | STRING | 6 | 0 | 6 | TaxLiabilityCode | Tax Liability Code | |||
SM04065 | NCHAR | SWITCH | 1 | 0 | 1 | Flag Forward Cover | Flag Forward Cover | |||
SM04066 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | Forward Cover Exchange rate | Forward Cover Exchange Rate | |||
SM04067 | NVARCHAR | VSTRING | 15 | 0 | 15 | Forward Cover reference | Forward Cover Reference | |||
SM04068 | NCHAR | SWITCH | 1 | 0 | 1 | Debit Invoice Flag | NULL | |||
SM04069 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeForInvFee | Tax Code for Invoice Fee | |||
SM04070 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | FixedPriceOCU | Fixed Price OCU | |||
SM04071 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | FixedPriceICU | Fixed Price ICU | |||
SM04072 | NUMERIC | X_NUMERIC | 21 | 8 | 13 | FixedPriceLCU | Fixed Price LCU | |||
SM04073 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeForFixPrice | Tax Code for Fixed Price | |||
SM04074 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type Order | Operation Type Order | |||
SM04075 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code Order | Financial Operation Code Order | |||
SM04076 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type Time | Operation Type Time | |||
SM04077 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code Time | Financial Operation Code Time | |||
SM04078 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type Cost | Operation Type Cost | |||
SM04079 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code Cost | Financial Operation Code Cost | |||
SM04080 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type Material | Operation Type Material | |||
SM04081 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code Material | Financial Operation Code Material | |||
SM04082 | NCHAR | SWITCH | 1 | 0 | 1 | Instalment | Instalment | |||
SM04083 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Interest% | Interest% | |||
SM04084 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | New Interest% | New Interest% | |||
SM04085 | DATETIME | DATE | 0 | 0 | 8 | Activate New Interest Date | Activate New Interest Date | |||
SM04086 | NUMERIC | MONEY | 28 | 8 | 20 | Financial Charge | Financial Charge | |||
SM04087 | NCHAR | STRING | 6 | 0 | 6 | Interest Tax Code | Interest Tax Code | |||
SM04088 | NCHAR | STRING | 6 | 0 | 6 | Financial Tax Code | Financial Tax Code |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Order Invoice Customers