пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Project Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PR13 — Project Module Parameters

Таблица: PR13 — «Project Module Parameters». Маска имени таблицы: «PR13%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PR13001 NVARCHAR VSTRING 1 0 1 IndexID Index Key   1 Да
PR13002 NVARCHAR VSTRING 1 0 1 PrjNoCounTpA (obsolete)      
PR13003 NVARCHAR VSTRING 1 0 1 PrjNoCounTpB (obsolete)      
PR13004 NVARCHAR VSTRING 1 0 1 PrjNoCounTpC (obsolete)      
PR13005 NVARCHAR VSTRING 1 0 1 PrjNoCounTpD (obsolete)      
PR13006 NVARCHAR VSTRING 1 0 1 PrjNoCounTpE (obsolete)      
PR13007 NVARCHAR VSTRING 1 0 1 PrjNoCounTpF (obsolete)      
PR13008 NVARCHAR VSTRING 1 0 1 PrjNoCounTpG (obsolete)      
PR13009 NVARCHAR VSTRING 1 0 1 NoOfLngeUsed (obsolete)      
PR13010 NVARCHAR VSTRING 1 0 1 InvoiNoCount (obsolete)      
PR13011 NVARCHAR VSTRING 1 0 1 CredNotNoCou (obsolete)      
PR13012 NVARCHAR VSTRING 1 0 1 IntInvNoCoun (obsolete)      
PR13013 NVARCHAR VSTRING 2 0 2 NoOfInvCopy Number of Invoice Copies      
PR13014 NVARCHAR VSTRING 20 0 20 InvFeeLCU Invoicing Fee (Local Currency)      
PR13015 NVARCHAR VSTRING 1 0 1 PrjNoCounTpH (obsolete)      
PR13016 NVARCHAR VSTRING 1 0 1 PrjNoCounTpI (obsolete)      
PR13017 NVARCHAR VSTRING 1 0 1 PrjNoCounTpJ (obsolete)      
PR13018 NVARCHAR VSTRING 1 0 1 PrjNoCounTpK (obsolete)      
PR13019 NVARCHAR VSTRING 1 0 1 PrjNoCounTpL (obsolete)      
PR13020 NVARCHAR VSTRING 1 0 1 PrjNoCounTpM (obsolete)      
PR13021 NVARCHAR VSTRING 1 0 1 PrjNoCounTpN (obsolete)      
PR13022 NVARCHAR VSTRING 1 0 1 PrjNoCounTpO (obsolete)      
PR13023 NVARCHAR VSTRING 1 0 1 PrjNoCounTpP (obsolete)      
PR13024 NVARCHAR VSTRING 6 0 6 AveragMarkup Average On-cost %      
PR13025 INT INTEGER 0 0 1 FlagDocXMLInvoice Flag Doc XML Invoice      
PR13026 NVARCHAR VSTRING 4 0 4 LineIncrDef Activity Line Number Increment      
PR13027 NVARCHAR VSTRING 4 0 4 StruLineIncr Activity Sub-line Number Increment      
PR13028 NVARCHAR VSTRING 1 0 1 Tax Point (default) Tax Point (default)      
PR13029 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13030 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13031 NVARCHAR VSTRING 2 0 2 InvSortCode Invoice Sort Code Default      
PR13032 NVARCHAR VSTRING 1 0 1 Spare Print Non-Chargeable Activities 0 — Non-chargeable activities are not printed on Invoice proposal and invoice
1 — Non-chargeable activities are printed on invoice proposal only
2 — Non-chargeable activities are printed on both invoice proposal and invoice
   
PR13033 NVARCHAR VSTRING 8 0 8 StatInvDate Statistics on Invoice Date      
PR13034 NVARCHAR VSTRING 6 0 6 InternMarkUp On-cost Internal Invoice %      
PR13035 NVARCHAR VSTRING 6 0 6 TaxCodAcInv VAT Code On-account Invoices      
PR13036 NVARCHAR VSTRING 1 0 1 InvOnSubProjectLevl Invoice on Sub-Project Level      
PR13037 NVARCHAR VSTRING 1 0 1 NLtransaCoun (obsolete)      
PR13038 NVARCHAR VSTRING 1 0 1 ProjTransCou (obsolete)      
PR13039 NVARCHAR VSTRING 1 0 1 NoOfDeciCost Decimals in Quantity for Cost Activities      
PR13040 NVARCHAR VSTRING 1 0 1 NoOfDecTime Decimals in Hours for Time Activities      
PR13041 NVARCHAR VSTRING 4 0 4 Spare Invoice Plan Line Number Increment      
PR13042 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13043 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13044 NVARCHAR VSTRING 6 0 6 Journal Code for Revenue Recognition Journal Journal Code for Revenue Recognition Journal      
PR13045 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13046 NVARCHAR VSTRING 6 0 6 Journal Code for Project WIP Journal Journal Code for Project WIP Journal      
PR13047 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13048 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
PR13049 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13050 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13051 NVARCHAR VSTRING 1 0 1 DispNoteNo (obsolete)      
PR13052 NVARCHAR VSTRING 2 0 2 DispNoteCopy (obsolete)      
PR13053 NVARCHAR VSTRING 2 0 2 ConfirmCopy (obsolete)      
PR13054 NVARCHAR VSTRING 1 0 1 DiscountMeth (obsolete)      
PR13055 NVARCHAR VSTRING 20 0 20 InvoicingFee (obsolete)      
PR13056 NVARCHAR VSTRING 20 0 20 LimitInvFee (obsolete)      
PR13057 NVARCHAR VSTRING 2 0 2 AccCodeNoSto (obsolete)      
PR13058 NVARCHAR VSTRING 1 0 1 DefStatConf (obsolete)      
PR13059 NVARCHAR VSTRING 1 0 1 DefStatDispN (obsolete)      
PR13060 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13061 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13062 NVARCHAR VSTRING 1 0 1 AcsLevLinAdj (obsolete)      
PR13063 NVARCHAR VSTRING 1 0 1 AcsLevPrsAdj (obsolete)      
PR13064 NVARCHAR VSTRING 1 0 1 PrjNoCounTpQ (obsolete)      
PR13065 NVARCHAR VSTRING 1 0 1 PrjNoCounTpR (obsolete)      
PR13066 NVARCHAR VSTRING 1 0 1 PrjNoCounTpS (obsolete)      
PR13067 NVARCHAR VSTRING 1 0 1 PrjNoCounTpT (obsolete)      
PR13068 NVARCHAR VSTRING 1 0 1 PrjNoCounTpU (obsolete)      
PR13069 NVARCHAR VSTRING 1 0 1 PrjNoCounTpV (obsolete)      
PR13070 NVARCHAR VSTRING 1 0 1 PrjNoCounTpW (obsolete)      
PR13071 NVARCHAR VSTRING 1 0 1 PrjNoCounTpX (obsolete)      
PR13072 NVARCHAR VSTRING 1 0 1 PrjNoCounTpY (obsolete)      
PR13073 NVARCHAR VSTRING 1 0 1 PrjNoCounTpZ (obsolete)      
PR13074 NVARCHAR VSTRING 1 0 1 DefaultInvoiceSplit Default invoice split Used as default value for ‘Separate per invoice’ parameter in Print Invoice(Credit Note)    
PR13075 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13076 NVARCHAR VSTRING 10 0 10 MinInvAmount Minimum Invoice Amount (Local Currency)      
PR13077 NVARCHAR VSTRING 6 0 6 MarkupTimeB Price Increase Time % — Cost Category B      
PR13078 NVARCHAR VSTRING 6 0 6 MarkupTimeC Price Increase Time % — Cost Category C      
PR13079 NVARCHAR VSTRING 6 0 6 MarkupTimeD Price Increase Time % — Cost Category D      
PR13080 NVARCHAR VSTRING 6 0 6 MarkupTimeE Price Increase Time % — Cost Category E      
PR13081 NVARCHAR VSTRING 6 0 6 MarkupTimeF Price Increase Time % — Cost Category F      
PR13082 NVARCHAR VSTRING 1 0 1 PerfCrTestEn Credit Control Enabled      
PR13083 NVARCHAR VSTRING 1 0 1 GenPayrTrans Create Payroll Transactions      
PR13084 NVARCHAR VSTRING 1 0 1 AllocStrBase (obsolete)      
PR13085 NVARCHAR VSTRING 1 0 1 PrnDispNote (obsolete)      
PR13086 NVARCHAR VSTRING 1 0 1 DelivDateWN (obsolete)      
PR13087 NVARCHAR VSTRING 1 0 1 EnterDiscPr (obsolete)      
PR13088 NVARCHAR VSTRING 1 0 1 QtyPackUnit (obsolete)      
PR13089 NVARCHAR VSTRING 1 0 1 CreaPurcProp (obsolete)      
PR13090 NVARCHAR VSTRING 1 0 1 DelivPlann (obsolete)      
PR13091 NVARCHAR VSTRING 1 0 1 AutStrPrepar (obsolete)      
PR13092 NVARCHAR VSTRING 1 0 1 SortPickList (obsolete)      
PR13093 NVARCHAR VSTRING 1 0 1 DiscProdGrou (obsolete)      
PR13094 NVARCHAR VSTRING 1 0 1 IngrNominLed Integrated with General Ledger      
PR13095 NVARCHAR VSTRING 1 0 1 UseGLTransCounter Use General Ledger Transaction Counter      
PR13096 NVARCHAR VSTRING 1 0 1 StockAcMater (obsolete)      
PR13097 NVARCHAR VSTRING 1 0 1 CostAccHour Cost Accounting for Time Activities      
PR13098 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13099 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13100 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PR13101 NVARCHAR VSTRING 1 0 1 TransactJour Use Transaction Journal      
PR13102 NVARCHAR VSTRING 1 0 1 UserDefin1 Use Code Table for User Defined Field 1      
PR13103 NVARCHAR VSTRING 1 0 1 UserDefin2 Use Code Table for User Defined Field 2      
PR13104 NVARCHAR VSTRING 1 0 1 UserDefin3 Use Code Table for User Defined Field 3      
PR13105 NVARCHAR VSTRING 1 0 1 UserDefin4 Use Code Table for User Defined Field 4      
PR13106 NVARCHAR VSTRING 1 0 1 UserDefin5 Use Code Table for User Defined Field 5      
PR13107 NVARCHAR VSTRING 1 0 1 UserDefin6 Use Code Table for User Defined Field 6      
PR13108 NVARCHAR VSTRING 1 0 1 UserDefin7 Use Code Table for User Defined Field 7      
PR13109 NVARCHAR VSTRING 1 0 1 UserDefin8 Use Code Table for User Defined Field 8      
PR13110 NVARCHAR VSTRING 1 0 1 UserDefin9 Use Code Table for User Defined Field 9      
PR13111 NVARCHAR VSTRING 1 0 1 UserDefin10 Use Code Table for User Defined Field 10      
PR13112 NVARCHAR VSTRING 1 0 1 CurrFromCust User Currency from Customer      
PR13113 NVARCHAR VSTRING 1 0 1 CalcPrcProj Calculate Price from Base Price List      
PR13114 NVARCHAR VSTRING 1 0 1 EntTimeHHMM Enter Time as HH:MM      
PR13115 NVARCHAR VSTRING 1 0 1 ShoTimeHHMM Show Time as HH:MM      
PR13116 NVARCHAR VSTRING 1 0 1 Register project dimension for Quotation Register project dimension for Quotation      
PR13117 NVARCHAR VSTRING 1 0 1 Invoice Specification Counter Required Invoice Specification Counter Required      
PR13118 NVARCHAR VSTRING 12 0 12 TextSwitches0 Free Text Block 0 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13119 NVARCHAR VSTRING 12 0 12 TextSwitches1 Free Text Block 1 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13120 NVARCHAR VSTRING 12 0 12 TextSwitches2 Free Text Block 2 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13121 NVARCHAR VSTRING 12 0 12 TextSwitches3 Free Text Block 3 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13122 NVARCHAR VSTRING 12 0 12 TextSwitches4 Free Text Block 4 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13123 NVARCHAR VSTRING 12 0 12 TextSwitches5 Free Text Block 5 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13124 NVARCHAR VSTRING 12 0 12 TextSwitches6 Free Text Block 6 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13125 NVARCHAR VSTRING 12 0 12 TextSwitches7 Free Text Block 7 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13126 NVARCHAR VSTRING 12 0 12 TextSwitches8 Free Text Block 8 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13127 NVARCHAR VSTRING 12 0 12 TextSwitches9 Free Text Block 9 — Document Switches Each character in the string represent a document according to the following positions:
1 — Quotation
2 — Confirmation
3 — Work Order (Project)
4 — Project Specification
5 — Invoice Proposal
6 — Invoice
The value can be 0 or 1 where 0 means that the text will not be printed on the document and 1 means that the text will be printed.
   
PR13128 NVARCHAR VSTRING 4 0 4 CounAFixPre Prefix for Project Counter A      
PR13129 NVARCHAR VSTRING 4 0 4 CounBFixPre Prefix for Project Counter B      
PR13130 NVARCHAR VSTRING 4 0 4 CounCFixPre Prefix for Project Counter C      
PR13131 NVARCHAR VSTRING 4 0 4 CounDFixPre Prefix for Project Counter D      
PR13132 NVARCHAR VSTRING 4 0 4 CounEFixPre Prefix for Project Counter E      
PR13133 NVARCHAR VSTRING 4 0 4 CounFFixPre Prefix for Project Counter F      
PR13134 NVARCHAR VSTRING 4 0 4 CounGFixPre Prefix for Project Counter G      
PR13135 NVARCHAR VSTRING 4 0 4 CounHFixPre Prefix for Project Counter H      
PR13136 NVARCHAR VSTRING 4 0 4 CounIFixPre Prefix for Project Counter I      
PR13137 NVARCHAR VSTRING 4 0 4 CounJFixPre Prefix for Project Counter J      
PR13138 NVARCHAR VSTRING 4 0 4 CounKFixPre Prefix for Project Counter K      
PR13139 NVARCHAR VSTRING 4 0 4 CounLFixPre Prefix for Project Counter L      
PR13140 NVARCHAR VSTRING 4 0 4 CounMFixPre Prefix for Project Counter M      
PR13141 NVARCHAR VSTRING 4 0 4 CounNFixPre Prefix for Project Counter N      
PR13142 NVARCHAR VSTRING 4 0 4 CounOFixPre Prefix for Project Counter O      
PR13143 NVARCHAR VSTRING 4 0 4 CounPFixPre Prefix for Project Counter P      
PR13144 NVARCHAR VSTRING 4 0 4 CounQFixPre Prefix for Project Counter Q      
PR13145 NVARCHAR VSTRING 4 0 4 CounRFixPre Prefix for Project Counter R      
PR13146 NVARCHAR VSTRING 4 0 4 CounSFixPre Prefix for Project Counter S      
PR13147 NVARCHAR VSTRING 4 0 4 CounTFixPre Prefix for Project Counter T      
PR13148 NVARCHAR VSTRING 4 0 4 CounUFixPre Prefix for Project Counter U      
PR13149 NVARCHAR VSTRING 4 0 4 CounVFixPre Prefix for Project Counter V      
PR13150 NVARCHAR VSTRING 4 0 4 CounWFixPre Prefix for Project Counter W      
PR13151 NVARCHAR VSTRING 4 0 4 CounXFixPre Prefix for Project Counter X      
PR13152 NVARCHAR VSTRING 4 0 4 CounYFixPre Prefix for Project Counter Y      
PR13153 NVARCHAR VSTRING 4 0 4 CounZFixPre Prefix for Project Counter Z      
PR13154 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13155 NVARCHAR VSTRING 4 0 4 CountPreUsed Default Sales Order Counter      
PR13156 NVARCHAR VSTRING 4 0 4 DefPurchaseOrdCount Default Purchase Order Counter      
PR13157 NVARCHAR VSTRING 4 0 4 LinkedSalesOrderCounter Default Linked Sales Order Counter      
PR13158 NVARCHAR VSTRING 4 0 4 LinkedPurchaseOrderCounter Default Linked Purchase Order Counter      
PR13159 NVARCHAR VSTRING 6 0 6 LinkedServiceOrderCounter Default Linked Service Order Type      
PR13160 NVARCHAR VSTRING 4 0 4 LinkedServiceContractCounter Default Linked Service Contract Type      
PR13161 NVARCHAR VSTRING 4 0 4 LinkedWOCounter Default Linked Work Order Counter      
PR13162 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13163 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13164 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13165 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13166 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13167 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      
PR13168 INT INTEGER 0 0 3 CustomerPriorityWeightedforProject Weight Customer Priority for Project      
PR13169 INT INTEGER 0 0 3 ProjectPriorityWeighted Weight Project Priority      
PR13170 INT INTEGER 0 0 1 ProjectPriorityDefault Default Project Priority      
PR13171 NCHAR SWITCH 1 0 1 FlagAllowSiteCodeEmpty Site Code Is Mandatory      
PR13172 NCHAR STRING 1 0 1 ResourcePlanningLevel Resource Planning Level      
PR13173 NCHAR SWITCH 1 0 1 CreditCheckLine Credit Check Line      
PR13174 NCHAR SWITCH 1 0 1 CreditCheckSkipAdditional Credit Check Skip Additional      
PR13175 NCHAR SWITCH 1 0 1 CreditCheckExit Credit Check Exit      
PR13176 NCHAR SWITCH 1 0 1 CreditLimitBlockQuotation Credit Limit Block Quotation      
PR13177 NCHAR SWITCH 1 0 1 CreditLimitBlockEntry Credit Limit Block Entry      
PR13178 NCHAR SWITCH 1 0 1 CreditLimitBlockTransaction Credit Limit Block Transaction      
PR13179 NCHAR SWITCH 1 0 1 CreditLimitBlockLinkedObject Credit Limit Block Linked Object      

Навигация: