# 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 | 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 |  |
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 2009-Nov-19

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