Таблица: 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