Таблица: 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