UPDATE OPEN BILLING DETAIL BILLLABCATDESCR

This toolkit updates the Billing Labor Category Description (bill_lab_cat_desc) in source projects and transaction projects that  populate Open Billing Detail (OPEN_BILLING_DETL).  The process reviews the T&M Rate Order (TM_RT_ORDER) table to determine the Source Project ID (srce_proj_id) and then replaces the Billing Labor Category in Open Billing Detail. 

Select Tables

Use this group box to select which tables you would like to update.

Open Billing Detail

Select this check box to update the Open Billing Detail table for new labor category descriptions. You should select this check box if you think that some unbilled transactions are linked to incorrect descriptions.

Billing History

Select this check box to update the Closed Billing Detail and Billing History tables. Selecting this check box will update records that have already been billed.

Project Range

Use this group box to limit the projects that need to be updated.

All

Select this option to process all projects that meet the transaction posting criteria.

Range

Select this option to process a range of projects as specified in the From and To fields in the Select Project group box. 

One

Select this option to process a range of projects as specified in the From field in the Select Project group box. 

Select Project

After selecting the Range or One option in the Project Range group box, enter, or use to select, the beginning (From) and ending (To) project.

Execute

Click this button to start the toolkit.

Cancel

Click this button to exit this screen without running the toolkit.