На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SLMH — Mandate history

Таблица / Table: SLMH — «Mandate history». Маска имени таблицы / Table name mask: «SLMH%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLMH001 NVARCHAR VSTRING 35 0 35 MandateReference Mandate Reference   1 Да / Yes
SLMH002 NVARCHAR VSTRING 10 0 10 DebtorCode Debtor Code      
SLMH003 NVARCHAR VSTRING 35 0 35 DebtorName Debtor name      
SLMH004 NVARCHAR VSTRING 35 0 35 DebtorAddrLine1 Debtor Address line 1      
SLMH005 NVARCHAR VSTRING 35 0 35 DebtorAddrLine2 Debtor Address line 2      
SLMH006 NVARCHAR VSTRING 35 0 35 DebtorAddrLine3 Debtor Address line 3      
SLMH007 NVARCHAR VSTRING 35 0 35 DebtorAddrLine4 Debtor Address line 4      
SLMH008 NVARCHAR VSTRING 35 0 35 DebtorAddrLine5 Debtor Address line 5      
SLMH009 NVARCHAR VSTRING 35 0 35 DebtorAddrLine6 Debtor Address line 6      
SLMH010 NVARCHAR VSTRING 35 0 35 DebtorAddrLine7 Debtor Address line 7      
SLMH011 NCHAR STRING 3 0 3 DebtorCountryCode Debtor Country Code      
SLMH012 NVARCHAR VSTRING 25 0 25 DebtorID Debtor ID      
SLMH013 NVARCHAR VSTRING 35 0 35 DebtorRefName Debtor Reference name      
SLMH014 NVARCHAR VSTRING 25 0 25 DebtorReferenceID Debtor Reference ID      
SLMH015 NVARCHAR VSTRING 34 0 34 DebtorIBANaccount Debtor IBAN account      
SLMH016 NVARCHAR VSTRING 25 0 25 UnderlyingContractID Underlying Contract ID      
SLMH017 NVARCHAR VSTRING 15 0 15 DebtorBankBICcode Debtor Bank BIC code      
SLMH018 NVARCHAR VSTRING 25 0 25 CreditorID Creditor ID      
SLMH019 NVARCHAR VSTRING 35 0 35 CreditorName Creditor name      
SLMH020 NVARCHAR VSTRING 35 0 35 CreditorRefName Creditor Reference name      
SLMH021 NVARCHAR VSTRING 25 0 25 CreditorReferenceID Creditor Reference ID      
SLMH022 NVARCHAR VSTRING 35 0 35 CreditorAddressline1 Creditor Address line 1      
SLMH023 NVARCHAR VSTRING 35 0 35 CreditorAddressline2 Creditor Address line 2      
SLMH024 NVARCHAR VSTRING 35 0 35 CreditorAddressline3 Creditor Address line 3      
SLMH025 NVARCHAR VSTRING 35 0 35 CreditorAddressline4 Creditor Address line 4      
SLMH026 NVARCHAR VSTRING 35 0 35 CreditorAddressline5 Creditor Address line 5      
SLMH027 NVARCHAR VSTRING 35 0 35 CreditorAddressline6 Creditor Address line 6      
SLMH028 NVARCHAR VSTRING 35 0 35 CreditorAddressline7 Creditor Address line 7      
SLMH029 NCHAR STRING 3 0 3 CreditorCountryCode Creditor Country Code      
SLMH030 NVARCHAR VSTRING 50 0 50 SignedPlace Signed place      
SLMH031 NVARCHAR VSTRING 100 0 100 SignedBy Signed by      
SLMH032 DATETIME DATE 0 0 8 SignedDate Signed date      
SLMH033 NVARCHAR VSTRING 256 0 256 E-signature E-signature      
SLMH034 NCHAR STRING 1 0 1 PaymentType Type of payment      
SLMH035 DATETIME DATE 0 0 8 Validfromdate Valid from date      
SLMH036 DATETIME DATE 0 0 8 ValidToDate Valid up to date      
SLMH037 NCHAR STRING 1 0 1 RecordType Record Type      
SLMH038 NVARCHAR VSTRING 80 0 80 SpecialComment1 Special Comment1      
SLMH039 NVARCHAR VSTRING 80 0 80 SpecialComment2 Special Comment 2      
SLMH040 NVARCHAR VSTRING 80 0 80 SpecialComment3 Special Comment 3      
SLMH041 NVARCHAR VSTRING 80 0 80 ContractDescr Contract description      
SLMH042 NVARCHAR VSTRING 10 0 10 VersionNumber Version Number   2 Да / Yes
SLMH043 NCHAR STRING 3 0 3 DocLanguage Document language      
SLMH044 NVARCHAR VSTRING 8 0 8 ProposalCreatedBy Proposal created by      
SLMH045 DATETIME DATE 0 0 8 ProposalCreated Proposal created      
SLMH046 NVARCHAR VSTRING 8 0 8 ProposalPrintedBy Proposal printed by      
SLMH047 DATETIME DATE 0 0 8 ProposalPrinted Proposal printed      
SLMH048 NVARCHAR VSTRING 8 0 8 MandateCreatedBy Mandate created by      
SLMH049 DATETIME DATE 0 0 8 MandateCreated Mandate created      
SLMH050 NVARCHAR VSTRING 8 0 8 MandatePrintedBy Mandate printed by      
SLMH051 DATETIME DATE 0 0 8 MandatePrinted Mandate printed      
SLMH052 DATETIME DATE 0 0 8 MandateFirstUsed Mandate first used      
SLMH053 INT INTEGER 0 0 2 Priority Priority      
SLMH054 DATETIME DATE 0 0 8 MandateLastUsed Mandate last used      
SLMH055 INT INTEGER 0 0 1 Activated Activated      
SLMH056 NVARCHAR VSTRING 8 0 8 InactivatedBy Inactivated by      
SLMH057 DATETIME DATE 0 0 8 InactivatedDate Inactivated date      
SLMH058 NVARCHAR VSTRING 8 0 8 ActivatedBy Activated by      
SLMH059 DATETIME DATE 0 0 8 ActivatedDate Activated date      
SLMH060 NVARCHAR VSTRING 10 0 10 DebtorZipCode Debtor Zip-Code      
SLMH061 NVARCHAR VSTRING 10 0 10 DebtorCityCode Debtor City Code      
SLMH062 NVARCHAR VSTRING 10 0 10 CreditorZipCode Creditor Zip-Code      
SLMH063 NVARCHAR VSTRING 10 0 10 CreditorCityCode Creditor City Code      
SLMH064 NCHAR STRING 2 0 2 ReasonCodeChange Reason code change      
SLMH065 NVARCHAR VSTRING 8 0 8 MandateChangedBy Mandate changed by      
SLMH066 DATETIME DATE 0 0 8 MandateChanged Mandate changed      
SLMH067 NCHAR STRING 2 0 2 ReasonCodeDelete Reason code delete      
SLMH068 NVARCHAR VSTRING 8 0 8 MandateDeletedBy Mandate deleted by      
SLMH069 DATETIME DATE 0 0 8 MandateDeleted Mandate deleted      
SLMH070 NCHAR STRING 2 0 2 CreditorBankcode Creditor Bank code      

Навигация / Navigation: