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 PCR2 — Requisition Line

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PCR2001 NVARCHAR VSTRING 10 0 10 RequisitionHeaderNo Requisition Number   1 Да / Yes
PCR2002 NVARCHAR VSTRING 4 0 4 RequisitionLineNo Requisition Line Number   2 Да / Yes
PCR2003 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
   
PCR2004 NVARCHAR VSTRING 6 0 6 DepartmentCode Department Code      
PCR2005 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
PCR2006 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
PCR2007 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
PCR2008 NVARCHAR VSTRING 25 0 25 StockDescription1 Stock Item Description      
PCR2009 NUMERIC X_NUMERIC 20 8 12 QuantityOrdered Quantity Ordered      
PCR2010 NUMERIC MONEY 28 8 20 Price Unit Price      
PCR2011 NVARCHAR VSTRING 1 0 1 AuthorizationStatus Authorization Status 0 — Not authorized

1 — Authorized

2 — Rejected
   
PCR2012 NVARCHAR VSTRING 8 0 8 UserEnterAuthStatus Last Authorized By      
PCR2013 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
PCR2014 NVARCHAR VSTRING 8 0 8 UserPrintRqsnLine Printed By      
PCR2015 DATETIME DATE 0 0 8 RequisitionDate Requisition Date      
PCR2016 NVARCHAR VSTRING 8 0 8 UserEnterAdjRqsnLine Updated By      
PCR2017 NVARCHAR VSTRING 4 0 4 LinkedRqsnLine Linked Requisition Line Number      
PCR2018 NVARCHAR VSTRING 1 0 1 AccStrManualChange Accounting String Manually Changed      
PCR2019 NCHAR SWITCH 1 0 1 NonregisteredItem Non-Stock Item      
PCR2020 INT INTEGER 0 0 4 UnitCode Unit Code      
PCR2021 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PCR2022 NVARCHAR VSTRING 6 0 6 TargetWH Target Warehouse      
PCR2023 DATETIME DATE 0 0 8 RequiredDeliveryDate Required Delivery Date      
PCR2024 NVARCHAR VSTRING 25 0 25 StockDescription2 Stock Description 2      
PCR2025 NUMERIC X_NUMERIC 26 8 18 UnitConversionFactor Unit Conversion Factor      
PCR2026 NCHAR STRING 1 0 1 SuppManualChange Was Supplier manually changed?      
PCR2027 NCHAR STRING 1 0 1 PriceManualChange Was Price manually changed?      
PCR2028 INT INTEGER 0 0 1 CreationSource Creation Source      
PCR2029 NCHAR STRING 10 0 10 PickListID Picking List Id      
PCR2030 NVARCHAR VSTRING 6 0 6 FromBin From Bin      
PCR2031 NVARCHAR VSTRING 6 0 6 ToBin To Bin      
PCR2032 INT INTEGER 0 0 1 PickingStatus Picking Status      
PCR2033 NUMERIC X_NUMERIC 20 8 12 QtyIssued Issued (Delivered) Quantity      
PCR2034 NCHAR STRING 10 0 10 OrReference OR Reference Link requisitions released from MRP or SRP to demand    
PCR2035 NCHAR STRING 14 0 14 OrLineRef OR Line Reference Link requisitions released from MRP or SRP to demand    
PCR2036 NVARCHAR VSTRING 150 0 150 ExUserDef1 Extended User-Defined Field 1      
PCR2037 NVARCHAR VSTRING 150 0 150 ExUserDef2 Extended User-Defined Field 2      
PCR2038 NVARCHAR VSTRING 150 0 150 ExUserDef3 Extended User-Defined Field 3      
PCR2039 NVARCHAR VSTRING 150 0 150 ExUserDef4 Extended User-Defined Field 4      
PCR2040 NVARCHAR VSTRING 150 0 150 ExUserDef5 Extended User-Defined Field 5      
PCR2041 NVARCHAR VSTRING 150 0 150 ExUserDef6 Extended User-Defined Field 6      
PCR2042 NVARCHAR VSTRING 150 0 150 ExUserDef7 Extended User-Defined Field 7      
PCR2043 NVARCHAR VSTRING 150 0 150 ExUserDef8 Extended User-Defined Field 8      
PCR2044 NVARCHAR VSTRING 150 0 150 ExUserDef9 Extended User-Defined Field 9      
PCR2045 NVARCHAR VSTRING 150 0 150 ExUserDef10 Extended User-Defined Field 10      
PCR2046 NVARCHAR VSTRING 150 0 150 ExUserDef11 Extended User-Defined Field 11      
PCR2047 NVARCHAR VSTRING 150 0 150 ExUserDef12 Extended User-Defined Field 12      
PCR2048 NVARCHAR VSTRING 150 0 150 ExUserDef13 Extended User-Defined Field 13      
PCR2049 NVARCHAR VSTRING 150 0 150 ExUserDef14 Extended User-Defined Field 14      
PCR2050 NVARCHAR VSTRING 150 0 150 ExUserDef15 Extended User-Defined Field 15      
PCR2051 NVARCHAR VSTRING 150 0 150 ExUserDef16 Extended User-Defined Field 16      
PCR2052 NVARCHAR VSTRING 150 0 150 ExUserDef17 Extended User-Defined Field 17      
PCR2053 NVARCHAR VSTRING 150 0 150 ExUserDef18 Extended User-Defined Field 18      
PCR2054 NVARCHAR VSTRING 150 0 150 ExUserDef19 Extended User-Defined Field 19      
PCR2055 NVARCHAR VSTRING 150 0 150 ExUserDef20 Extended User-Defined Field 20      

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