Understanding Job Status Inquiry-User Defined Columns Program (P512000)

The Job Status Inquiry User Defined Columns program (P512000) provides the most flexibility for reviewing the important job or project information. Unlike the Job Status Inquiry Basic program, which retrieves information only from the Account Balances table, the P512000 program can retrieve information from both the Account Balances table and Account Ledger (F0911) table. You can use dates for partial periods and select unposted records from the F0911 table.

Using this program, you decide the columns to display, the sequence in which to display the information, and the search criteria to use to retrieve the information, such as dates, cost code ranges, posted status, and so on. Processing options let you specify default values for search criteria, and column versions let you save selected columns. By using both processing options and column versions, you can set up multiple versions of the inquiry program for different types of searches.