пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PR44 — Project Delivered Material

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR44001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да / Yes
PR44002 NVARCHAR VSTRING 6 0 6 SubProject Sub-Project   2 Да / Yes
PR44003 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number   3 Да / Yes
PR44004 NVARCHAR VSTRING 6 0 6 ActivStrLine Activity Sub-line Number   4 Да / Yes
PR44005 DATETIME DATE 0 0 8 TransactDate Transaction Date   5 Да / Yes
PR44006 NVARCHAR VSTRING 10 0 10 ResourceCode Resource Code   6 Да / Yes
PR44007 NVARCHAR VSTRING 6 0 6 TransactLine Transaction Line Number   7 Да / Yes
PR44008 NVARCHAR VSTRING 6 0 6 DelivTransLn Delivery Line Number   8 Да / Yes
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      
PR44048 NCHAR STRING 3 0 3 Taxation Reason Code Taxation Reason Code      

Навигация / Navigation: