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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PCR4 — Requisition Template Line

Таблица: PCR4 — «Requisition Template Line». Маска имени таблицы: «PCR4%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PCR4001 NVARCHAR VSTRING 10 0 10 RequisitionHeaderNo Requisition Number   1 Да
PCR4002 NVARCHAR VSTRING 4 0 4 RequisitionLineNo Requisition Line Number   2 Да
PCR4003 NVARCHAR VSTRING 1 0 1 RequisitionType Requisition Type 0 — Undefined
1 — Normal purchase order
2 — Stock transfer
3 — Direct delivery
4 — Commissary item
5 — Stock issue
   
PCR4004 NVARCHAR VSTRING 6 0 6 DepartmentCode Department Code      
PCR4005 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
PCR4006 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
PCR4007 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
PCR4008 NVARCHAR VSTRING 25 0 25 StockDescription1 Stock Item Description      
PCR4009 NUMERIC X_NUMERIC 20 8 12 QuantityOrdered Quantity Ordered      
PCR4010 NUMERIC MONEY 28 8 20 Price Unit Price      
PCR4011 NVARCHAR VSTRING 1 0 1 AuthorizationStatus Authorization Status 0 — Not authorized
1 — Authorized
2 — Rejected
   
PCR4012 NVARCHAR VSTRING 8 0 8 UserEnterAuthStatus Last Authorized By      
PCR4013 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
PCR4014 NVARCHAR VSTRING 8 0 8 UserPrintRqsnLine Printed By      
PCR4015 DATETIME DATE 0 0 8 RequisitionDate Requisition Date      
PCR4016 NVARCHAR VSTRING 8 0 8 UserEnterAdjRqsnLine Updated By      
PCR4017 NVARCHAR VSTRING 4 0 4 LinkedRqsnLine Linked Requisition Line Number      
PCR4018 NVARCHAR VSTRING 1 0 1 AccStrManualChange Accounting String Manually Changed      
PCR4019 NCHAR SWITCH 1 0 1 NonregisteredItem Non-Stock Item      
PCR4020 INT INTEGER 0 0 4 UnitCode Unit Code      
PCR4021 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PCR4022 NVARCHAR VSTRING 6 0 6 TargetWH Target Warehouse      
PCR4023 DATETIME DATE 0 0 8 RequiredDeliveryDate Required Delivery Date      
PCR4024 NVARCHAR VSTRING 25 0 25 StockDescription2 Stock Description 2      
PCR4025 NUMERIC X_NUMERIC 26 8 18 UnitConversionFactor Unit Conversion Factor      
PCR4026 NCHAR STRING 1 0 1 SuppManualChange Was Supplier manually changed?      
PCR4027 NCHAR STRING 1 0 1 PriceManualChange Was Price manually changed?      
PCR4028 INT INTEGER 0 0 1 CreationSource Creation Source      
PCR4029 NCHAR STRING 10 0 10 PickListID Picking List Id      
PCR4030 NVARCHAR VSTRING 6 0 6 FromBin From Bin      
PCR4031 NVARCHAR VSTRING 6 0 6 ToBin To Bin      
PCR4032 INT INTEGER 0 0 1 PickingStatus Picking Status 0 – Not Processed
1 — Request Created
2 – Printed
3 – Started
4 – Closed
   
PCR4033 NUMERIC X_NUMERIC 20 8 12 QtyIssued Issued (Delivered) Quantity      
PCR4034 NCHAR STRING 10 0 10 OrReference OR Reference Link requisitions released from MRP or SRP to demand    
PCR4035 NCHAR STRING 14 0 14 OrLineRef OR Line Ref Link requisitions released from MRP or SRP to demand    
PCR4036 NVARCHAR VSTRING 150 0 150 ExUserDef1 Extended User-Defined Field 1      
PCR4037 NVARCHAR VSTRING 150 0 150 ExUserDef2 Extended User-Defined Field 2      
PCR4038 NVARCHAR VSTRING 150 0 150 ExUserDef3 Extended User-Defined Field 3      
PCR4039 NVARCHAR VSTRING 150 0 150 ExUserDef4 Extended User-Defined Field 4      
PCR4040 NVARCHAR VSTRING 150 0 150 ExUserDef5 Extended User-Defined Field 5      
PCR4041 NVARCHAR VSTRING 150 0 150 ExUserDef6 Extended User-Defined Field 6      
PCR4042 NVARCHAR VSTRING 150 0 150 ExUserDef7 Extended User-Defined Field 7      
PCR4043 NVARCHAR VSTRING 150 0 150 ExUserDef8 Extended User-Defined Field 8      
PCR4044 NVARCHAR VSTRING 150 0 150 ExUserDef9 Extended User-Defined Field 9      
PCR4045 NVARCHAR VSTRING 150 0 150 ExUserDef10 Extended User-Defined Field 10      
PCR4046 NVARCHAR VSTRING 150 0 150 ExUserDef11 Extended User-Defined Field 11      
PCR4047 NVARCHAR VSTRING 150 0 150 ExUserDef12 Extended User-Defined Field 12      
PCR4048 NVARCHAR VSTRING 150 0 150 ExUserDef13 Extended User-Defined Field 13      
PCR4049 NVARCHAR VSTRING 150 0 150 ExUserDef14 Extended User-Defined Field 14      
PCR4050 NVARCHAR VSTRING 150 0 150 ExUserDef15 Extended User-Defined Field 15      
PCR4051 NVARCHAR VSTRING 150 0 150 ExUserDef16 Extended User-Defined Field 16      
PCR4052 NVARCHAR VSTRING 150 0 150 ExUserDef17 Extended User-Defined Field 17      
PCR4053 NVARCHAR VSTRING 150 0 150 ExUserDef18 Extended User-Defined Field 18      
PCR4054 NVARCHAR VSTRING 150 0 150 ExUserDef19 Extended User-Defined Field 19      
PCR4055 NVARCHAR VSTRING 150 0 150 ExUserDef20 Extended User-Defined Field 20      

Навигация: