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

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Service Order Management | Service Order Invoice Customers