Daily Invoice Supplementary Export - Invoice Line

Sr No	Field Label	Data Type	Length	Notes	Mandatory
A	Job Reference	integer	8	ViSN enquiry number	Y
B	Transaction type	text	1	I represents an invoice	Y
C	Invoice/Credit Number	text	20	This value is retrieved from the invoice number recorded in the invoice drawer during invoicing.	Y
D	Invoice/Credit creation date	integer	8	The date on which the invoice is generated CCYYMMDD (e.g., "20031225")	Y
E	Site ID	text	20	Supplier Account Number Same as RE-4 in daily invoice export The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} groupId	Y
F	Site Name	text	30	Supplier Name from Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier. If the content for this column is found to be more than 30 characters in length, it will be trimmed down to 30 characters.	Y
G	Site Address (1)	text	30	number from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	Y
H	Site Address (2)	text	30	address1 from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	Y
I	Site Address (3)	text	30	address2 from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	N
J	Site Address (4)	text	30	county from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	N
K	Site Postcode	text	8	postcode from Supplier Address Details of Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier.	N
L	Account Reference	text	20	Supplier Account Number Same as RE-4 in daily invoice export The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} groupId	Y
M	Account Name	text	30	Supplier Name from Invoice Supplier Details Invoice Supplier Details The DI Admin Portal allows us to select whether the export utilizes supplier details or the details from the supplier group. The format for these details is as follows: Supplier Name: The name of the supplier Supplier Address: The address of the supplier. number address1 address2 county postcode VAT Number: The unique VAT number assigned to the supplier. If the content for this column is found to be more than 30 characters in length, it will be trimmed down to 30 characters.	Y
N	Vehicle Registration	text	14	VRM of vehicle associated with the enquiry	Y
O	Asset ID	text	10	The asset number of the vehicle associated with the enquiry will be populated into this column	Y
P	File ID	integer	8	Same as HE-5 from daily invoice export Retrieve the baseReferenceDate and baseSequenceNumber from Firebase at the following location: - leasecompany {leaseId} exports settings invoiceExportsSequenceNumber baseReferenceDate baseSequenceNumber Determine days elapsed as number of days between the baseReferenceDate and the current date Add baseSequenceNumber to it to use it as the export sequence number	Y
Q	Tax point date	integer	8	This value is retrieved from the invoice number recorded in the invoice drawer during invoicing. CCYYMMDD (e.g., "20031225")	Y
R	Amount Nett VAT	number	5.2	The Total Nett Line Cost is determined by combining the total net parts cost and the total net labour cost if the job line includes both parts and labour. Otherwise, it represents the total value of the job line. (e.g., 99999.99)	Y
S	Gross Amount	number	5.2	Mandatory with an invoice or credit note The final value is calculated by factoring in the total net jobline cost and applying the VAT rate (e.g., 99999.99)	Y
T	Job Sheet Creation Date	integer	8	Check-in date from the associated enquiry	Y
U	Franchise Name	text	30	uses supplier franchises and vehicle's make to perform Manufacturer Column Logic Manufacturer Column Logic Determines whether a supplier’s franchises are associated with a given vehicle manufacturer and returns the corresponding manufacturer-related metadata for inclusion in supplementary invoice exports. The Manufacturer Column Logic compares a vehicle’s make against a supplier’s registered franchises to identify whether the supplier is an in-manufacturer and which franchise name should be displayed in the export data. It produces a structured output summarizing manufacturer alignment and franchise identification. Inputs Name Type Description franchises Array<String> A list of supplier franchises, each containing a franchise label. vehicleMake string The vehicle manufacturer name used to check against the supplier’s franchises. Output Key Type Description inManufacturer string ("Y" or "N") Indicates whether the supplier’s franchises include the given vehicle make. franchiseName string The matching franchise name if found; otherwise, either the first supplier franchise name in the list or an empty string. Example: {inManufacturer: 'Y', franchiseName: 'Citroen'} Logic Summary Match Evaluation The vehicle make is compared against each supplier franchise name. A match may be exact or partial (e.g., "Citroen" matches "Citroen - LCV"). When a match is found, the record is marked as inManufacturer = 'Y'. No Match Handling If no supplier franchise corresponds to the vehicle make: { inManufacturer: 'N', franchiseName: <first franchise or empty string> } Special Case — “All” The franchise name "All" represents a general franchise and does not count as a manufacturer match. Returns inManufacturer: 'N'. Multiple Matches When multiple relevant supplier franchises exist (e.g., "Volkswagen" and "Volkswagen - LCV"), the logic prioritizes the most precise match. Empty Input If no supplier franchises are provided, the output defaults to: { inManufacturer: 'N', franchiseName: '' } Example Scenarios Vehicle Make Supplier Franchises Output Citroen [Citroen] { inManufacturer: 'Y', franchiseName: 'Citroen' } Audi [Audi, Ford, All] { inManufacturer: 'Y', franchiseName: 'Audi' } Citroen [Citroen - LCV] { inManufacturer: 'Y', franchiseName: 'Citroen - LCV' } Audi [Citroen] { inManufacturer: 'N', franchiseName: 'Citroen' } Volkswagen [Volkswagen, Volkswagen - LCV] { inManufacturer: 'Y', franchiseName: 'Volkswagen' } Audi [] { inManufacturer: 'N', franchiseName: '' } and use franchiseName from the result	Y
V	Service Centre Group Name	text	50	Group name of the supplier	Y
W	In Manufacturer	text	1	uses supplier franchises and vehicle's make to perform Manufacturer Column Logic Manufacturer Column Logic Determines whether a supplier’s franchises are associated with a given vehicle manufacturer and returns the corresponding manufacturer-related metadata for inclusion in supplementary invoice exports. The Manufacturer Column Logic compares a vehicle’s make against a supplier’s registered franchises to identify whether the supplier is an in-manufacturer and which franchise name should be displayed in the export data. It produces a structured output summarizing manufacturer alignment and franchise identification. Inputs Name Type Description franchises Array<String> A list of supplier franchises, each containing a franchise label. vehicleMake string The vehicle manufacturer name used to check against the supplier’s franchises. Output Key Type Description inManufacturer string ("Y" or "N") Indicates whether the supplier’s franchises include the given vehicle make. franchiseName string The matching franchise name if found; otherwise, either the first supplier franchise name in the list or an empty string. Example: {inManufacturer: 'Y', franchiseName: 'Citroen'} Logic Summary Match Evaluation The vehicle make is compared against each supplier franchise name. A match may be exact or partial (e.g., "Citroen" matches "Citroen - LCV"). When a match is found, the record is marked as inManufacturer = 'Y'. No Match Handling If no supplier franchise corresponds to the vehicle make: { inManufacturer: 'N', franchiseName: <first franchise or empty string> } Special Case — “All” The franchise name "All" represents a general franchise and does not count as a manufacturer match. Returns inManufacturer: 'N'. Multiple Matches When multiple relevant supplier franchises exist (e.g., "Volkswagen" and "Volkswagen - LCV"), the logic prioritizes the most precise match. Empty Input If no supplier franchises are provided, the output defaults to: { inManufacturer: 'N', franchiseName: '' } Example Scenarios Vehicle Make Supplier Franchises Output Citroen [Citroen] { inManufacturer: 'Y', franchiseName: 'Citroen' } Audi [Audi, Ford, All] { inManufacturer: 'Y', franchiseName: 'Audi' } Citroen [Citroen - LCV] { inManufacturer: 'Y', franchiseName: 'Citroen - LCV' } Audi [Citroen] { inManufacturer: 'N', franchiseName: 'Citroen' } Volkswagen [Volkswagen, Volkswagen - LCV] { inManufacturer: 'Y', franchiseName: 'Volkswagen' } Audi [] { inManufacturer: 'N', franchiseName: '' } and use inManufacturer from the result	Y
X	Franchise Preference Code	text	8	This value is retrieved from the Franchise preferences of supplier's rate card.	N
Y	Franchise Preference Name	text	30	This value is retrieved from the Franchise preferences of supplier's rate card.	N

Status: Accepted
Category: Protected
Authored By: Rama on Nov 12, 2025

Revisions
12 Nov, 2025 – Add Daily Invoice Supplementary Export Documentation, VN-20902