View: Budget Detail

RotoID: PM0122
Table: PMBUDD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PMBUDD

Compositions: 2

RotoID Tables Title DLL
PM0123 PMBUDH Budget Header PMBUDH
PM0124 Budget Lookup PMBUDL

Keys: 4

Title Fields
SEQ, LINENUM
CTUNIQ, FISCALYEAR, BUDGET, LINENUM
CONTRACT, FISCALYEAR, BUDGET, LINENUM
CONTRACT, PROJECT, CATEGORY, RESOURCE, FISCALYEAR, BUDGET, COSTCCY, CCYTYPE

Fields: 187

Field Index Type Title Attributes Presentation
SEQ 1 Long E A K R 
LINENUM 2 Long E A K R 
CTUNIQ 3 BCD*10.0 ^1 Uniq E A 
FISCALYEAR 4 String*4 Fiscal Year E A  Mask: %04D
BUDGET 5 Integer Budget Set E A P  List:7 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
500 = Actuals
501 = Recognized
CONTRACT 6 String*16 ^1 E A  Mask: %-16C
PROJECT 7 String*16 ^2 E A  Mask: %-16N
CATEGORY 8 String*16 ^3 E A  Mask: %-16N
RESOURCE 9 String*24 Resource E A 
REVCCY 10 String*3 Revenue Currency A C  Mask: %-3N
COSTCCY 11 String*3 Cost Currency A C  Mask: %-3N
CCYTYPE 12 Integer Currency Type A C 
CONTSTYLE 13 Integer ^1 Style A C  List:2 entries
1 = Standard
2 = Basic
PROJTYPE 14 Integer ^2 Type A C  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 15 Integer Accounting Method A C  List:7 entries
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
8 = Accrual-Basis
Q1 16 BCD*10.5 Quantity For Period 1 E A 
Q2 17 BCD*10.5 Quantity For Period 2 E A 
Q3 18 BCD*10.5 Quantity For Period 3 E A 
Q4 19 BCD*10.5 Quantity For Period 4 E A 
Q5 20 BCD*10.5 Quantity For Period 5 E A 
Q6 21 BCD*10.5 Quantity For Period 6 E A 
Q7 22 BCD*10.5 Quantity For Period 7 E A 
Q8 23 BCD*10.5 Quantity For Period 8 E A 
Q9 24 BCD*10.5 Quantity For Period 9 E A 
Q10 25 BCD*10.5 Quantity For Period 10 E A 
Q11 26 BCD*10.5 Quantity For Period 11 E A 
Q12 27 BCD*10.5 Quantity For Period 12 E A 
Q13 28 BCD*10.5 Quantity For Period 13 E A 
Q14 29 BCD*10.5 E A 
Q15 30 BCD*10.5 E A 
QTOTAL 31 BCD*10.5 Total Quantity For The Year A C 
CS1 32 BCD*10.3 Total Cost (Source) For Period 1 E A 
CS2 33 BCD*10.3 Total Cost (Source) For Period 2 E A 
CS3 34 BCD*10.3 Total Cost (Source) For Period 3 E A 
CS4 35 BCD*10.3 Total Cost (Source) For Period 4 E A 
CS5 36 BCD*10.3 Total Cost (Source) For Period 5 E A 
CS6 37 BCD*10.3 Total Cost (Source) For Period 6 E A 
CS7 38 BCD*10.3 Total Cost (Source) For Period 7 E A 
CS8 39 BCD*10.3 Total Cost (Source) For Period 8 E A 
CS9 40 BCD*10.3 Total Cost (Source) For Period 9 E A 
CS10 41 BCD*10.3 Total Cost (Source) For Period 10 E A 
CS11 42 BCD*10.3 Total Cost (Source) For Period 11 E A 
CS12 43 BCD*10.3 Total Cost (Source) For Period 12 E A 
CS13 44 BCD*10.3 Total Cost (Source) For Period 13 E A 
CS14 45 BCD*10.3 E A 
CS15 46 BCD*10.3 E A 
CSTOTAL 47 BCD*10.3 Total Cost (Source) For The Year A C 
CH1 48 BCD*10.3 Total Cost (Functional) For Period 1 E A 
CH2 49 BCD*10.3 Total Cost (Functional) For Period 2 E A 
CH3 50 BCD*10.3 Total Cost (Functional) For Period 3 E A 
CH4 51 BCD*10.3 Total Cost (Functional) For Period 4 E A 
CH5 52 BCD*10.3 Total Cost (Functional) For Period 5 E A 
CH6 53 BCD*10.3 Total Cost (Functional) For Period 6 E A 
CH7 54 BCD*10.3 Total Cost (Functional) For Period 7 E A 
CH8 55 BCD*10.3 Total Cost (Functional) For Period 8 E A 
CH9 56 BCD*10.3 Total Cost (Functional) For Period 9 E A 
CH10 57 BCD*10.3 Total Cost (Functional) For Period 10 E A 
CH11 58 BCD*10.3 Total Cost (Functional) For Period 11 E A 
CH12 59 BCD*10.3 Total Cost (Functional) For Period 12 E A 
CH13 60 BCD*10.3 Total Cost (Functional) For Period 13 E A 
CH14 61 BCD*10.3 E A 
CH15 62 BCD*10.3 E A 
CHTOTAL 63 BCD*10.3 Total Cost (Functional) For The Year A C 
RS1 64 BCD*10.3 Total Revenue (Source) For Period 1 E A 
RS2 65 BCD*10.3 Total Revenue (Source) For Period 2 E A 
RS3 66 BCD*10.3 Total Revenue (Source) For Period 3 E A 
RS4 67 BCD*10.3 Total Revenue (Source) For Period 4 E A 
RS5 68 BCD*10.3 Total Revenue (Source) For Period 5 E A 
RS6 69 BCD*10.3 Total Revenue (Source) For Period 6 E A 
RS7 70 BCD*10.3 Total Revenue (Source) For Period 7 E A 
RS8 71 BCD*10.3 Total Revenue (Source) For Period 8 E A 
RS9 72 BCD*10.3 Total Revenue (Source) For Period 9 E A 
RS10 73 BCD*10.3 Total Revenue (Source) For Period 10 E A 
RS11 74 BCD*10.3 Total Revenue (Source) For Period 11 E A 
RS12 75 BCD*10.3 Total Revenue (Source) For Period 12 E A 
RS13 76 BCD*10.3 Total Revenue (Source) For Period 13 E A 
RS14 77 BCD*10.3 E A 
RS15 78 BCD*10.3 E A 
RSTOTAL 79 BCD*10.3 Total Revenue (Source) For The Year A C 
RH1 80 BCD*10.3 Total Revenue (Functional) For Period 1 E A 
RH2 81 BCD*10.3 Total Revenue (Functional) For Period 2 E A 
RH3 82 BCD*10.3 Total Revenue (Functional) For Period 3 E A 
RH4 83 BCD*10.3 Total Revenue (Functional) For Period 4 E A 
RH5 84 BCD*10.3 Total Revenue (Functional) For Period 5 E A 
RH6 85 BCD*10.3 Total Revenue (Functional) For Period 6 E A 
RH7 86 BCD*10.3 Total Revenue (Functional) For Period 7 E A 
RH8 87 BCD*10.3 Total Revenue (Functional) For Period 8 E A 
RH9 88 BCD*10.3 Total Revenue (Functional) For Period 9 E A 
RH10 89 BCD*10.3 Total Revenue (Functional) For Period 10 E A 
RH11 90 BCD*10.3 Total Revenue (Functional) For Period 11 E A 
RH12 91 BCD*10.3 Total Revenue (Functional) For Period 12 E A 
RH13 92 BCD*10.3 Total Revenue (Functional) For Period 13 E A 
RH14 93 BCD*10.3 E A 
RH15 94 BCD*10.3 E A 
RHTOTAL 95 BCD*10.3 Total Revenue (Functional) For The Year A C 
INQ1 96 BCD*10.5 Inquiry Quantity For Period 1 E A 
INQ2 97 BCD*10.5 Inquiry Quantity For Period 2 E A 
INQ3 98 BCD*10.5 Inquiry Quantity For Period 3 E A 
INQ4 99 BCD*10.5 Inquiry Quantity For Period 4 E A 
INQ5 100 BCD*10.5 Inquiry Quantity For Period 5 E A 
INQ6 101 BCD*10.5 Inquiry Quantity For Period 6 E A 
INQ7 102 BCD*10.5 Inquiry Quantity For Period 7 E A 
INQ8 103 BCD*10.5 Inquiry Quantity For Period 8 E A 
INQ9 104 BCD*10.5 Inquiry Quantity For Period 9 E A 
INQ10 105 BCD*10.5 Inquiry Quantity For Period 10 E A 
INQ11 106 BCD*10.5 Inquiry Quantity For Period 11 E A 
INQ12 107 BCD*10.5 Inquiry Quantity For Period 12 E A 
INQ13 108 BCD*10.5 Inquiry Quantity For Period 13 E A 
INQ14 109 BCD*10.5 E A 
INQ15 110 BCD*10.5 E A 
INQTOTAL 111 BCD*10.5 Inquiry Total Quantity For The Year E A 
INCS1 112 BCD*10.3 Inquiry Total Cost (Source) For Period 1 E A 
INCS2 113 BCD*10.3 Inquiry Total Cost (Source) For Period 2 E A 
INCS3 114 BCD*10.3 Inquiry Total Cost (Source) For Period 3 E A 
INCS4 115 BCD*10.3 Inquiry Total Cost (Source) For Period 4 E A 
INCS5 116 BCD*10.3 Inquiry Total Cost (Source) For Period 5 E A 
INCS6 117 BCD*10.3 Inquiry Total Cost (Source) For Period 6 E A 
INCS7 118 BCD*10.3 Inquiry Total Cost (Source) For Period 7 E A 
INCS8 119 BCD*10.3 Inquiry Total Cost (Source) For Period 8 E A 
INCS9 120 BCD*10.3 Inquiry Total Cost (Source) For Period 9 E A 
INCS10 121 BCD*10.3 Inquiry Total Cost (Source) For Period 10 E A 
INCS11 122 BCD*10.3 Inquiry Total Cost (Source) For Period 11 E A 
INCS12 123 BCD*10.3 Inquiry Total Cost (Source) For Period 12 E A 
INCS13 124 BCD*10.3 Inquiry Total Cost (Source) For Period 13 E A 
INCS14 125 BCD*10.3 E A 
INCS15 126 BCD*10.3 E A 
INCSTOTAL 127 BCD*10.3 Inquiry Total Cost (Source) For The Year E A 
INCH1 128 BCD*10.3 Inquiry Total Cost (Functional) For Period 1 E A 
INCH2 129 BCD*10.3 Inquiry Total Cost (Functional) For Period 2 E A 
INCH3 130 BCD*10.3 Inquiry Total Cost (Functional) For Period 3 E A 
INCH4 131 BCD*10.3 Inquiry Total Cost (Functional) For Period 4 E A 
INCH5 132 BCD*10.3 Inquiry Total Cost (Functional) For Period 5 E A 
INCH6 133 BCD*10.3 Inquiry Total Cost (Functional) For Period 6 E A 
INCH7 134 BCD*10.3 Inquiry Total Cost (Functional) For Period 7 E A 
INCH8 135 BCD*10.3 Inquiry Total Cost (Functional) For Period 8 E A 
INCH9 136 BCD*10.3 Inquiry Total Cost (Functional) For Period 9 E A 
INCH10 137 BCD*10.3 Inquiry Total Cost (Functional) For Period 10 E A 
INCH11 138 BCD*10.3 Inquiry Total Cost (Functional) For Period 11 E A 
INCH12 139 BCD*10.3 Inquiry Total Cost (Functional) For Period 12 E A 
INCH13 140 BCD*10.3 Inquiry Total Cost (Functional) For Period 13 E A 
INCH14 141 BCD*10.3 E A 
INCH15 142 BCD*10.3 E A 
INCHTOTAL 143 BCD*10.3 Inquiry Total Cost (Functional) For The Year E A 
INRS1 144 BCD*10.3 Inquiry Total Revenue (Source) For Period 1 E A 
INRS2 145 BCD*10.3 Inquiry Total Revenue (Source) For Period 2 E A 
INRS3 146 BCD*10.3 Inquiry Total Revenue (Source) For Period 3 E A 
INRS4 147 BCD*10.3 Inquiry Total Revenue (Source) For Period 4 E A 
INRS5 148 BCD*10.3 Inquiry Total Revenue (Source) For Period 5 E A 
INRS6 149 BCD*10.3 Inquiry Total Revenue (Source) For Period 6 E A 
INRS7 150 BCD*10.3 Inquiry Total Revenue (Source) For Period 7 E A 
INRS8 151 BCD*10.3 Inquiry Total Revenue (Source) For Period 8 E A 
INRS9 152 BCD*10.3 Inquiry Total Revenue (Source) For Period 9 E A 
INRS10 153 BCD*10.3 Inquiry Total Revenue (Source) For Period 10 E A 
INRS11 154 BCD*10.3 Inquiry Total Revenue (Source) For Period 11 E A 
INRS12 155 BCD*10.3 Inquiry Total Revenue (Source) For Period 12 E A 
INRS13 156 BCD*10.3 Inquiry Total Revenue (Source) For Period 13 E A 
INRS14 157 BCD*10.3 E A 
INRS15 158 BCD*10.3 E A 
INRSTOTAL 159 BCD*10.3 Inquiry Total Revenue (Source) For The Year E A 
INRH1 160 BCD*10.3 Inquiry Total Revenue (Functional) For Period 1 E A 
INRH2 161 BCD*10.3 Inquiry Total Revenue (Functional) For Period 2 E A 
INRH3 162 BCD*10.3 Inquiry Total Revenue (Functional) For Period 3 E A 
INRH4 163 BCD*10.3 Inquiry Total Revenue (Functional) For Period 4 E A 
INRH5 164 BCD*10.3 Inquiry Total Revenue (Functional) For Period 5 E A 
INRH6 165 BCD*10.3 Inquiry Total Revenue (Functional) For Period 6 E A 
INRH7 166 BCD*10.3 Inquiry Total Revenue (Functional) For Period 7 E A 
INRH8 167 BCD*10.3 Inquiry Total Revenue (Functional) For Period 8 E A 
INRH9 168 BCD*10.3 Inquiry Total Revenue (Functional) For Period 9 E A 
INRH10 169 BCD*10.3 Inquiry Total Revenue (Functional) For Period 10 E A 
INRH11 170 BCD*10.3 Inquiry Total Revenue (Functional) For Period 11 E A 
INRH12 171 BCD*10.3 Inquiry Total Revenue (Functional) For Period 12 E A 
INRH13 172 BCD*10.3 Inquiry Total Revenue (Functional) For Period 13 E A 
INRH14 173 BCD*10.3 E A 
INRH15 174 BCD*10.3 E A 
INRHTOTAL 175 BCD*10.3 Inquiry Total Revenue (Functional) For The Year E A 
RATETYPE 176 String*2 Rate Type A X  Mask: %-2N
RATEDATE 177 Date Rate Date A X 
RATEOP 178 Integer Rate Operator A C  List:2 entries
1 = Multiply
2 = Divide
RATE 179 BCD*8.7 Rate A X 
SHOW 1001 Integer Show l) For The Year E A C  List:4 entries
0 = None
1 = Original
2 = Current
3 = Actual
SQTY 1002 BCD*10.5 Quantity l) For The Year A C 
SCOSTS 1003 BCD*10.3 Cost l) For The Year A C 
SCOSTH 1004 BCD*10.3 Cost l) For The Year A C 
SRS 1005 BCD*10.3 Revenue (Source) l) For The Year A C 
SRH 1006 BCD*10.3 Revenue (Functional) l) For The Year A C 
LEVEL 1007 Integer Description l) For The Year E A C  List:3 entries
1 = Contract
2 = Project
3 = Category
CATTYPE 1008 Integer Cost Class l) For The Year E A C 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).