пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: PN03 - «PN03 Partners». Маска имени таблицы: «PN03%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PN03001 NCHAR STRING 1 0 1 PartnerType Partner Type C - Customer
S - Supplier
X - Extraneous
Y - Temporary
1 Да
PN03002 NCHAR STRING 10 0 10 PartnerCode Partner Code   2 Да
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      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Promissory Notes | Partners

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.