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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PLPU — Payment Proposal unique parameters

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PLPU001 NCHAR STRING 10 0 10 ProposalNumber P.K. Field filled from counter 1 Да
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      

Навигация: