Updating Select Columns for JD Edwards EnterpriseOne Advanced Contract Billing in the F5201 Table

You can update records for the JD Edwards EnterpriseOne Advanced Contract Billing system in the F5201 table with data relationships rules using one of these methods:

  • Manually update the records in the Create/Edit Advanced Contracts program (P52G01M).

  • Automatically update the records by running the Update Data Relationships program (R00422).

See "Updating F0006 and F5201 Records with Data Relationships Rules" in the JD Edwards EnterpriseOne Applications Financial Management Fundamentals Implementation Guide.

Regardless of whether you update records manually or automatically, the system follows the same guidelines to update the data relationships rules in the F5201 table with one exception. The exception applies to these columns in the F5201 table, which are used specifically for the JD Edwards EnterpriseOne Advanced Contract Billing system:

  • USA4

  • USA5

  • CAB9

  • QCOPR

When you manually update records in the P52G01M program, the system applies the changes to related invoice (C2) and funding levels (C3) for the columns listed. For example, if you manually change the CAB9 column at the invoice level to a new value, the system updates the funding level with the same value. Typically, the values for these columns are the same at the invoice and funding levels (that is, the C2 and C3 values are the same).

When you run the R00422 batch program to automatically update F5201 records, the system does not update the funding level for the USA4, USA5, CAB9, and QCOPR columns (that is, the C2 and C3 values are not the same). Having different column values at the invoice and funding levels does not negatively affect the contract or any subsequent processes.