пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»

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

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PLM0001 NVARCHAR VSTRING 35 0 35 MandateReference Mandate Reference   2 Да / Yes
PLM0002 NVARCHAR VSTRING 10 0 10 DebtorCode Debtor Code      
PLM0003 NVARCHAR VSTRING 35 0 35 DebtorName Debtor Name      
PLM0004 NVARCHAR VSTRING 35 0 35 DebtorAddrLine1 Debtor Address Line 1      
PLM0005 NVARCHAR VSTRING 35 0 35 DebtorAddrLine2 Debtor Address Line 2      
PLM0006 NVARCHAR VSTRING 35 0 35 DebtorAddrLine3 Debtor Address Line 3      
PLM0007 NVARCHAR VSTRING 35 0 35 DebtorAddrLine4 Debtor Address Line 4      
PLM0008 NVARCHAR VSTRING 35 0 35 DebtorAddrLine5 Debtor Address Line 5      
PLM0009 NVARCHAR VSTRING 35 0 35 DebtorAddrLine6 Debtor Address Line 6      
PLM0010 NVARCHAR VSTRING 35 0 35 DebtorAddrLine7 Debtor Address Line 7      
PLM0011 NCHAR STRING 3 0 3 DebtorCountryCode Debtor Country Code      
PLM0012 NVARCHAR VSTRING 25 0 25 DebtorID Debtor ID      
PLM0013 NVARCHAR VSTRING 35 0 35 DebtorRefName Debtor Reference Name      
PLM0014 NVARCHAR VSTRING 25 0 25 DebtorReferenceID Debtor Reference ID      
PLM0015 NVARCHAR VSTRING 34 0 34 DebtorIBANAccount Debtor IBAN Account      
PLM0016 NVARCHAR VSTRING 25 0 25 UnderlyingContractID Underlying Contract ID      
PLM0017 NVARCHAR VSTRING 15 0 15 DebtorBankBICCode Debtor Bank BIC Code      
PLM0018 NVARCHAR VSTRING 25 0 25 CreditorID Creditor ID      
PLM0019 NVARCHAR VSTRING 35 0 35 CreditorName Creditor Name      
PLM0020 NVARCHAR VSTRING 35 0 35 CreditorRefName Creditor Reference Name      
PLM0021 NVARCHAR VSTRING 25 0 25 CreditorReferenceID Creditor Reference ID      
PLM0022 NVARCHAR VSTRING 35 0 35 CreditorAddressline1 Creditor Address line 1      
PLM0023 NVARCHAR VSTRING 35 0 35 CreditorAddressline2 Creditor Address line 2      
PLM0024 NVARCHAR VSTRING 35 0 35 CreditorAddressline3 Creditor Address line 3      
PLM0025 NVARCHAR VSTRING 35 0 35 CreditorAddressline4 Creditor Address line 4      
PLM0026 NVARCHAR VSTRING 35 0 35 CreditorAddressline5 Creditor Address line 5      
PLM0027 NVARCHAR VSTRING 35 0 35 CreditorAddressline6 Creditor Address line 6      
PLM0028 NVARCHAR VSTRING 35 0 35 CreditorAddressline7 Creditor Address line 7      
PLM0029 NCHAR STRING 3 0 3 CreditorCountryCode Creditor Country Code      
PLM0030 NVARCHAR VSTRING 50 0 50 SignedPlace Signed place      
PLM0031 NVARCHAR VSTRING 100 0 100 SignedBy Signed by      
PLM0032 DATETIME DATE 0 0 8 SignedDate Signed date      
PLM0033 NVARCHAR VSTRING 256 0 256 E-signature E-signature      
PLM0034 NCHAR STRING 1 0 1 PaymentType Type of payment      
PLM0035 DATETIME DATE 0 0 8 Validfromdate Valid from date      
PLM0036 DATETIME DATE 0 0 8 ValidToDate Valid up to date      
PLM0037 NCHAR STRING 1 0 1 RecordType Record Type      
PLM0038 NVARCHAR VSTRING 80 0 80 SpecialComment1 Special Comment1      
PLM0039 NVARCHAR VSTRING 80 0 80 SpecialComment2 Special Comment 2      
PLM0040 NVARCHAR VSTRING 80 0 80 SpecialComment3 Special Comment 3      
PLM0041 NVARCHAR VSTRING 80 0 80 ContractDescr Contract description      
PLM0042 NVARCHAR VSTRING 10 0 10 VersionNumber Version Number      
PLM0043 NCHAR STRING 3 0 3 DocLanguage Document language      
PLM0044 NVARCHAR VSTRING 8 0 8 ProposalCreatedBy Proposal created by      
PLM0045 DATETIME DATE 0 0 8 ProposalCreated Proposal created      
PLM0046 NVARCHAR VSTRING 8 0 8 ProposalPrintedBy Proposal printed by      
PLM0047 DATETIME DATE 0 0 8 ProposalPrinted Proposal printed      
PLM0048 NVARCHAR VSTRING 8 0 8 MandateCreatedBy Mandate created by      
PLM0049 DATETIME DATE 0 0 8 MandateCreated Mandate created      
PLM0050 NVARCHAR VSTRING 8 0 8 MandatePrintedBy Mandate printed by      
PLM0051 DATETIME DATE 0 0 8 MandatePrinted Mandate printed      
PLM0052 INT INTEGER 0 0 2 Priority Priority      
PLM0053 NVARCHAR VSTRING 10 0 10 Supplier Supplier   1 Да / Yes
PLM0054 NVARCHAR VSTRING 10 0 10 DebtorZipCode Debtor Zip-Code      
PLM0055 NVARCHAR VSTRING 10 0 10 DebtorCityCode Debtor City Code      
PLM0056 NVARCHAR VSTRING 10 0 10 CreditorZipCode Creditor Zip-Code      
PLM0057 NVARCHAR VSTRING 10 0 10 CreditorCityCode Creditor City Code      
PLM0058 NCHAR STRING 2 0 2 CreditorBankcode Creditor Bank code      

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