На один уровень вверх / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Promissory Notes»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PN02 — Promissory Notes

Таблица: PN02 — «PN02 Prom.Notes». Маска имени таблицы: «PN02%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PN02001 NCHAR STRING 2 0 2 Type Document Type CR — Cheque receivable
NR — Notes Receivable
CP — Cheques payable
NP — Notes payable		 1 Да
PN02002 NCHAR STRING 6 0 6 InternalNo Internal Number   2 Да
PN02003 NCHAR STRING 2 0 2 PNPDCStatus PN/PDC Status      
PN02004 DATETIME DATE 0 0 8 DueDate Due Date      
PN02005 NCHAR STRING 2 0 2 PortfolioNo Portfolio Number      
PN02006 NVARCHAR VSTRING 15 0 15 PNPDCSerNo PN/PDC Serial Number      
PN02007 NUMERIC X_NUMERIC 28 8 20 SavedAmLCU Saved Amount (Local Currency)      
PN02008 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PN02009 NUMERIC X_NUMERIC 28 8 20 FacedAmFCU Faced Amount (Document Currency)      
PN02010 DATETIME DATE 0 0 8 DrawDate Draw Date      
PN02011 NCHAR STRING 10 0 10 IssuerCode Issuer Code      
PN02012 NVARCHAR VSTRING 35 0 35 IssuerName Issuer Name      
PN02013 NVARCHAR VSTRING 10 0 10 OrigBankCode Originator/Drawee Bank Code      
PN02014 NVARCHAR VSTRING 35 0 35 OrigBankName Originator/Drawee Bank Name      
PN02015 NVARCHAR VSTRING 35 0 35 OrigBankAdd1 Originator/Drawee Bank Address Line 1      
PN02016 NVARCHAR VSTRING 35 0 35 OrigBankAdd2 Originator/Drawee Bank Address Line 2      
PN02017 NVARCHAR VSTRING 35 0 35 OrigBankAdd3 Originator/Drawee Bank Address Line 3      
PN02018 NVARCHAR VSTRING 35 0 35 OrigBankAdd4 Originator/Drawee Bank Address Line 4      
PN02019 NCHAR STRING 10 0 10 EndorserCode Endorser Code      
PN02020 DATETIME DATE 0 0 8 InputBEDate Input BE Date      
PN02021 NCHAR STRING 9 0 9 InputTransNo Input Transaction Number      
PN02022 NCHAR STRING 15 0 15 InputInvoiNo Input Invoice Number      
PN02023 NUMERIC X_NUMERIC 28 8 20 InputAmLCU Input Amount (Local Currency)      
PN02024 NCHAR STRING 1 0 1 Spare (obsolete)      
PN02025 NCHAR STRING 1 0 1 Spare (obsolete)      
PN02026 NVARCHAR ACCSTR 50 0 50 InputContStr Accounting String Input      
PN02027 NCHAR STRING 10 0 10 EndorseeCode Endorsee/Payee Code      
PN02028 DATETIME DATE 0 0 8 OutputBEDate Output Book-Entry Date      
PN02029 NCHAR STRING 9 0 9 OutputTranNo Output Transaction Number      
PN02030 NCHAR STRING 15 0 15 OutputInvoNo Output Invoice Number      
PN02031 NUMERIC X_NUMERIC 28 8 20 OutputAmLCU Output Amount (Local Currency)      
PN02032 NVARCHAR ACCSTR 50 0 50 OutpContrStr Accounting String Output      
PN02033 NCHAR STRING 1 0 1 PrintePNPDC Printed PN/PDC      
PN02034 NCHAR STRING 1 0 1 PrintedRepLn Printed Report Line      
PN02035 NUMERIC X_NUMERIC 28 8 20 AmountLCUBef Amount Before Last Revaluation (Local Currency)      
PN02036 NCHAR STRING 1 0 1 RevalModeTaken Revaluation Mode Taken      
PN02037 NUMERIC X_NUMERIC 28 8 20 DiscAmounLCU Discounted Amount (Local Currency)      
PN02038 NUMERIC X_NUMERIC 28 8 20 DiscAmounCUR Discounted Amount (Document Currency)      
PN02039 NCHAR STRING 6 0 6 InterestProc Interest %      
PN02040 NCHAR STRING 3 0 3 NoEndorsBefore Times Endorsed Before      
PN02041 NCHAR STRING 3 0 3 SalesManCode Salesman      
PN02042 NCHAR STRING 10 0 10 OriginTaxCode Originator Tax Code      
PN02043 NCHAR STRING 10 0 10 OriginTaxNo Originator Tax Number      
PN02044 NCHAR STRING 10 0 10 GracePeriLen Grace Period      
PN02045 NCHAR STRING 10 0 10 GracePerUnit Grace Period Unit      
PN02046 NCHAR STRING 10 0 10 AcceptPerLen Acceptance Period      
PN02047 NCHAR STRING 10 0 10 AcceptPerUnt Acceptance Period Unit      
PN02048 NCHAR STRING 10 0 10 ProtesPerLen Protest Period      
PN02049 NCHAR STRING 10 0 10 ProtesPerUnt Protest Period Unit      
PN02050 NCHAR STRING 10 0 10 ContLiabiLen Contingent Liability Margin Period      
PN02051 NCHAR STRING 10 0 10 ContLiabiUnt Contingent Liability Margin Period Unit      
PN02052 NVARCHAR VSTRING 50 0 50 RemarkLine1 Remark Line 1      
PN02053 NVARCHAR VSTRING 50 0 50 RemarkLine2 Remark Line 2      
PN02054 NVARCHAR VSTRING 50 0 50 RemarkLine3 Remark Line 3      
PN02055 NVARCHAR VSTRING 50 0 50 RemarkLine4 Remark Line 4      
PN02056 NCHAR STRING 2 0 2 StatistCode1 Statistical Code 1      
PN02057 NCHAR STRING 2 0 2 StatistCode2 Statistical Code 2      
PN02058 NCHAR STRING 1 0 1 SettledFlag Settled Flag      
PN02059 DATETIME DATE 0 0 8 HoldDate Hold Date      
PN02060 NVARCHAR VSTRING 35 0 35 IssuerDescript Issuer Description      
PN02061 NCHAR STRING 1 0 1 Spare (obsolete)      
PN02062 NCHAR STRING 1 0 1 Spare (obsolete)      
PN02063 NCHAR STRING 8 0 8 LockedByUserId Locked By      
PN02064 NCHAR STRING 1 0 1 Selected Selected      
PN02065 NCHAR STRING 1 0 1 PortfolioType Portfolio Type      
PN02066 NCHAR STRING 1 0 1 DraweeType Drawee Type      
PN02067 NCHAR STRING 1 0 1 IssuerType Issuer Type      
PN02068 NCHAR STRING 1 0 1 EndorserType Endorser Type      
PN02069 NCHAR STRING 1 0 1 EndorseeType Endorsee Type      
PN02070 DATETIME DATE 0 0 8 LastRevaDate Last Revaluation Date      
PN02071 DATETIME DATE 0 0 8 ReceiptDate Received Date      
PN02072 NCHAR STRING 10 0 10 SettleBankCode Settlement/Pledged Bank Code      
PN02073 NCHAR STRING 10 0 10 PaymBankCode Payment Bank Code      
PN02074 NVARCHAR VSTRING 35 0 35 PaymBankName Payment Bank Name      
PN02075 NVARCHAR VSTRING 35 0 35 PaymBankAddr1 Payment Bank Address 1      
PN02076 NVARCHAR VSTRING 35 0 35 PaymBankAddr2 Payment Bank Address 2      
PN02077 NVARCHAR VSTRING 35 0 35 PaymBankAddr3 Payment Bank Address 3      
PN02078 NVARCHAR VSTRING 35 0 35 PaymBankAddr4 Payment Bank Address 4      
PN02079 DATETIME DATE 0 0 8 ProcessDate Process Date      
PN02080 NVARCHAR VSTRING 8 0 8 OperPropNo Operational Proposal Number      
PN02081 NVARCHAR VSTRING 28 0 28 IBANforPayment IBAN for Payment      
PN02082 NVARCHAR VSTRING 35 0 35 OrigBankAdd5 Originator/Drawee Bank Address Line 5      
PN02083 NVARCHAR VSTRING 35 0 35 OrigBankAdd6 Originator/Drawee Bank Address Line 6      
PN02084 NVARCHAR VSTRING 35 0 35 OrigBankAdd7 Originator/Drawee Bank Address Line 7      
PN02085 NVARCHAR VSTRING 35 0 35 PaymBankAddr5 Payment Bank Address 5      
PN02086 NVARCHAR VSTRING 35 0 35 PaymBankAddr6 Payment Bank Address 6      
PN02087 NVARCHAR VSTRING 35 0 35 PaymBankAddr7 Payment Bank Address 7      
PN02088 NVARCHAR VSTRING 3 0 3 OrigCountryCode Originator/Drawee Country Code      
PN02089 NVARCHAR VSTRING 3 0 3 PaymCountryCode Payment Country Code      

Навигация: