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