Таблица: SM31 - «WIP Transaction Journal». Маска имени таблицы: «SM31%cc%yy»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM31001 | NUMERIC | NUMBER | 20 | 0 | 8 | Reccounter | Record Counter | |||
SM31002 | NCHAR | STRING | 6 | 0 | 6 | Transactno | Transaction Number | 1 | Да | |
SM31003 | NCHAR | STRING | 5 | 0 | 5 | Linenumber | Line Number | 2 | Да | |
SM31004 | DATETIME | DATE | 0 | 0 | 8 | Trandate | Transaction Date | |||
SM31005 | NCHAR | SWITCH | 1 | 0 | 1 | Flag | Primary Line Currency | |||
SM31006 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstring | Accounting String | |||
SM31007 | NUMERIC | MONEY | 28 | 8 | 20 | Amountlcu | Amount (Local Currency) | |||
SM31008 | INT | INTEGER | 0 | 0 | 2 | Currcode | Currency Code Line | |||
SM31009 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstringocu | Accounting String Line Currency | |||
SM31010 | NUMERIC | MONEY | 28 | 8 | 20 | Amountocu | Amount (Line Currency) | |||
SM31011 | NVARCHAR | VSTRING | 25 | 0 | 25 | Trantext | Transaction Line Text | |||
SM31012 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Customer | |||
SM31013 | NVARCHAR | VSTRING | 23 | 0 | 23 | Code2 | Transaction Code 2 | |||
SM31014 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Transaction Code 3 | |||
SM31015 | NCHAR | STRING | 2 | 0 | 2 | Code4 | Transaction Code 4 | |||
SM31016 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Contract Number | |||
SM31017 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Transaction Code 6 | |||
SM31018 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Transaction Tag 1 | |||
SM31019 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Transaction Tag 2 | |||
SM31020 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Transaction Tag 3 | |||
SM31021 | NCHAR | STRING | 1 | 0 | 1 | Tranlinetype | Line Type | |||
SM31022 | NCHAR | STRING | 1 | 0 | 1 | Tranlinesign | Transaction Sign | |||
SM31023 | NUMERIC | NUMBER | 20 | 0 | 1 | Noofdecimals | Number of Decimals | |||
SM31024 | NCHAR | STRING | 5 | 0 | 5 | Linkcode | Link Code | |||
SM31025 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
SM31026 | NCHAR | STRING | 2 | 0 | 2 | Unitcode | Unit Code | |||
SM31027 | NUMERIC | MONEY | 28 | 8 | 20 | Amountccu | Amount (Alternative Currency) | |||
SM31028 | NCHAR | STRING | 13 | 0 | 13 | contraacc | Contra Account | |||
SM31029 | NUMERIC | NUMBER | 20 | 0 | 6 | Journalno | Journal Number | |||
SM31030 | NCHAR | STRING | 6 | 0 | 6 | Plreference | PL Reference | |||
SM31031 | NCHAR | STRING | 6 | 0 | 6 | Subprjcode | Sub-Project Number | |||
SM31032 | NCHAR | STRING | 6 | 0 | 6 | Activitycode | Activity Code | |||
SM31033 | NCHAR | STRING | 8 | 0 | 8 | Usridentby | Entered By | |||
SM31034 | DATETIME | DATE | 0 | 0 | 8 | Dateofentry | Date Entered | |||
SM31035 | NCHAR | STRING | 8 | 0 | 8 | Usridupdby | Updated By | |||
SM31036 | DATETIME | DATE | 0 | 0 | 8 | Dateofupd | Date Updated | |||
SM31037 | NVARCHAR | VSTRING | 25 | 0 | 25 | Trantxtocu | Transaction Text Line Currency |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | WIP Transaction Journal