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     
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 2008-May-01

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