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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PC17 — Purchase Order Text Lines

Таблица / Table: PC17 — «Purchase Order Text Lines». Маска имени таблицы / Table name mask: «PC17%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC17001 NCHAR STRING 10 0 10 OrderNo Purchase Order Number   1 Да / Yes
PC17002 NCHAR STRING 6 0 6 LineNo Purchase Order Line Number Line number ‘000000’ and ‘999999’ is used for text that are related to the order and not a specific line. Line ‘00000’ is printed before first order line and ‘999999’ is printed after last order line. 2 Да / Yes
PC17003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   3 Да / Yes
PC17004 NCHAR STRING 6 0 6 Number Text Line Number Line numbers with value 500 or greater will be printed after the order line in documents, lines with value 0-499 will be printed before the order line on documents. 4 Да / Yes
PC17005 NVARCHAR VSTRING 70 0 70 TextLine1 Text Line 1      
PC17006 NVARCHAR VSTRING 70 0 70 TextLine2 Text Line 2      
PC17007 NVARCHAR VSTRING 1 0 1 PurchOrdFLAGPrint Print Text on Purchase Order      
PC17008 NVARCHAR VSTRING 1 0 1 RemConfirmFLAGPrint Print Text on Reminder of Confirmation      
PC17009 NVARCHAR VSTRING 1 0 1 RemShipConfFLAGPrint Print Text on Reminder of Shipment      
PC17010 NVARCHAR VSTRING 1 0 1 PurchOrdTlxFLAGPrint Print Text on Purchase Order Telex      
PC17011 NVARCHAR VSTRING 1 0 1 RqstQuotFLAGPrint Print Text on Request for Quotation      
PC17012 NVARCHAR VSTRING 1 0 1 RqstQuotTlxFLAGPrint Print Text on Request for Quotation Telex      
PC17013 NVARCHAR VSTRING 1 0 1 GRNFLAGPrint Print Text on Goods Received Note      
PC17014 NVARCHAR VSTRING 1 0 1 SPARE8 (obsolete)      
PC17015 NVARCHAR VSTRING 1 0 1 SPARE9 (obsolete)      
PC17016 NVARCHAR VSTRING 1 0 1 SPARE10 (obsolete)      
PC17017 NVARCHAR VSTRING 1 0 1 SPARE11 (obsolete)      
PC17018 NVARCHAR VSTRING 1 0 1 SPARE12 (obsolete)      
PC17019 NVARCHAR VSTRING 1 0 1 SPARE13 (obsolete)      
PC17020 NVARCHAR VSTRING 1 0 1 CreatedFromORorSM Created from OR or SM      
PC17021 INT INTEGER 0 0 1 FLAGNotSavHs Not Saved in History      
PC17022 NVARCHAR VSTRING 25 0 25 InvoiceNoLast Invoice Number      
PC17023 NVARCHAR VSTRING 6 0 6 LinkedSMTextSubline Linked SM text sub line number      

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