This chapter contains the following topics:
The JD Edwards EnterpriseOne PGCA system includes several UDC tables. Many of the UDC tables have hard-coded values that you cannot change; however, some of the tables enable you to set up your own values to meet your business needs. For example, you can set up a list of valid labor types, such as technical, nontechnical, and support. Before using the JD Edwards EnterpriseOne PGCA system, set up these UDC tables:
This UDC table lists codes for types of labor. Examples include:
SUP: Support
TEC: Technical
This table lists ledger types that are to be included in the burdening process. Examples include:
AA: Actual amounts ledger
BA: Budget amounts ledger
This UDC table lists codes for billing groups.
This UDC table lists billing frequencies.
This table lists types of contracts. You select the type of contract when you set up the contract in the Create/Edit Project and Government Contracts program (P52G01M). Examples include:
PRI: Prime
SUB: Subcontractor
SSUB: Sub-subcontractor
This table lists types of clients for which you are setting up the contract. You select the type of client when you set up the contract in the P52G01M program. Examples include:
COM: Commercial
FED: Federal
LOC: Local
ST: State
This table lists frequencies for the system to calculate fees. Examples include:
M: Monthly
S: Semi-monthly
W: Weekly
This table lists reasons for modifying contracts. Examples include:
A: Amount Change
C: Created
S: System Generated (Hard-coded value)
T: Terms Change
U: User Error
This UDC table lists statuses for revenue. Examples include:
C: Revenue complete
E: Eligible for revenue
H: On hold
N: Not eligible for revenue
These UDC tables enable you to set up additional information to identify accounting classification reference numbers (ACRNs.)
This list includes the UDC tables that contain hard-coded values. You do not need to set up these UDC tables, but you should verify that they exist:
This UDC table lists the base methods for depleting ACRNs.
Values include:
A: Award fee amount
C: Cost amount
F: Fee amount
S: Sum (cost amount plus fee amount)
T: Total (cost, fee, and award fee amounts)
See Setting Up ACRNs.
This UDC table lists allocation levels. Values include:
Blank: None
1: Specific job
2: All jobs
This UDC table lists methods for depleting ACRNs. Values include:
Blank: None
1: FIFO
2: Ratio
3: Manual
This UDC table lists billing statuses that you assign to contracts. Values include:
B: Billable
C: Billing complete
F: Awaiting final bill
H: On hold
N: Do not bill
This UDC table lists billing methods that you assign to contracts. Values include:
F: Fixed price
N: None
S: Cost plus
T: Time and materials
This UDC table lists methods for summarizing cumulative amounts in a section of an invoice style. Values include:
01: Detail (Every Transaction)
02: One Line
03: Employee Name
04: Employee Name + Date
05: Job Type (Labor Category)
06: Job Type + Emp Name
07: Job Type + Emp Name + Date
08: Job Type + Job Step
09: Job Step
10: Object Account
11: Pay Type (PDBA)
12: Name Alpha Explanation (EXA)
13: Name Remark Explanation (EXR)
This table lists methods for summarizing current amounts in a section of an invoice style. Values include:
01: Detail (Every Transaction)
02: One Line
03: Employee Name
04: Employee Name + Date
05: Job Type (Labor Category)
06: Job Type + Emp Name
07: Job Type + Emp Name + Date
08: Job Type + Job Step
09: Job Step
10: Object Account
11: Pay Type (PDBA)
12: Name Alpha Explanation (EXA)
13: Name Remark Explanation (EXR)
This table lists options for the level of detail to retain when the system creates reburdening records. Values include:
1: No detail
2: Detail by Alt Home BU
3: Detail by Alt Home BU, Job Type
4: Detail by Alt Home BU, Job Step
5: Det by Alt HBU, Job Ty & Step
6: Detail by Job Type
7: Detail by Job Step
8: Detail by Job Type, Job Step
9: Full Detail (By All)
This table lists eligibility statuses for fees. Values include:
0: 0 - Recurring
1: 1 - One Time Occurrence - Both
2: 2 - One Time Occurrence - Inv
3: 3 - One Time Occurrence - Rev
4: 4 - Suspended
This table lists methods for calculating fees. Values include:
1: 1 - Percent (Of Cost)
2: 2 - Labor Category
3: 3 - Rate per Hour
4: 4 - Flat Amount
5: 5 - LOE @ Funding Level
6: 6 - LOE @ Labor Category
7: 7 - Percent (Of Limit Value)
This UDC table lists methods by which the system calculates fees. Values include:
1: Amount per hour
2: Percent
This table identifies form exits on the Work With Project and Government Contracts form. Values include:
01: Contract Master
02: Job Master
03: Contract Labor Categories
This table is used by the Project and Gov Contract Accounting Used check box in the Billing Constants program (P48091) and specifies whether the Project and Government Contract Accounting system is used. Values include:
Blank: Proj and Gov Contracts Not Used
1: Proj and Gov Contracts Used
This table is used by the Maintain Invoice History field in the P48091 program and specifies whether to maintain invoice history. Values include:
Blank: Do Not Maintain Inv. History
1: Maintain Invoice History
This UDC table lists methods to apply limits. Values include:
1: Funded by line
2: Funded by total
3: Awarded by line
4: Awarded by total
5: No limit
This table lists source amounts to be used in calculating the percent complete for retainage. Values include:
Blank: Schedule of Values
1: Funded Amount
2: Awarded Amount
See Setting Up and Calculating Retainage for PGCA Contracts.
This table lists presentation levels for invoice styles. Values include:
1: Invoice Level Contract
2: Funding Level Contract
3: Business Unit
4: Business Unit + Subsidiary
This table lists options for printing rates in a section of an invoice style. Values include:
Blank: Do Not Print
1: Print for Current Only
This table lists options for printing units in a section of an invoice style. Values include:
Blank: Do Not Print
1: Print for Current Only
2: Print for Cumulative Only
3: Print for Current and Cum
This UDC table lists calculation methods for revenue recognition. Values include
E: Revenue percent method
F: Fixed price
H: Percent of billing method
N: None
S: Cost plus
T: Time and materials
This table lists row exits on the Work With Project and Government Contracts form. Values include:
01: Attachments
02: Supplemental Data
03: Billing Line Details
04: ACRN Detail Revisions
05: ACRN History Inquiry
06: Contract Limit Summary Inquiry
07: Print Contract
This table lists options for summarizing burden and component amounts in invoices. You assign summarization options to burden/component rules and then assign burden/component rules to sections in invoice styles. Values include:
1: Add to Base Line.
2: Detailed After Base Line.
3: By Burden at Section End.
4: By Burden in App Burden Sec
5: One Line in Applied Burden Sec
This table lists types of invoice sections. You use multiple invoice sections to create an invoice style. Values include:
A: Award Fee
B: Labor Burden
BRD: Applied Burden/Component
D: Direct Draw
DSC: Discount
EXC: Limit Exceeded/Adjustment
F: Fee Line
L: Lump Sum
M: Milestone
OTH: Other
P: Progress
R: Rated Draw
RET: Retainage
S: Cost Plus
SBT: Subtotal
T: Time and Material
TAX: Tax
TXT: Text
U: Unit Price