Таблица: GL80 - «Un-Authorized Transactions (Greece)». Маска имени таблицы: «GL80%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GL80001 | NUMERIC | NUMBER | 20 | 0 | 9 | Reccounter | Record Counter | |||
GL80002 | NCHAR | STRING | 9 | 0 | 9 | Transactno | Transaction Number | 1 | Да | |
GL80003 | NCHAR | STRING | 7 | 0 | 7 | Linenumber | Line Number | 2 | Да | |
GL80004 | DATETIME | DATE | 0 | 0 | 8 | TranDate | Transaction Date | |||
GL80005 | NCHAR | SWITCH | 1 | 0 | 1 | Flag | Primary Line Currency | |||
GL80006 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstring | Accounting String | |||
GL80007 | NUMERIC | MONEY | 28 | 8 | 20 | Amountlcu | Amount (Local Currency) | |||
GL80008 | INT | INTEGER | 0 | 0 | 2 | Currcode | Currency Code Line | |||
GL80009 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstringocu | Accounting String Line Currency | |||
GL80010 | NUMERIC | MONEY | 28 | 8 | 20 | Amountocu | Amount (Line Currency) | |||
GL80011 | NVARCHAR | VSTRING | 36 | 0 | 36 | Trantext | Transaction Line Text | |||
GL80012 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Customer/Supplier Code | |||
GL80013 | NVARCHAR | VSTRING | 25 | 0 | 25 | Code2 | Document Number | |||
GL80014 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Journal Code | |||
GL80015 | NCHAR | STRING | 2 | 0 | 2 | Code4 | General Ledger Period | |||
GL80016 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Foreign Amount (Currency Account) | |||
GL80017 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Compound Allocation Switches | |||
GL80018 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Period Allocation | |||
GL80019 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Project Line Type | |||
GL80020 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Transaction Flag | |||
GL80021 | NCHAR | STRING | 1 | 0 | 1 | Tranlinetype | Line Type | |||
GL80022 | NCHAR | STRING | 1 | 0 | 1 | Tranlinesign | Transaction Sign | |||
GL80023 | NUMERIC | NUMBER | 20 | 0 | 1 | Noofdecimals | Number of Decimals | |||
GL80024 | NCHAR | STRING | 5 | 0 | 5 | Linkcode | Link Code | |||
GL80025 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
GL80026 | INT | INTEGER | 0 | 0 | 4 | Unitcode | Unit Code | |||
GL80027 | NUMERIC | MONEY | 28 | 8 | 20 | Amountccu | Amount (Alternative Currency) | |||
GL80028 | NCHAR | STRING | 13 | 0 | 13 | Contraacc | Contra Account | |||
GL80029 | NUMERIC | NUMBER | 20 | 0 | 6 | Journalno | Journal Number | |||
GL80030 | NCHAR | STRING | 9 | 0 | 9 | Plreference | PL Reference | |||
GL80031 | NCHAR | STRING | 6 | 0 | 6 | Subprjcode | Sub-Project Number | |||
GL80032 | NCHAR | STRING | 6 | 0 | 6 | Activitycode | Activity Code | |||
GL80033 | NCHAR | STRING | 8 | 0 | 8 | Usridupdby | UserID for Update | |||
GL80034 | DATETIME | DATE | 0 | 0 | 8 | Dateofentry | Date Entered | |||
GL80035 | NCHAR | STRING | 8 | 0 | 8 | Usridentby | UserID for Entry | |||
GL80036 | DATETIME | DATE | 0 | 0 | 8 | Dateofupd | Date Updated | |||
GL80037 | NVARCHAR | VSTRING | 36 | 0 | 36 | Trantxtocu | Transaction Text Line Currency | |||
GL80038 | NCHAR | STRING | 8 | 0 | 8 | Usridprnby | Printed By | |||
GL80039 | DATETIME | DATE | 0 | 0 | 8 | Dateofprn | Date Printed |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Un-Authorized Transactions (Greece)