One level Up / 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 PLPU — Payment Proposal unique parameters

Таблица / Table: PLPU — «Payment Proposal unique parameters». Маска имени таблицы / Table name mask: «PLPU%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PLPU001 NCHAR STRING 10 0 10 ProposalNumber P.K. Field filled from counter 1 Да / Yes
PLPU002 INT INTEGER 0 0 3 DueDateAdjust1 Due Date Adjust 1      
PLPU003 INT INTEGER 0 0 3 DueDateAdjust2 Due Date Adjust 2      
PLPU004 INT INTEGER 0 0 3 DueDateAdjust3 Due Date Adjust 3      
PLPU005 INT INTEGER 0 0 3 DueDateAdjust4 Due Date Adjust 4      
PLPU006 INT INTEGER 0 0 3 DueDateAdjust5 Due Date Adjust 5      
PLPU007 INT INTEGER 0 0 3 DueDateAdjust6 Due Date Adjust 6      
PLPU008 INT INTEGER 0 0 3 DueDateAdjust7 Due Date Adjust 7      
PLPU009 INT INTEGER 0 0 3 DueDateAdjust8 Due Date Adjust 8      
PLPU010 INT INTEGER 0 0 3 DueDateAdjust9 Due Date Adjust 9      
PLPU011 INT INTEGER 0 0 3 DueDateAdjust10 Due Date Adjust 10      
PLPU012 DATETIME DATE 0 0 8 PaymentDate Payment Date      
PLPU013 NUMERIC MONEY 28 8 20 MaxAmount Max Amount      
PLPU014 NCHAR STRING 2 0 2 PaymentMethod Payment Method      
PLPU015 NCHAR STRING 2 0 2 AltPaymentMethod Alt. Payment Method      
PLPU016 NVARCHAR VSTRING 10 0 10 SuppMin Supplier min      
PLPU017 NVARCHAR VSTRING 10 0 10 SuppMax Supplier max      
PLPU018 NCHAR STRING 4 0 4 CategoryMin Category min      
PLPU019 NCHAR STRING 4 0 4 CategoryMax Category max      
PLPU020 NCHAR STRING 2 0 2 CurrencyMin Currency min      
PLPU021 NCHAR STRING 2 0 2 CurrencyMax Currency max      
PLPU022 NVARCHAR VSTRING 50 0 50 SegMin accounting string      
PLPU023 NVARCHAR VSTRING 50 0 50 SegMax accounting string      
PLPU024 NUMERIC MONEY 28 8 20 DebitSum Debit sum      
PLPU025 DATETIME DATE 0 0 8 SelectedDueDate Selected Due Date      
PLPU026 INT INTEGER 0 0 2 SundayPayment Sunday Payment      
PLPU027 INT INTEGER 0 0 2 SaturdayPayment Saturday Payment      
PLPU028 INT INTEGER 0 0 2 DirectUseOfCredit Direct use of Credit      
PLPU029 DATETIME DATE 0 0 8 NoPayDate1 No Pay Date 1      
PLPU030 DATETIME DATE 0 0 8 NoPayDate2 No Pay Date 2      
PLPU031 DATETIME DATE 0 0 8 NoPayDate3 No Pay Date 3      
PLPU032 DATETIME DATE 0 0 8 NoPayDate4 No Pay Date 4      
PLPU033 DATETIME DATE 0 0 8 NoPayDate5 No Pay Date 5      
PLPU034 DATETIME DATE 0 0 8 NoPayDate6 No Pay Date 6      
PLPU035 DATETIME DATE 0 0 8 NoPayDate7 No Pay Date 7      
PLPU036 DATETIME DATE 0 0 8 NoPayDate8 No Pay Date 8      
PLPU037 DATETIME DATE 0 0 8 NoPayDate9 No Pay Date 9      
PLPU038 DATETIME DATE 0 0 8 NoPayDate10 No Pay Date 10      
PLPU039 DATETIME DATE 0 0 8 NoPayDate11 No Pay Date 11      
PLPU040 DATETIME DATE 0 0 8 NoPayDate12 No Pay Date 12      
PLPU041 DATETIME DATE 0 0 8 NoPayDate13 No Pay Date 13      
PLPU042 DATETIME DATE 0 0 8 NoPayDate14 No Pay Date 14      
PLPU043 DATETIME DATE 0 0 8 NoPayDate15 No Pay Date 15      
PLPU044 DATETIME DATE 0 0 8 NoPayDate16 No Pay Date 16      
PLPU045 DATETIME DATE 0 0 8 NoPayDate17 No Pay Date 17      
PLPU046 DATETIME DATE 0 0 8 NoPayDate18 No Pay Date 18      
PLPU047 DATETIME DATE 0 0 8 NoPayDate19 No Pay Date 19      
PLPU048 DATETIME DATE 0 0 8 NoPayDate20 No Pay Date 20      
PLPU049 DATETIME DATE 0 0 8 NoPayDate21 No Pay Date 21      
PLPU050 DATETIME DATE 0 0 8 NoPayDate22 No Pay Date 22      
PLPU051 DATETIME DATE 0 0 8 NoPayDate23 No Pay Date 23      
PLPU052 DATETIME DATE 0 0 8 NoPayDate24 No Pay Date 24      
PLPU053 DATETIME DATE 0 0 8 NoPayDate25 No Pay Date 25      
PLPU054 DATETIME DATE 0 0 8 NoPayDate26 No Pay Date 26      
PLPU055 DATETIME DATE 0 0 8 NoPayDate27 No Pay Date 27      
PLPU056 DATETIME DATE 0 0 8 NoPayDate28 No Pay Date 28      
PLPU057 DATETIME DATE 0 0 8 NoPayDate29 No Pay Date 29      
PLPU058 DATETIME DATE 0 0 8 NoPayDate30 No Pay Date 30      
PLPU059 DATETIME DATE 0 0 8 NoPayDate31 No Pay Date 31      
PLPU060 DATETIME DATE 0 0 8 NoPayDate32 No Pay Date 32      
PLPU061 DATETIME DATE 0 0 8 NoPayDate33 No Pay Date 33      
PLPU062 DATETIME DATE 0 0 8 NoPayDate34 No Pay Date 34      
PLPU063 DATETIME DATE 0 0 8 NoPayDate35 No Pay Date 35      
PLPU064 DATETIME DATE 0 0 8 NoPayDate36 No Pay Date 36      
PLPU065 DATETIME DATE 0 0 8 NoPayDate37 No Pay Date 37      
PLPU066 DATETIME DATE 0 0 8 NoPayDate38 No Pay Date 38      
PLPU067 DATETIME DATE 0 0 8 NoPayDate39 No Pay Date 39      
PLPU068 DATETIME DATE 0 0 8 NoPayDate40 No Pay Date 40      
PLPU069 DATETIME DATE 0 0 8 NoPayDate41 No Pay Date 41      
PLPU070 DATETIME DATE 0 0 8 NoPayDate42 No Pay Date 42      
PLPU071 DATETIME DATE 0 0 8 NoPayDate43 No Pay Date 43      
PLPU072 DATETIME DATE 0 0 8 NoPayDate44 No Pay Date 44      
PLPU073 DATETIME DATE 0 0 8 NoPayDate45 No Pay Date 45      
PLPU074 DATETIME DATE 0 0 8 NoPayDate46 No Pay Date 46      
PLPU075 DATETIME DATE 0 0 8 NoPayDate47 No Pay Date 47      
PLPU076 DATETIME DATE 0 0 8 NoPayDate48 No Pay Date 48      
PLPU077 INT INTEGER 0 0 2 UseSLCredits Use SL Credits      
PLPU078 INT INTEGER 0 0 2 AllowNegBalance Allow negative balance      
PLPU079 NUMERIC MONEY 28 8 20 CreditSum Credit sum      
PLPU080 INT INTEGER 0 0 2 UseOtherCurrency Use Other Currency      
PLPU081 INT INTEGER 0 0 2 PaymentCurrency Payment Currency      
PLPU082 DATETIME DATE 0 0 8 BookDate Book Date      
PLPU083 DATETIME DATE 0 0 8 DueDateCredit Due Date Credit      
PLPU084 NCHAR STRING 6 0 6 JournalCode Journal Code      
PLPU085 INT INTEGER 0 0 2 TransInClose Trans in Close      
PLPU086 NVARCHAR VSTRING 10 0 10 BankCode swiss      
PLPU087 INT INTEGER 0 0 2 CheckPMBalance Check PM Balance      
PLPU088 INT INTEGER 0 0 3 DeferOfPayment Defer. of Payment      
PLPU089 INT INTEGER 0 0 1 Priority1 Priority 1      
PLPU090 INT INTEGER 0 0 1 Priority2 Priority 2      
PLPU091 INT INTEGER 0 0 1 Priority3 Priority 3      
PLPU092 INT INTEGER 0 0 1 Priority4 Priority 4      
PLPU093 INT INTEGER 0 0 1 Priority5 Priority 5      
PLPU094 INT INTEGER 0 0 1 Priority6 Priority 6      
PLPU095 INT INTEGER 0 0 1 Priority7 Priority 7      
PLPU096 INT INTEGER 0 0 1 Priority8 Priority 8      
PLPU097 INT INTEGER 0 0 1 Priority9 Priority 9      
PLPU098 INT INTEGER 0 0 2 PaymentCurrency2 Payment Currency 2      
PLPU099 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type1 Payment Currency Sub-type 1      
PLPU100 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type2 Payment Currency Sub-type 2      
PLPU101 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type3 Payment Currency Sub-type 3      
PLPU102 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type4 Payment Currency Sub-type 4      
PLPU103 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type5 Payment Currency Sub-type 5      
PLPU104 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type6 Payment Currency Sub-type 6      
PLPU105 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type7 Payment Currency Sub-type 7      
PLPU106 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type8 Payment Currency Sub-type 8      
PLPU107 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type9 Payment Currency Sub-type 9      
PLPU108 NCHAR SWITCH 1 0 1 PaymentCurrencySub-type10 Payment Currency Sub-type 10      
PLPU109 INT INTEGER 0 0 2 CurrencyCodeSub-type1 Currency Code Sub-type 1      
PLPU110 INT INTEGER 0 0 2 CurrencyCodeSub-type2 Currency Code Sub-type 2      
PLPU111 INT INTEGER 0 0 2 CurrencyCodeSub-type3 Currency Code Sub-type 3      
PLPU112 INT INTEGER 0 0 2 CurrencyCodeSub-type4 Currency Code Sub-type 4      
PLPU113 INT INTEGER 0 0 2 CurrencyCodeSub-type5 Currency Code Sub-type 5      
PLPU114 INT INTEGER 0 0 2 CurrencyCodeSub-type6 Currency Code Sub-type 6      
PLPU115 INT INTEGER 0 0 2 CurrencyCodeSub-type7 Currency Code Sub-type 7      
PLPU116 INT INTEGER 0 0 2 CurrencyCodeSub-type8 Currency Code Sub-type 8      
PLPU117 INT INTEGER 0 0 2 CurrencyCodeSub-type9 Currency Code Sub-type 9      
PLPU118 INT INTEGER 0 0 2 CurrencyCodeSub-type10 Currency Code Sub-type 10      

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