Таблица: SM33 - «WIP Transaction Journal». Маска имени таблицы: «SM33%cc%yy»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM33001 | NCHAR | STRING | 6 | 0 | 6 | TransactionNo | Transaction Number | 1 | Да | |
SM33002 | NCHAR | STRING | 5 | 0 | 5 | LineNo | Line Number | 2 | Да | |
SM33003 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | Service Order Number | |||
SM33004 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
SM33005 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | WIPAmtLCU | WIP Amount (Local Currency) | |||
SM33006 | NCHAR | STRING | 8 | 0 | 8 | UserID | User | |||
SM33007 | DATETIME | DATE | 0 | 0 | 8 | EntryDate | Date Entered | |||
SM33008 | DATETIME | DATE | 0 | 0 | 8 | TransDate | Transaction Date | |||
SM33009 | NCHAR | STRING | 25 | 0 | 25 | TranText | Transaction Text | |||
SM33010 | INT | INTEGER | 0 | 0 | 1 | FlagPrinted | Line Printed | |||
SM33011 | NUMERIC | NUMBER | 20 | 0 | 8 | RecCounter | Record Counter | |||
SM33012 | INT | INTEGER | 0 | 0 | 2 | CurrCode | Currency Code | |||
SM33013 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccStringOCU | Accounting String OCU | |||
SM33014 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | Amount OCU | |||
SM33015 | NCHAR | STRING | 25 | 0 | 25 | TranTextOCU | Transaction Text OCU | |||
SM33016 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Customer/Supplier Code | |||
SM33017 | NCHAR | STRING | 23 | 0 | 23 | Code2 | Document Number | |||
SM33018 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Journal Code | |||
SM33019 | NCHAR | STRING | 2 | 0 | 2 | Code4 | General Ledger Period | |||
SM33020 | NCHAR | STRING | 35 | 0 | 35 | Code5 | Foreign Amount (Currency Account) | |||
SM33021 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Compound Allocation Switches | |||
SM33022 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Period Allocation | |||
SM33023 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Project Line Type | |||
SM33024 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Transaction Flag | |||
SM33025 | NCHAR | STRING | 1 | 0 | 1 | TranLineType | Transaction Line Type | |||
SM33026 | NCHAR | STRING | 1 | 0 | 1 | TranLineSign | Transaction Line Sign | |||
SM33027 | NUMERIC | NUMBER | 20 | 0 | 1 | NumOfDecimals | Number of decimals | |||
SM33028 | NCHAR | STRING | 5 | 0 | 5 | LinkCode | Link Code | |||
SM33029 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
SM33030 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Unit Code | |||
SM33031 | NUMERIC | MONEY | 28 | 8 | 20 | AmountCCU | Amount (Alternative Currency) | |||
SM33032 | NCHAR | STRING | 13 | 0 | 13 | Contra Account | Contra Account | |||
SM33033 | NUMERIC | NUMBER | 20 | 0 | 6 | Journal Number | Journal Number | |||
SM33034 | NCHAR | STRING | 6 | 0 | 6 | PL Reference | PL Reference | |||
SM33035 | NCHAR | STRING | 6 | 0 | 6 | SubProjectCode | Sub Project Code | |||
SM33036 | NCHAR | STRING | 6 | 0 | 6 | Activity Code | Activity Code | |||
SM33037 | NCHAR | STRING | 8 | 0 | 8 | User Id Updated By | User Id Updated By | |||
SM33038 | DATETIME | DATE | 0 | 0 | 8 | Update Date | Update Date | |||
SM33039 | NCHAR | STRING | 2 | 0 | 2 | Source Company | Source Company | |||
SM33040 | NCHAR | STRING | 8 | 0 | 8 | User Id Printed By | User Id Printed By | |||
SM33041 | DATETIME | DATE | 0 | 0 | 8 | Date of Print | Date of Print | |||
SM33042 | NCHAR | STRING | 2 | 0 | 2 | Source Module | Source Module |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Service Order Management | WIP Transaction Journal