Таблица: PLPU - «Payment Proposal unique parameters». Маска имени таблицы: «PLPU%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | Payment Proposal unique parameters