Таблица / Table: SM01 — «Service Order Master File». Маска имени таблицы / Table name mask: «SM01%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
SM01001 | NCHAR | STRING | 10 | 0 | 10 | ServiceOrdNo | Service Order Number | 1 | Да / Yes | |
SM01002 | NCHAR | STRING | 10 | 0 | 10 | CustCodeInv | Customer Code Invoice | |||
SM01003 | NCHAR | STRING | 10 | 0 | 10 | CustCodeServ | Customer Code Service | |||
SM01004 | NVARCHAR | VSTRING | 35 | 0 | 35 | CustomerRef | Customer Reference | |||
SM01005 | NCHAR | STRING | 20 | 0 | 20 | CustomerPONo | Customer Purchase Order Number | |||
SM01006 | NCHAR | STRING | 35 | 0 | 35 | ObjStockCode | Service Object | |||
SM01007 | NCHAR | STRING | 20 | 0 | 20 | ObjSerialNo | Service Object Serial Number | |||
SM01008 | NVARCHAR | VSTRING | 25 | 0 | 25 | ObjectDescr1 | Service Object Description Line 1 | |||
SM01009 | NVARCHAR | VSTRING | 25 | 0 | 25 | ObjectDescr2 | Service Object Description Line 2 | |||
SM01010 | NCHAR | STRING | 10 | 0 | 10 | ObjMaintContNo | Service Object Contract | |||
SM01011 | NVARCHAR | VSTRING | 70 | 0 | 70 | ServiceReq1 | Text Line 1 | |||
SM01012 | NVARCHAR | VSTRING | 70 | 0 | 70 | ServiceReq2 | Text Line 2 | |||
SM01013 | NVARCHAR | VSTRING | 70 | 0 | 70 | ServiceReq3 | Text Line 3 | |||
SM01014 | NVARCHAR | VSTRING | 70 | 0 | 70 | ServiceReq4 | Text Line 4 | |||
SM01015 | NVARCHAR | VSTRING | 35 | 0 | 35 | OurReference | Our Reference | |||
SM01016 | NCHAR | STRING | 10 | 0 | 10 | FieldEngineer | Resource Code Engineer | |||
SM01017 | DATETIME | DATE | 0 | 0 | 8 | CALLETADate | Service Call ETA Date | |||
SM01018 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | CALLETATime | Service Call ETA Time | |||
SM01019 | DATETIME | DATE | 0 | 0 | 8 | CALLETRDate | Service Call ETR Date | |||
SM01020 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | CALLETRTime | Service Call ETR Time | |||
SM01021 | DATETIME | DATE | 0 | 0 | 8 | CALLLOGEDDt | Service Call Date Logged | |||
SM01022 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | CALLLOGEDTime | Service Call Time Logged | |||
SM01023 | DATETIME | DATE | 0 | 0 | 8 | CALLOPENDate | Service Call Date Opened | |||
SM01024 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | CALLOPENTime | Service Call Time Opened | |||
SM01025 | DATETIME | DATE | 0 | 0 | 8 | CALLCOMPLDate | Service Call Date Committed | |||
SM01026 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | CALLCOMPLTime | Service Call Time Committed | |||
SM01027 | DATETIME | DATE | 0 | 0 | 8 | CALLCLOSEDt | Service Call Date Closed | |||
SM01028 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | CALLCLOSETime | Service Call Time Closed | |||
SM01029 | NCHAR | STRING | 4 | 0 | 4 | ProPriGroCode | Product Price Group Code | |||
SM01030 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriceHrs | (obsolete) | |||
SM01031 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriceCst | (obsolete) | |||
SM01032 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriceMat | (obsolete) | |||
SM01033 | INT | INTEGER | 0 | 0 | 1 | InvSpecHours | (obsolete) | |||
SM01034 | INT | INTEGER | 0 | 0 | 1 | InvSpecCosts | (obsolete) | |||
SM01035 | INT | INTEGER | 0 | 0 | 1 | InvSpecMat | (obsolete) | |||
SM01036 | NCHAR | STRING | 2 | 0 | 2 | PaymentTerm | (obsolete) | |||
SM01037 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Last Invoice Date | |||
SM01038 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Last Invoice Number | |||
SM01039 | INT | INTEGER | 0 | 0 | 1 | InteStatFlag | Quotation State | 0 — The Service Order is in Order State 1 — The Service Order is in Quotation State |
||
SM01040 | INT | INTEGER | 0 | 0 | 1 | DOCFLAGQuotation | Quotation Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01041 | INT | INTEGER | 0 | 0 | 1 | DOCFLAGConfirm | Confirmation Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01042 | INT | INTEGER | 0 | 0 | 1 | DOCFLAGSrvOrder | Service Order Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01043 | INT | INTEGER | 0 | 0 | 1 | InvUpdStatus | (obsolete) | |||
SM01044 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | |||
SM01045 | NCHAR | STRING | 1 | 0 | 1 | DocmntLayout | Document Layout | |||
SM01046 | INT | INTEGER | 0 | 0 | 1 | EngnPagingFlag | Engineer Paging Status | |||
SM01047 | INT | INTEGER | 0 | 0 | 1 | InvMergeOption | Invoice 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 |
||
SM01048 | NUMERIC | MONEY | 28 | 8 | 20 | HandlingFee | (obsolete) | |||
SM01049 | NCHAR | STRING | 2 | 0 | 2 | CurrencyCode | Currency Code Order | |||
SM01050 | NCHAR | STRING | 2 | 0 | 2 | Pricelist | (obsolete) | |||
SM01051 | NCHAR | STRING | 6 | 0 | 6 | WareHouse | Warehouse | |||
SM01052 | DATETIME | DATE | 0 | 0 | 8 | BookEntryDate | Book-Entry Date | |||
SM01053 | NCHAR | STRING | 1 | 0 | 1 | CurrencyClause | Currency Compensation | |||
SM01054 | NCHAR | STRING | 1 | 0 | 1 | CurrencyContract | Currency Contract | |||
SM01055 | NCHAR | STRING | 1 | 0 | 1 | StkToolWCHR | Service Object Type | A — Asset B — BOM Configuration C — Training Course H — Resource N — No service object S — Stock Item T — MPC Tool W — Work Centre |
||
SM01056 | INT | INTEGER | 0 | 0 | 2 | EDITransmCnt | EDI Sent Counter | |||
SM01057 | INT | INTEGER | 0 | 0 | 2 | EDIReceivCnt | EDI Received Counter | |||
SM01058 | NCHAR | SWITCH | 1 | 0 | 1 | EDIFlag1 | EDI Document 1 Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01059 | NCHAR | SWITCH | 1 | 0 | 1 | EDIFlag2 | EDI Document 2 Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01060 | NCHAR | SWITCH | 1 | 0 | 1 | EDIFlag3 | EDI Document 3 Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01061 | NCHAR | SWITCH | 1 | 0 | 1 | EDIFlag4 | EDI Document 4 Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01062 | NCHAR | SWITCH | 1 | 0 | 1 | PriorityFlg1 | Service Order Priority | |||
SM01063 | NCHAR | SWITCH | 1 | 0 | 1 | PriorityFlg2 | Weighted Priority | |||
SM01064 | NCHAR | STRING | 2 | 0 | 2 | OrderStatus | Order Status | |||
SM01065 | NCHAR | STRING | 3 | 0 | 3 | MaintenaCode | Contract Type | |||
SM01066 | NCHAR | SWITCH | 1 | 0 | 1 | LetterOfCredit | Letter of Credit | |||
SM01067 | DATETIME | DATE | 0 | 0 | 8 | LCOpenDate | Letter of Credit Open Date | |||
SM01068 | DATETIME | DATE | 0 | 0 | 8 | LCDueDate | Letter of Credit Due Date | |||
SM01069 | NVARCHAR | VSTRING | 20 | 0 | 20 | LCReference | Letter of Credit Reference | |||
SM01070 | NCHAR | SWITCH | 1 | 0 | 1 | GenerPIATrans | Generate WIP Transactions | |||
SM01071 | NCHAR | STRING | 4 | 0 | 4 | CustSiteNo | Site Code | |||
SM01072 | DATETIME | DATE | 0 | 0 | 8 | CALLATADate | Service Call ATA Date | |||
SM01073 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | CALLATATime | Service Call ATA Time | |||
SM01074 | DATETIME | DATE | 0 | 0 | 8 | MaterialDate | Material Date | |||
SM01075 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | MaterialTime | Material Time | |||
SM01076 | NCHAR | STRING | 4 | 0 | 4 | IncidentCode | Incident Code | |||
SM01077 | NCHAR | STRING | 15 | 0 | 15 | AnalysisCode | Analysis Code | |||
SM01078 | NCHAR | STRING | 10 | 0 | 10 | MasterServOrder | Master Service Order Number | |||
SM01079 | INT | INTEGER | 0 | 0 | 1 | OrderStruStatus | Order Structure Status | |||
SM01080 | INT | INTEGER | 0 | 0 | 1 | DOCFLAGPckNo | Picking List Local Print Status | Document status for internal material picking list: 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01081 | INT | INTEGER | 0 | 0 | 1 | DOCFLAGTrans | Transport Document Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01082 | INT | INTEGER | 0 | 0 | 1 | DOCFLAGExport | Export Document Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01083 | INT | INTEGER | 0 | 0 | 1 | DOCFLAGProformInv | Proforma Invoice Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01084 | NCHAR | STRING | 15 | 0 | 15 | ExtSrvStaCode | Extended Service Statistic Code | |||
SM01085 | NCHAR | STRING | 20 | 0 | 20 | DeliveryNotNo | Delivery Note Number | |||
SM01086 | NCHAR | STRING | 2 | 0 | 2 | DeliveryCode | Delivery Terms | |||
SM01087 | NCHAR | STRING | 2 | 0 | 2 | DeliveryMethod | Delivery Method | |||
SM01088 | INT | INTEGER | 0 | 0 | 1 | DOCFLDeliNot | Delivery Note 1 Print Status | Document status for customer delivery note 1: 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01089 | INT | INTEGER | 0 | 0 | 1 | DOCFLSubsuppler | Sub-Supplier Delivery Note Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01090 | INT | INTEGER | 0 | 0 | 1 | DOCFLFridok1 | User Document 1 Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01091 | INT | INTEGER | 0 | 0 | 1 | DOCFLFridok2 | User Document 2 Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01092 | INT | INTEGER | 0 | 0 | 1 | DOCFLFridok3 | User Document 3 Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01093 | INT | INTEGER | 0 | 0 | 1 | DOCFLCustDel | Delivery Note 2 Print Status | Document status for customer delivery note 2: 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01094 | NCHAR | SWITCH | 1 | 0 | 1 | MastOrdPrint | Master Order Printing | 1 — The serviced item belong to a master order and can not be delivered with customer delivery note before all orders are closed. 0 — The serviced item can be delivered when closed. |
||
SM01095 | DATETIME | DATE | 0 | 0 | 8 | SerNoDelDate | Serial Number Delivery Date | |||
SM01096 | DATETIME | DATE | 0 | 0 | 8 | SerNoWarrExp | Serial Number Warranty Expire Date | |||
SM01097 | NCHAR | STRING | 6 | 0 | 6 | OrderType | Order Type | |||
SM01098 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlannedHours | Planned Hours | |||
SM01099 | NCHAR | STRING | 35 | 0 | 35 | SwapArtNo | Swap Stock Item | |||
SM01100 | NVARCHAR | VSTRING | 25 | 0 | 25 | SwapDescr1 | Swap Stock Item Description Line 1 | |||
SM01101 | NVARCHAR | VSTRING | 25 | 0 | 25 | SwapDescr2 | Swap Stock Item Description Line 2 | |||
SM01102 | NCHAR | STRING | 20 | 0 | 20 | SwapSerieNo | Swap Serial Number | |||
SM01103 | INT | INTEGER | 0 | 0 | 1 | PickinglCenter | Picking List External Print Status | Document status for external material picking list: 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01104 | INT | INTEGER | 0 | 0 | 1 | ReturnNote | Return Note Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01105 | INT | INTEGER | 0 | 0 | 1 | Proforma | Proforma Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01106 | INT | INTEGER | 0 | 0 | 1 | Ettikes | Labels Print Status | 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01107 | INT | INTEGER | 0 | 0 | 1 | CustDelNote | Delivery Note 3 Print Status | Document status for customer delivery note 3: 0 — Document not ready for printing 1 — Print document 2 — Document sent |
||
SM01108 | NCHAR | STRING | 14 | 0 | 14 | StatistCode | Statistical Code Extended | |||
SM01109 | NUMERIC | MONEY | 28 | 8 | 20 | StatistValue | Statistical Value (Local Currency) | The unit price of the service object (only for stock items) | ||
SM01110 | NCHAR | STRING | 3 | 0 | 3 | SalesmanOrder | Salesman | |||
SM01111 | NCHAR | STRING | 3 | 0 | 3 | SalesmanInvoicer | Salesman Invoice Manager | |||
SM01112 | NCHAR | STRING | 4 | 0 | 4 | ObjPriceGroup | Product Group as Price Group | |||
SM01113 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SM01114 | DATETIME | DATE | 0 | 0 | 8 | STATUSDate | Status Date | |||
SM01115 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | STATUSTime | Status Time | |||
SM01116 | NVARCHAR | VSTRING | 20 | 0 | 20 | STATUSTEXT | Status Text | |||
SM01117 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RespTimeCont | Response Time Contract | |||
SM01118 | NCHAR | STRING | 10 | 0 | 10 | CustContrGar | Customer Code Internal for Contract and Warranty | |||
SM01119 | NCHAR | STRING | 2 | 0 | 2 | PriclCntrGar | Price List for Contract and Warranty | |||
SM01120 | NCHAR | STRING | 10 | 0 | 10 | CustomerCntr | (obsolete) | |||
SM01121 | NCHAR | STRING | 6 | 0 | 6 | WIPWHGood | WIP Warehouse | |||
SM01122 | NCHAR | STRING | 6 | 0 | 6 | WIPBinGood | WIP Bin | |||
SM01123 | NCHAR | STRING | 6 | 0 | 6 | WIPDACode | WIP Delivery Address Code | |||
SM01124 | DATETIME | DATE | 0 | 0 | 8 | ExchangeDate | Currency Exchange Date | |||
SM01125 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | Spare | (obsolete) | |||
SM01126 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RespTimePhone | Call Back Response Time | |||
SM01127 | INT | INTEGER | 0 | 0 | 1 | WIPDACtype | WIP Delivery Address Code Type | 0 — Delivery Warehouse 1 — Installation Address (Site) 2 — Internal Customer 3 — Delivery Address (Temporary) |
||
SM01128 | NCHAR | STRING | 4 | 0 | 4 | InteEscaCode | Internal Escalation Code | |||
SM01129 | NCHAR | STRING | 20 | 0 | 20 | TextRef | Text Reference | |||
SM01130 | DATETIME | DATE | 0 | 0 | 8 | ETCDate | ETC Date | |||
SM01131 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ETCTime | ETC Time | |||
SM01132 | INT | INTEGER | 0 | 0 | 1 | CustStatus | Invoice Customer Type | 0 — Customer 1 — Contract 2 — Warranty |
||
SM01133 | NCHAR | STRING | 10 | 0 | 10 | ReferenceNo | Problem Code Reference | |||
SM01134 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Spare | (obsolete) | |||
SM01135 | NCHAR | STRING | 3 | 0 | 3 | ExchangeAlgorithm | Currency Exchange Algorithm | |||
SM01136 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM01137 | NCHAR | STRING | 10 | 0 | 10 | OrderedCustomerCode | Customer Code Order | |||
SM01138 | NVARCHAR | VSTRING | 3 | 0 | 3 | SerNumWarType | Serial number selected warranty type | |||
SM01139 | NCHAR | STRING | 10 | 0 | 10 | Spare | Contract Line Number | |||
SM01140 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM01141 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MassRepairQty | Quantity for Mass Repair | |||
SM01142 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | OrderDiscPerc | Order Discount % | |||
SM01143 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | ExtComissPerc | (obsolete) | |||
SM01144 | NVARCHAR | VSTRING | 10 | 0 | 10 | ExtComissText | (obsolete) | |||
SM01145 | NCHAR | STRING | 2 | 0 | 2 | SOAccCode | Accounting Code Service Order | |||
SM01146 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | ExchangeRate1 | Currency Exchange Rate 1 | |||
SM01147 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | ExchangeRate2 | Exchange Rate 2 | |||
SM01148 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriceHoursLcu | (obsolete) | |||
SM01149 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriceCostsLcu | (obsolete) | |||
SM01150 | NUMERIC | MONEY | 28 | 8 | 20 | FixPriceMatLcu | (obsolete) | |||
SM01151 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | FixedExchRate1 | Fixed Exchange Rate 1 | |||
SM01152 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | FixedExchRate2 | Fixed Exchange Rate 2 | |||
SM01153 | NCHAR | STRING | 3 | 0 | 3 | FixesExchAlgorithm | Fixed Exchange Algorithm | |||
SM01154 | NVARCHAR | VSTRING | 15 | 0 | 15 | CurrencyContractNr | Currency Contract Number | |||
SM01155 | NVARCHAR | VSTRING | 8 | 0 | 8 | CampaignCode | Campaign | |||
SM01156 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | LimitForCurrClausePc | Currency Compensation Limit % | |||
SM01157 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | CompensationPer | Currency Compensation % | |||
SM01158 | NCHAR | STRING | 10 | 0 | 10 | RequestNo | Customer Request | |||
SM01159 | INT | INTEGER | 0 | 0 | 9 | SchemaCode | Discount Schema Code | |||
SM01160 | DATETIME | DATE | 0 | 0 | 8 | DateDiscount | Date Discount | |||
SM01161 | NCHAR | STRING | 6 | 0 | 6 | ContractStructLineNo | Contract Sub-line Number | |||
SM01162 | INT | INTEGER | 0 | 0 | 9 | CalendarColRef | Calendar Collection | |||
SM01163 | NCHAR | STRING | 38 | 0 | 38 | BOMConfigID | BOM Configuration ID | |||
SM01164 | NCHAR | STRING | 38 | 0 | 38 | BOMNodeID | BOM Node ID | |||
SM01165 | NCHAR | STRING | 30 | 0 | 30 | LinkedProjectActivity | Linked Project Number | |||
SM01166 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGElectronicOrder | Electronic Order | |||
SM01167 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLQuote | XML/EDI Quotation Status | |||
SM01168 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLConf | XML/EDI Confirmation Status | |||
SM01169 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLSO | XML/EDI Service Order Status | |||
SM01170 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLMatPickNoteLoc | XML/EDI Picking List Local Status | |||
SM01171 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLTransport | XML/EDI Transport Document Status | |||
SM01172 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLExport | XML/EDI Export Document Status | |||
SM01173 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLDeliveryNote | XML/EDI Delivery Note 1 Status | |||
SM01174 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLSubSuppDelivNote | XML/EDI Sub-Supplier Delivery Note Status | |||
SM01175 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLUser1 | XML/EDI User Document 1 Status | |||
SM01176 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLUser2 | XML/EDI User Document 2 Status | |||
SM01177 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLUser3 | XML/EDI User Document 3 Status | |||
SM01178 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLCustDelivNote | XML/EDI Delivery Note 2 Status | |||
SM01179 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLMatPickNoteExt | XML/EDI Picking List External Status | |||
SM01180 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLReturnNote | XML/EDI Return Note Status | |||
SM01181 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLProforma | XML/EDI Proforma Status | |||
SM01182 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLEttikets | XML/EDI Labels Status | |||
SM01183 | INT | INTEGER | 0 | 0 | 1 | FLAGDocXMLCustDelivNote3 | XML/EDI Delivery Note 3 Status | |||
SM01184 | NCHAR | STRING | 10 | 0 | 10 | BOMConfigurationVersion | BOM Configuration Version | |||
SM01185 | NCHAR | SWITCH | 1 | 0 | 1 | FlagForwardCover | Flag Forward Cover | |||
SM01186 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | FwdCoverExchRate | Forward Cover Exchange rate | |||
SM01187 | NVARCHAR | VSTRING | 15 | 0 | 15 | FwdCoverRef | Forward Cover Reference | |||
SM01188 | NCHAR | STRING | 2 | 0 | 2 | CurrCodeForCurrClause | Currency Code Currency Clause | |||
SM01189 | DATETIME | DATE | 0 | 0 | 8 | CurrencyClauseStartDate | Currency Clause Start Date | |||
SM01190 | DATETIME | DATE | 0 | 0 | 8 | CurrencyClauseEndDate | Currency clause End Date | |||
SM01191 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | ForwardCoverExchangeRate2 | Forward Cover Exchange Rate 2 | |||
SM01192 | NCHAR | STRING | 3 | 0 | 3 | ForwardCoverExchangeRateAlgorithm | Forward Cover Exchange Rate Algorithm | |||
SM01193 | INT | INTEGER | 0 | 0 | 1 | DocSpecHrs | Documents Specification 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 document |
||
SM01194 | INT | INTEGER | 0 | 0 | 1 | DocSpecCost | Documents Specification Costs | 1 — All cost lines are printed as a single total amount. 2 — Each cost transaction is printed on the document |
||
SM01195 | INT | INTEGER | 0 | 0 | 1 | DocSpecMat | Documents Specification Material | 1 — All material lines are printed as a single total amount. 2 — Each material transaction is printed on the document |
||
SM01196 | NCHAR | SWITCH | 1 | 0 | 1 | ConsolidDSDelivery | Consolidate DS Delivery | |||
SM01197 | NCHAR | STRING | 10 | 0 | 10 | ValueComponentNo | Value Component No | |||
SM01198 | NCHAR | STRING | 1 | 0 | 1 | CommissionDistributionMethod | Commission Distribution Method | |||
SM01199 | NCHAR | SWITCH | 1 | 0 | 1 | ExecutionOrderFlag | Execution Order flag | |||
SM01200 | INT | INTEGER | 0 | 0 | 4 | WCMaintenanceTaskID | WC Maintenance Task ID | |||
SM01201 | NCHAR | STRING | 2 | 0 | 2 | PMCounterQtyType | PM Counter Qty Type | |||
SM01202 | INT | INTEGER | 0 | 0 | 1 | DeliveryNoteSortOrder | Delivery Note Sort Order | |||
SM01203 | NCHAR | SWITCH | 1 | 0 | 1 | PrintDNAtPickConfirm | Print Delivery Note at picking confirmation | |||
SM01204 | NCHAR | SWITCH | 1 | 0 | 1 | SendDNPickConfirm | Send Delivery Note at picking confirmation | |||
SM01205 | INT | INTEGER | 0 | 0 | 1 | DeliveryBlocked | Delivery blocked | |||
SM01206 | NVARCHAR | VSTRING | 200 | 0 | 200 | EmailAddress | E-Mail Address | |||
SM01207 | NVARCHAR | VSTRING | 1 | 0 | 1 | PartialDeliveryPlanning | Partial Delivery Planning | 0 – allowed 1 – prohibited |
||
SM01208 | INT | INTEGER | 0 | 0 | 1 | CustomerForPricing | Customer for pricing | |||
SM01209 | NCHAR | SWITCH | 1 | 0 | 1 | CreditCheckPassed | Credit Check Passed | |||
SM01210 | NVARCHAR | VSTRING | 36 | 0 | 36 | ExternalID | External ID | |||
SM01211 | NCHAR | SWITCH | 1 | 0 | 1 | Red Storno Default | Red Storno Default | |||
SM01212 | NCHAR | STRING | 6 | 0 | 6 | InvPlanLineNo | InvPlanLineNo | |||
SM01213 | NVARCHAR | VSTRING | 20 | 0 | 20 | Public Procurement Code 1 | Public Procurement Code 1 | |||
SM01214 | NVARCHAR | VSTRING | 20 | 0 | 20 | Public Procurement Code 2 | Public Procurement Code 2 |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»
- Структура таблиц / 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 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»