Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SLE3 - «Bank/Agent». Маска имени таблицы: «SLE3%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SLE3001 | NCHAR | STRING | 2 | 0 | 2 | Bank/AgentCode | Bank/AgentCode | 1 | Да | |
SLE3002 | NVARCHAR | VSTRING | 25 | 0 | 25 | Bank/AgentName | Bank/AgentName | |||
SLE3003 | NUMERIC | MONEY | 28 | 8 | 20 | DiscountLimit | DiscountLimit | |||
SLE3004 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccountingStringCashAccount | AccountingStringCashAccount | |||
SLE3005 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reserved | Reserved | |||
SLE3006 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reserved | Reserved | |||
SLE3007 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reserved | Reserved | |||
SLE3008 | NVARCHAR | VSTRING | 3 | 0 | 3 | WaitingDays | WaitingDays | |||
SLE3009 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccountingStringRiskAccount | AccountingStringRiskAccount | |||
SLE3010 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reserved | Reserved | |||
SLE3011 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reserved | Reserved | |||
SLE3012 | NVARCHAR | VSTRING | 1 | 0 | 1 | Reserved | Reserved | |||
SLE3013 | NUMERIC | MONEY | 28 | 8 | 20 | AmountRisk | AmountRisk | |||
SLE3014 | NVARCHAR | VSTRING | 20 | 0 | 20 | AmountNotRisk | AmountNotRisk | |||
SLE3015 | NVARCHAR | VSTRING | 4 | 0 | 4 | BankCode | BankCode | |||
SLE3016 | NVARCHAR | VSTRING | 4 | 0 | 4 | BankOfficeCode | BankOfficeCode | |||
SLE3017 | NVARCHAR | VSTRING | 10 | 0 | 10 | BankAccountNo | BankAccountNo | |||
SLE3018 | NVARCHAR | VSTRING | 2 | 0 | 2 | BankAccountNoCD | BankAccountNoCD | |||
SLE3019 | NVARCHAR | VSTRING | 35 | 0 | 35 | BankAAddress1 | BankAAddress1 | |||
SLE3020 | NVARCHAR | VSTRING | 35 | 0 | 35 | BankAAddress2 | BankAAddress2 | |||
SLE3021 | NVARCHAR | VSTRING | 35 | 0 | 35 | BankAAddress3 | BankAAddress3 | |||
SLE3022 | NVARCHAR | VSTRING | 15 | 0 | 15 | AssignorCodeNorm32 | AssignorCodeNorm32 | |||
SLE3023 | NVARCHAR | VSTRING | 15 | 0 | 15 | AssignorCodeNorm58 | AssignorCodeNorm58 | |||
SLE3024 | NVARCHAR | VSTRING | 15 | 0 | 15 | AssignorCodeNorm19 | AssignorCodeNorm19 | |||
SLE3025 | NVARCHAR | VSTRING | 6 | 0 | 6 | SupportNoNorm32 | SupportNoNorm32 | |||
SLE3026 | NVARCHAR | VSTRING | 6 | 0 | 6 | SupportNoNorm58 | SupportNoNorm58 | |||
SLE3027 | NVARCHAR | VSTRING | 6 | 0 | 6 | SupportNoNorm19 | SupportNoNorm19 | |||
SLE3028 | NVARCHAR | VSTRING | 35 | 0 | 35 | Path&NameFile | Path&NameFile | |||
SLE3029 | NVARCHAR | VSTRING | 2 | 0 | 2 | IBANISOCountryCode | IBAN ISO Country Code | |||
SLE3030 | NVARCHAR | VSTRING | 2 | 0 | 2 | ControlDigitsIBAN | Control Digits IBAN |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Sales Ledger | Bank/Agent