Таблица: PC29 - «Spare». Маска имени таблицы: «PC29%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| PC29001 | NCHAR | STRING | 4 | 0 | 4 | Id[OR10] | Index Key | 1 | Да | |
| PC29002 | NVARCHAR | VSTRING | 35 | 0 | 35 | Sendersname | Sender Name | |||
| PC29003 | NVARCHAR | VSTRING | 35 | 0 | 35 | SendersAddress1 | Sender Address Line 1 | |||
| PC29004 | NVARCHAR | VSTRING | 35 | 0 | 35 | Sendersaddress2 | Sender Address Line 2 | |||
| PC29005 | NVARCHAR | VSTRING | 35 | 0 | 35 | Dispatchtown | Dispatch Area | |||
| PC29006 | NVARCHAR | VSTRING | 10 | 0 | 10 | Postalgiroaccount | Postal Giro Account Number | |||
| PC29007 | NVARCHAR | VSTRING | 10 | 0 | 10 | Bankgiroaccount | Bank Giro Account Number | |||
| PC29008 | NVARCHAR | VSTRING | 10 | 0 | 10 | Suppliercoderail | Customer Code Forwarder 1 | |||
| PC29009 | NVARCHAR | VSTRING | 10 | 0 | 10 | Suppliercodesecuricor | Customer Code Forwarder 2 | |||
| PC29010 | NVARCHAR | VSTRING | 10 | 0 | 10 | SuppliercodeTNT | Customer Code Forwarder 3 | |||
| PC29011 | NVARCHAR | VSTRING | 10 | 0 | 10 | SuppliercodeElan | Customer Code Forwarder 4 | |||
| PC29012 | NVARCHAR | VSTRING | 25 | 0 | 25 | Standardcontent | Standard Content | |||
| PC29013 | NVARCHAR | VSTRING | 15 | 0 | 15 | PC29013 | Parcel Number Single Units Minimum Number | |||
| PC29014 | NVARCHAR | VSTRING | 15 | 0 | 15 | PC29014 | Parcel Number Single Units Maximum Number | |||
| PC29015 | NVARCHAR | VSTRING | 15 | 0 | 15 | PC29015 | Parcel Number Single Units Number | |||
| PC29016 | NVARCHAR | VSTRING | 15 | 0 | 15 | PC29016 | Parcel Number Multi Units Minimum Number | |||
| PC29017 | NVARCHAR | VSTRING | 15 | 0 | 15 | PC29017 | Parcel Number Multi Units Maximum Number | |||
| PC29018 | NVARCHAR | VSTRING | 15 | 0 | 15 | PC29018 | Parcel Number Multi Units Number | |||
| PC29019 | NVARCHAR | VSTRING | 28 | 0 | 28 | IBANforpayment | IBAN Account Number for Payment | |||
| PC29020 | INT | INTEGER | 0 | 0 | 2 | Qty_Selection_TransportDocuments | Quantity Selection for Documents | 0 - Ordered quantity for order line is used for calculation of the totals
1 - Delivered quantity for order line is used for calculation of the totals 2 - Only delivery lines are printed and used for calculation of the totals 3 - The latest delivery line is printed and used for calculation of the totals |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Order | Service Order Transport Document Parameters
