Таблица: MP9C - «WIP Transact. II». Маска имени таблицы: «MP9C%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP9C001 | NUMERIC | NUMBER | 20 | 0 | 9 | Reccounter | Record Counter | |||
MP9C002 | NCHAR | STRING | 9 | 0 | 9 | Transactno | Transaction Number | 1 | Да | |
MP9C003 | NCHAR | STRING | 7 | 0 | 7 | Linenumber | Line Number | 2 | Да | |
MP9C004 | DATETIME | DATE | 0 | 0 | 8 | Trandate | Transaction Date | |||
MP9C005 | NCHAR | SWITCH | 1 | 0 | 1 | Flag | Primary Line Currency | |||
MP9C006 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstring | Accounting String | |||
MP9C007 | NUMERIC | MONEY | 28 | 8 | 20 | Amount | Amount (Local Currency) | |||
MP9C008 | INT | INTEGER | 0 | 0 | 2 | Currcode | Currency Code Line | |||
MP9C009 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstrocu | Accounting String Line Currency | |||
MP9C010 | NUMERIC | MONEY | 28 | 8 | 20 | Amountocu | Amount (Line Currency) | |||
MP9C011 | NVARCHAR | VSTRING | 36 | 0 | 36 | Trantext | Transaction Line Text | |||
MP9C012 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Work Order Number | |||
MP9C013 | NVARCHAR | VSTRING | 25 | 0 | 25 | Code2 | Tool Number | |||
MP9C014 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Journal Code | |||
MP9C015 | NCHAR | STRING | 2 | 0 | 2 | Code4 | General Ledger Period | |||
MP9C016 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Stock Item Code | |||
MP9C017 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Work Centre | |||
MP9C018 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Period Allocation | |||
MP9C019 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Project Line Type | |||
MP9C020 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Transaction Flag | |||
MP9C021 | NCHAR | STRING | 1 | 0 | 1 | Tranlinetype | Line Type | |||
MP9C022 | NCHAR | STRING | 1 | 0 | 1 | Tranlinesign | Transaction Sign | |||
MP9C023 | NUMERIC | NUMBER | 20 | 0 | 1 | Noofdecimals | Number of Decimals | |||
MP9C024 | NCHAR | STRING | 5 | 0 | 5 | Linkcode | Link Code | |||
MP9C025 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
MP9C026 | INT | INTEGER | 0 | 0 | 4 | Unitcode | Unit Code | |||
MP9C027 | NUMERIC | MONEY | 28 | 8 | 20 | Amountccu | Amount (Alternative Currency) | |||
MP9C028 | NCHAR | STRING | 13 | 0 | 13 | Contraacc | Contra Account | |||
MP9C029 | NUMERIC | NUMBER | 20 | 0 | 6 | Journalno | Journal Number | |||
MP9C030 | NCHAR | STRING | 9 | 0 | 9 | Plreference | PL Reference | |||
MP9C031 | NCHAR | STRING | 6 | 0 | 6 | Subprjcode | Sub-Project Number | |||
MP9C032 | NCHAR | STRING | 6 | 0 | 6 | Activitycode | Activity Code | |||
MP9C033 | NCHAR | STRING | 8 | 0 | 8 | Usridentby | Entered By | |||
MP9C034 | DATETIME | DATE | 0 | 0 | 8 | Dateofentry | Date Entered | |||
MP9C035 | NCHAR | STRING | 8 | 0 | 8 | Usridupdby | Updated By | |||
MP9C036 | DATETIME | DATE | 0 | 0 | 8 | Dateofupd | Date Updated | |||
MP9C037 | NVARCHAR | VSTRING | 36 | 0 | 36 | Trantxtocu | Transaction Text Line Currency | |||
MP9C038 | NCHAR | STRING | 8 | 0 | 8 | Usridprnby | Printed By | |||
MP9C039 | DATETIME | DATE | 0 | 0 | 8 | Dateofprn | Date Printed | |||
MP9C040 | NVARCHAR | VSTRING | 25 | 0 | 25 | AASCode | AAS code |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | WIP Transactions Journal