1. Job Cost Implementation Guide
  2. Inquiry Ledger Types (51/IL)

Inquiry Ledger Types (51/IL)

Use inquiry ledger types to identify any additional ledgers from which the system can retrieve amounts or unit quantities for the Job Status Inquiry User Defined Columns program (P512000).

  • For amounts, the valid codes are 11 through 20 and 70 through 79.

  • For unit quantities, the valid codes are 31 through 40 and 80 through 89.

  • For unit quantities at the header account level, the valid codes are 51 through 60 and 90 through 99.

The first two characters of the Description 02 field must specify the amount ledger type. The third and fourth characters of the field must specify the corresponding unit ledger type, if one exists.

The ledger types must be in uppercase.

The Special Handling field should contain one of the values:

  • Blank: Non-budget ledger (period buckets only)

  • 1:Budget ledger (period buckets and BORG)

  • 2: BORG field retrieval (original budget only)

When you complete the Description 01,Description 02, and Special Handling fields for the code, the system automatically displays it in the formula list that you use to define inquiry columns.