Understanding Major Keys for Billing AAIs

You must specify a major key for each billing AAI table that you set up. The major key includes:

Billing AAI

Corresponds to the type of accounting entry that you created. For example, AAI 4811 (Actual Revenue Account) tells the system which G/L account to credit for revenue when you process invoices or revenue recognition.

Key Type

Defines the type of major key value for the billing AAIs. The system recognizes the use of these hard-coded values:

  • Work order

  • Work order class

  • Contract number

  • Parent contract number

  • Customer

  • Job or business unit

  • Job class

  • Company

  • Default

Table Key

Defines the major key value, based on the key type, that the system uses to verify that the information in the billing detail transactions exists in various tables in Contract and Service Billing.

Effective Dates

Specifies when the billing AAI table is effective. The system compares the table basis date of the workfile transaction to these dates when it searches the billing AAIs.