Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PN21 - «PN Operational Proposal Header». Маска имени таблицы: «PN21%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PN21001 | NVARCHAR | VSTRING | 8 | 0 | 8 | OperPropNo | Proposal Number | 1 | Да | |
PN21002 | NVARCHAR | VSTRING | 1 | 0 | 1 | NotesType | Notes Type | |||
PN21003 | NVARCHAR | VSTRING | 2 | 0 | 2 | PropCurrCode | Proposal Currency Code | |||
PN21004 | NUMERIC | MONEY | 28 | 8 | 20 | PropAmount | Proposal Amount | |||
PN21005 | DATETIME | DATE | 0 | 0 | 8 | CreationDate | Date Created | |||
PN21006 | DATETIME | DATE | 0 | 0 | 8 | FirstPrintDate | Date First Printed | |||
PN21007 | DATETIME | DATE | 0 | 0 | 8 | ReprintDate | Date Reprinted | |||
PN21008 | DATETIME | DATE | 0 | 0 | 8 | UpdDate | Date Updated | |||
PN21009 | DATETIME | DATE | 0 | 0 | 8 | ApprovalDate | Date Approved | |||
PN21010 | DATETIME | DATE | 0 | 0 | 8 | MinDueDate | Minimum Due Date | |||
PN21011 | DATETIME | DATE | 0 | 0 | 8 | MaxDueDate | Maximum Due Date | |||
PN21012 | NVARCHAR | VSTRING | 6 | 0 | 6 | MinIntNum | Minimum Internal Number | |||
PN21013 | NVARCHAR | VSTRING | 6 | 0 | 6 | MaxIntNum | Maximum Internal Number | |||
PN21014 | NVARCHAR | VSTRING | 2 | 0 | 2 | MinNotStat | Minimum Note Status | |||
PN21015 | NVARCHAR | VSTRING | 2 | 0 | 2 | MaxNotStat | Maximum Note Status | |||
PN21016 | NVARCHAR | VSTRING | 1 | 0 | 1 | MinErsrTyp | Minimum Endorser Type | |||
PN21017 | NVARCHAR | VSTRING | 1 | 0 | 1 | MaxErsrTyp | Maximum Endorser Type | |||
PN21018 | NVARCHAR | VSTRING | 10 | 0 | 10 | MinErsrCod | Minimum Endorser Code | |||
PN21019 | NVARCHAR | VSTRING | 10 | 0 | 10 | MaxErsrCod | Maximum Endorser Code | |||
PN21020 | NVARCHAR | VSTRING | 1 | 0 | 1 | MinErseTyp | Minimum Endorsee Type | |||
PN21021 | NVARCHAR | VSTRING | 1 | 0 | 1 | MaxErseTyp | Maximum Endorsee Type | |||
PN21022 | NVARCHAR | VSTRING | 10 | 0 | 10 | MinErseCod | Minimum Endorsee Code | |||
PN21023 | NVARCHAR | VSTRING | 10 | 0 | 10 | MaxErseCod | Maximum Endorsee Code | |||
PN21024 | NVARCHAR | VSTRING | 1 | 0 | 1 | MinPotfTyp | Minimum Portfolio Type | |||
PN21025 | NVARCHAR | VSTRING | 1 | 0 | 1 | MaxPortfTyp | Maximum Portfolio Type | |||
PN21026 | NVARCHAR | VSTRING | 2 | 0 | 2 | MinPortfNum | Minimum Portfolio Number | |||
PN21027 | NVARCHAR | VSTRING | 2 | 0 | 2 | MaxPortfNum | Maximum Portfolio Number | |||
PN21028 | NVARCHAR | VSTRING | 10 | 0 | 10 | MinPBankCod | Minimum Payment Bank Code | |||
PN21029 | NVARCHAR | VSTRING | 10 | 0 | 10 | MaxPBankCod | Maximum Payment Bank Code | |||
PN21030 | NUMERIC | MONEY | 28 | 8 | 20 | MinNotAmt | Minimum Note Amount | |||
PN21031 | NUMERIC | MONEY | 28 | 8 | 20 | MaxNotAmt | Maximum Note Amount | |||
PN21032 | NVARCHAR | VSTRING | 2 | 0 | 2 | LastOpCode | Last Operation Code |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Promissory Notes | Promissory Notes Operation Proposal Header