Таблица: PR27 - «Project Invoice Proposal Transaction File». Маска имени таблицы: «PR27%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR27001 | NVARCHAR | VSTRING | 12 | 0 | 12 | ProjectNo | Project Number | 1 | Да | |
PR27002 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProject | Sub-Project | Only used when invoicing is done on sub-project level | 2 | Да |
PR27003 | NVARCHAR | VSTRING | 2 | 0 | 2 | SequenceNo | Sequence Number | Reserved for future use to support multiple active invoice proposals for one project/sub-project | 4 | Да |
PR27004 | NVARCHAR | VSTRING | 43 | 0 | 43 | InvSortCode | Invoice Sort Key | This string include key values stored in the order of the invoice sort code to be able to sort the invoice correctly. | 5 | Да |
PR27005 | NVARCHAR | VSTRING | 10 | 0 | 10 | Manager | Resource Code Manager | |||
PR27006 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProject | Sub-Project | |||
PR27007 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityLine | Activity Line Number | |||
PR27008 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivStruLin | Activity Sub-line Number | |||
PR27009 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
PR27010 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | |||
PR27011 | NVARCHAR | VSTRING | 3 | 0 | 3 | TransactLine | Transact Line Number | |||
PR27012 | NUMERIC | MONEY | 28 | 8 | 20 | PropInvAmoun | Proposed Invoice Amount (Project Currency) | |||
PR27013 | NUMERIC | MONEY | 28 | 8 | 20 | PriceToInvo | Unit Price to Invoice (Project Currency) | |||
PR27014 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursQty | Quantity/Hours to Invoice | |||
PR27015 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Markup | Mark-up % | |||
PR27016 | NUMERIC | MONEY | 28 | 8 | 20 | PrcFromFixPr | Distributed Price from Fixed Price | |||
PR27017 | NVARCHAR | VSTRING | 1 | 0 | 1 | ActivityType | Activity Type | 0 - Cost Activity
1 - Time Activity 2 - Material Activity (Sales Order or Purchase Order) 3 - Milestone 4 - Text Annotation 5 - Linked Sales Order 6 - Linked Purchase Order 7 - Linked Service Order 8 - Linked Contract 9 - Linked Work Order |
||
PR27018 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityCode | Activity Code | |||
PR27019 | NVARCHAR | VSTRING | 4 | 0 | 4 | LinNoInvPlan | Line Number on Invoice Plan | |||
PR27020 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvTrigger | Selected for Invoice | |||
PR27021 | NVARCHAR | VSTRING | 1 | 0 | 1 | InclFixedPrc | Included in Fixed Price | |||
PR27022 | NCHAR | STRING | 10 | 0 | 10 | Credit_for_InvoiceNo | Invoice Number to be Credited | |||
PR27023 | NCHAR | STRING | 10 | 0 | 10 | Customer_Code_Invoice | Customer Code Invoice | 3 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Project Management | Project Invoice Proposal Transactions