The Product group contracts query is used to generate customer fuel contracts data, showing each fuel contract and mutation type per row.
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 |
|---|---|---|
|
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 |
Related pages:
-
Contracts query — The Contracts query is used to export customer Contract data, showing each contract per row.
-
Product group contracts query — The Product group contracts query is used to generate customer fuel contracts data, showing each fuel contract and mutation type per row.
Comments
0 comments
Please sign in to leave a comment.