Таблица | Table: PC44 - «Purchase Order TextLines History». Маска имени таблицы | Table Name Mask: «PC44%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?
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 15 0 15 InvoiceNo_Last Invoice Number   2 Да / Yes
PC44023 NVARCHAR VSTRING 6 0 6 Linked SM text sub line number        

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