One level Up / One level Up: Структура таблиц / 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 :: Таблица / 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 Identification Code      
PLM0013 NVARCHAR VSTRING 35 0 35 DebtorRefName Debtor Reference Name      
PLM0014 NVARCHAR VSTRING 25 0 25 DebtorReferenceID Debtor Identification of Reference Part      
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 Identification Code      
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 Identification of Reference Part      
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 Esignature 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 to Date      
PLM0037 NCHAR STRING 1 0 1 RecordType Record type      
PLM0038 NVARCHAR VSTRING 80 0 80 SpecialComment1 Special Comment 1      
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 date      
PLM0046 NVARCHAR VSTRING 8 0 8 ProposalPrintedBy Proposal printed by      
PLM0047 DATETIME DATE 0 0 8 ProposalPrinted Proposal printed date      
PLM0048 NVARCHAR VSTRING 8 0 8 MandateCreatedBy Mandate created by      
PLM0049 DATETIME DATE 0 0 8 MandateCreated Mandate created date      
PLM0050 NVARCHAR VSTRING 8 0 8 MandatePrintedBy Mandate printed by      
PLM0051 DATETIME DATE 0 0 8 MandatePrinted Mandate printed date      
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 Post Code      
PLM0055 NVARCHAR VSTRING 10 0 10 DebtorCityCode Debtor City Code      
PLM0056 NVARCHAR VSTRING 10 0 10 CreditorZipCode Creditor Post Code      
PLM0057 NVARCHAR VSTRING 10 0 10 CreditorCityCode Creditor City Code      
PLM0058 NCHAR STRING 2 0 2 CreditorBankcode Creditor Bank Code      

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