Таблица: PR46 - «Invoice Statistics Lines». Маска имени таблицы: «PR46%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR46001 NVARCHAR VSTRING 12 0 12 Project_No Project Number   1 Да
PR46002 NVARCHAR VSTRING 15 0 15 Invoice_No Invoice Number   2 Да
PR46003 NVARCHAR VSTRING 6 0 6 Line_Number Line Number   3 Да
PR46004 NVARCHAR VSTRING 6 0 6 Sub_Project Sub-Project      
PR46005 NVARCHAR VSTRING 35 0 35 DescrSubProj Description Sub-Project      
PR46006 NVARCHAR VSTRING 10 0 10 ManagSubProj Manager Sub-Project      
PR46007 NVARCHAR VSTRING 6 0 6 ActivityLine Activity Line Number      
PR46008 NVARCHAR VSTRING 6 0 6 ActivStrLine Activity Sub-line Number      
PR46009 NVARCHAR VSTRING 6 0 6 Activ_Code Activity Code      
PR46010 NVARCHAR VSTRING 1 0 1 TypeOfActiv 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
   
PR46011 NVARCHAR VSTRING 35 0 35 DescActiLine Description Activity Line      
PR46012 NVARCHAR VSTRING 10 0 10 ManaActiLine Manager Activity Line      
PR46013 NVARCHAR VSTRING 1 0 1 InclFixPrice Is Included in Fixed Price      
PR46014 NVARCHAR VSTRING 8 0 8 ReportCode Report Code Transaction      
PR46015 NVARCHAR VSTRING 1 0 1 LinkedModule Linked Module Only used for activity type 0 and 2:
0 - Purchase Order
1 - Sales Order
   
PR46016 NVARCHAR VSTRING 10 0 10 LinkedOrdNo Linked Order Number      
PR46017 DATETIME DATE 0 0 8 TransactDate Transaction Date      
PR46018 NVARCHAR VSTRING 10 0 10 ResourceCode Resource Code      
PR46019 NUMERIC X_NUMERIC 20 8 12 InvcdHrsQty Invoiced Quantity/Hours      
PR46020 NUMERIC MONEY 28 8 20 InvoicePrice Unit Price Invoiced (Project Currency)      
PR46021 NUMERIC MONEY 28 8 20 Cost Unit Cost (Local Currency)      
PR46022 NVARCHAR VSTRING 1 0 1 ChargeCode Charge Activity 0 - Activity shall not be charged to customer but cost allocated to the project
1 - Activity will included when invoicing the project
   
PR46023 NVARCHAR ACCSTR 50 0 50 AccounString Accounting String      
PR46024 NVARCHAR VSTRING 6 0 6 VATcode VAT Code      
PR46025 NVARCHAR VSTRING 6 0 6 LinkActiLine Linked Activity Line Number      
PR46026 NVARCHAR VSTRING 6 0 6 LnkActStrLin Linked Activity Sub-line Number      
PR46027 NVARCHAR VSTRING 1 0 1 DateType012 Date Type Time reported as per:
0 - Date
1 - Week
2 - Month
   
PR46028 NUMERIC X_NUMERIC 20 8 12 ActuHrsQty Actual Quantity/Hours      
PR46029 NCHAR STRING 3 0 3 TransactionNo_Act Activity Transaction Line      
PR46030 NCHAR STRING 10 0 10 Customer_Code_Invoice Customer Code Invoice      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Invoice Statistics Lines