One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Purchase Order»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PCR5 — Requisition History Lines

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PCR5001 NVARCHAR VSTRING 10 0 10 RequisitionHeaderNo Requisition Number   1 Да
PCR5002 NVARCHAR VSTRING 4 0 4 RequisitionLineNo Requisition Line Number   2 Да
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      

Навигация: