One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказ на Закупку»/List of tables of module «Purchase Order»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table PC29 — Service Order Transport Document Parameters

Таблица / Table: PC29 — «Spare». Маска имени таблицы / Table name mask: «PC29%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC29001 NCHAR STRING 4 0 4 IdOR10] 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 QtySelectionTransportDocuments 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      

Навигация / Navigation: