На один уровень вверх / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Project Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PR46 — Invoice Statistics Lines

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR46001 NVARCHAR VSTRING 12 0 12 ProjectNo Project Number   1 Да
PR46002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да
PR46003 NVARCHAR VSTRING 6 0 6 LineNumber Line Number   3 Да
PR46004 NVARCHAR VSTRING 6 0 6 SubProject 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 ActivCode 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 6 0 6 TransactionNoAct Activity Transaction Line      
PR46030 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      

Навигация: