Table: Budget Detail

Table: PMBUDD
View: PM0122
Record Length: 1751

Flags: A R 

Keys: 4

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

Fields: 183

Field Type Title Presentation
SEQ Long
LINENUM Long
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CTUNIQ BCD*10.0 ^1 Uniq
FISCALYEAR String*4 Fiscal Year Mask: %04D
BUDGET Integer Budget Set List:7 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
500 = Actuals
501 = Recognized
CONTRACT String*16 ^1 Mask: %-16C
PROJECT String*16 ^2 Mask: %-16N
CATEGORY String*16 ^3 Mask: %-16N
RESOURCE String*24 Resource
REVCCY String*3 Revenue Currency Mask: %-3N
COSTCCY String*3 Cost Currency Mask: %-3N
CCYTYPE Integer Currency Type
CONTSTYLE Integer ^1 Style List:2 entries
1 = Standard
2 = Basic
PROJTYPE Integer ^2 Type List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC Integer Accounting Method 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 BCD*10.5 Quantity For Period 1
Q2 BCD*10.5 Quantity For Period 2
Q3 BCD*10.5 Quantity For Period 3
Q4 BCD*10.5 Quantity For Period 4
Q5 BCD*10.5 Quantity For Period 5
Q6 BCD*10.5 Quantity For Period 6
Q7 BCD*10.5 Quantity For Period 7
Q8 BCD*10.5 Quantity For Period 8
Q9 BCD*10.5 Quantity For Period 9
Q10 BCD*10.5 Quantity For Period 10
Q11 BCD*10.5 Quantity For Period 11
Q12 BCD*10.5 Quantity For Period 12
Q13 BCD*10.5 Quantity For Period 13
Q14 BCD*10.5
Q15 BCD*10.5
QTOTAL BCD*10.5 Total Quantity For The Year
CS1 BCD*10.3 Total Cost (Source) For Period 1
CS2 BCD*10.3 Total Cost (Source) For Period 2
CS3 BCD*10.3 Total Cost (Source) For Period 3
CS4 BCD*10.3 Total Cost (Source) For Period 4
CS5 BCD*10.3 Total Cost (Source) For Period 5
CS6 BCD*10.3 Total Cost (Source) For Period 6
CS7 BCD*10.3 Total Cost (Source) For Period 7
CS8 BCD*10.3 Total Cost (Source) For Period 8
CS9 BCD*10.3 Total Cost (Source) For Period 9
CS10 BCD*10.3 Total Cost (Source) For Period 10
CS11 BCD*10.3 Total Cost (Source) For Period 11
CS12 BCD*10.3 Total Cost (Source) For Period 12
CS13 BCD*10.3 Total Cost (Source) For Period 13
CS14 BCD*10.3
CS15 BCD*10.3
CSTOTAL BCD*10.3 Total Cost (Source) For The Year
CH1 BCD*10.3 Total Cost (Functional) For Period 1
CH2 BCD*10.3 Total Cost (Functional) For Period 2
CH3 BCD*10.3 Total Cost (Functional) For Period 3
CH4 BCD*10.3 Total Cost (Functional) For Period 4
CH5 BCD*10.3 Total Cost (Functional) For Period 5
CH6 BCD*10.3 Total Cost (Functional) For Period 6
CH7 BCD*10.3 Total Cost (Functional) For Period 7
CH8 BCD*10.3 Total Cost (Functional) For Period 8
CH9 BCD*10.3 Total Cost (Functional) For Period 9
CH10 BCD*10.3 Total Cost (Functional) For Period 10
CH11 BCD*10.3 Total Cost (Functional) For Period 11
CH12 BCD*10.3 Total Cost (Functional) For Period 12
CH13 BCD*10.3 Total Cost (Functional) For Period 13
CH14 BCD*10.3
CH15 BCD*10.3
CHTOTAL BCD*10.3 Total Cost (Functional) For The Year
RS1 BCD*10.3 Total Revenue (Source) For Period 1
RS2 BCD*10.3 Total Revenue (Source) For Period 2
RS3 BCD*10.3 Total Revenue (Source) For Period 3
RS4 BCD*10.3 Total Revenue (Source) For Period 4
RS5 BCD*10.3 Total Revenue (Source) For Period 5
RS6 BCD*10.3 Total Revenue (Source) For Period 6
RS7 BCD*10.3 Total Revenue (Source) For Period 7
RS8 BCD*10.3 Total Revenue (Source) For Period 8
RS9 BCD*10.3 Total Revenue (Source) For Period 9
RS10 BCD*10.3 Total Revenue (Source) For Period 10
RS11 BCD*10.3 Total Revenue (Source) For Period 11
RS12 BCD*10.3 Total Revenue (Source) For Period 12
RS13 BCD*10.3 Total Revenue (Source) For Period 13
RS14 BCD*10.3
RS15 BCD*10.3
RSTOTAL BCD*10.3 Total Revenue (Source) For The Year
RH1 BCD*10.3 Total Revenue (Functional) For Period 1
RH2 BCD*10.3 Total Revenue (Functional) For Period 2
RH3 BCD*10.3 Total Revenue (Functional) For Period 3
RH4 BCD*10.3 Total Revenue (Functional) For Period 4
RH5 BCD*10.3 Total Revenue (Functional) For Period 5
RH6 BCD*10.3 Total Revenue (Functional) For Period 6
RH7 BCD*10.3 Total Revenue (Functional) For Period 7
RH8 BCD*10.3 Total Revenue (Functional) For Period 8
RH9 BCD*10.3 Total Revenue (Functional) For Period 9
RH10 BCD*10.3 Total Revenue (Functional) For Period 10
RH11 BCD*10.3 Total Revenue (Functional) For Period 11
RH12 BCD*10.3 Total Revenue (Functional) For Period 12
RH13 BCD*10.3 Total Revenue (Functional) For Period 13
RH14 BCD*10.3
RH15 BCD*10.3
RHTOTAL BCD*10.3 Total Revenue (Functional) For The Year
INQ1 BCD*10.5 Inquiry Quantity For Period 1
INQ2 BCD*10.5 Inquiry Quantity For Period 2
INQ3 BCD*10.5 Inquiry Quantity For Period 3
INQ4 BCD*10.5 Inquiry Quantity For Period 4
INQ5 BCD*10.5 Inquiry Quantity For Period 5
INQ6 BCD*10.5 Inquiry Quantity For Period 6
INQ7 BCD*10.5 Inquiry Quantity For Period 7
INQ8 BCD*10.5 Inquiry Quantity For Period 8
INQ9 BCD*10.5 Inquiry Quantity For Period 9
INQ10 BCD*10.5 Inquiry Quantity For Period 10
INQ11 BCD*10.5 Inquiry Quantity For Period 11
INQ12 BCD*10.5 Inquiry Quantity For Period 12
INQ13 BCD*10.5 Inquiry Quantity For Period 13
INQ14 BCD*10.5
INQ15 BCD*10.5
INQTOTAL BCD*10.5 Inquiry Total Quantity For The Year
INCS1 BCD*10.3 Inquiry Total Cost (Source) For Period 1
INCS2 BCD*10.3 Inquiry Total Cost (Source) For Period 2
INCS3 BCD*10.3 Inquiry Total Cost (Source) For Period 3
INCS4 BCD*10.3 Inquiry Total Cost (Source) For Period 4
INCS5 BCD*10.3 Inquiry Total Cost (Source) For Period 5
INCS6 BCD*10.3 Inquiry Total Cost (Source) For Period 6
INCS7 BCD*10.3 Inquiry Total Cost (Source) For Period 7
INCS8 BCD*10.3 Inquiry Total Cost (Source) For Period 8
INCS9 BCD*10.3 Inquiry Total Cost (Source) For Period 9
INCS10 BCD*10.3 Inquiry Total Cost (Source) For Period 10
INCS11 BCD*10.3 Inquiry Total Cost (Source) For Period 11
INCS12 BCD*10.3 Inquiry Total Cost (Source) For Period 12
INCS13 BCD*10.3 Inquiry Total Cost (Source) For Period 13
INCS14 BCD*10.3
INCS15 BCD*10.3
INCSTOTAL BCD*10.3 Inquiry Total Cost (Source) For The Year
INCH1 BCD*10.3 Inquiry Total Cost (Functional) For Period 1
INCH2 BCD*10.3 Inquiry Total Cost (Functional) For Period 2
INCH3 BCD*10.3 Inquiry Total Cost (Functional) For Period 3
INCH4 BCD*10.3 Inquiry Total Cost (Functional) For Period 4
INCH5 BCD*10.3 Inquiry Total Cost (Functional) For Period 5
INCH6 BCD*10.3 Inquiry Total Cost (Functional) For Period 6
INCH7 BCD*10.3 Inquiry Total Cost (Functional) For Period 7
INCH8 BCD*10.3 Inquiry Total Cost (Functional) For Period 8
INCH9 BCD*10.3 Inquiry Total Cost (Functional) For Period 9
INCH10 BCD*10.3 Inquiry Total Cost (Functional) For Period 10
INCH11 BCD*10.3 Inquiry Total Cost (Functional) For Period 11
INCH12 BCD*10.3 Inquiry Total Cost (Functional) For Period 12
INCH13 BCD*10.3 Inquiry Total Cost (Functional) For Period 13
INCH14 BCD*10.3
INCH15 BCD*10.3
INCHTOTAL BCD*10.3 Inquiry Total Cost (Functional) For The Year
INRS1 BCD*10.3 Inquiry Total Revenue (Source) For Period 1
INRS2 BCD*10.3 Inquiry Total Revenue (Source) For Period 2
INRS3 BCD*10.3 Inquiry Total Revenue (Source) For Period 3
INRS4 BCD*10.3 Inquiry Total Revenue (Source) For Period 4
INRS5 BCD*10.3 Inquiry Total Revenue (Source) For Period 5
INRS6 BCD*10.3 Inquiry Total Revenue (Source) For Period 6
INRS7 BCD*10.3 Inquiry Total Revenue (Source) For Period 7
INRS8 BCD*10.3 Inquiry Total Revenue (Source) For Period 8
INRS9 BCD*10.3 Inquiry Total Revenue (Source) For Period 9
INRS10 BCD*10.3 Inquiry Total Revenue (Source) For Period 10
INRS11 BCD*10.3 Inquiry Total Revenue (Source) For Period 11
INRS12 BCD*10.3 Inquiry Total Revenue (Source) For Period 12
INRS13 BCD*10.3 Inquiry Total Revenue (Source) For Period 13
INRS14 BCD*10.3
INRS15 BCD*10.3
INRSTOTAL BCD*10.3 Inquiry Total Revenue (Source) For The Year
INRH1 BCD*10.3 Inquiry Total Revenue (Functional) For Period 1
INRH2 BCD*10.3 Inquiry Total Revenue (Functional) For Period 2
INRH3 BCD*10.3 Inquiry Total Revenue (Functional) For Period 3
INRH4 BCD*10.3 Inquiry Total Revenue (Functional) For Period 4
INRH5 BCD*10.3 Inquiry Total Revenue (Functional) For Period 5
INRH6 BCD*10.3 Inquiry Total Revenue (Functional) For Period 6
INRH7 BCD*10.3 Inquiry Total Revenue (Functional) For Period 7
INRH8 BCD*10.3 Inquiry Total Revenue (Functional) For Period 8
INRH9 BCD*10.3 Inquiry Total Revenue (Functional) For Period 9
INRH10 BCD*10.3 Inquiry Total Revenue (Functional) For Period 10
INRH11 BCD*10.3 Inquiry Total Revenue (Functional) For Period 11
INRH12 BCD*10.3 Inquiry Total Revenue (Functional) For Period 12
INRH13 BCD*10.3 Inquiry Total Revenue (Functional) For Period 13
INRH14 BCD*10.3
INRH15 BCD*10.3
INRHTOTAL BCD*10.3 Inquiry Total Revenue (Functional) For The Year
RATETYPE String*2 Rate Type Mask: %-2N
RATEDATE Date Rate Date
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
RATE BCD*8.7 Rate

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).