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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PCR4001 NVARCHAR VSTRING 10 0 10 Requisition Header No Requisition Number   1 Да
PCR4002 NVARCHAR VSTRING 4 0 4 Requisition Line No Requisition Line Number   2 Да
PCR4003 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
   
PCR4004 NVARCHAR VSTRING 6 0 6 Department Code Department Code      
PCR4005 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
PCR4006 NVARCHAR VSTRING 10 0 10 Supplier Code Supplier Code      
PCR4007 NVARCHAR VSTRING 35 0 35 Stock Code Stock Item Code      
PCR4008 NVARCHAR VSTRING 25 0 25 Stock Description 1 Stock Item Description      
PCR4009 NUMERIC X_NUMERIC 20 8 12 Quantity Ordered Quantity Ordered      
PCR4010 NUMERIC MONEY 28 8 20 Price Unit Price      
PCR4011 NVARCHAR VSTRING 1 0 1 Authorization Status Authorization Status 0 - Not authorized
1 - Authorized
2 - Rejected
   
PCR4012 NVARCHAR VSTRING 8 0 8 User Code (Who last entered authorisation status) Last Authorized By      
PCR4013 NVARCHAR VSTRING 50 0 50 Accounting String Accounting String      
PCR4014 NVARCHAR VSTRING 8 0 8 User Code (Who printed the requisition line) Printed By      
PCR4015 DATETIME DATE 0 0 8 Requisition Date Requisition Date      
PCR4016 NVARCHAR VSTRING 8 0 8 User Code (Who entered/adjusted the requisition line) Updated By      
PCR4017 NVARCHAR VSTRING 4 0 4 Linked requisition line No. Linked Requisition Line Number      
PCR4018 NVARCHAR VSTRING 1 0 1 Was Acc.String manually changed ? Accounting String Manually Changed      
PCR4019 NCHAR SWITCH 1 0 1 Nonregistered Item Non-Stock Item      
PCR4020 INT INTEGER 0 0 4 Unit Code Unit Code      
PCR4021 NVARCHAR VSTRING 2 0 2 Currency Code Currency Code      
PCR4022 NVARCHAR VSTRING 6 0 6 Target Warehause Target Warehouse      
PCR4023 DATETIME DATE 0 0 8 Required Delivery Date        
PCR4024 NVARCHAR VSTRING 25 0 25 Stock Description 2        
PCR4025 NUMERIC X_NUMERIC 26 8 18 Unit Conversion Factor        
PCR4026 NCHAR STRING 1 0 1 Was Supplier manually changed? Was Supplier manually changed?      
PCR4027 NCHAR STRING 1 0 1 Was Price manually changed? Was Price manually changed?      
PCR4028 INT INTEGER 0 0 1 CreationSource Creation Source      
PCR4029 NCHAR STRING 10 0 10 Picking List Id Picking List Id      
PCR4030 NVARCHAR VSTRING 6 0 6 From Bin From Bin      
PCR4031 NVARCHAR VSTRING 6 0 6 To Bin To Bin      
PCR4032 INT INTEGER 0 0 1 Picking Status Picking Status 0 – Not Processed
1 - Request Created
2 – Printed
3 – Started
4 – Closed
   
PCR4033 NUMERIC X_NUMERIC 20 8 12 Issued (Delivered) Quantity Issued (Delivered) Quantity      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Order | Requisition Template Line