Product group contracts query

You can download customer fuel contracts using the default ‘Product group contracts’ report.

Contents:

Filters

There are no required filters for this query.

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Name

Description

Example

Allow reward program

Indicates if the contract allows for reward programs. See ‘Allow reward program' field in contract. See Reward programs (Administration).

TRUE

Currency to charge in

This column is no longer used and is for backward compatibility only.

 

Days credit for fuel

The credit term in days for the contract. See 'Credit term in days' field in contract.

15

Days credit for handling

The credit term in days for the contract. See 'Credit term in days' field in contract.

Note: This column is a duplicate for ‘Days credit for fuel

15

Debtor name

The debtors name for the contract. See ‘Organization name’ field in the contract’s debtor contact.

American International Group

Is debtors order number required

Indicates if the debtor’s order number is required. See 'Is ticket debtor's order number required' field in contract

FALSE

Must be invoiced separately from handling services

Indicates if the contract’s product group should be invoiced separately to other product groups. See 'Must be invoiced separately from other contracts’ field in contract.

TRUE

Must be paid at OPS desk

Indicates if the contract must be paid at front desk. See 'Must be paid at OPS desk' field in contract.

FALSE

Mutation type

The mutation type for the Contract, added to the product group. See 'Members of product group' table in Product Groups (Administration) page.

Uplift

Ramp staff validation text

The checkout remarks for users on checkout. See 'Check-out remarks for customer service reps' field in contract.

Fuel release number

Remarks

Free text remarks for the contract. See 'Remarks' field in contract.

Contract added based on network contract arrangement

Require fuel release or valid fuel card

Indicates if the contract requires carnet payment. See 'Requires carnet payment' field in contract.

FALSE

SKU

The SKU for the Contract, added to the product group. See 'Members of product group' table in Product Groups (Administration) page.

JET A1

Unit to charge in

Contract’s unit of measure to charge fuel. See 'Unit of measure to charge fuel in' field in contract.

ltr

Valid before date UTC

Expiry date for the contract. See 'Expiry date' field in contract.

12-31-99