Таблица / Table: SLM0 — «Mandate». Маска имени таблицы / Table name mask: «SLM0%cc00»
Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
SLM0001 | NVARCHAR | VSTRING | 35 | 0 | 35 | MandateReference | Mandate Reference | 1 | Да / Yes | |
SLM0002 | NVARCHAR | VSTRING | 10 | 0 | 10 | DebtorCode | Debtor Code | |||
SLM0003 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorName | Debtor Name | |||
SLM0004 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorAddrLine1 | Debtor Address Line 1 | |||
SLM0005 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorAddrLine2 | Debtor Address Line 2 | |||
SLM0006 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorAddrLine3 | Debtor Address Line 3 | |||
SLM0007 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorAddrLine4 | Debtor Address Line 4 | |||
SLM0008 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorAddrLine5 | Debtor Address Line 5 | |||
SLM0009 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorAddrLine6 | Debtor Address Line 6 | |||
SLM0010 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorAddrLine7 | Debtor Address Line 7 | |||
SLM0011 | NCHAR | STRING | 3 | 0 | 3 | DebtorCountryCode | Debtor Country Code | |||
SLM0012 | NVARCHAR | VSTRING | 25 | 0 | 25 | DebtorID | Debtor Identification Code | |||
SLM0013 | NVARCHAR | VSTRING | 35 | 0 | 35 | DebtorRefName | Debtor Reference Name | |||
SLM0014 | NVARCHAR | VSTRING | 25 | 0 | 25 | DebtorReferenceID | Debtor Identification of Reference Part | |||
SLM0015 | NVARCHAR | VSTRING | 34 | 0 | 34 | DebtorIBANAccount | Debtor IBAN Account | |||
SLM0016 | NVARCHAR | VSTRING | 25 | 0 | 25 | UnderlyingContractID | Underlying Contract ID | |||
SLM0017 | NVARCHAR | VSTRING | 15 | 0 | 15 | DebtorBankBICCode | Debtor Bank BIC Code | |||
SLM0018 | NVARCHAR | VSTRING | 25 | 0 | 25 | CreditorID | Creditor Identification Code | |||
SLM0019 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorName | Creditor Name | |||
SLM0020 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorRefName | Creditor Reference Name | |||
SLM0021 | NVARCHAR | VSTRING | 25 | 0 | 25 | CreditorReferenceID | Creditor Identification of Reference Part | |||
SLM0022 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorAddressline1 | Creditor Address line 1 | |||
SLM0023 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorAddressline2 | Creditor Address line 2 | |||
SLM0024 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorAddressline3 | Creditor Address line 3 | |||
SLM0025 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorAddressline4 | Creditor Address line 4 | |||
SLM0026 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorAddressline5 | Creditor Address line 5 | |||
SLM0027 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorAddressline6 | Creditor Address line 6 | |||
SLM0028 | NVARCHAR | VSTRING | 35 | 0 | 35 | CreditorAddressline7 | Creditor Address line 7 | |||
SLM0029 | NCHAR | STRING | 3 | 0 | 3 | CreditorCountryCode | Creditor Country Code | |||
SLM0030 | NVARCHAR | VSTRING | 50 | 0 | 50 | SignedPlace | Signed Place | |||
SLM0031 | NVARCHAR | VSTRING | 100 | 0 | 100 | SignedBy | Signed by | |||
SLM0032 | DATETIME | DATE | 0 | 0 | 8 | SignedDate | Signed Date | |||
SLM0033 | NVARCHAR | VSTRING | 256 | 0 | 256 | E-signature | E-signature | |||
SLM0034 | NCHAR | STRING | 1 | 0 | 1 | PaymentType | Type of Payment | |||
SLM0035 | DATETIME | DATE | 0 | 0 | 8 | Validfromdate | Valid from Date | |||
SLM0036 | DATETIME | DATE | 0 | 0 | 8 | ValidToDate | Valid to Date | |||
SLM0037 | NCHAR | STRING | 1 | 0 | 1 | RecordType | Record type | |||
SLM0038 | NVARCHAR | VSTRING | 80 | 0 | 80 | SpecialComment1 | Special Comment 1 | |||
SLM0039 | NVARCHAR | VSTRING | 80 | 0 | 80 | SpecialComment2 | Special Comment 2 | |||
SLM0040 | NVARCHAR | VSTRING | 80 | 0 | 80 | SpecialComment3 | Special Comment 3 | |||
SLM0041 | NVARCHAR | VSTRING | 80 | 0 | 80 | ContractDescr | Contract Description | |||
SLM0042 | NVARCHAR | VSTRING | 10 | 0 | 10 | VersionNumber | Version number | |||
SLM0043 | NCHAR | STRING | 3 | 0 | 3 | DocLanguage | Document Language | |||
SLM0044 | NVARCHAR | VSTRING | 8 | 0 | 8 | ProposalCreatedBy | Proposal created by | |||
SLM0045 | DATETIME | DATE | 0 | 0 | 8 | ProposalCreated | Proposal created date | |||
SLM0046 | NVARCHAR | VSTRING | 8 | 0 | 8 | ProposalPrintedBy | Proposal printed by | |||
SLM0047 | DATETIME | DATE | 0 | 0 | 8 | ProposalPrinted | Proposal printed date | |||
SLM0048 | NVARCHAR | VSTRING | 8 | 0 | 8 | MandateCreatedBy | Mandate created by | |||
SLM0049 | DATETIME | DATE | 0 | 0 | 8 | MandateCreated | Mandate created date | |||
SLM0050 | NVARCHAR | VSTRING | 8 | 0 | 8 | MandatePrintedBy | Mandate printed by | |||
SLM0051 | DATETIME | DATE | 0 | 0 | 8 | MandatePrinted | Mandate printed date | |||
SLM0052 | DATETIME | DATE | 0 | 0 | 8 | MandateFirstUsed | Mandate first used | |||
SLM0053 | INT | INTEGER | 0 | 0 | 2 | Priority | Priority | |||
SLM0054 | DATETIME | DATE | 0 | 0 | 8 | MandateLastUsed | Mandate last used | |||
SLM0055 | INT | INTEGER | 0 | 0 | 1 | Activated | Activated | |||
SLM0056 | NVARCHAR | VSTRING | 8 | 0 | 8 | InactivatedBy | Inactivated by | |||
SLM0057 | DATETIME | DATE | 0 | 0 | 8 | InactivatedDate | Inactivated date | |||
SLM0058 | NVARCHAR | VSTRING | 8 | 0 | 8 | ActivatedBy | Activated by | |||
SLM0059 | DATETIME | DATE | 0 | 0 | 8 | ActivatedDate | Activated date | |||
SLM0060 | NVARCHAR | VSTRING | 10 | 0 | 10 | DebtorZipCode | Debtor Post Code | |||
SLM0061 | NVARCHAR | VSTRING | 10 | 0 | 10 | DebtorCityCode | Debtor City Code | |||
SLM0062 | NVARCHAR | VSTRING | 10 | 0 | 10 | CreditorZipCode | Creditor Post Code | |||
SLM0063 | NVARCHAR | VSTRING | 10 | 0 | 10 | CreditorCityCode | Creditor City Code | |||
SLM0064 | NCHAR | STRING | 2 | 0 | 2 | CreditorBankcode | Creditor Bank Code | |||
SLM0065 | INT | INTEGER | 0 | 0 | 1 | UsedInProposal | Used in proposal |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «System Utilities/Office Autom.»