Таблица | Table: SM13 - «Service Contract Line File I/O». Маска имени таблицы | Table Name Mask: «SM13%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SM13001 | NCHAR | STRING | 10 | 0 | 10 | ServContrNo | Service Contract Number | 1 | Да / Yes | |
SM13002 | NCHAR | STRING | 6 | 0 | 6 | LineNo | Contract Line Number | 2 | Да / Yes | |
SM13003 | NCHAR | STRING | 1 | 0 | 1 | LineType | Line Type | 0 - Normal contract line
9 - Text line |
||
SM13004 | NCHAR | STRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
SM13005 | NCHAR | STRING | 20 | 0 | 20 | SerialNo | Serial Number | |||
SM13006 | NVARCHAR | VSTRING | 25 | 0 | 25 | DescrLine1 | Description Line 1 | |||
SM13007 | NVARCHAR | VSTRING | 25 | 0 | 25 | DescrLine2 | Description Line 2 | |||
SM13008 | NUMERIC | MONEY | 28 | 8 | 20 | PricePerUnitOCU | Unit Price (Contract Currency) | |||
SM13009 | NCHAR | STRING | 1 | 0 | 1 | Spare | (obsolete) | |||
SM13010 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Discount | Discount % | |||
SM13011 | DATETIME | DATE | 0 | 0 | 8 | Date_EntryLine | Date Entered | |||
SM13012 | NCHAR | STRING | 3 | 0 | 3 | Contract_Type | Contract Type | |||
SM13013 | INT | INTEGER | 0 | 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. |
||
SM13014 | NCHAR | STRING | 2 | 0 | 2 | AccCode | Accounting Code | |||
SM13015 | NCHAR | STRING | 6 | 0 | 6 | JobCode | Job Number | |||
SM13016 | NCHAR | STRING | 6 | 0 | 6 | WH | Warehouse | |||
SM13017 | NCHAR | STRING | 7 | 0 | 7 | Spare | (obsolete) | |||
SM13018 | NCHAR | STRING | 6 | 0 | 6 | Spare | (obsolete) | |||
SM13019 | NCHAR | STRING | 6 | 0 | 6 | SalesTaxCode | VAT Code | |||
SM13020 | NCHAR | STRING | 7 | 0 | 7 | LineTax2 | VAT Code 2 | |||
SM13021 | DATETIME | DATE | 0 | 0 | 8 | NextInvDate | Next Invoice Date | |||
SM13022 | NCHAR | STRING | 4 | 0 | 4 | InstallatSite | Site Code | |||
SM13023 | DATETIME | DATE | 0 | 0 | 8 | Date_LineStart | Contract Line Start Date | |||
SM13024 | DATETIME | DATE | 0 | 0 | 8 | Date_LineEnd | Contract Line End Date | |||
SM13025 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | OverRespTime | Response Time Override | |||
SM13026 | INT | INTEGER | 0 | 0 | 1 | Status | Line Status | 0 - Normal contract line
1 - Changed invoice amount 2 - Cancelled line, by date 3 - Switched of line |
||
SM13027 | NUMERIC | MONEY | 28 | 8 | 20 | DebitCreditValueOCU | Debit/Credit Value (Contract Currency) | |||
SM13028 | NCHAR | STRING | 20 | 0 | 20 | ReasChngText | Change Reason | |||
SM13029 | DATETIME | DATE | 0 | 0 | 8 | StatusDate | Status Date | |||
SM13030 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SM13031 | DATETIME | DATE | 0 | 0 | 8 | DiscEndDate | Discount End Date | |||
SM13032 | NCHAR | STRING | 10 | 0 | 10 | CustCodeSite | Customer Code Installation Address | |||
SM13033 | NCHAR | STRING | 2 | 0 | 2 | ContactCurrency | Currency Code Contract | |||
SM13034 | NUMERIC | MONEY | 28 | 8 | 20 | PrevAccPrice | Previous Accrual Unit Price (Local Currency) | |||
SM13035 | DATETIME | DATE | 0 | 0 | 8 | DateAcCreated | Date Accruals Created | |||
SM13036 | DATETIME | DATE | 0 | 0 | 8 | DateContrClosed | Date Contract Closed | |||
SM13037 | NUMERIC | MONEY | 28 | 8 | 20 | AccumAccrAcount | Accumulated Accrual Amount (Local Currency) | |||
SM13038 | DATETIME | DATE | 0 | 0 | 8 | PrevAccrStartDate | Previous Accrual Start Date | |||
SM13039 | DATETIME | DATE | 0 | 0 | 8 | PrevAccrEndDate | Previous Accrual End Date | |||
SM13040 | NCHAR | STRING | 6 | 0 | 6 | SubLineNo | Contract Sub-line Number | 3 | Да / Yes | |
SM13041 | NCHAR | STRING | 2 | 0 | 2 | PriceList | Price List | |||
SM13042 | INT | INTEGER | 0 | 0 | 2 | Price_UnitCode | Unit Code Price | |||
SM13043 | NCHAR | STRING | 10 | 0 | 10 | CalendarID | Calendar ID | |||
SM13044 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty_Planned | Quantity Planned | |||
SM13045 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty_Actual | Quantity Actual | |||
SM13046 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RentalUnits_Actual | Quantity Actual Rental | |||
SM13047 | INT | INTEGER | 0 | 0 | 4 | UnitCode_Qty | Unit Code Quantity | |||
SM13048 | NCHAR | STRING | 4 | 0 | 4 | CntrLineStartTime | Contract Line Start Time | |||
SM13049 | NCHAR | STRING | 4 | 0 | 4 | CntrLineEndTime | Contract Line End Time | |||
SM13050 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | InvoiceQty | Invoice Qty | |||
SM13051 | DATETIME | DATE | 0 | 0 | 8 | RequestedDate | Requested Date | |||
SM13052 | DATETIME | DATE | 0 | 0 | 8 | ConfirmedDate | Confirmed Date | |||
SM13053 | DATETIME | DATE | 0 | 0 | 8 | LastUsedDate | Last Used Date | |||
SM13054 | DATETIME | DATE | 0 | 0 | 8 | AcceptedDate | AcceptedDate | |||
SM13055 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Spare | Spare | |||
SM13056 | NVARCHAR | VSTRING | 10 | 0 | 10 | Default Engineer | Default Engineer | |||
SM13057 | DATETIME | DATE | 0 | 0 | 8 | Expiry Date | Reservation Expiry Date | |||
SM13058 | NVARCHAR | VSTRING | 20 | 0 | 20 | ReqDelTimeRem | Requested Delivery Time remark | |||
SM13059 | NVARCHAR | VSTRING | 20 | 0 | 20 | AccDelTimeRem | Accepted Delivery Time remark | |||
SM13060 | DATETIME | DATE | 0 | 0 | 8 | Contract Line Pricing Date | Contract Line Pricing Date | |||
SM13061 | NCHAR | STRING | 10 | 0 | 10 | Contract Pricing Number | Contract Pricing Number | |||
SM13062 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | InvoiceNo | |||
SM13063 | NCHAR | STRING | 4 | 0 | 4 | Execution Line No | Execution Line No | |||
SM13064 | NCHAR | STRING | 1 | 0 | 1 | Lease Object Type | Lease Object Type | For lease contracts: Asset or Accessory | ||
SM13065 | INT | INTEGER | 0 | 0 | 1 | Lease Line Nature | Lease Line Nature | For lease contracts: Lease or Maintenance line | ||
SM13066 | NVARCHAR | VSTRING | 6 | 0 | 6 | Line Group Code | Line Group Code | |||
SM13067 | NVARCHAR | VSTRING | 10 | 0 | 10 | Value Component | Value Component | |||
SM13068 | NCHAR | SWITCH | 1 | 0 | 1 | Index Clause | Index Clause | |||
SM13069 | NUMERIC | MONEY | 28 | 8 | 20 | Deposit | Deposit | |||
SM13070 | NUMERIC | MONEY | 28 | 8 | 20 | Capital Value | Capital Value | |||
SM13071 | NUMERIC | MONEY | 28 | 8 | 20 | Residual Value | Residual Value | |||
SM13072 | NVARCHAR | VSTRING | 6 | 0 | 6 | Interest Rate Code | Interest Rate Code | |||
SM13073 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Interest Rate Percentage | Interest Rate Percentage | |||
SM13074 | INT | INTEGER | 0 | 0 | 3 | Interest Rate Time | Interest Rate Time | |||
SM13075 | INT | INTEGER | 0 | 0 | 1 | Interest Rate Time Unit | Interest Rate Time Unit | |||
SM13076 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Total Number of Periods | Total Number of Periods | |||
SM13077 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Current number of Periods | Current number of Periods | |||
SM13078 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Invoiced number of Periods | Invoiced number of Periods | |||
SM13079 | NUMERIC | MONEY | 28 | 8 | 20 | Lease Charge | Lease Charge | |||
SM13080 | NUMERIC | MONEY | 28 | 8 | 20 | Accumulated Depreciation | Accumulated Depreciation | |||
SM13081 | NCHAR | STRING | 6 | 0 | 6 | Execution Structure Line Number | Execution Structure Line Number | |||
SM13082 | NCHAR | STRING | 6 | 0 | 6 | Execution Sub Structure Line Number | Execution Sub Structure Line Number | |||
SM13083 | NCHAR | SWITCH | 1 | 0 | 1 | Create Service Order on Return | Create Service Order on Return | |||
SM13084 | INT | INTEGER | 0 | 0 | 3 | Days in Service | Days in Service | |||
SM13085 | NVARCHAR | VSTRING | 10 | 0 | 10 | Lease Contract No | Linked Lease Contract No | |||
SM13086 | NVARCHAR | VSTRING | 6 | 0 | 6 | Lease Line No | Linked Lease Contract Line No | |||
SM13087 | NVARCHAR | VSTRING | 6 | 0 | 6 | Lease Subline No | Linked Lease Contract Subline No | |||
SM13088 | NUMERIC | MONEY | 28 | 8 | 20 | Capital Charge | Capital Charge | |||
SM13089 | NUMERIC | MONEY | 28 | 8 | 20 | Interest Charge | Interest Charge | |||
SM13090 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Invoice Time Value | Invoice Time Value | |||
SM13091 | INT | INTEGER | 0 | 0 | 2 | Invoice Time Unit | Invoice Time Unit | |||
SM13092 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Prior Qty | Prior Qty | |||
SM13093 | DATETIME | DATE | 0 | 0 | 8 | Change Date | Change Date | |||
SM13094 | NCHAR | SWITCH | 1 | 0 | 1 | Use Best Price | Use Best Price | |||
SM13095 | INT | INTEGER | 0 | 0 | 9 | JobID | Job ID | |||
SM13096 | NCHAR | STRING | 6 | 0 | 6 | Service Order Type | Service Order Type | |||
SM13097 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Min Ordered Qty | Min Ordered Qty | |||
SM13098 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Delivery Time | Delivery Time | |||
SM13099 | INT | INTEGER | 0 | 0 | 2 | Delivery Time Unit | Delivery Time Unit | |||
SM13100 | INT | INTEGER | 0 | 0 | 1 | Subtype | Subtype | |||
SM13101 | NCHAR | SWITCH | 1 | 0 | 1 | Approved Credit Limit | Approved Credit Limit |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Service Contract Lines