Таблица | Table: SM48 - «Service Order Invoice Customer File History». Маска имени таблицы | Table Name Mask: «SM48%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SM48001 NCHAR STRING 10 0 10 ServOrder Service Order   1 Да / Yes
SM48002 NCHAR STRING 10 0 10 ICustCode Customer Code Invoice   2 Да / Yes
SM48003 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)		    
SM48004 NCHAR STRING 2 0 2 ICusPriceList Price List      
SM48005 NUMERIC MONEY 28 8 20 FixPriHrsOCU Fixed Price Work (Order Currency)      
SM48006 NUMERIC MONEY 28 8 20 FixPriCostOCU Fixed Price Cost (Order Currency)      
SM48007 NUMERIC MONEY 28 8 20 FixPriMatOCU Fixed Price Material (Order Currency)      
SM48008 NUMERIC MONEY 28 8 20 FixPriHrsICU Fixed Price Work (Invoice Currency)      
SM48009 NUMERIC MONEY 28 8 20 FixPriCostICU Fixed Price Cost (Invoice Currency)      
SM48010 NUMERIC MONEY 28 8 20 FixPriMatICU Fixed Price Material (Invoice Currency)      
SM48011 NUMERIC MONEY 28 8 20 FixPriHrsLCU Fixed Price Work (Local Currency)      
SM48012 NUMERIC MONEY 28 8 20 FixPriCostLCU Fixed Price Cost (Local Currency)      
SM48013 NUMERIC MONEY 28 8 20 FixPriMatLCU Fixed Price Material (Local Currency)      
SM48014 INT INTEGER 0 0 1 InvSpecHrs Invoice Specification Work 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		    
SM48015 INT INTEGER 0 0 1 InvSpecCost Invoice Specification Cost 1 - All cost lines are printed as a single total amount.
2 - Each cost transaction is printed on the invoice		    
SM48016 INT INTEGER 0 0 1 InvSpecMat Invoice Specification Material 1 - All material lines are printed as a single total amount.
2 - Each material transaction is printed on the invoice		    
SM48017 NUMERIC MONEY 28 8 20 HandFeeOCU Invoice Fee (Order Currency)      
SM48018 NUMERIC MONEY 28 8 20 HandFeeICU Invoice Fee (Invoice Currency)      
SM48019 NUMERIC MONEY 28 8 20 HandFeeLCU Invoice Fee (Local Currency)      
SM48020 NCHAR STRING 2 0 2 TermOfPay Payment Terms      
SM48021 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		    
SM48022 NUMERIC X_NUMERIC 15 8 7 ExtCommis External Commission %      
SM48023 NVARCHAR VSTRING 10 0 10 ExtCommCode External Commission Code      
SM48024 NCHAR STRING 2 0 2 SOAccCode Accounting Code Service Order      
SM48025 NVARCHAR ACCSTR 50 0 50 AccString Accounting String      
SM48026 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
SM48027 NCHAR STRING 1 0 1 DocLayout Document Layout      
SM48028 NUMERIC MONEY 28 8 20 AdvInvoiceAmountOCU On-account Amount (Order Currency)      
SM48029 NUMERIC MONEY 28 8 20 AdvInvoiceAmountICU On-account Amount (Invoice Currency)      
SM48030 NUMERIC MONEY 28 8 20 AdvInvoiceAmountLCU On-account Amount (Local Currency)      
SM48031 NUMERIC MONEY 28 8 20 CeilingAmountOCU Ceiling Amount (Order Currency)      
SM48032 NUMERIC MONEY 28 8 20 CeilingAmountICU Ceiling Amount (Invoice Currency)      
SM48033 NUMERIC MONEY 28 8 20 CeilingAmountLCU Ceiling Amount (Local Currency)      
SM48034 NUMERIC MONEY 28 8 20 AdvInvPaidAmountOCU On-account Invoice Amount (Order Currency)      
SM48035 NUMERIC MONEY 28 8 20 AdvInvPaidAmountICU On-account Invoice Amount (Invoice Currency)      
SM48036 NUMERIC MONEY 28 8 20 AdvInvPaidAmountLCU On-account Invoice Amount (Local Currency)      
SM48037 NUMERIC MONEY 28 8 20 AdvInvUsedAmountOCU On-account Deducted Amount (Order Currency)      
SM48038 NUMERIC MONEY 28 8 20 AdvInvUsedAmountICU On-account Deducted Amount (Invoice Currency)      
SM48039 NUMERIC MONEY 28 8 20 AdvInvUsedAmountLCU On-account Deducted Amount (Local Currency)      
SM48040 NCHAR STRING 6 0 6 AdvInvoiceTaxCode On-account VAT Code      
SM48041 NCHAR SWITCH 1 0 1 DeductAdvInvoice Deduct On-account Invoice      
SM48042 NCHAR STRING 25 0 25 AdvInvoiceText1 Advance Invoice Text Line 1      
SM48043 NCHAR STRING 25 0 25 AdvInvoiceText2 Advance Invoice Text Line 2      
SM48044 DATETIME DATE 0 0 8 ExchngDate Currency Exchange Date      
SM48045 NCHAR STRING 1 0 1 UsageFlag Usage Flag      
SM48046 NUMERIC MONEY 28 8 20 AdvInvTotalAmountOCU On-account Total Amount (Order Currency)      
SM48047 NUMERIC MONEY 28 8 20 AdvInvTotalAmountICU On-account Total Amount (Invoice Currency)      
SM48048 NUMERIC MONEY 28 8 20 AdvInvTotalAmountLCU On-account Total Amount (Local Currency)      
SM48049 NCHAR STRING 2 0 2 InvCurrencyCode Currency Code Invoice      
SM48050 NCHAR STRING 15 0 15 LastInvoiceNumber Invoice Number   3 Да / Yes
SM48051 DATETIME DATE 0 0 8 LastInvoiceDate Invoice Date      
SM48052 NCHAR STRING 15 0 15 LastAdvInvoiceNumber Last Advance Invoice Number      
SM48053 DATETIME DATE 0 0 8 LastAdvInvoiceDate Last Advance Invoice Date      
SM48054 NUMERIC MONEY 28 8 20 CoveredAmountOCU Covered Amount (Order Currency)      
SM48055 NUMERIC MONEY 28 8 20 CoveredAmountICU Covered Amount (Invoice Currency)      
SM48056 NUMERIC MONEY 28 8 20 CoveredAmountLCU Covered Amount (Local Currency)      
SM48057 NUMERIC MONEY 28 8 20 CoveredTotAmountOCU Covered Total Amount (Order Currency)      
SM48058 NUMERIC MONEY 28 8 20 CoveredTotAmountICU Covered Total Amount (Invoice Currency)      
SM48059 NUMERIC MONEY 28 8 20 CoveredTotAmountLCU Covered Total Amount (Local Currency)      
SM48060 INT INTEGER 0 0 4 Mark_Up Mark-up %      
SM48061 NVARCHAR VSTRING 6 0 6 InvIssuer Invoice Issuer Code      
SM48062 NCHAR SWITCH 1 0 1 InvCategory Invoice Category      
SM48063 NCHAR SWITCH 1 0 1 InvType Invoice Type 0 - Invoice (day to day business)
1 - Debit note
2 - Credit note		    
SM48064 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
SM48065 NCHAR SWITCH 1 0 1 Flag Forward Cover Flag Forward Cover      
SM48066 NUMERIC X_NUMERIC 23 8 15 Forward Cover Exchange rate Forward Cover Exchange Rate      
SM48067 NVARCHAR VSTRING 15 0 15 Forward Cover reference Forward Cover Reference      
SM48068 NCHAR SWITCH 1 0 1 Debit Invoice Flag        
SM48069 NCHAR STRING 6 0 6 TaxCodeForInvFee Tax Code for Invoice Fee      
SM48070 NUMERIC X_NUMERIC 21 8 13 FixedPriceOCU Fixed Price OCU      
SM48071 NUMERIC X_NUMERIC 21 8 13 FixedPriceICU Fixed Price ICU      
SM48072 NUMERIC X_NUMERIC 21 8 13 FixedPriceLCU Fixed Price LCU      
SM48073 NCHAR STRING 6 0 6 TaxCodeForFixPrice Tax Code for Fixed Price      
SM48074 NVARCHAR VSTRING 10 0 10 Operation Type Order Operation Type Order      
SM48075 NVARCHAR VSTRING 10 0 10 Financial Operation Code Order Financial Operation Code Order      
SM48076 NVARCHAR VSTRING 10 0 10 Operation Type Time Operation Type Time      
SM48077 NVARCHAR VSTRING 10 0 10 Financial Operation Code Time Financial Operation Code Time      
SM48078 NVARCHAR VSTRING 10 0 10 Operation Type Cost Operation Type Cost      
SM48079 NVARCHAR VSTRING 10 0 10 Financial Operation Code Cost Financial Operation Code Cost      
SM48080 NVARCHAR VSTRING 10 0 10 Operation Type Material Operation Type Material      
SM48081 NVARCHAR VSTRING 10 0 10 Financial Operation Code Material Financial Operation Code Material      
SM48082 NCHAR SWITCH 1 0 1 Instalment Instalment      
SM48083 NUMERIC X_NUMERIC 20 8 12 Interest% Interest%      
SM48084 NUMERIC X_NUMERIC 20 8 12 New Interest% New Interest%      
SM48085 DATETIME DATE 0 0 8 Activate New Interest Date Activate New Interest Date      
SM48086 NUMERIC MONEY 28 8 20 Financial Charge Financial Charge      
SM48087 NCHAR STRING 6 0 6 Interest Tax Code Interest Tax Code      
SM48088 NCHAR STRING 6 0 6 Financial Tax Code Financial Tax Code      
SM48089 NCHAR SWITCH 1 0 1 SpecificationPrintedFlag Specification Printed Flag      
SM48090 NVARCHAR VSTRING 6 0 6 Fixed Price Time Line Group Fixed Price Time Line Group      
SM48091 NVARCHAR VSTRING 6 0 6 Fixed Price Cost Line Group Fixed Price Cost Line Group      
SM48092 NVARCHAR VSTRING 6 0 6 Fixed Price Mat Line Group Fixed Price Mat Line Group      
SM48093 NUMERIC MONEY 28 8 20 ExternalCommissionAmount External Commission Amount      
SM48094 NCHAR STRING 2 0 2 District District      
SM48095 NCHAR STRING 2 0 2 AdvertisingCode Advertising Code      
SM48096 NCHAR STRING 4 0 4 CityCode City Code      
SM48097 NCHAR STRING 5 0 5 SNI Code SNI Code      
SM48098 NVARCHAR VSTRING 10 0 10 Bank Code Bank Code      
SM48099 NVARCHAR VSTRING 2 0 2 Payment Address Code Payment Address Code      
SM48100 NCHAR STRING 2 0 2 Extended Commission Code Extended Commission Code      
SM48101 NVARCHAR VSTRING 12 0 12 Invoice counter ID Invoice counter ID      
SM48102 INT INTEGER 0 0 4 Invoice Copy Number Invoice Copy Number      
SM48103 INT INTEGER 0 0 4 On-account Invoice Copy Number On-account Invoice Copy Number      
SM48104 NVARCHAR VSTRING 10 0 10 Original Order No Original Order No      
SM48105 NVARCHAR VSTRING 15 0 15 Original Invoice No Original Invoice No      
SM48106 INT INTEGER 0 0 1 Flag Doc XML Invoice Flag Doc XML Invoice      
SM48107 DATETIME X_DATETIME 0 0 17 LastInvoiceTime Last Invoice Time      
SM48108 DATETIME X_DATETIME 0 0 17 LastAdvInvoiceTime Last Advance Invoice Time      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Service Order Invoice Customers History