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

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PC44 — Purchase Order Text Lines History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC44001 NCHAR STRING 10 0 10 OrderNo Purchase Order Number   1 Да / Yes
PC44002 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. 3 Да / Yes
PC44003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   4 Да / Yes
PC44004 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. 5 Да / Yes
PC44005 NVARCHAR VSTRING 70 0 70 TextLine1 Text Line 1      
PC44006 NVARCHAR VSTRING 70 0 70 TextLine2 Text Line 2      
PC44007 NVARCHAR VSTRING 1 0 1 PurchOrdFLAGPrint Print Text on Purchase Order      
PC44008 NVARCHAR VSTRING 1 0 1 RemConfirmFLAGPrint Print Text on Reminder of Confirmation      
PC44009 NVARCHAR VSTRING 1 0 1 RemShipConfFLAGPrint Print Text on Reminder of Shipment      
PC44010 NVARCHAR VSTRING 1 0 1 PurchOrdTlxFLAGPrint Print Text on Purchase Order Telex      
PC44011 NVARCHAR VSTRING 1 0 1 RqstQuotFLAGPrint Print Text on Request for Quotation      
PC44012 NVARCHAR VSTRING 1 0 1 RqstQuotTlxFLAGPrint Print Text on Request for Quotation Telex      
PC44013 NVARCHAR VSTRING 1 0 1 GRNFLAGPrint Print Text on Goods Received Note      
PC44014 NVARCHAR VSTRING 1 0 1 SPARE8 (obsolete)      
PC44015 NVARCHAR VSTRING 1 0 1 SPARE9 (obsolete)      
PC44016 NVARCHAR VSTRING 1 0 1 SPARE10 (obsolete)      
PC44017 NVARCHAR VSTRING 1 0 1 SPARE11 (obsolete)      
PC44018 NVARCHAR VSTRING 1 0 1 SPARE12 (obsolete)      
PC44019 NVARCHAR VSTRING 1 0 1 SPARE13 (obsolete)      
PC44020 NVARCHAR VSTRING 1 0 1 SPARE14 (obsolete)      
PC44021 INT INTEGER 0 0 1 FLAGNotSavHs Not Saved in History      
PC44022 NVARCHAR VSTRING 25 0 25 InvoiceNoLast Invoice Number   2 Да / Yes
PC44023 NVARCHAR VSTRING 6 0 6 LinkedSMTextSubline Linked SM text sub line number      

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