Таблица | Table: PCR5 - «Requisition History Lines». Маска имени таблицы | Table Name Mask: «PCR5%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?
PCR5001 NVARCHAR VSTRING 10 0 10 Requisition Header No Requisition Number   1 Да / Yes
PCR5002 NVARCHAR VSTRING 4 0 4 Requisition Line No Requisition Line Number   2 Да / Yes
PCR5003 NVARCHAR VSTRING 1 0 1 Request Type 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 Department Code 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 Stock Code Stock Item Code      
PCR5008 NVARCHAR VSTRING 25 0 25 Stock Description 1 Stock Item Description      
PCR5009 NUMERIC X_NUMERIC 20 8 12 Quantity Ordered Quantity Ordered      
PCR5010 NUMERIC MONEY 28 8 20 Price Unit Price      
PCR5011 NVARCHAR VSTRING 1 0 1 Authorization Status Authorization Status 0 - Not authorized
1 - Authorized
2 - Rejected		    
PCR5012 NVARCHAR VSTRING 8 0 8 User Code (Who last entered authorisation status) Last Authorized By      
PCR5013 NVARCHAR VSTRING 50 0 50 Accounting String Accounting String      
PCR5014 NVARCHAR VSTRING 8 0 8 User Code (Who printed the requisition line) Printed By      
PCR5015 DATETIME DATE 0 0 8 Requisition Date Requisition Date      
PCR5016 NVARCHAR VSTRING 8 0 8 User Code (Who entered requisition) Created/Updated By      
PCR5017 NVARCHAR VSTRING 4 0 4 Linked requisition line No. Linked Requisition Line Number      
PCR5018 NVARCHAR VSTRING 1 0 1 Was Acc.String manually changed ? Accounting String Manually Changed      
PCR5019 NVARCHAR VSTRING 6 0 6 To Warehouse To Warehouse      
PCR5020 NUMERIC X_NUMERIC 20 8 12 Issued (Delivered) Quantity Issued (Delivered) Quantity      
PCR5021 NVARCHAR VSTRING 10 0 10 Purchase Order No Purchase Order Number      
PCR5022 NVARCHAR VSTRING 6 0 6 Purchase Order Line No Purchase Order Line Number      
PCR5023 NVARCHAR VSTRING 6 0 6 Purchase Order SubLine No Purchase Order Sub-line Number      
PCR5024 DATETIME DATE 0 0 8 Issue/Receipt Date Issue/Receipt Date      
PCR5025 NVARCHAR VSTRING 1 0 1 Requisition Line Status Requisition Line Status      
PCR5026 DATETIME DATE 0 0 8 Conversion/Deletion Date Conversion/Deletion Date      
PCR5027 NCHAR SWITCH 1 0 1 Nonregistered Item Non-Stock Item      
PCR5028 INT INTEGER 0 0 4 Unit Code Unit Code      
PCR5029 NVARCHAR VSTRING 2 0 2 Currency Code Currency Code      
PCR5030 DATETIME DATE 0 0 8 Required Delivery Date        
PCR5031 NVARCHAR VSTRING 25 0 25 Stock Description 2        
PCR5032 NUMERIC X_NUMERIC 26 8 18 Unit Conversion Factor        
PCR5033 NCHAR STRING 1 0 1 Was Supplier manually changed? Was Supplier manually changed?      
PCR5034 NCHAR STRING 1 0 1 Was Price manually changed? Was Price manually changed?      
PCR5035 NCHAR STRING 10 0 10 Picking List Id Picking List Id      
PCR5036 NVARCHAR VSTRING 6 0 6 From Bin From Bin      
PCR5037 NVARCHAR VSTRING 6 0 6 To Bin To Bin      
PCR5038 INT INTEGER 0 0 1 Picking Status Picking Status 0 – Not Processed
1 - Request Created
2 – Printed
3 – Started
4 – Closed		    
PCR5039 NUMERIC X_NUMERIC 20 8 12 Spare Spare      

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