Data Format |
The Data Format tab enables you to define the data format used in the automated fuel system.
The field in the top section of this tab defines the data that displays.
Fuel system ID
Identifier of the fuel system for which you are defining a data format. Numeric. This field has a choice list of previously defined fuel system IDs that have a check in the System available field on the Fuel System Description tab. The system name displays to the right of the ID.
Fuel systems are defined on the Data -> Equipment Activity -> Fueling -> Setup -> Automated Fuel Systems screen.
Data in the screen groups in the bottom section of the tab display and define the format. Unless otherwise indicated, these fields are required.
Data in the first screen group, Descriptive data items, delete or define the data format of descriptive data items in the transaction.
Data in the second screen group, Quantitative data items, delete or define the data format of numeric data items in the transaction.
Note: Unless otherwise noted, the following fields are in both screen groups.
Delete
If this field has a check, the entries in the fields to the right are deleted when you process the request. The following two fields apply if the Transaction format information/Transaction format field on the Fuel System Description tab specifies FIXED for the automated fuel system.
Data type
Type of descriptive data for which information is provided. This field contains a choice list.
EQUIPMENT ID: Information in each transaction record used to identify the equipment ID that received the fuel. Required if there is information in the Transaction codes for miscellaneous costs field on the Other Transactions tab. The equipment identifying information contained in each transaction record is specified on the Equipment identifier field on the Processing Rules - General tab.
DATE: Transaction date in each transaction record. Date format is specified in the Date format field on the Fuel System Description tab. Required for all fuel systems.
ACCOUNT ID Identifier of the account to associate with the fuel ticket. Required if the fuel system contains account ID information that should be processed. When you process fuel transactions, it must be an account ID with a status of ACTIVE. Account status is specified on the Basic Info tab of the Data -> Setup -> Organization Structure -> Accounts -> Primary Information screen.
EMPLOYEE ID: Identifier of the employee who dispensed the fuel on the fuel ticket. Required if the fuel system contains employee ID information that should be processed.
SITE ID: Fuel site from which the fuel ticket originated. Required if the Fuel price comes from field on the Processing Rules - Fuel tab specifies FUEL TANK LOOKUP and the Fuel source identifier field on that tab specifies SITE ID PLUS PUMP ID 1.
PUMP ID 1: Dispensing fuel pump for the fuel ticket. Required if the Fuel price comes from field on the Processing Rules - Fuel tab specifies FUEL TANK LOOKUP and the Fuel source identifier field on that tab specifies PUMP ID 1, PUMP ID 1 PLUS PUMP ID 2, or SITE ID PLUS PUMP ID 1.
PUMP ID 2: Together with PUMP ID 1, this field identifies the dispensing fuel pump for the fuel ticket. Required if the Fuel price comes from field on the Processing Rules - Fuel tab specifies FUEL TANK LOOKUP and the Fuel source identifier field on that tab specifies PUMP ID 1 PLUS PUMP ID 2.
TANK ID: Fuel tank from which the fuel ticket originated. Required if the Fuel price comes from field on the Processing Rules - Fuel tab specifies FUEL TANK LOOKUP and the Fuel source identifier field on that tab specifies TANK ID. Also required if there is information in the Transaction codes for fuel receipts or tank readings fields on the Other Transactions tab.
PRODUCT ID: Fuel or fluid type of the fuel or fluid on the fuel ticket. Required if the Fuel price comes from field on the Processing Rules - Fuel tab specifies FUEL TYPE LOOKUP.
REVERSAL INDICATOR: Code that indicates whether the transaction should be processed as a reversal. Reversal indicators include:
Y or R: The fuel ticket is a reversal (credit) transaction. The transaction is processed as reversals.
Other: Standard charge transaction.
TRANSACTION CODE: Transaction code in transaction records that indicates that the transaction should be processed. This information is used only if there is a check in the Check fuel transaction codes field on the Processing Rules - Fuel tab or the Check fluid transaction codes field on the Processing Rules - Fluid tab.
STATE/PROVINCE: Transaction code in transaction records that indicates the state or province in which the transaction took place. Required if there is a check in the Require state/province on external fuel tickets field on the Data -> Equipment Activity -> Fueling -> Setup -> Options screen.
FROM TANK ID: Identifier of the tank from which fuel was transferred. Required if there is information in the Transaction codes for fuel transfers field on the Other Transactions tab.
TO TANK ID: Identifier of the tank to which fuel was transferred. Required if there is information in the Transaction codes for fuel transfers field on the Other Transactions tab.
VENDOR ID: Identifier of the fuel vendor that supplied the fuel. It must be a vendor with a check in the Vendor provides: Fuel field on the Functions tab of the Data -> Setup -> Organization Structure -> Vendors -> Primary Information screen.
EXTERNAL ID: Identifier of the fuel transaction.
SESSION START DATE: The starting tansaction date in each transaction record. Date format is specified in the Date format field on the Fuel System Description tab. Required for all fuel systems.
SESSION START TIME: The starting transaction time in each transaction record.
SESSION END DATE: The ending tansaction date in each transaction record. Date format is specified in the Date format field on the Fuel System Description tab. Required for all fuel systems.
SESSION END TIME: The ending transaction time in each transaction record.
CONNECTION TYPE: The connection or plug type of the electric charging connection. This field has a drop-down list and a selection can be made from that list, or entered as a new selection.
Starting position
The character position in each transaction record of the first character of each data type. The first character position in the transaction record is position 1. If the Transaction format information/Transaction format field specifies COMMA-SEPARATED, this field is blank.
Length
Number of character positions in each transaction record occupied by each data type. The minimum value is 1. If the Transaction format information/Transaction format field specifies COMMA-SEPARATED, this field is blank.
Field number
If the Transaction format information/Transaction format field on the Fuel System Description tab specifies COMMA-SEPARATED, this field must contain the relative position in each transaction record of each data type. The first field number in the transaction record is 1. The value of this item must be one more than the number of commas that precede this data type in each transaction record. If the Transaction format information/Transaction format field specifies FIXED, this field is blank.
Right aligned
If this field has a check, leading spaces are removed from the value before it is validated or processed.
Note: This field is only in the Descriptive data items screen group data table.
Delete
If this field has a check, the entries in the fields to the right are deleted when you process the request.
Data type
Type of quantitative data for which information is provided. This field contains a choice list.
METER 1 READING: Equipment unit’s meter (or meter 1) reading at the time the fuel was dispensed. Required if the fuel system contains meter (or meter 1) information that should be processed and if the fuel system provides a quantitative data item for the meter 2 reading.
METER 2 READING: Reading of the equipment unit’s meter 2 (if any) at the time the fuel was dispensed. Required if the fuel system contains meter 2 information that should be processed. If the fuel system provides a quantitative data item of meter 2 reading, there must also be a quantitative data item of meter 1 reading.
FUEL QUANTITY: Quantity of fuel dispensed. Required if there is information in the Transaction codes for fuel receipts, transfers, or tank readings fields on the Other Transactions tab.
FUEL UNIT PRICE: Unit price of the fuel dispensed. If the Fuel price comes from field on the Processing Rules - Fuel tab specifies TRANSACTION, either a fuel unit price or a fuel total cost is required. If both exist, fuel total cost information is used and fuel unit price information is ignored. Required if there is information in the Transaction codes for fuel receipts field on the Other Transactions tab.
FUEL TOTAL COST: Total price of the fuel dispensed. If the Fuel price comes from field on the Processing Rules - Fuel tab specifies TRANSACTION, either a fuel total cost or a fuel unit price is required. If information for both exists, the fuel total cost information is used and the fuel unit price ignored.
FLUID QUANTITY: Quantity of the fluid dispensed. Required for all fuel systems that provide fluid transactions.
FLUID UNIT PRICE: Unit price of the fluid dispensed. If the fuel system provides a fluid quantity and the Fluid price comes from field on the Processing Rules - Fluids tab specifies TRANSACTION, either a fluid unit price or a fluid total cost is required. If information for both exists, the fluid total cost information is used and the fluid unit price ignored.
FLUID TOTAL COST: Total price of the fluid dispensed. If the fuel system provides a fluid quantity and the Fluid price comes from field on the Processing Rules - Fluids tab specifies TRANSACTION, either this data type or a fluid unit price is required. If information for both exists, fluid total cost is used and fluid unit price is ignored.
MISC COST: Miscellaneous costs associated with the transaction.
FUELING TIME: The number of seconds to perform the fueling.
Starting position
The character position in each transaction record of the first character of each data type. The first character position in the transaction record is position 1. If the Transaction format information/Transaction format field specifies COMMA-SEPARATED, this field is blank.
Length
Number of character positions in each transaction record occupied by each data type. The minimum value is 1. If the Transaction format information/Transaction format field specifies COMMA-SEPARATED, this field is blank.
Field number
If the Transaction format information/Transaction format field on the Fuel System Description tab specifies COMMA-SEPARATED, this field must contain the relative position in each transaction record of each data type. The first field number in the transaction record is 1. The value of this item must be one more than the number of commas that precede this data type in each transaction record. If the Transaction format information/Transaction format field specifies FIXED, this field is blank.
Decimal point explicit
Note: This field is only in the Quantitative data items screen group data table.
If this field has a check, the system contains data with explicit decimal points (for example, 999.99). If you place a check in this box, leave the Qty of decimal places field blank.
If this field is blank, the system contains data with implicit decimal points (for example, 99999). There must be information in the Qty of decimal places field.
Qty of decimal places
Note: This field is only in the Quantitative data items screen group data table.
Number of decimal places included in this data type. This information is used only if the Decimal point explicit field is blank.