Таблица | Table: PC29 - «Spare». Маска имени таблицы | Table Name Mask: «PC29%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
PC29001 NCHAR STRING 4 0 4 Id[OR10] Index Key   1 Да / Yes
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		    
PC29021 NVARCHAR VSTRING 35 0 35 SendersAddress3 Sender Address Line 3      
PC29022 NVARCHAR VSTRING 35 0 35 SendersAddress4 Sender Address Line 4      
PC29023 NVARCHAR VSTRING 35 0 35 SendersAddress5 Sender Address Line 5      
PC29024 NVARCHAR VSTRING 35 0 35 SendersAddress6 Sender Address Line 6      
PC29025 NVARCHAR VSTRING 35 0 35 SendersAddress7 Sender Address Line 7      
PC29026 NVARCHAR VSTRING 3 0 3 SendersCountryCode Senders Country Code      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | Service Order Transport Document Parameters