One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Purchase Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PLE0 — Spain Payment Parameters

Таблица: PLE0 — «Spain Payment Parameters». Маска имени таблицы: «PLE0%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PLE0001 NCHAR STRING 10 0 10 BankCode Bank Code Bank Code 1 Да
PLE0002 NVARCHAR VSTRING 15 0 15 CodeOrderingParty Code Ordering Party Code of the ordering party    
PLE0003 NVARCHAR VSTRING 1 0 1 DetailCharge Detail Charge Detail of the charge    
PLE0004 DATETIME DATE 0 0 8 DateFileCreation Date File Creation Date of file creation    
PLE0005 DATETIME DATE 0 0 8 DateIssue Date Issue Date of issue of the payment orders    
PLE0006 NVARCHAR VSTRING 4 0 4 CCCOrganizationCode CCC Organization Code CCC Organization Code    
PLE0007 NVARCHAR VSTRING 4 0 4 CCCBranchCode CCC Branch Code CCC Branch Code    
PLE0008 NVARCHAR VSTRING 11 0 11 CCCAccountNumber CCC Account Number CCC Account Number    
PLE0009 NVARCHAR VSTRING 2 0 2 CCCControlDigits CCC Control Digits CCC Control Digits    
PLE0010 NVARCHAR VSTRING 36 0 36 NameOrderingParty Name Ordering Party Name of the Ordering Party    
PLE0011 NVARCHAR VSTRING 36 0 36 AddressOrderingParty Address Ordering Party Address of the Ordering Party    
PLE0012 NVARCHAR VSTRING 36 0 36 LocationOrderingParty Location Ordering Party Location of the Ordering Party    
PLE0013 NVARCHAR VSTRING 200 0 200 OutputFilePath Output File Path Output File Path    
PLE0014 NVARCHAR VSTRING 1 0 1 BankCharges Bank Charges Bank Charges    
PLE0015 NVARCHAR VSTRING 1 0 1 PaymentType Payment Type Payment Type    
PLE0016 NVARCHAR VSTRING 1 0 1 CrossedChequePN Crossed Cheque/Promissory Note Crossed Cheque/Promissory Note    
PLE0017 NVARCHAR VSTRING 1 0 1 ByPost By Post By Post    
PLE0018 NVARCHAR VSTRING 1 0 1 OrderPN Order Promissory Notes Order for promissory notes    
PLE0019 NVARCHAR VSTRING 1 0 1 PaymentLedgerEntry Payment Ledger Entry Payment Ledger Entry    
PLE0020 NVARCHAR VSTRING 1 0 1 GroupPayments Group Payments Group Payments    
PLE0021 NVARCHAR VSTRING 12 0 12 ChequeGLAccount Cheque GL Account Cheque GL Account    
PLE0022 NVARCHAR VSTRING 12 0 12 PNGLAccount Promissory Note GL Account Promissory Note GL Account    
PLE0023 NVARCHAR VSTRING 12 0 12 TransferGLAccount Transfer GL Account Transfer GL Account    
PLE0024 NVARCHAR VSTRING 6 0 6 OutputFilesCounter Output Files Counter Output Files Counter    
PLE0025 NVARCHAR VSTRING 6 0 6 NumberSuffix NumberSuffix Number Suffix    
PLE0026 NVARCHAR VSTRING 4 0 4 IDCodeCheque ID Code Cheque ID Code Cheque    
PLE0027 NVARCHAR VSTRING 1 0 1 IDControlCheque ID Control Cheque ID Control Cheque    
PLE0028 NVARCHAR VSTRING 7 0 7 InitialCounterCheque Initial Counter Cheque Initial Counter Cheque    
PLE0029 NVARCHAR VSTRING 7 0 7 LastPrintCounterCheque Last Print Counter Cheque Last printer Counter Cheque    
PLE0030 NVARCHAR VSTRING 7 0 7 LastCounterCheque Last Counter Cheque Last Counter Cheque    
PLE0031 NVARCHAR VSTRING 4 0 4 IDCodePN ID Code Promissory Note ID Code Promissory Note    
PLE0032 NVARCHAR VSTRING 1 0 1 IDControlPN ID Control Promissory Note ID Control Promissory Note    
PLE0033 NVARCHAR VSTRING 7 0 7 InitialCounterPN Initial Counter Promissory Note Initial Counter Promissory Note    
PLE0034 NVARCHAR VSTRING 7 0 7 LastPrintCounterPN Last Print Counter Promissory Note Last Printer Counter Promissory Note    
PLE0035 NVARCHAR VSTRING 7 0 7 LastCounterPN Last Counter Promissory Note Last Counter Promissory Note    
PLE0036 NVARCHAR VSTRING 1 0 1 Status Status Status    
PLE0037 NVARCHAR VSTRING 2 0 2 IBANISOCountryCode IBAN ISO Country Code IBAN ISO Country Code    
PLE0038 NVARCHAR VSTRING 2 0 2 IBANCheckDigits IBAN Check Digits IBAN Check Digits    
PLE0039 NVARCHAR VSTRING 4 0 4 Spare Spare Spare    
PLE0040 NVARCHAR VSTRING 10 0 10 Spare Spare Spare    
PLE0041 NVARCHAR VSTRING 1 0 1 ChequeLayout Cheque Layout Cheque Layout    
PLE0042 NVARCHAR VSTRING 4 0 4 CounterCheque Counter Cheque Counter Cheque    
PLE0043 NVARCHAR VSTRING 4 0 4 CounterPN Counter Promissory Note Counter Promissory Note    
PLE0044 NVARCHAR VSTRING 2 0 2 SeriesCheque Series Cheque Series Cheque    
PLE0045 NVARCHAR VSTRING 2 0 2 SeriesPN Series Promissory Note Series Promissory Note    
PLE0046 NVARCHAR VSTRING 1 0 1 DeletePaymentsOverLimit Delete Payments Over Limit Delete Payments Over Limit    
PLE0047 NVARCHAR VSTRING 4 0 4 IDCodePostalGiro ID Code Postal Giro ID Code Postal Giro    
PLE0048 NVARCHAR VSTRING 1 0 1 IDControlPostalGiro ID Control Postal Giro ID Control Postal Giro    
PLE0049 NVARCHAR VSTRING 7 0 7 InitialCounterPostalGiro Initial Counter Postal Giro Initial Counter Postal Giro    
PLE0050 NVARCHAR VSTRING 7 0 7 LastPrintCounterPostalGiro Last Print Counter Postal Giro Last printer Counter Postal Giro    
PLE0051 NVARCHAR VSTRING 7 0 7 LastCounterPostalGiro Last Counter Postal Giro Last Counter Postal Giro    
PLE0052 NVARCHAR VSTRING 2 0 2 SeriesPostalGiro Series Postal Giro Series Postal Giro    
PLE0053 NVARCHAR VSTRING 4 0 4 CounterPostalGiro Counter Postal Giro Counter Postal Giro    
PLE0054 NUMERIC MONEY 28 8 20 WagesLimit Wages Limit Wages Limit    

Навигация: