Таблица: 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