Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PN03 - «Partners» («Партнеры»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PN03001 | STRING | 1 | PartnerType | Да |
| PN03002 | STRING | 10 | PartnerCode | Да |
| PN03003 | VSTRING | 35 | Name | |
| PN03004 | VSTRING | 35 | Description | |
| PN03005 | VSTRING | 35 | Address_1 | |
| PN03006 | VSTRING | 35 | Address_2 | |
| PN03007 | VSTRING | 35 | Address_3 | |
| PN03008 | VSTRING | 35 | Address_4 | |
| PN03009 | STRING | 3 | Country | |
| PN03010 | STRING | 10 | Tax_No | |
| PN03011 | VSTRING | 20 | Phone_No | |
| PN03012 | VSTRING | 20 | Fax_No | |
| PN03013 | VSTRING | 10 | Telex_No | |
| PN03014 | VSTRING | 35 | ContactPerson | |
| PN03015 | STRING | 6 | NoChequeReceiv | |
| PN03016 | X_NUMERIC | 20 | AmountReceived | |
| PN03017 | STRING | 6 | IncludCollected | |
| PN03018 | X_NUMERIC | 20 | AmountCollected | |
| PN03019 | STRING | 6 | IncludReturned | |
| PN03020 | X_NUMERIC | 20 | AmountReturned | |
| PN03021 | STRING | 6 | IncludProtested | |
| PN03022 | X_NUMERIC | 20 | AmountProtested | |
| PN03023 | STRING | 6 | NoPNotesReceive | |
| PN03024 | X_NUMERIC | 20 | AmountReceived | |
| PN03025 | STRING | 6 | IncludCollected | |
| PN03026 | X_NUMERIC | 20 | AmountCollected | |
| PN03027 | STRING | 6 | IncludReturned | |
| PN03028 | X_NUMERIC | 20 | AmountReturned | |
| PN03029 | STRING | 6 | IncludProtested | |
| PN03030 | X_NUMERIC | 20 | AmountProtested | |
| PN03031 | STRING | 10 | AlternatCode | |
| PN03032 | STRING | 2 | DefPortfolioCheq | |
| PN03033 | STRING | 1 | Spare | |
| PN03034 | DATE | 8 | BehavTrcStDt | |
| PN03035 | VSTRING | 25 | BankAccNo | |
| PN03036 | VSTRING | 35 | CrspBankName | |
| PN03037 | VSTRING | 35 | SearchName | |
| PN03038 | VSTRING | 25 | CrspBankAcnt | |
| PN03039 | VSTRING | 35 | CrspBankAdd1 | |
| PN03040 | VSTRING | 35 | CrspBankAdd2 | |
| PN03041 | VSTRING | 35 | CrspBankAdd3 | |
| PN03042 | VSTRING | 35 | CrspBankAdd4 | |
| PN03043 | VSTRING | 15 | State_Code | |
| PN03044 | VSTRING | 15 | CrspStatCode | |
| PN03045 | STRING | 10 | ZIP_Code | |
| PN03046 | STRING | 10 | Tax_Code | |
| PN03047 | STRING | 1 | DefPortfType | |
| PN03048 | STRING | 2 | DefPortfolioNotes | |
| PN03049 | VSTRING | 10 | BankCode |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Promissory Notes (Долговые обязательства) | Partners (Партнеры)
/* */