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 PCR5 — Requisition History Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PCR5001 NVARCHAR VSTRING 10 0 10 RequisitionHeaderNo Requisition Number   1 Да / Yes
PCR5002 NVARCHAR VSTRING 4 0 4 RequisitionLineNo Requisition Line Number   2 Да / Yes
PCR5003 NVARCHAR VSTRING 1 0 1 ReqType Requisition Type 0 — Undefined

1 — Normal purchase order

2 — Stock transfer

3 — Direct delivery

4 — Commissary item

5 — Stock issue
   
PCR5004 NVARCHAR VSTRING 6 0 6 DepartmentCode Department Code      
PCR5005 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
PCR5006 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
PCR5007 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
PCR5008 NVARCHAR VSTRING 25 0 25 StockDescription1 Stock Item Description      
PCR5009 NUMERIC X_NUMERIC 20 8 12 QuantityOrdered Quantity Ordered      
PCR5010 NUMERIC MONEY 28 8 20 Price Unit Price      
PCR5011 NVARCHAR VSTRING 1 0 1 AuthorizationStatus Authorization Status 0 — Not authorized

1 — Authorized

2 — Rejected
   
PCR5012 NVARCHAR VSTRING 8 0 8 UserEnterAuthStatus Last Authorized By      
PCR5013 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
PCR5014 NVARCHAR VSTRING 8 0 8 UserPrintRqsnLine Printed By      
PCR5015 DATETIME DATE 0 0 8 RequisitionDate Requisition Date      
PCR5016 NVARCHAR VSTRING 8 0 8 UserRQSNEnter Created/Updated By      
PCR5017 NVARCHAR VSTRING 4 0 4 LinkedRqsnLine Linked Requisition Line Number      
PCR5018 NVARCHAR VSTRING 1 0 1 AccStrManualChange Accounting String Manually Changed      
PCR5019 NVARCHAR VSTRING 6 0 6 ToWarehouse To Warehouse      
PCR5020 NUMERIC X_NUMERIC 20 8 12 QtyIssued Issued (Delivered) Quantity      
PCR5021 NVARCHAR VSTRING 10 0 10 PurchaseOrderNo Purchase Order Number      
PCR5022 NVARCHAR VSTRING 6 0 6 PurchaseOrderLineNo Purchase Order Line Number      
PCR5023 NVARCHAR VSTRING 6 0 6 PurchaseOrderSubLineNo Purchase Order Sub-line Number      
PCR5024 DATETIME DATE 0 0 8 IssueReceiptDate Issue/Receipt Date      
PCR5025 NVARCHAR VSTRING 1 0 1 RequisitionLineStatus Requisition Line Status      
PCR5026 DATETIME DATE 0 0 8 ConversionDeletionDate Conversion/Deletion Date      
PCR5027 NCHAR SWITCH 1 0 1 NonregisteredItem Non-Stock Item      
PCR5028 INT INTEGER 0 0 4 UnitCode Unit Code      
PCR5029 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PCR5030 DATETIME DATE 0 0 8 RequiredDeliveryDate Required Delivery Date      
PCR5031 NVARCHAR VSTRING 25 0 25 StockDescription2 Stock Description 2      
PCR5032 NUMERIC X_NUMERIC 26 8 18 UnitConversionFactor Unit Conversion Factor      
PCR5033 NCHAR STRING 1 0 1 SuppManualChange Was Supplier manually changed?      
PCR5034 NCHAR STRING 1 0 1 PriceManualChange Was Price manually changed?      
PCR5035 NCHAR STRING 10 0 10 PickListID Picking List Id      
PCR5036 NVARCHAR VSTRING 6 0 6 FromBin From Bin      
PCR5037 NVARCHAR VSTRING 6 0 6 ToBin To Bin      
PCR5038 INT INTEGER 0 0 1 PickingStatus Picking Status 0 – Not Processed

1 — Request Created

2 – Printed

3 – Started

4 – Closed
   
PCR5039 NUMERIC X_NUMERIC 20 8 12 Spare Spare      
PCR5040 NCHAR STRING 10 0 10 OrReference OR Reference Link requisitions released from MRP or SRP to demand    
PCR5041 NCHAR STRING 14 0 14 OrLineRef OR Line Ref Link requisitions released from MRP or SRP to demand    
PCR5042 NVARCHAR VSTRING 150 0 150 ExUserDef1 Extended User-Defined Field 1      
PCR5043 NVARCHAR VSTRING 150 0 150 ExUserDef2 Extended User-Defined Field 2      
PCR5044 NVARCHAR VSTRING 150 0 150 ExUserDef3 Extended User-Defined Field 3      
PCR5045 NVARCHAR VSTRING 150 0 150 ExUserDef4 Extended User-Defined Field 4      
PCR5046 NVARCHAR VSTRING 150 0 150 ExUserDef5 Extended User-Defined Field 5      
PCR5047 NVARCHAR VSTRING 150 0 150 ExUserDef6 Extended User-Defined Field 6      
PCR5048 NVARCHAR VSTRING 150 0 150 ExUserDef7 Extended User-Defined Field 7      
PCR5049 NVARCHAR VSTRING 150 0 150 ExUserDef8 Extended User-Defined Field 8      
PCR5050 NVARCHAR VSTRING 150 0 150 ExUserDef9 Extended User-Defined Field 9      
PCR5051 NVARCHAR VSTRING 150 0 150 ExUserDef10 Extended User-Defined Field 10      
PCR5052 NVARCHAR VSTRING 150 0 150 ExUserDef11 Extended User-Defined Field 11      
PCR5053 NVARCHAR VSTRING 150 0 150 ExUserDef12 Extended User-Defined Field 12      
PCR5054 NVARCHAR VSTRING 150 0 150 ExUserDef13 Extended User-Defined Field 13      
PCR5055 NVARCHAR VSTRING 150 0 150 ExUserDef14 Extended User-Defined Field 14      
PCR5056 NVARCHAR VSTRING 150 0 150 ExUserDef15 Extended User-Defined Field 15      
PCR5057 NVARCHAR VSTRING 150 0 150 ExUserDef16 Extended User-Defined Field 16      
PCR5058 NVARCHAR VSTRING 150 0 150 ExUserDef17 Extended User-Defined Field 17      
PCR5059 NVARCHAR VSTRING 150 0 150 ExUserDef18 Extended User-Defined Field 18      
PCR5060 NVARCHAR VSTRING 150 0 150 ExUserDef19 Extended User-Defined Field 19      
PCR5061 NVARCHAR VSTRING 150 0 150 ExUserDef20 Extended User-Defined Field 20      

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