One level Up / One level Up: Структура таблиц / 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 :: Таблица / Table SLM0 — Mandate

Таблица / 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: