Таблица / 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 | ACCSTR | 120 | 0 | 120 | SegMin | accounting string | |||
PLPU023 | NVARCHAR | ACCSTR | 120 | 0 | 120 | 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:
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Order»
- Структура таблиц / 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 :: Список таблиц модуля /List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «System Utilities/Office Autom.»