One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Project Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PR44 — Project Delivered Material

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR44001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да
PR44002 NVARCHAR VSTRING 6 0 6 SubProject 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 6 0 6 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 OrderNumber Order Number      
PR44014 NVARCHAR VSTRING 6 0 6 LineNumber 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 QtyOrderedSC Quantity Ordered (Stock Unit)      
PR44020 NUMERIC X_NUMERIC 20 8 12 QtyDelivSC 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 UnitPriceExclDisc Unit Price Excluding Discount (Project Currency)      
PR44024 NUMERIC MONEY 28 8 20 UnitPriceInclDisc Unit Price Including Discount (Project Currency)      
PR44025 NUMERIC MONEY 28 8 20 UnitPriceExclDiscLCU Unit Price Excluding Discount (Local Currency)      
PR44026 NUMERIC MONEY 28 8 20 UnitPriceInclDiscLCU 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 VATCode 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 %      
PR44046 NCHAR STRING 1 0 1 ItemType Item Type      
PR44047 DATETIME DATE 0 0 8 CloseDate Close Date      

Навигация: