На один уровень вверх / 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 PCR4 — Requisition Template Line

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PCR4001 NVARCHAR VSTRING 10 0 10 RequisitionHeaderNo Requisition Number   1 Да / Yes
PCR4002 NVARCHAR VSTRING 4 0 4 RequisitionLineNo Requisition Line Number   2 Да / Yes
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      

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