На один уровень вверх / 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 PLMH — Mandate history

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PLMH001 NVARCHAR VSTRING 35 0 35 MandateReference Mandate Reference   2 Да / Yes
PLMH002 NVARCHAR VSTRING 10 0 10 DebtorCode Debtor Code      
PLMH003 NVARCHAR VSTRING 35 0 35 DebtorName Debtor name      
PLMH004 NVARCHAR VSTRING 35 0 35 DebtorAddrLine1 Debtor Address line 1      
PLMH005 NVARCHAR VSTRING 35 0 35 DebtorAddrLine2 Debtor Address line 2      
PLMH006 NVARCHAR VSTRING 35 0 35 DebtorAddrLine3 Debtor Address line 3      
PLMH007 NVARCHAR VSTRING 35 0 35 DebtorAddrLine4 Debtor Address line 4      
PLMH008 NVARCHAR VSTRING 35 0 35 DebtorAddrLine5 Debtor Address line 5      
PLMH009 NVARCHAR VSTRING 35 0 35 DebtorAddrLine6 Debtor Address line 6      
PLMH010 NVARCHAR VSTRING 35 0 35 DebtorAddrLine7 Debtor Address line 7      
PLMH011 NCHAR STRING 3 0 3 DebtorCountryCode Debtor Country Code      
PLMH012 NVARCHAR VSTRING 25 0 25 DebtorID Debtor ID      
PLMH013 NVARCHAR VSTRING 35 0 35 DebtorRefName Debtor Reference name      
PLMH014 NVARCHAR VSTRING 25 0 25 DebtorReferenceID Debtor Reference ID      
PLMH015 NVARCHAR VSTRING 34 0 34 DebtorIBANaccount Debtor IBAN account      
PLMH016 NVARCHAR VSTRING 25 0 25 UnderlyingContractID Underlying Contract ID      
PLMH017 NVARCHAR VSTRING 15 0 15 DebtorBankBICcode Debtor Bank BIC code      
PLMH018 NVARCHAR VSTRING 25 0 25 CreditorID Creditor ID      
PLMH019 NVARCHAR VSTRING 35 0 35 CreditorName Creditor name      
PLMH020 NVARCHAR VSTRING 35 0 35 CreditorRefName Creditor Reference name      
PLMH021 NVARCHAR VSTRING 25 0 25 CreditorReferenceID Creditor Reference ID      
PLMH022 NVARCHAR VSTRING 35 0 35 CreditorAddressline1 Creditor Address line 1      
PLMH023 NVARCHAR VSTRING 35 0 35 CreditorAddressline2 Creditor Address line 2      
PLMH024 NVARCHAR VSTRING 35 0 35 CreditorAddressline3 Creditor Address line 3      
PLMH025 NVARCHAR VSTRING 35 0 35 CreditorAddressline4 Creditor Address line 4      
PLMH026 NVARCHAR VSTRING 35 0 35 CreditorAddressline5 Creditor Address line 5      
PLMH027 NVARCHAR VSTRING 35 0 35 CreditorAddressline6 Creditor Address line 6      
PLMH028 NVARCHAR VSTRING 35 0 35 CreditorAddressline7 Creditor Address line 7      
PLMH029 NCHAR STRING 3 0 3 CreditorCountryCode Creditor Country Code      
PLMH030 NVARCHAR VSTRING 50 0 50 SignedPlace Signed place      
PLMH031 NVARCHAR VSTRING 100 0 100 SignedBy Signed by      
PLMH032 DATETIME DATE 0 0 8 SignedDate Signed date      
PLMH033 NVARCHAR VSTRING 256 0 256 E-signature E-signature      
PLMH034 NCHAR STRING 1 0 1 PaymentType Type of payment      
PLMH035 DATETIME DATE 0 0 8 Validfromdate Valid from date      
PLMH036 DATETIME DATE 0 0 8 ValidToDate Valid up to date      
PLMH037 NCHAR STRING 1 0 1 RecordType Record Type      
PLMH038 NVARCHAR VSTRING 80 0 80 SpecialComment1 Special Comment 1      
PLMH039 NVARCHAR VSTRING 80 0 80 SpecialComment2 Special Comment 2      
PLMH040 NVARCHAR VSTRING 80 0 80 SpecialComment3 Special Comment 3      
PLMH041 NVARCHAR VSTRING 80 0 80 ContractDescr Contract description      
PLMH042 NVARCHAR VSTRING 10 0 10 VersionNumber Version Number   3 Да / Yes
PLMH043 NCHAR STRING 3 0 3 DocLanguage Document language      
PLMH044 NVARCHAR VSTRING 8 0 8 ProposalCreatedBy Proposal created by      
PLMH045 DATETIME DATE 0 0 8 ProposalCreated Proposal created      
PLMH046 NVARCHAR VSTRING 8 0 8 ProposalPrintedBy Proposal printed by      
PLMH047 DATETIME DATE 0 0 8 ProposalPrinted Proposal printed      
PLMH048 NVARCHAR VSTRING 8 0 8 MandateCreatedBy Mandate created by      
PLMH049 DATETIME DATE 0 0 8 MandateCreated Mandate created      
PLMH050 NVARCHAR VSTRING 8 0 8 MandatePrintedBy Mandate printed by      
PLMH051 DATETIME DATE 0 0 8 MandatePrinted Mandate printed      
PLMH052 INT INTEGER 0 0 2 Priority Priority      
PLMH053 NVARCHAR VSTRING 10 0 10 Supplier Supplier   1 Да / Yes
PLMH054 NVARCHAR VSTRING 10 0 10 DebtorZipCode Debtor Zip-Code      
PLMH055 NVARCHAR VSTRING 10 0 10 DebtorCityCode Debtor City Code      
PLMH056 NVARCHAR VSTRING 10 0 10 CreditorZipCode Creditor Zip-Code      
PLMH057 NVARCHAR VSTRING 10 0 10 CreditorCityCode Creditor City Code      
PLMH058 NCHAR STRING 2 0 2 ReasonCodeChange Reason code change      
PLMH059 NVARCHAR VSTRING 8 0 8 MandateChangedBy Mandate changed by      
PLMH060 DATETIME DATE 0 0 8 MandateChanged Mandate changed      
PLMH061 NCHAR STRING 2 0 2 ReasonCodeDelete Reason code delete      
PLMH062 NVARCHAR VSTRING 8 0 8 MandateDeletedBy Mandate deleted by      
PLMH063 DATETIME DATE 0 0 8 MandateDeleted Mandate deleted      
PLMH064 NCHAR STRING 2 0 2 CreditorBankcode Creditor Bank code      

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