Таблица: SM11 - «Service Contract Master File I/O». Маска имени таблицы: «SM11%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM11001 | NCHAR | STRING | 10 | 0 | 10 | ServContrNo | Service Contract Number | 1 | Да | |
SM11002 | NCHAR | STRING | 10 | 0 | 10 | ICusCodeBuyer | Customer Code Invoice (Contract) | |||
SM11003 | NCHAR | STRING | 10 | 0 | 10 | CustCodeCont | Customer Code Service Address | |||
SM11004 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerRef | Customer Reference | |||
SM11005 | NVARCHAR | VSTRING | 35 | 0 | 35 | Remarks1 | Remark Line 1 | |||
SM11006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Remarks2 | Remark Line 2 | |||
SM11007 | INT | INTEGER | 0 | 0 | 1 | FLAGContract | Contract Print Status | 0 - The contract will not be sent.
1 - The contract is sent automatically when a new contract is entered. 2 - The contract has been sent. |
||
SM11008 | INT | INTEGER | 0 | 0 | 1 | FLAGDoc2 | Document 1 Print Status | 0 - Own Document 1 will not be sent.
1 - Own Document 1 will be sent. 2 - Own Document 1 has been sent. |
||
SM11009 | INT | INTEGER | 0 | 0 | 1 | FLAGDoc3 | Document 2 Print Status | 0 - Own Document 2 will not be sent.
1 - Own Document 2 will be sent. 2 - Own Document 2 has been sent. |
||
SM11010 | INT | INTEGER | 0 | 0 | 1 | FLAGInvoice | Invoice Print Status | 0 - Invoice will not be sent
1 - Invoice will be sent Note: Invoice printing is controlled internally by schedule, not this status |
||
SM11011 | NCHAR | STRING | 2 | 0 | 2 | PaymentTerm | Payment Terms | |||
SM11012 | DATETIME | DATE | 0 | 0 | 8 | ContractDate | Contract Date | |||
SM11013 | DATETIME | DATE | 0 | 0 | 8 | NextInvDate | Next Invoicing Date | |||
SM11014 | INT | INTEGER | 0 | 0 | 4 | InvIntervall | Invoicing Interval | Defines the time interval in month, years, week or days between each invoice. The time unit is defined in column SM11134 | ||
SM11015 | DATETIME | DATE | 0 | 0 | 8 | ContrStrDate | Contract Start Date | |||
SM11016 | DATETIME | DATE | 0 | 0 | 8 | ContrEndDate | Contract End Date | |||
SM11017 | NCHAR | STRING | 3 | 0 | 3 | SalesmanNo | Salesman | |||
SM11018 | NVARCHAR | VSTRING | 35 | 0 | 35 | OurReference | Our Reference | |||
SM11019 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrdDiscount | Order Discount Period 1 % | |||
SM11020 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | Current invoice number for contract that have been invoice but not closed | ||
SM11021 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
SM11022 | NUMERIC | MONEY | 28 | 8 | 20 | ContractValueOCU | Contract Value (Contract Currency) | |||
SM11023 | INT | INTEGER | 0 | 0 | 6 | Spare | Currency Code Invoice | |||
SM11024 | NCHAR | STRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SM11025 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | Tax Liability Code | |||
SM11026 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | |||
SM11027 | NCHAR | STRING | 2 | 0 | 2 | ContractCurrencyCode | Currency Code Contract | |||
SM11028 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGExpOrder | Is Export Contract | |||
SM11029 | NCHAR | SWITCH | 1 | 0 | 1 | IndexClause | Has Index Clause | |||
SM11030 | NUMERIC | MONEY | 28 | 8 | 20 | MinServCharLCU | Minimum Service Charge (Local Currency) | |||
SM11031 | NUMERIC | MONEY | 28 | 8 | 20 | AccInvAmntOCU | Accumulated Invoiced Amount (Contract Currency) | |||
SM11032 | NUMERIC | MONEY | 28 | 8 | 20 | HandlingFeeLCU | Invoice Fee (Local Currency) | |||
SM11033 | NCHAR | STRING | 2 | 0 | 2 | PriceList_Default | Price List | |||
SM11034 | NCHAR | STRING | 3 | 0 | 3 | ContractCode | Contract Type | |||
SM11035 | NCHAR | SWITCH | 1 | 0 | 1 | PriceType | Price Type | 0 - The prices entered on the contract lines are used, index can be used to restate the prices at invoice time.
1 - Current price from price list will be used at the time of invoice. |
||
SM11036 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | ExternalComm | External Commission % | |||
SM11037 | NCHAR | STRING | 10 | 0 | 10 | ExternComCode | External Commission Code | |||
SM11038 | NCHAR | STRING | 1 | 0 | 1 | DocumLayout | Document Layout | |||
SM11039 | NCHAR | STRING | 1 | 0 | 1 | InvRoundMod | Invoice Rounding Model | Used internally to keep information how rounding where calculated during printing of invoices. | ||
SM11040 | NCHAR | STRING | 20 | 0 | 20 | CustPONo | Customer Purchase Order Number | |||
SM11041 | DATETIME | DATE | 0 | 0 | 8 | LastInvDate | Last Invoicing Date | |||
SM11042 | NCHAR | STRING | 15 | 0 | 15 | LastInvoicNo | Last Invoice Number | Specifies the last contract invoice number that was printed and closed. | ||
SM11043 | INT | INTEGER | 0 | 0 | 1 | OrdMergeOption | Order Merge Option | Invoice merge option (invoices will be consolidated in sales ledger).
0 - No consolidated invoice 1 - Consolidate invoice per week 2 - Consolidate invoice per month |
||
SM11044 | NCHAR | STRING | 4 | 0 | 4 | CustSiteNo | Site Code | |||
SM11045 | INT | INTEGER | 0 | 0 | 2 | IndexSched1 | Index Month 1 | |||
SM11046 | INT | INTEGER | 0 | 0 | 2 | IndexSched2 | Index Month 2 | |||
SM11047 | INT | INTEGER | 0 | 0 | 2 | IndexSched3 | Index Month 3 | |||
SM11048 | INT | INTEGER | 0 | 0 | 2 | IndexSched4 | Index Month 4 | |||
SM11049 | INT | INTEGER | 0 | 0 | 1 | Index1No | Index 1 Number | |||
SM11050 | DATETIME | DATE | 0 | 0 | 8 | Idx1BaseDate | Index 1 Base Date | |||
SM11051 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx1Value | Index 1 Value | |||
SM11052 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx1Weighting | Index 1 Weighting | |||
SM11053 | INT | INTEGER | 0 | 0 | 1 | Index2No | Index 2 Number | |||
SM11054 | DATETIME | DATE | 0 | 0 | 8 | Idx2BaseDate | Index 2 Base Date | |||
SM11055 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx2Value | Index 2 Value | |||
SM11056 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx2Weighting | Index 2 Weighting | |||
SM11057 | INT | INTEGER | 0 | 0 | 1 | Index3No | Index 3 Number | |||
SM11058 | DATETIME | DATE | 0 | 0 | 8 | Idx3BaseDate | Index 3 Base Date | |||
SM11059 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx3Value | Index 3 Value | |||
SM11060 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx3Weighting | Index 3 Weighting | |||
SM11061 | INT | INTEGER | 0 | 0 | 1 | Index4No | Index 4 Number | |||
SM11062 | DATETIME | DATE | 0 | 0 | 8 | Idx4BaseDate | Index 4 Base Date | |||
SM11063 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Idx4Value | Index 4 Value | |||
SM11064 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Idx4Weighting | Index 4 Weighting | |||
SM11065 | INT | INTEGER | 0 | 0 | 1 | FLContrCancel | Cancellation Document Print Status | 0 - Cancellation Document will not be sent.
1 - Cancellation Document will be sent. 2 - Cancellation Document been sent. |
||
SM11066 | NCHAR | SWITCH | 1 | 0 | 1 | FLCreditInv | Credit When Cancel | 1 - When deleting a contract line from the contract, a credit is
made for overcharging, for example payment in advance. 0 - No credit is allowed when deleting a line. |
||
SM11067 | NCHAR | SWITCH | 1 | 0 | 1 | FLFixPrices | Has Fixed Prices | |||
SM11068 | NCHAR | STRING | 2 | 0 | 2 | ContractType | Contract Code | |||
SM11069 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | DiscntLabour | Discount on Labour % | |||
SM11070 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | DiscntCosts | Discount on Costs % | |||
SM11071 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | DiscntParts | Discount on Parts % | |||
SM11072 | NCHAR | STRING | 2 | 0 | 2 | LabPricCode | Labour Price Code | |||
SM11073 | NUMERIC | MONEY | 28 | 8 | 20 | PricehourOCU | Labour Price per Hour (Contract Currency) | |||
SM11074 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Labour Hours Included | |||
SM11075 | NCHAR | STRING | 2 | 0 | 2 | LabPricCode | Cost Price Code | |||
SM11076 | NUMERIC | MONEY | 28 | 8 | 20 | PricehourOCU | Cost Unit Price (Contract Currency) | |||
SM11077 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Cost Quantity Included | |||
SM11078 | NCHAR | STRING | 2 | 0 | 2 | LabPricCode | Material Price Code | |||
SM11079 | NUMERIC | MONEY | 28 | 8 | 20 | PricehourOCU | Material Unit Price (Contract Currency) | |||
SM11080 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Material Quantity Included | |||
SM11081 | NCHAR | STRING | 1 | 0 | 1 | TypeOfTimeBank | Type of Time Bank | |||
SM11082 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursIncluded | Hours Included | |||
SM11083 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursWorked | Hours Worked | |||
SM11084 | INT | INTEGER | 0 | 0 | 1 | FLAGLabels | Labels Print Status | 0 - Labels will not be sent.
1 - Labels will be sent. 2 - Labels been sent. |
||
SM11085 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | LatestIdxAdjust | Latest Index Adjustment | |||
SM11086 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice 1 Number | Last invoice printed and closed | ||
SM11087 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Invoice 1 Due Date | |||
SM11088 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice 2 Number | Second to last invoice printed and closed | ||
SM11089 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Invoice 2 Due Date | |||
SM11090 | NCHAR | SWITCH | 1 | 0 | 1 | FLInvDuePmt | Invoice is Due for Payment | |||
SM11091 | INT | INTEGER | 0 | 0 | 1 | QuotationStatus | Contract Status | 0 - Quotation
1 - Equipment/reference 2 - Contract terms, no invoice 3 - Invoice contract |
||
SM11092 | INT | INTEGER | 0 | 0 | 1 | FLQuotation | Quotation Print Status | 0 - Quotation will not be sent.
1 - Quotation will be sent. 2 - Quotation has been sent. |
||
SM11093 | NCHAR | STRING | 20 | 0 | 20 | CustAlphaKey | Customer Search Key | |||
SM11094 | NVARCHAR | VSTRING | 20 | 0 | 20 | SiteName | Site Name | |||
SM11095 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGTempInv | Invoice is Blocked | 0 - Invoices will be generated according to specified invoice interval and terms
1 - Generation of invoices is temporary blocked for the contract |
||
SM11096 | INT | INTEGER | 0 | 0 | 1 | ExtensStatus | Contract Terms | 0 - Automatic renewal with 12 months after expiration of contract time.
1 - Manual renewal, the contract must be renewed after expiration. 2 - Cancelled. |
||
SM11097 | DATETIME | DATE | 0 | 0 | 8 | LastChngDate | Date Changed | |||
SM11098 | DATETIME | DATE | 0 | 0 | 8 | LastChngIdx | Date Index Changed | |||
SM11099 | NCHAR | SWITCH | 1 | 0 | 1 | FlagChanging | Changes are Made | |||
SM11100 | DATETIME | DATE | 0 | 0 | 8 | LateIdxTabDt | Latest Index Table Date | |||
SM11101 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SM11102 | NCHAR | STRING | 10 | 0 | 10 | ICusCodeCont | Customer Code Invoice (Contractual Service) | Specifies the customer that shall be charged for services that are covered by the contract, excluding service of part with valid warranty. | ||
SM11103 | NCHAR | SWITCH | 1 | 0 | 1 | StdContCode | Standard Contract Type | |||
SM11104 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ResponceTime | Response Time | |||
SM11105 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ETATime | Call-back Time (ETA) | |||
SM11106 | NCHAR | STRING | 1 | 0 | 1 | InvoiceRoundModel | Invoice Rounding Model | |||
SM11107 | NCHAR | STRING | 1 | 0 | 1 | CurrencyContract | Has Currency Contract | |||
SM11108 | NCHAR | STRING | 1 | 0 | 1 | Flag_Create_CreditNote | Generate Credit Note/Invoice | |||
SM11109 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SM11110 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SM11111 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SM11112 | NCHAR | SWITCH | 1 | 0 | 1 | FlagForText | Has Extended Text | |||
SM11113 | NCHAR | STRING | 3 | 0 | 3 | Manager | Salesman Contract Administrator | |||
SM11114 | NCHAR | STRING | 10 | 0 | 10 | MasterContract | Master Contract | |||
SM11115 | NCHAR | STRING | 4 | 0 | 4 | Spare | (obsolete) | |||
SM11116 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrderDisc2 | Order Discount Period 2 % | |||
SM11117 | NCHAR | STRING | 4 | 0 | 4 | Spare | (obsolete) | |||
SM11118 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrderDisc3 | Order Discount Period 3 % | |||
SM11119 | NCHAR | STRING | 4 | 0 | 4 | Spare | (obsolete) | |||
SM11120 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrderDisc4 | Order Discount Period 4 % | |||
SM11121 | NCHAR | STRING | 4 | 0 | 4 | Spare | (obsolete) | |||
SM11122 | NCHAR | STRING | 10 | 0 | 10 | ICustGaranti | Customer Code Invoice (Warranty Service) | Specifies thee customer that shall be charged for services that are covered by a valid warranty. | ||
SM11123 | NCHAR | STRING | 3 | 0 | 3 | ContCodeGuarantee | Contract Type Warranty | |||
SM11124 | NUMERIC | MONEY | 28 | 8 | 20 | ContractValueLCU | Contract Value (Local Currency) | |||
SM11125 | NUMERIC | MONEY | 28 | 8 | 20 | ActInvAmountLCU | Accumulated Invoiced Amount (Local Currency) | |||
SM11126 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | FixExchRate1 | Fixed Exchange Rate 1 | |||
SM11127 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | FixExchRate2 | Fixed Exchange Rate 2 | |||
SM11128 | NCHAR | STRING | 3 | 0 | 3 | FixExchAlgorithm | Fixed Exchange Rate Algorithm | |||
SM11129 | NCHAR | STRING | 15 | 0 | 15 | CurrencyContractNr | Currency Contract Number | |||
SM11130 | NCHAR | STRING | 8 | 0 | 8 | CampaignCode | Campaign Code | |||
SM11131 | NCHAR | SWITCH | 1 | 0 | 1 | InvInAdvance | Invoice In Advance | |||
SM11132 | NCHAR | STRING | 10 | 0 | 10 | RequestNo | Customer Request Number | |||
SM11133 | NCHAR | STRING | 10 | 0 | 10 | CalendarID | Calendar ID | |||
SM11134 | INT | INTEGER | 0 | 0 | 2 | Default_InvoiceIntervalTimeUnit | Unit Code Invoice Interval | 1 - Years
2 - Month 3 - Weeks 4 - Days |
||
SM11135 | INT | INTEGER | 0 | 0 | 20 | Discount interval 1 | Discount Interval Period 1 | |||
SM11136 | INT | INTEGER | 0 | 0 | 10 | Discount interval 2 | Discount Interval Period 2 | |||
SM11137 | INT | INTEGER | 0 | 0 | 10 | Discount interval 3 | Discount Interval Period 3 | |||
SM11138 | INT | INTEGER | 0 | 0 | 10 | Discount interval 4 | Discount Interval Period 4 | |||
SM11139 | INT | INTEGER | 0 | 0 | 10 | Discount 1 Time Unit | Discount Time Unit Period 1 | -1 - During Warranty
1 - Years 2 - Month 3 - Weeks 4 - Days |
||
SM11140 | INT | INTEGER | 0 | 0 | 10 | Discount 2 Time Unit | Discount Time Unit Period 2 | -1 - During Warranty
1 - Years 2 - Month 3 - Weeks 4 - Days |
||
SM11141 | INT | INTEGER | 0 | 0 | 10 | Discount 3 Time Unit | Discount Time Unit Period 3 | -1 - During Warranty
1 - Years 2 - Month 3 - Weeks 4 - Days |
||
SM11142 | INT | INTEGER | 0 | 0 | 10 | Discount 4 Time Unit | Discount Time Unit Period 4 | -1 - During Warranty
1 - Years 2 - Month 3 - Weeks 4 - Days |
||
SM11143 | NCHAR | STRING | 2 | 0 | 2 | Accounting Code | Accounting Code | |||
SM11144 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGElectronicContract | Has Electronic Contract | |||
SM11145 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLContract | EDI/XML Contract Status | 0 - The contract will not be sent.
1 - The contract is sent automatically when a new contract is entered. 2 - The contract has been sent. |
||
SM11146 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLDoc2 | EDI/XML Document 1 | 0 - Own Document 1 will not be sent.
1 - Own Document 1 will be sent. 2 - Own Document 1 has been sent. |
||
SM11147 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLDoc3 | EDI/XML Document 2 | 0 - Own Document 2 will not be sent.
1 - Own Document 2 will be sent. 2 - Own Document 2 has been sent. |
||
SM11148 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLCancel | EDI/XML Cancellation Document | 0 - Cancellation Document will not be sent.
1 - Cancellation Document will be sent. 2 - Cancellation Document been sent. |
||
SM11149 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLLabels | EDI/XML Labels | 0 - Labels will not be sent.
1 - Labels will be sent. 2 - Labels been sent. |
||
SM11150 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLQuotation | EDI/XML Quotation | 0 - Quotation will not be sent.
1 - Quotation will be sent. 2 - Quotation has been sent. |
||
SM11151 | NVARCHAR | VSTRING | 4 | 0 | 4 | InvIssuer | Invoice Issuer Code | |||
SM11152 | NCHAR | SWITCH | 1 | 0 | 1 | InvCategory | Invoice Category | |||
SM11153 | NCHAR | SWITCH | 1 | 0 | 1 | InvType | Invoice Type | |||
SM11154 | DATETIME | DATE | 0 | 0 | 8 | CancellationDate | Contract Cancellation Date | |||
SM11155 | DATETIME | DATE | 0 | 0 | 8 | InvoiceFrom | Invoice From Date | |||
SM11156 | DATETIME | DATE | 0 | 0 | 8 | InvoiceTo | Invoice To Date | |||
SM11157 | NCHAR | STRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
SM11158 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerName | Customer Name | |||
SM11159 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress1 | Shipping Address Line 1 | |||
SM11160 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress2 | Shipping Address Line 2 | |||
SM11161 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress3 | Shipping Address Line 3 | |||
SM11162 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShippingAddress4 | Shipping Address Line 4 | |||
SM11163 | NVARCHAR | VSTRING | 6 | 0 | 6 | Purchaser | Purchaser | |||
SM11164 | NVARCHAR | VSTRING | 2 | 0 | 2 | PaymentTerms | Payment Terms | |||
SM11165 | NVARCHAR | VSTRING | 2 | 0 | 2 | DeliveryMethod | Delivery Method | |||
SM11166 | NVARCHAR | VSTRING | 2 | 0 | 2 | DeliveryTerms | Delivery Terms | |||
SM11167 | DATETIME | DATE | 0 | 0 | 8 | BookEntryDate | Book Entry Date | |||
SM11168 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeForInvFee | Tax Code for Invoice Fee | |||
SM11169 | INT | INTEGER | 0 | 0 | 2 | ReservationDuration | Reservation Time Out (Duration) | |||
SM11170 | INT | INTEGER | 0 | 0 | 2 | ReservationTimeUnit | Reservation Time Out (Time unit) | |||
SM11171 | NCHAR | SWITCH | 1 | 0 | 1 | Avoid Backorders | Avoid Backorders | |||
SM11172 | NCHAR | SWITCH | 1 | 0 | 1 | AcceptLineSplit | Accept Line Split | |||
SM11173 | NCHAR | SWITCH | 1 | 0 | 1 | Accept Order Split | AcceptOrderSplit | |||
SM11174 | NCHAR | SWITCH | 1 | 0 | 1 | UseLTM | Use LTM | |||
SM11175 | INT | INTEGER | 0 | 0 | 2 | AcceptedDeliveryInterval | Accepted Delivery Interval | |||
SM11176 | NVARCHAR | VSTRING | 10 | 0 | 10 | CarrierCode | Carrier Code | |||
SM11177 | NVARCHAR | VSTRING | 35 | 0 | 35 | CarrierName | Carrier Name | |||
SM11178 | INT | INTEGER | 0 | 0 | 4 | Delivery Note, sort | Delivery Note, sort | |||
SM11179 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto print DN | Auto print DN | |||
SM11180 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto send DN | Auto send DN | |||
SM11181 | NVARCHAR | VSTRING | 10 | 0 | 10 | Operation Type | Operation Type | |||
SM11182 | NVARCHAR | VSTRING | 10 | 0 | 10 | Financial Operation Code | Financial Operation Code | |||
SM11183 | NCHAR | SWITCH | 1 | 0 | 1 | Instalment | Instalment | |||
SM11184 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Interest% | Interest% | |||
SM11185 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | New Interest% | New Interest% | |||
SM11186 | DATETIME | DATE | 0 | 0 | 8 | Activate New Interest Date | Activate New Interest Date | |||
SM11187 | NUMERIC | MONEY | 28 | 8 | 20 | Financial Charge | Financial Charge | |||
SM11188 | NCHAR | STRING | 6 | 0 | 6 | Interest Tax Code | Interest Tax Code | |||
SM11189 | NCHAR | STRING | 6 | 0 | 6 | Financial Tax Code | Financial Tax Code | |||
SM11190 | NVARCHAR | VSTRING | 10 | 0 | 10 | Default Engineer | Default Engineer | |||
SM11191 | NCHAR | SWITCH | 1 | 0 | 1 | Reorder Customer | Reorder Customer | |||
SM11192 | INT | INTEGER | 0 | 0 | 1 | Delivery note printing | Delivery note printing | |||
SM11193 | INT | INTEGER | 0 | 0 | 1 | Invoice printing | Invoice printing | |||
SM11194 | DATETIME | DATE | 0 | 0 | 8 | Contract Pricing Date | Contract Pricing Date | |||
SM11195 | NCHAR | STRING | 10 | 0 | 10 | Contract Pricing Number | Contract Pricing Number | |||
SM11196 | INT | INTEGER | 0 | 0 | 1 | Invoice Status | Invoice Status |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Contract Master