Таблица: PR38 - «Project Invoice History Details File». Маска имени таблицы: «PR38%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR38001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да
PR38002 NVARCHAR VSTRING 6 0 6 SubProject Sub-Project Invoice Only used when invoicing is done on sub-project level 2 Да
PR38003 DATETIME DATE 0 0 8 InvoiceDate Invoice Date   3 Да
PR38004 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   4 Да
PR38005 NVARCHAR VSTRING 2 0 2 SequenceNo Sequence Number   6 Да
PR38006 NVARCHAR VSTRING 46 0 46 InvSortCode Invoice Sort Key   7 Да
PR38007 NVARCHAR VSTRING 10 0 10 Manager Resource Code Manager      
PR38008 NVARCHAR VSTRING 6 0 6 SubProjTrans Sub-Project Transaction      
PR38009 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number      
PR38010 NVARCHAR VSTRING 6 0 6 ActivStruLin Activity Sub-line Number      
PR38011 DATETIME DATE 0 0 8 TransactDate Transaction Date      
PR38012 NVARCHAR VSTRING 10 0 10 ResourceCode Resource Code      
PR38013 NVARCHAR VSTRING 6 0 6 TransactLine Transaction Line Number      
PR38014 NUMERIC MONEY 28 8 20 PropInvAmoun Invoice Line Amount      
PR38015 NUMERIC MONEY 28 8 20 PriceToInvo Unit Price to Invoice (Project Currency)      
PR38016 NUMERIC X_NUMERIC 20 8 12 HoursQty Quantity/Hours to Invoice      
PR38017 NUMERIC X_NUMERIC 14 8 6 Markup Mark-up %      
PR38018 NUMERIC MONEY 28 8 20 PrcFromFixPr Distributed Price from Fixed Price      
PR38019 NVARCHAR VSTRING 1 0 1 ActivityType Activity Type 0 - Cost Activity
1 - Time Activity
2 - Material Activity (Sales Order or Purchase Order)
5 - Linked Sales Order
6 - Linked Purchase Order
7 - Linked Service Order
8 - Linked Contract
9 - Linked Work Order		    
PR38020 NVARCHAR VSTRING 6 0 6 ActivityCode Activity Code      
PR38021 NVARCHAR VSTRING 4 0 4 LinNoInvPlan Line Number on Invoice Plan      
PR38022 NVARCHAR VSTRING 1 0 1 InvTrigger Selected for Invoice      
PR38023 NVARCHAR VSTRING 1 0 1 InclFixedPrc Included in Fixed Price      
PR38024 NCHAR STRING 15 0 15 CreditforInvoiceNo Invoice Number to be Credited      
PR38025 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
PR38026 NCHAR STRING 2 0 2 LineType Line Type Either an activity type 0-9 or 50 for details of deduction of advance amounts on invoices. 5 Да
PR38027 NVARCHAR VSTRING 15 0 15 InitialInvoiceNumber Initial Invoice Number      
PR38028 NCHAR STRING 6 0 6 TAXCode VAT Code      
PR38029 NUMERIC MONEY 28 8 20 TAXAmount VAT Amount (Project Currency)      
PR38030 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
PR38031 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Project Invoice History Details