Таблица | Table: PCR2 - «Requisition Line». Маска имени таблицы | Table Name Mask: «PCR2%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
PCR2001 NVARCHAR VSTRING 10 0 10 Requisition Header No Requisition Number   1 Да / Yes
PCR2002 NVARCHAR VSTRING 4 0 4 Requisition Line No Requisition Line Number   2 Да / Yes
PCR2003 NVARCHAR VSTRING 1 0 1 Requisition Type 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 Department Code Department Code      
PCR2005 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
PCR2006 NVARCHAR VSTRING 10 0 10 Supplier Code Supplier Code      
PCR2007 NVARCHAR VSTRING 35 0 35 Stock Code Stock Item Code      
PCR2008 NVARCHAR VSTRING 25 0 25 Stock Description 1 Stock Item Description      
PCR2009 NUMERIC X_NUMERIC 20 8 12 Quantity Ordered Quantity Ordered      
PCR2010 NUMERIC MONEY 28 8 20 Price Unit Price      
PCR2011 NVARCHAR VSTRING 1 0 1 Authorization Status Authorization Status 0 - Not authorized
1 - Authorized
2 - Rejected		    
PCR2012 NVARCHAR VSTRING 8 0 8 User Code (Who last entered authorisation status) Last Authorized By      
PCR2013 NVARCHAR VSTRING 50 0 50 Accounting String Accounting String      
PCR2014 NVARCHAR VSTRING 8 0 8 User Code (Who printed the requisition line) Printed By      
PCR2015 DATETIME DATE 0 0 8 Requisition Date Requisition Date      
PCR2016 NVARCHAR VSTRING 8 0 8 User Code (Who entered/adjusted the requisition line) Updated By      
PCR2017 NVARCHAR VSTRING 4 0 4 Linked requisition line No. Linked Requisition Line Number      
PCR2018 NVARCHAR VSTRING 1 0 1 Was Acc.String manually changed ? Accounting String Manually Changed      
PCR2019 NCHAR SWITCH 1 0 1 Nonregistered Item Non-Stock Item      
PCR2020 INT INTEGER 0 0 4 Unit Code Unit Code      
PCR2021 NVARCHAR VSTRING 2 0 2 Currency Code Currency Code      
PCR2022 NVARCHAR VSTRING 6 0 6 Target Warehouse Target Warehouse      
PCR2023 DATETIME DATE 0 0 8 Required Delivery Date        
PCR2024 NVARCHAR VSTRING 25 0 25 Stock Description 2        
PCR2025 NUMERIC X_NUMERIC 26 8 18 Unit Conversion Factor        
PCR2026 NCHAR STRING 1 0 1 Was Supplier manually changed? Was Supplier manually changed?      
PCR2027 NCHAR STRING 1 0 1 Was Price manually changed? Was Price manually changed?      
PCR2028 INT INTEGER 0 0 1 CreationSource Creation Source      
PCR2029 NCHAR STRING 10 0 10 Picking List Id Picking List Id      
PCR2030 NVARCHAR VSTRING 6 0 6 From Bin From Bin      
PCR2031 NVARCHAR VSTRING 6 0 6 To Bin To Bin      
PCR2032 INT INTEGER 0 0 1 Picking Status Picking Status      
PCR2033 NUMERIC X_NUMERIC 20 8 12 Issued (Delivered) Quantity Issued (Delivered) Quantity      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | Requisition Line