One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SM48 — Service Order Invoice Customers History

Таблица / Table: SM48 — «Service Order Invoice Customer File History». Маска имени таблицы / Table name mask: «SM48%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 CorrectionNumber Correction Number      
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 MarkUp 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 FlagForwardCover Flag Forward Cover      
SM48066 NUMERIC X_NUMERIC 23 8 15 FwdCoverExchRate Forward Cover Exchange Rate      
SM48067 NVARCHAR VSTRING 15 0 15 FwdCoverRef Forward Cover Reference      
SM48068 NCHAR SWITCH 1 0 1 DebitInvoiceFlag 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 OperationTypeOrder Operation Type Order      
SM48075 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeOrder Financial Operation Code Order      
SM48076 NVARCHAR VSTRING 10 0 10 OperationTypeTime Operation Type Time      
SM48077 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeTime Financial Operation Code Time      
SM48078 NVARCHAR VSTRING 10 0 10 OperationTypeCost Operation Type Cost      
SM48079 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeCost Financial Operation Code Cost      
SM48080 NVARCHAR VSTRING 10 0 10 OperationTypeMaterial Operation Type Material      
SM48081 NVARCHAR VSTRING 10 0 10 FinancialOperationCodeMaterial Financial Operation Code Material      
SM48082 NCHAR SWITCH 1 0 1 Instalment Instalment      
SM48083 NUMERIC X_NUMERIC 20 8 12 InterestPercent Interest%      
SM48084 NUMERIC X_NUMERIC 20 8 12 NewInterestPercent New Interest%      
SM48085 DATETIME DATE 0 0 8 ActivateNewInterestDate Activate New Interest Date      
SM48086 NUMERIC MONEY 28 8 20 FinancialCharge Financial Charge      
SM48087 NCHAR STRING 6 0 6 InterestTaxCode Interest Tax Code      
SM48088 NCHAR STRING 6 0 6 FinancialTaxCode Financial Tax Code      
SM48089 NCHAR SWITCH 1 0 1 SpecificationPrintedFlag Specification Printed Flag      
SM48090 NVARCHAR VSTRING 6 0 6 FixedPriceTimeLineGroup Fixed Price Time Line Group      
SM48091 NVARCHAR VSTRING 6 0 6 FixedPriceCostLineGroup Fixed Price Cost Line Group      
SM48092 NVARCHAR VSTRING 6 0 6 FixedPriceMatLineGroup 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 SNICode SNI Code      
SM48098 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
SM48099 NVARCHAR VSTRING 2 0 2 PaymentAddressCode Payment Address Code      
SM48100 NCHAR STRING 2 0 2 ExtendedCommissionCode Extended Commission Code      
SM48101 NVARCHAR VSTRING 12 0 12 InvCounterID Invoice counter ID      
SM48102 INT INTEGER 0 0 4 InvoiceCopyNumber Invoice Copy Number      
SM48103 INT INTEGER 0 0 4 OnaccountInvoiceCopyNumber On-account Invoice Copy Number      
SM48104 NVARCHAR VSTRING 10 0 10 OriginalOrderNo Original Order No      
SM48105 NVARCHAR VSTRING 15 0 15 OriginalInvoiceNo Original Invoice No      
SM48106 INT INTEGER 0 0 1 FlagDocXMLInvoice 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      
SM48109 NUMERIC MONEY 28 8 20 FreightAmountICU Freight Amount, ICU      
SM48110 NCHAR STRING 6 0 6 TaxCodeFreight Tax Code for Freight      
SM48111 NCHAR STRING 1 0 1 FreightPayer Freight Payer      
SM48112 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
SM48113 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
SM48114 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
SM48115 NUMERIC X_NUMERIC 18 8 10 NoOfUnits No Of Units      
SM48116 NVARCHAR VSTRING 15 0 15 KindOfBox Kind Of Box      
SM48117 NVARCHAR VSTRING 15 0 15 BoxNumbering Box Numbering      
SM48118 NVARCHAR VSTRING 15 0 15 NumberOfPallets Number Of Pallets      
SM48119 NVARCHAR VSTRING 10 0 10 TransportCompanyCode Transport Company Code      
SM48120 NVARCHAR VSTRING 10 0 10 VehicleState Vehicle State      
SM48121 NVARCHAR VSTRING 15 0 15 VehicleLicensePlate Vehicle License Plate      
SM48122 NVARCHAR VSTRING 10 0 10 CodeANTT Code ANTT      
SM48123 NCHAR STRING 1 0 1 TaxesForFreight Taxes for Freight      
SM48124 NVARCHAR VSTRING 50 0 50 FiscalKeyReference Fiscal Key Reference      
SM48125 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
SM48126 NCHAR STRING 1 0 1 Tax Point Tax Point      
SM48127 NCHAR STRING 6 0 6 InvPlanLineNo InvPlanLineNo   4 Да / Yes
SM48128 NCHAR STRING 3 0 3 Taxation Reason Code Fixed Price Taxation Reason Code Fixed Price      
SM48129 NCHAR STRING 3 0 3 Taxation Reason Code On-Account Taxation Reason Code On-Account      

Навигация / Navigation: