Таблица: PR44 - «Project Delivered Material». Маска имени таблицы: «PR44%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR44001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да
PR44002 NVARCHAR VSTRING 6 0 6 Sub_Project Sub-Project   2 Да
PR44003 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number   3 Да
PR44004 NVARCHAR VSTRING 6 0 6 ActivStrLine Activity Sub-line Number   4 Да
PR44005 DATETIME DATE 0 0 8 TransactDate Transaction Date   5 Да
PR44006 NVARCHAR VSTRING 10 0 10 ResourceCode Resource Code   6 Да
PR44007 NVARCHAR VSTRING 3 0 3 TransactLine Transaction Line Number   7 Да
PR44008 NVARCHAR VSTRING 6 0 6 DelivTransLn Delivery Line Number   8 Да
PR44009 NVARCHAR VSTRING 2 0 2 StoItemAcCod Accounting Code Stock Item      
PR44010 NVARCHAR ACCSTR 50 0 50 AccounString Accounting String      
PR44011 NVARCHAR VSTRING 35 0 35 StockItem Stock Item Code      
PR44012 NVARCHAR VSTRING 12 0 12 BatchNoDeliv Batch ID      
PR44013 NVARCHAR VSTRING 10 0 10 Order_Number Order Number      
PR44014 NVARCHAR VSTRING 6 0 6 Line_Number Order Line Number      
PR44015 NVARCHAR VSTRING 6 0 6 StructLineNo Order Sub-line Number      
PR44016 NVARCHAR VSTRING 4 0 4 AutSubStrLNo Order Delivery Line Number      
PR44017 NUMERIC X_NUMERIC 20 8 12 QtyOrdered Quantity Ordered (Order Unit)      
PR44018 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered (Order Unit)      
PR44019 NUMERIC X_NUMERIC 20 8 12 QtyOrdered Quantity Ordered (Stock Unit)      
PR44020 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered (Stock Unit)      
PR44021 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PR44022 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
PR44023 NUMERIC MONEY 28 8 20 PrUnitDisc Unit Price Excluding Discount (Project Currency)      
PR44024 NUMERIC MONEY 28 8 20 PrUnitDisc Unit Price Including Discount (Project Currency)      
PR44025 NUMERIC MONEY 28 8 20 PrUnitDisc Unit Price Excluding Discount (Local Currency)      
PR44026 NUMERIC MONEY 28 8 20 PrUnitDisc Unit Price Including Discount (Local Currency)      
PR44027 NUMERIC X_NUMERIC 28 8 20 DelivDaExRat Delivery Date Exchange Rate      
PR44028 NUMERIC MONEY 28 8 20 CostUnit Unit Cost (Local Currency)      
PR44029 DATETIME DATE 0 0 8 DeliDateRequ Delivery Date Requested      
PR44030 DATETIME DATE 0 0 8 DeliDateComm Delivery Date Committed      
PR44031 DATETIME DATE 0 0 8 DeliDateActu Delivery Date Actual      
PR44032 NVARCHAR VSTRING 20 0 20 DeliNoteNo Delivery Note Number      
PR44033 NVARCHAR VSTRING 1 0 1 DelivNotePrn Delivery Note Print Status 0/1 - Delivery note was not printed for the delivery line
2 - Delivery note has been printed for the delivery line
   
PR44034 NVARCHAR VSTRING 1 0 1 PickListPrin Line Layout 0 - The line is NOT printed on order documents.
1 - The line is printed with quantity, unit price and line total (Controlled by DDF file).
2 - The line is printed with line total amount only on the documents (Controlled by DDF file).
   
PR44035 NVARCHAR VSTRING 1 0 1 DeliPropPrin BOM Level 0 - Not a BOM line
5 - The order line is the top level in a BOM structure
6 - The order line is the lowest level in a BOM structure
7 - The order line is a intermediate level in a BOM structure
   
PR44036 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PR44037 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PR44038 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
PR44039 NVARCHAR VSTRING 10 0 10 PickListNo Picking List Number      
PR44040 NVARCHAR VSTRING 10 0 10 DelivPropNo Delivery Proposal Number      
PR44041 NUMERIC MONEY 28 8 20 ConsCostType Unit Cost (Alternative Currency)      
PR44042 NVARCHAR VSTRING 6 0 6 VAT_Code VAT Code      
PR44043 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
PR44044 NUMERIC X_NUMERIC 14 8 6 LineDiscount Line Discount %      
PR44045 NUMERIC X_NUMERIC 14 8 6 OrdDiscount Order Discount %      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Project Delivered Material