Таблица: SLE5 - «Sales Ledger Payment Provisional». Маска имени таблицы: «SLE5%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SLE5001 | NUMERIC | NUMBER | 20 | 0 | 9 | Reccounter | Reccounter | |||
SLE5002 | NCHAR | STRING | 9 | 0 | 9 | TransactNo | TransactNo | 1 | Да | |
SLE5003 | NCHAR | STRING | 7 | 0 | 7 | LineNo | LineNo | 2 | Да | |
SLE5004 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | TransactDate | |||
SLE5005 | NCHAR | SWITCH | 1 | 0 | 1 | Flag | Flag | |||
SLE5006 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccountString | AccountString | |||
SLE5007 | NUMERIC | MONEY | 28 | 8 | 20 | AmountLCU | AmountLCU | |||
SLE5008 | INT | INTEGER | 0 | 0 | 2 | CurrCode | CurrCode | |||
SLE5009 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccStringOCU | AccStringOCU | |||
SLE5010 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | AmountOCU | |||
SLE5011 | NVARCHAR | VSTRING | 36 | 0 | 36 | TransacText | TransacText | |||
SLE5012 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Code1 | |||
SLE5013 | NVARCHAR | VSTRING | 25 | 0 | 25 | Code2 | Code2 | |||
SLE5014 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Code3 | |||
SLE5015 | NCHAR | STRING | 2 | 0 | 2 | Code4 | Code4 | |||
SLE5016 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Code5 | |||
SLE5017 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Code6 | |||
SLE5018 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Tag1 | |||
SLE5019 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Tag2 | |||
SLE5020 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Tag3 | |||
SLE5021 | NCHAR | STRING | 1 | 0 | 1 | TransLineType | TransLineType | |||
SLE5022 | NCHAR | STRING | 1 | 0 | 1 | TransLineSign | TransLineSign | |||
SLE5023 | NUMERIC | NUMBER | 20 | 0 | 1 | NoDecimals | NoDecimals | |||
SLE5024 | NCHAR | STRING | 5 | 0 | 5 | Linkcode | Linkcode | |||
SLE5025 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
SLE5026 | INT | INTEGER | 0 | 0 | 4 | Unitcode | Unitcode | |||
SLE5027 | NUMERIC | MONEY | 28 | 8 | 20 | AmntOCU | AmountOCU | |||
SLE5028 | NCHAR | STRING | 13 | 0 | 13 | ContraAcc | ContraAcc | |||
SLE5029 | NUMERIC | NUMBER | 20 | 0 | 6 | JournalNo | JournalNo | |||
SLE5030 | NCHAR | STRING | 9 | 0 | 9 | PlReference | PlReference | |||
SLE5031 | NCHAR | STRING | 6 | 0 | 6 | SubprjCode | SubprjCode | |||
SLE5032 | NCHAR | STRING | 6 | 0 | 6 | ActivityCode | ActivityCode | |||
SLE5033 | NCHAR | STRING | 8 | 0 | 8 | UsrIdBy | UsrIdBy | |||
SLE5034 | DATETIME | DATE | 0 | 0 | 8 | DateEntry | DateEntry | |||
SLE5035 | NCHAR | STRING | 8 | 0 | 8 | UsrIdUpdBy | UsrIdUpdBy | |||
SLE5036 | DATETIME | DATE | 0 | 0 | 8 | dateUpd | dateUpd | |||
SLE5037 | NVARCHAR | VSTRING | 36 | 0 | 36 | TransTxtOCU | TransTxtOCU | |||
SLE5038 | NCHAR | STRING | 10 | 0 | 10 | PaxRate | PaxRate | |||
SLE5039 | NCHAR | STRING | 10 | 0 | 10 | PaxRate2 | PaxRate2 | |||
SLE5040 | NCHAR | STRING | 3 | 0 | 3 | PaAlgorithm | PaAlgorithm |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Sales Ledger Payment Provisional