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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PC11 — Import Document Parameter File

Таблица / Table: PC11 — «Import Document Parameter File». Маска имени таблицы / Table name mask: «PC11%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC11001 NCHAR STRING 4 0 4 ID Index Key   1 Да / Yes
PC11002 NVARCHAR VSTRING 35 0 35 ImporterName Importer Name      
PC11003 NVARCHAR VSTRING 35 0 35 ImporterAdd1 Importer Address Line 1      
PC11004 NVARCHAR VSTRING 35 0 35 ImporterAdd2 Importer Address Line 2      
PC11005 NVARCHAR VSTRING 35 0 35 ImporterAdd3 Importer Address Line 3      
PC11006 NVARCHAR VSTRING 16 0 16 OrgNo Organization Number      
PC11007 NVARCHAR VSTRING 18 0 18 ShippAgent Shipment Agent      
PC11008 NVARCHAR VSTRING 18 0 18 ShippingPort Shipment Port      
PC11009 NVARCHAR VSTRING 40 0 40 RefAndTelNo Reference and Telephone Number      
PC11010 NVARCHAR VSTRING 40 0 40 CompanySign1 Company Signature Line 1      
PC11011 NVARCHAR VSTRING 40 0 40 CompanySign2 Company Signature Line 2      
PC11012 NVARCHAR VSTRING 40 0 40 CompanySign3 Company Signature Line 3      
PC11013 NVARCHAR VSTRING 40 0 40 CompanySign4 Company Signature Line 4      
PC11014 NCHAR STRING 2 0 2 CountryCodeEURCert1 Country Codes Excluded from EUR Certificate 1      
PC11015 NCHAR STRING 2 0 2 CountryCodeEURCert2 Country Codes Excluded from EUR Certificate 2      
PC11016 NCHAR STRING 2 0 2 CountryCodeEURCert3 Country Codes Excluded from EUR Certificate 3      
PC11017 NCHAR STRING 2 0 2 CountryCodeEURCert4 Country Codes Excluded from EUR Certificate 4      
PC11018 NCHAR STRING 2 0 2 CountryCodeEURCert5 Country Codes Excluded from EUR Certificate 5      
PC11019 NCHAR STRING 2 0 2 CountryCodeEURCert6 Country Codes Excluded from EUR Certificate 6      
PC11020 NCHAR STRING 2 0 2 CountryCodeEURCert7 Country Codes Excluded from EUR Certificate 7      
PC11021 NCHAR STRING 2 0 2 CountryCodeEURCert8 Country Codes Excluded from EUR Certificate 8      
PC11022 NCHAR STRING 2 0 2 CountryCodeEURCert9 Country Codes Excluded from EUR Certificate 9      
PC11023 NCHAR STRING 2 0 2 CountryCodeEURCert10 Country Codes Excluded from EUR Certificate 10      
PC11024 NCHAR STRING 2 0 2 CountryCodeEURCert11 Country Codes Excluded from EUR Certificate 11      
PC11025 NCHAR STRING 2 0 2 CountryCodeEURCert12 Country Codes Excluded from EUR Certificate 12      
PC11026 NCHAR STRING 2 0 2 CountryCodeEURCert13 Country Codes Excluded from EUR Certificate 13      
PC11027 NCHAR STRING 2 0 2 CountryCodeEURCert14 Country Codes Excluded from EUR Certificate 14      
PC11028 NCHAR STRING 2 0 2 CountryCodeEURCert15 Country Codes Excluded from EUR Certificate 15      
PC11029 NCHAR STRING 2 0 2 CountryCodeEURCert16 Country Codes Excluded from EUR Certificate 16      
PC11030 NCHAR STRING 2 0 2 CountryCodeEURCert17 Country Codes Excluded from EUR Certificate 17      
PC11031 NCHAR STRING 2 0 2 CountryCodeEURCert18 Country Codes Excluded from EUR Certificate 18      
PC11032 NCHAR STRING 2 0 2 CountryCodeEURCert19 Country Codes Excluded from EUR Certificate 19      
PC11033 NCHAR STRING 2 0 2 CountryCodeEURCert20 Country Codes Excluded from EUR Certificate 20      
PC11034 NCHAR STRING 2 0 2 CountryCodeEURCert21 Country Codes Excluded from EUR Certificate 21      
PC11035 NCHAR STRING 2 0 2 CountryCodeEURCert22 Country Codes Excluded from EUR Certificate 22      
PC11036 INT INTEGER 0 0 2 QtySelectionImportDocuments Quantity Selection for Import 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		    
PC11037 NVARCHAR VSTRING 35 0 35 ImporterAdd4 Importer Address Line 4      
PC11038 NVARCHAR VSTRING 35 0 35 ImporterAdd5 Importer Address Line 5      
PC11039 NVARCHAR VSTRING 35 0 35 ImporterAdd6 Importer Address Line 6      
PC11040 NVARCHAR VSTRING 35 0 35 ImporterAdd7 Importer Address Line 7      
PC11041 NVARCHAR VSTRING 3 0 3 ImporterCountryCode Importer Country Code      

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