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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 Address_1 Address Line 1      
PN03006 NVARCHAR VSTRING 35 0 35 Address_2 Address Line 2      
PN03007 NVARCHAR VSTRING 35 0 35 Address_3 Address Line 3      
PN03008 NVARCHAR VSTRING 35 0 35 Address_4 Address Line 4      
PN03009 NCHAR STRING 3 0 3 Country Country Code      
PN03010 NCHAR STRING 10 0 10 Tax_No Partner Tax Code      
PN03011 NVARCHAR VSTRING 20 0 20 Phone_No Telephone Number      
PN03012 NVARCHAR VSTRING 20 0 20 Fax_No Telefax Number      
PN03013 NVARCHAR VSTRING 10 0 10 Telex_No 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 AmountReceived Cheques: Amount Received (Local Currency)      
PN03017 NCHAR STRING 6 0 6 IncludCollected Cheques: Including Collected      
PN03018 NUMERIC X_NUMERIC 28 8 20 AmountCollected Cheques: Amount Collected (Local Currency)      
PN03019 NCHAR STRING 6 0 6 IncludReturned Cheques: Including Returned      
PN03020 NUMERIC X_NUMERIC 28 8 20 AmountReturned Cheques: Amount Returned (Local Currency)      
PN03021 NCHAR STRING 6 0 6 IncludProtested Cheques: Including Protested      
PN03022 NUMERIC X_NUMERIC 28 8 20 AmountProtested Cheques: Amount Protested (Local Currency)      
PN03023 NCHAR STRING 6 0 6 NoPNotesReceive Number of Notes Received      
PN03024 NUMERIC X_NUMERIC 28 8 20 AmountReceived Notes: Amount Received (Local Currency)      
PN03025 NCHAR STRING 6 0 6 IncludCollected Notes: Including Collected      
PN03026 NUMERIC X_NUMERIC 28 8 20 AmountCollected Notes: Amount Collected (Local Currency)      
PN03027 NCHAR STRING 6 0 6 IncludReturned Notes: Including Returned      
PN03028 NUMERIC X_NUMERIC 28 8 20 AmountReturned Notes: Amount Returned (Local Currency)      
PN03029 NCHAR STRING 6 0 6 IncludProtested Notes: Including Protested      
PN03030 NUMERIC X_NUMERIC 28 8 20 AmountProtested 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 State_Code State Code      
PN03044 NVARCHAR VSTRING 15 0 15 CrspStatCode Correspondent Bank State Code      
PN03045 NCHAR STRING 10 0 10 ZIP_Code Zip Code      
PN03046 NCHAR STRING 10 0 10 Tax_Code 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      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Promissory Notes | Partners