Work Order Workfile Generation Program

Generating the work order workfile enables you to:

Bill customers for services that you provided to them.
Pay service providers for services that they provided to the company.

The system retrieves the billing information from the parts and routing detail lines.

This table lists the tables that the system accesses when you generate the work order workfile:

Table	Description
Work Order Master File (F4801)	Contains general work order information.
Service Order Extension (F4817)	Contains work order information that is specific to Service Management.
Work Order Parts List (F3111)	Contains general parts list information.
Parts Extension (F31171)	Contains parts list information that is specific to Service Management.
Work Order Routing (F3112)	Contains general routing and instruction information.
Routing Instructions - Extension (F31172)	Contains information about routings and instructions that is specific to Service Management.

This table lists the tables that the system creates or updates when you generate the work order workfile:

Table	Description
Billing Details Workfile (F4812)	When you run the Work Order Workfile Generation program in final mode, the system creates table F4812 records for each detail line within the Work Order Parts List table (F3111) and Work Order Routing table (F3112). When you create payable records to pay a service provider, the system creates a record within the billing details workfile for the covered expense and a separate record for the noncovered expense.
Parts Extension (F31171)	Based on the processing involved, it is possible for the system to update these fields: Date Billed Date Paid Actual Billable Unit Actual Payable Unit Actual Billable Amount Actual Payable Amount
Routing Instructions - Extension (F31172)	Based on the processing involved, it is possible for the system to update these fields: Date Billed Date Paid Actual Billable Rate Actual Payable Rate Actual Billable Amount Actual Payable Amount

Table

Description

Billing Details Workfile (F4812)

When you run the Work Order Workfile Generation program in final mode, the system creates table F4812 records for each detail line within the Work Order Parts List table (F3111) and Work Order Routing table (F3112). When you create payable records to pay a service provider, the system creates a record within the billing details workfile for the covered expense and a separate record for the noncovered expense.

Parts Extension (F31171)

Based on the processing involved, it is possible for the system to update these fields:

Date Billed
Date Paid
Actual Billable Unit
Actual Payable Unit
Actual Billable Amount
Actual Payable Amount

Routing Instructions - Extension (F31172)

Based on the processing involved, it is possible for the system to update these fields:

Date Billed
Date Paid
Actual Billable Rate
Actual Payable Rate
Actual Billable Amount
Actual Payable Amount