Таблица: SM03 - «Service Order Activity File I/O». Маска имени таблицы: «SM03%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM03001 | NCHAR | STRING | 10 | 0 | 10 | ServOrderNo | Service Order Number | 1 | Да | |
SM03002 | NCHAR | STRING | 4 | 0 | 4 | ItemNo | Order Line Number | 2 | Да | |
SM03003 | NCHAR | STRING | 1 | 0 | 1 | LineType | Line Type | 0 - Normal activity line
5 - Linked picture 9 - Text line |
||
SM03004 | NCHAR | STRING | 8 | 0 | 8 | ActivityCode | Activity Code | |||
SM03005 | NVARCHAR | VSTRING | 35 | 0 | 35 | Description | Description | |||
SM03006 | NCHAR | STRING | 10 | 0 | 10 | FldEngineer | Resource Code Engineer | |||
SM03007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlannedHours | Hours Planned | |||
SM03008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ActualHours | Hours Actual | |||
SM03009 | NUMERIC | MONEY | 28 | 8 | 20 | SPARE | SPARE | |||
SM03010 | NUMERIC | MONEY | 28 | 8 | 20 | SPARE | SPARE | |||
SM03011 | NUMERIC | MONEY | 28 | 8 | 20 | BudgCostLCU | Unit Cost Planned (Local Currency) | |||
SM03012 | NUMERIC | MONEY | 28 | 8 | 20 | ActuaCostLCU | Unit Cost Actual (Local Currency) | |||
SM03013 | NCHAR | STRING | 4 | 0 | 4 | Spare | (obsolete) | |||
SM03014 | NUMERIC | MONEY | 28 | 8 | 20 | ProposInvAmoOcu | Unit Price Proposed for Invoice (Invoice Currency) | |||
SM03015 | NUMERIC | MONEY | 28 | 8 | 20 | ActualInvAmoOcu | Unit Price Actual Invoiced (Invoice Currency) | |||
SM03016 | NCHAR | STRING | 6 | 0 | 6 | VATCode1 | VAT Code 1 | |||
SM03017 | NCHAR | STRING | 2 | 0 | 2 | AccountCode | Accounting Code | |||
SM03018 | NCHAR | STRING | 6 | 0 | 6 | CostType | Cost Category | |||
SM03019 | NCHAR | STRING | 6 | 0 | 6 | CoveredByContract | Covered By Contract | 0 - The activity line is not covered by any contract
1 - The activity line is covered be a contract and will not be charged to the customer |
||
SM03020 | NCHAR | STRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SM03021 | NCHAR | SWITCH | 1 | 0 | 1 | IncludFixPr | Included in Fixed Price | |||
SM03022 | NCHAR | STRING | 10 | 0 | 10 | CustCodeInv | Customer Code Invoice | |||
SM03023 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | |||
SM03024 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | |||
SM03025 | NUMERIC | MONEY | 28 | 8 | 20 | PlannedPriceOCU | Unit Price Planned (Order Currency) | |||
SM03026 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
SM03027 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | DiscountLabour | Discount % | |||
SM03028 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursInvoice | Hours to Invoiced | |||
SM03029 | NCHAR | STRING | 2 | 0 | 2 | PricelistNo | Price List | |||
SM03030 | NCHAR | SWITCH | 1 | 0 | 1 | ChangeCustomer | Calculate Price | Option used internally to indicate if price needs to be recalculated on the activity line.
1 - The price on the activity line has not been recalculated after change of customer 2 - The price on the activity line has already been calculated for the customer on the order line |
||
SM03031 | INT | INTEGER | 0 | 0 | 1 | InvUpdStat | Invoice Status | 0/1 - The line has not been sent on a invoice
2 - The activity line has been sent/included in a invoice. |
||
SM03032 | NCHAR | STRING | 2 | 0 | 2 | Spare | (obsolete) | |||
SM03033 | NCHAR | STRING | 8 | 0 | 8 | PriceTabell | Price Table | |||
SM03034 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SM03035 | NCHAR | STRING | 6 | 0 | 6 | VATCode2 | VAT Code 2 | |||
SM03036 | DATETIME | DATE | 0 | 0 | 8 | ActivStrDate | Planned Start Date | |||
SM03037 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ActivStrTime | Planned Start Time | |||
SM03038 | DATETIME | DATE | 0 | 0 | 8 | ActivEndDate | Planned End Date | |||
SM03039 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ActivEndTime | Planned End Time | |||
SM03040 | INT | INTEGER | 0 | 0 | 1 | IncludedInCurrencyClause | Include in Currency Clause | |||
SM03041 | NCHAR | STRING | 2 | 0 | 2 | OrderCurrencyCode | Currency Code Order | |||
SM03042 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | CurrExchRate | Currency Exchange Rate | |||
SM03043 | NUMERIC | MONEY | 28 | 8 | 20 | SPARE | SPARE | |||
SM03044 | NUMERIC | MONEY | 28 | 8 | 20 | ActualPriceOCU | Unit Price Actual (Order Currency) | |||
SM03045 | NUMERIC | MONEY | 28 | 8 | 20 | SPARE | SPARE | |||
SM03046 | NUMERIC | MONEY | 28 | 8 | 20 | PropInvAmountIcu | Unit Price Proposed for Invoice (Order Currency) | |||
SM03047 | NUMERIC | MONEY | 28 | 8 | 20 | PropInvAmountLcu | Unit Price Proposed for Invoice (Local Currency) | |||
SM03048 | NUMERIC | MONEY | 28 | 8 | 20 | ActInvAmountIcu | Unit Price Actual Invoiced (Order Currency) | |||
SM03049 | NUMERIC | MONEY | 28 | 8 | 20 | ActInvAmountLCU | Unit Price Actual Invoiced (Local Currency) | |||
SM03050 | NCHAR | STRING | 2 | 0 | 2 | InvoiceCurrency | Currency Code Invoice | |||
SM03051 | NCHAR | SWITCH | 1 | 0 | 1 | StatusSwitch0 | Line Status 1 | |||
SM03052 | NCHAR | SWITCH | 1 | 0 | 1 | StatusSwitch1 | Line Status 2 | |||
SM03053 | NCHAR | SWITCH | 1 | 0 | 1 | StatusSwitch2 | Line Status 3 | |||
SM03054 | NCHAR | SWITCH | 1 | 0 | 1 | StatusSwitch3 | Line Status 4 | |||
SM03055 | NCHAR | SWITCH | 1 | 0 | 1 | StatusSwitch4 | Line Status 5 | |||
SM03056 | NCHAR | SWITCH | 1 | 0 | 1 | StatusSwitch5 | Marked for Invoice | Applies only to long term order:
0 - The activity line is not marked as ready for invoice 1 - The activity line is ready for invoice |
||
SM03057 | DATETIME | DATE | 0 | 0 | 8 | ActualStartDate | Actual Start Date | |||
SM03058 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ActualStrTime | Actual Start Time | |||
SM03059 | DATETIME | DATE | 0 | 0 | 8 | ActualEndDate | Actual End Date | |||
SM03060 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ActualEndTime | Actual End Time | |||
SM03061 | NCHAR | STRING | 150 | 0 | 150 | Predecessors | Predecessors MS Project | Reserved for use when integrating with MS project | ||
SM03062 | NCHAR | STRING | 6 | 0 | 6 | JobNo | Job Number | |||
SM03063 | NCHAR | STRING | 10 | 0 | 10 | CheckListID | Check List ID | |||
SM03064 | NCHAR | SWITCH | 1 | 0 | 1 | FlagCreatedbyJobOrder | Was Created from Job | |||
SM03065 | NCHAR | SWITCH | 1 | 0 | 1 | UseCustomICURate | Use Custom Invoice Currency Rate | |||
SM03066 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | CustomICURate | Custom Invoice Currency Exchange Rate 1 | |||
SM03067 | NUMERIC | X_NUMERIC | 23 | 8 | 15 | CustomICUExchRate2 | Custom Invoice Currency Exchange Rate 2 | |||
SM03068 | NCHAR | STRING | 3 | 0 | 3 | CustomICUExchRateAlg | Custom Invoice Currency Exchange Rate Algorithm | |||
SM03069 | NVARCHAR | VSTRING | 10 | 0 | 10 | OperationTypeTime | Operation Type Time | |||
SM03070 | NVARCHAR | VSTRING | 10 | 0 | 10 | FinancialOperationCodeTime | Financial Operation CodeTime | |||
SM03071 | NVARCHAR | VSTRING | 36 | 0 | 36 | LineGUID | Line GUID | |||
SM03072 | NVARCHAR | VSTRING | 6 | 0 | 6 | LineGroup | Line Group | |||
SM03073 | INT | INTEGER | 0 | 0 | 9 | JobID | JobID | |||
SM03074 | NVARCHAR | VSTRING | 20 | 0 | 20 | DelivNoteNo | Delivery Note Number | |||
SM03075 | INT | INTEGER | 0 | 0 | 1 | DeliveryBlocked | Delivery blocked | |||
SM03076 | NCHAR | SWITCH | 1 | 0 | 1 | ApprovedCreditLimit | Approved Credit Limit | |||
SM03077 | DATETIME | DATE | 0 | 0 | 8 | ConfirmedArrivalDate | Confirmed Arrival Date | Confirmed Arrival Date - 'Delivery Confirmation' functionality |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Service Order Activity Lines