Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SM33 - «WIP Transaction Journal». Маска имени таблицы: «SM33%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM33001 | NCHAR | STRING | 9 | 0 | 9 | TransactionNo | Transaction Number | 1 | Да | |
SM33002 | NCHAR | STRING | 7 | 0 | 7 | 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 | ContraAccount | Contra Account | |||
SM33033 | NUMERIC | NUMBER | 20 | 0 | 6 | JournalNumber | Journal Number | |||
SM33034 | NCHAR | STRING | 6 | 0 | 6 | PLReference | PL Reference | |||
SM33035 | NCHAR | STRING | 6 | 0 | 6 | SubProjectCode | Sub Project Code | |||
SM33036 | NCHAR | STRING | 6 | 0 | 6 | ActivityCode | Activity Code | |||
SM33037 | NCHAR | STRING | 8 | 0 | 8 | UserIdUpdatedBy | User Id Updated By | |||
SM33038 | DATETIME | DATE | 0 | 0 | 8 | UpdateDate | Update Date | |||
SM33039 | NCHAR | STRING | 2 | 0 | 2 | SourceCompany | Source Company | |||
SM33040 | NCHAR | STRING | 8 | 0 | 8 | UserIdPrintedBy | User Id Printed By | |||
SM33041 | DATETIME | DATE | 0 | 0 | 8 | DateOfPrint | Date of Print | |||
SM33042 | NCHAR | STRING | 2 | 0 | 2 | SourceModule | Source Module | |||
SM33043 | NVARCHAR | VSTRING | 25 | 0 | 25 | AASPosition | AAS position |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | WIP Transaction Journal