Common Fields Used in This Chapter

Specify the component code to use to assign accounting rules. You leave this field blank to enable base and component workfile transactions to use this accounting rule. You update this field with a valid component code to assign accounting rules to component workfile transactions that are different from the accounting rules that are set up for the base workfile transactions. When the system does not find a component code in the Markup Table that exactly matches the component workfile transaction, it uses the accounting rule that you set up for the base workfile transaction.

For example, if a base workfile transaction has three component workfile transactions, OVH (overhead), GA (general and administrative), and FEE (fees), and you want the OVH revenue that is assigned to an accounting rule to be different from that of the base or the other component workfile transactions, you would set up two accounting rules: one accounting rule with OVH entered in the Component Code field to process the OVH revenue, and another accounting rule with a blank component code to process the base, GA, and FEE workfile transactions.

Enter the name of the component cost rate table to use for this entry in the Billing Rate / Mark up Table (F48096). The component table identifies the components and their calculation rules. These component amounts are applied as overhead to the original cost. You set up component tables on the Component Table Revisions form.

Complete this field to override the customer information from the address book or customer master information.

Enter a code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates the value that you enter to the AAI item RC (for Accounts Receivable) or PC (for Accounts Payable) to locate the trade account. For example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables).

You can assign as many as four alphanumeric characters to represent the G/L offset, or you can assign the three-character currency code (if you enter transactions in a multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the G/L offset and uses the account that is set up for PC or RC for the company specified.

If you set up a default value in the G/L Offset field of the customer or supplier record, the system uses the value during transaction entry unless you override it.

Note: Do not use code 9999. It is reserved for the post program and indicates that offsets should not be created.

Enter the name of the component invoice or revenue table to use for this entry in the Billing Rate / Mark up Table (F48096). The component table identifies the components and their calculation rules. These component amounts are recognized as invoice or revenue in addition to any invoice or revenue markups.

The generation type of the Billing Rate / Mark up Table, in conjunction with the Independent Revenue/Invoice Amounts option in the Billing Constants program (P48091), determines whether this is a component table for invoice amounts, revenue amounts, or both. You set up component tables on the Component Table Revisions form.

Enter a code that the system uses in combination with the table key to locate and validate the source and workfile transactions against the various tables and user-defined codes in Contract and Service Billing.

Key type codes and their related tables or user-defined codes are:

1: Work order number - Work Order Master File (F4801)

2: Work Order Class - User Defined Code (00/W7)

3: Contract number - Contract Master (F5201)

4: Parent contract number - Contract Master (F5201)

5: Customer - Address Book Master (F0101)

6: Job or business unit - Business Unit Master (F0006)

7: Job class - User Defined Code (00/11)

8: Company - Company Constants (F0010)

9: Default

When you select a key type:

You cannot use the key types for contract number (3) or parent contract number (4) with the Tax Derivation and G/L Offset & Retainage tables.

You cannot use the key type for company (8) with the G/L Offset and Retainage tables.

You can use the default key type (9) with the Billing AAI Information table (F48S95) and the Billing Rate / Mark up Table (F48096) only.

Enter the portion of a general ledger account that refers to the division of the cost code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the cost code for labor into regular time, premium time, and burden.

Note: If you use a flexible chart of accounts and the object account is set to six digits, we recommend that you use all six digits. For example, entering 000456 is not the same as entering 456 because if you enter 456, the system enters three blank spaces to fill a six-digit object.

Enter a value that identifies the ending object account in a range of accounts.

Enter a subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.

Note: If you are using a flexible chart of accounts and the object account is set to six digits, you must use all six digits. For example, entering 000456 is not the same as entering 456 because if you enter 456, the system enters three blank spaces to fill a six-digit object.

Enter a number that specifies the ending subsidiary account in a range of accounts. The system uses the accounts in this range to determine the basis for the allocation. Only posted amounts in the account range are included.

Enter a value that the system uses in combination with the key type to locate and validate workfile transactions against the various tables in Contract and Service Billing. The value that you enter in the Key Type field determines the values for the Table Key field. For example, if you specify the key type for work order number (1), you must enter a valid work order number from the Work Order Master File table (F4801) in the Table Key field. The key type that you specify also controls the search window that you access from the Table Key field when you click the search button. For example, when you select key type 1, you can click the search button for the Table Key field to access the Work Order Search window. With key type 2, you access the User Defined Codes window for work order class.