Table: Budget Detail

Table: PMBUDD
View: PM0122
Record length: 1751
Flags: A R 

Keys: 4

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

Fields: 183

Field  Type  Title  Presentation 
SEQ  Long  SEQ   
LINENUM  Long  LINENUM   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CTUNIQ  BCD*10.0  Contract 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  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CATEGORY  String*16  Category  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  Contract Style  List: 2 entries
1=Standard
2=Basic
PROJTYPE  Integer  Project 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  Q14   
Q15  BCD*10.5  Q15   
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 1   
CS11  BCD*10.3  Total Cost (Source) For Period 1   
CS12  BCD*10.3  Total Cost (Source) For Period 1   
CS13  BCD*10.3  Total Cost (Source) For Period 1   
CS14  BCD*10.3  CS14   
CS15  BCD*10.3  CS15   
CSTOTAL  BCD*10.3  Total Cost (Source) For The Year   
CH1  BCD*10.3  Total Cost (Functional) For Peri   
CH2  BCD*10.3  Total Cost (Functional) For Peri   
CH3  BCD*10.3  Total Cost (Functional) For Peri   
CH4  BCD*10.3  Total Cost (Functional) For Peri   
CH5  BCD*10.3  Total Cost (Functional) For Peri   
CH6  BCD*10.3  Total Cost (Functional) For Peri   
CH7  BCD*10.3  Total Cost (Functional) For Peri   
CH8  BCD*10.3  Total Cost (Functional) For Peri   
CH9  BCD*10.3  Total Cost (Functional) For Peri   
CH10  BCD*10.3  Total Cost (Functional) For Peri   
CH11  BCD*10.3  Total Cost (Functional) For Peri   
CH12  BCD*10.3  Total Cost (Functional) For Peri   
CH13  BCD*10.3  Total Cost (Functional) For Peri   
CH14  BCD*10.3  CH14   
CH15  BCD*10.3  CH15   
CHTOTAL  BCD*10.3  Total Cost (Functional) For The   
RS1  BCD*10.3  Total Revenue (Source) For Perio   
RS2  BCD*10.3  Total Revenue (Source) For Perio   
RS3  BCD*10.3  Total Revenue (Source) For Perio   
RS4  BCD*10.3  Total Revenue (Source) For Perio   
RS5  BCD*10.3  Total Revenue (Source) For Perio   
RS6  BCD*10.3  Total Revenue (Source) For Perio   
RS7  BCD*10.3  Total Revenue (Source) For Perio   
RS8  BCD*10.3  Total Revenue (Source) For Perio   
RS9  BCD*10.3  Total Revenue (Source) For Perio   
RS10  BCD*10.3  Total Revenue (Source) For Perio   
RS11  BCD*10.3  Total Revenue (Source) For Perio   
RS12  BCD*10.3  Total Revenue (Source) For Perio   
RS13  BCD*10.3  Total Revenue (Source) For Perio   
RS14  BCD*10.3  RS14   
RS15  BCD*10.3  RS15   
RSTOTAL  BCD*10.3  Total Revenue (Source) For The Y   
RH1  BCD*10.3  Total Revenue (Functional) For P   
RH2  BCD*10.3  Total Revenue (Functional) For P   
RH3  BCD*10.3  Total Revenue (Functional) For P   
RH4  BCD*10.3  Total Revenue (Functional) For P   
RH5  BCD*10.3  Total Revenue (Functional) For P   
RH6  BCD*10.3  Total Revenue (Functional) For P   
RH7  BCD*10.3  Total Revenue (Functional) For P   
RH8  BCD*10.3  Total Revenue (Functional) For P   
RH9  BCD*10.3  Total Revenue (Functional) For P   
RH10  BCD*10.3  Total Revenue (Functional) For P   
RH11  BCD*10.3  Total Revenue (Functional) For P   
RH12  BCD*10.3  Total Revenue (Functional) For P   
RH13  BCD*10.3  Total Revenue (Functional) For P   
RH14  BCD*10.3  RH14   
RH15  BCD*10.3  RH15   
RHTOTAL  BCD*10.3  Total Revenue (Functional) For T   
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  INQ14   
INQ15  BCD*10.5  INQ15   
INQTOTAL  BCD*10.5  Inquiry Total Quantity For The Y   
INCS1  BCD*10.3  Inquiry Total Cost (Source) For   
INCS2  BCD*10.3  Inquiry Total Cost (Source) For   
INCS3  BCD*10.3  Inquiry Total Cost (Source) For   
INCS4  BCD*10.3  Inquiry Total Cost (Source) For   
INCS5  BCD*10.3  Inquiry Total Cost (Source) For   
INCS6  BCD*10.3  Inquiry Total Cost (Source) For   
INCS7  BCD*10.3  Inquiry Total Cost (Source) For   
INCS8  BCD*10.3  Inquiry Total Cost (Source) For   
INCS9  BCD*10.3  Inquiry Total Cost (Source) For   
INCS10  BCD*10.3  Inquiry Total Cost (Source) For   
INCS11  BCD*10.3  Inquiry Total Cost (Source) For   
INCS12  BCD*10.3  Inquiry Total Cost (Source) For   
INCS13  BCD*10.3  Inquiry Total Cost (Source) For   
INCS14  BCD*10.3  INCS14   
INCS15  BCD*10.3  INCS15   
INCSTOTAL  BCD*10.3  Inquiry Total Cost (Source) For   
INCH1  BCD*10.3  Inquiry Total Cost (Functional)   
INCH2  BCD*10.3  Inquiry Total Cost (Functional)   
INCH3  BCD*10.3  Inquiry Total Cost (Functional)   
INCH4  BCD*10.3  Inquiry Total Cost (Functional)   
INCH5  BCD*10.3  Inquiry Total Cost (Functional)   
INCH6  BCD*10.3  Inquiry Total Cost (Functional)   
INCH7  BCD*10.3  Inquiry Total Cost (Functional)   
INCH8  BCD*10.3  Inquiry Total Cost (Functional)   
INCH9  BCD*10.3  Inquiry Total Cost (Functional)   
INCH10  BCD*10.3  Inquiry Total Cost (Functional)   
INCH11  BCD*10.3  Inquiry Total Cost (Functional)   
INCH12  BCD*10.3  Inquiry Total Cost (Functional)   
INCH13  BCD*10.3  Inquiry Total Cost (Functional)   
INCH14  BCD*10.3  INCH14   
INCH15  BCD*10.3  INCH15   
INCHTOTAL  BCD*10.3  Inquiry Total Cost (Functional)   
INRS1  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS2  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS3  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS4  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS5  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS6  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS7  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS8  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS9  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS10  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS11  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS12  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS13  BCD*10.3  Inquiry Total Revenue (Source) F   
INRS14  BCD*10.3  INRS14   
INRS15  BCD*10.3  INRS15   
INRSTOTAL  BCD*10.3  Inquiry Total Revenue (Source) F   
INRH1  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH2  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH3  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH4  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH5  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH6  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH7  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH8  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH9  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH10  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH11  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH12  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH13  BCD*10.3  Inquiry Total Revenue (Functiona   
INRH14  BCD*10.3  INRH14   
INRH15  BCD*10.3  INRH15   
INRHTOTAL  BCD*10.3  Inquiry Total Revenue (Functiona   
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 2008-Apr-11

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.