Project Status Inquiry Tables (Release 9.2 Update)
Project status inquiry uses tables from several JD Edwards EnterpriseOne systems as well as tables that are specific to project status inquiry.
This table lists the tables used by project status inquiry as it processes records:
Table |
Description |
|---|---|
F0006 (Business Unit Master) |
The system retrieves job and project information from the F0006 table. The system uses the F0006 records to select data in other tables. It also displays the F0006 values in the Project Status Inquiry form. |
F03B11 (Customer Ledger) |
The system retrieves data from the F03B11 table for certain types of billing lines, and displays values from the table in the Project Status Inquiry form. |
F0902 (Account Balances) |
The system retrieves data from the F0902 table and displays account values from the table in the Project Status Inquiry form. |
F0911 (Account Ledger) |
The system retrieves data from the F0911 table for the AA and AU ledgers when you specify to use specific dates instead of periods. |
F4812 (Billing Detail Workfile) |
The system retrieves data from the F4812 table for certain types of billing lines, and displays values from the table in the Project Status Inquiry form. |
F4812H (Billing Workfile History) |
The system retrieves data from the F4812H table for certain types of billing lines, and displays values from the table in the Project Status Inquiry form. |
F4822 (Invoices Summary Workfile) |
The system retrieves data from the F4822 table for certain types of billing lines, and displays values from the table in the Project Status Inquiry form. |
F51X10 (Project Status Inquiry Worktable) |
This table holds the job, project, contract, and account data that you specified to include in a view, and includes the values that the system calculated for your selected data, such as totals and subtotals. The system populates this table with temporary records when you click View Now on the Work with Project Status Inquiry form. Unless you save the results, the system deletes the view records when you exit the Project Status Inquiry form. When you save results to view later, the system saves the view data such as the job, project, and calculated totals until you delete the saved results. You delete records from this table by deleting the saved view using the Work with Project Status Inquiry View program (P51X30). |
F51X100 (Account Range Table) |
The system populates this table with the records that you set up using the Project Status Inquiry Account Ranges program (P51X100). |
F51X30 (View List) |
The system populates this table with information about the view results when you save results to view later. You access and modify records in the table using the Work with Project Status Inquiry View program (P51X30). When you delete records from this table, the system also deletes the related records from the F51X10 table. |
F51X90 (Column Definition) |
This table includes the column definitions that you set up in the Project Status Inquiry Column Definitions program. The system uses the values in this table when you specify columns in the Project Status Inquiry Column Layouts program (P51X091) and the Work with Project Status Inquiry program (P51X0200). |
F51X91 (Column Layout table) |
This table includes the column layouts that you set up in the Project Status Inquiry Column Layout program. The system uses the values in this table when you specify columns in the Work with Project Status Inquiry program and when you modify column layouts in the Project Status Inquiry program (P51X0210). |