One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Promissory Notes»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PN03 — Partners

Таблица / Table: PN03 — «PN03 Partners». Маска имени таблицы / Table name mask: «PN03%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PN03001 NCHAR STRING 1 0 1 PartnerType Partner Type C — Customer

S — Supplier

X — Extraneous

Y — Temporary
1 Да / Yes
PN03002 NCHAR STRING 10 0 10 PartnerCode Partner Code   2 Да / Yes
PN03003 NVARCHAR VSTRING 35 0 35 Name Name      
PN03004 NVARCHAR VSTRING 35 0 35 Description Description      
PN03005 NVARCHAR VSTRING 35 0 35 Address1 Address Line 1      
PN03006 NVARCHAR VSTRING 35 0 35 Address2 Address Line 2      
PN03007 NVARCHAR VSTRING 35 0 35 Address3 Address Line 3      
PN03008 NVARCHAR VSTRING 35 0 35 Address4 Address Line 4      
PN03009 NCHAR STRING 3 0 3 CountryCode Country Code      
PN03010 NCHAR STRING 10 0 10 TaxNo Partner Tax Code      
PN03011 NVARCHAR VSTRING 20 0 20 PhoneNo Telephone Number      
PN03012 NVARCHAR VSTRING 20 0 20 FaxNo Telefax Number      
PN03013 NVARCHAR VSTRING 10 0 10 TelexNo Telex Number      
PN03014 NVARCHAR VSTRING 35 0 35 ContactPerson Contact Person      
PN03015 NCHAR STRING 6 0 6 NoChequeReceiv Number of Cheques Received      
PN03016 NUMERIC X_NUMERIC 28 8 20 AmountReceivedC Cheques: Amount Received (Local Currency)      
PN03017 NCHAR STRING 6 0 6 IncludCollectedC Cheques: Including Collected      
PN03018 NUMERIC X_NUMERIC 28 8 20 AmountCollectedC Cheques: Amount Collected (Local Currency)      
PN03019 NCHAR STRING 6 0 6 IncludReturnedC Cheques: Including Returned      
PN03020 NUMERIC X_NUMERIC 28 8 20 AmountReturnedC Cheques: Amount Returned (Local Currency)      
PN03021 NCHAR STRING 6 0 6 IncludProtestedC Cheques: Including Protested      
PN03022 NUMERIC X_NUMERIC 28 8 20 AmountProtestedC Cheques: Amount Protested (Local Currency)      
PN03023 NCHAR STRING 6 0 6 NoPNotesReceive Number of Notes Received      
PN03024 NUMERIC X_NUMERIC 28 8 20 AmountReceivedN Notes: Amount Received (Local Currency)      
PN03025 NCHAR STRING 6 0 6 IncludCollectedN Notes: Including Collected      
PN03026 NUMERIC X_NUMERIC 28 8 20 AmountCollectedN Notes: Amount Collected (Local Currency)      
PN03027 NCHAR STRING 6 0 6 IncludReturnedN Notes: Including Returned      
PN03028 NUMERIC X_NUMERIC 28 8 20 AmountReturnedN Notes: Amount Returned (Local Currency)      
PN03029 NCHAR STRING 6 0 6 IncludProtestedN Notes: Including Protested      
PN03030 NUMERIC X_NUMERIC 28 8 20 AmountProtestedN Notes: Amount Protested (Local Currency)      
PN03031 NCHAR STRING 10 0 10 AlternatCode Alternative Code      
PN03032 NCHAR STRING 2 0 2 DefPortfolioCheq Default Portfolio for Cheques      
PN03033 NCHAR STRING 1 0 1 Spare (obsolete)      
PN03034 DATETIME DATE 0 0 8 BehavTrcStDt Start Date Behaviour Tracking      
PN03035 NVARCHAR VSTRING 34 0 34 BankAccNo Bank Account Number      
PN03036 NVARCHAR VSTRING 35 0 35 CrspBankName Correspondent Bank Name      
PN03037 NVARCHAR VSTRING 35 0 35 SearchName Partner Name      
PN03038 NVARCHAR VSTRING 34 0 34 CrspBankAcnt Correspondent Bank Account Number      
PN03039 NVARCHAR VSTRING 35 0 35 CrspBankAdd1 Correspondent Bank Address Line 1      
PN03040 NVARCHAR VSTRING 35 0 35 CrspBankAdd2 Correspondent Bank Address Line 2      
PN03041 NVARCHAR VSTRING 35 0 35 CrspBankAdd3 Correspondent Bank Address Line 3      
PN03042 NVARCHAR VSTRING 35 0 35 CrspBankAdd4 Correspondent Bank Address Line 4      
PN03043 NVARCHAR VSTRING 15 0 15 StateCode State Code      
PN03044 NVARCHAR VSTRING 15 0 15 CrspStatCode Correspondent Bank State Code      
PN03045 NCHAR STRING 10 0 10 ZIPCode Zip Code      
PN03046 NCHAR STRING 10 0 10 TaxCode Partner Tax Office      
PN03047 NCHAR STRING 1 0 1 DefPortfType Default Portfolio Type      
PN03048 NCHAR STRING 2 0 2 DefPortfolioNotes Default Portfolio for Notes      
PN03049 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
PN03050 INT INTEGER 0 0 1 IBANactivation IBAN Activated      
PN03051 NVARCHAR VSTRING 35 0 35 Address5 Address Line 5      
PN03052 NVARCHAR VSTRING 35 0 35 Address6 Address Line 6      
PN03053 NVARCHAR VSTRING 35 0 35 Address7 Address Line 7      
PN03054 NVARCHAR VSTRING 35 0 35 CrspBankAdd5 Correspondent Bank Address Line 5      
PN03055 NVARCHAR VSTRING 35 0 35 CrspBankAdd6 Correspondent Bank Address Line 6      
PN03056 NVARCHAR VSTRING 35 0 35 CrspBankAdd7 Correspondent Bank Address Line 7      
PN03057 NVARCHAR VSTRING 3 0 3 CrspCountryCode Correspondent Country Code      

Навигация / Navigation: