Daily Invoice Export - Invoice Block

Terminology

Record Set

A set of rows exported into the CSV file, it consists of the records in the order as in below Order Indicator Context 1.x TH Transaction Header 2.x RE Supplier/Repairer Details 3.x IN Invoice Credit Note Details 4.x.1 IL Item Line Details 4.x.2.n IP Parts Record 4.x.3 TL Total Line Cost Record 5.x TC Total Transaction Cost Record 6.x VA VAT Summary Record 7.x TT Transaction Trailer Record * x denotes an index of the transaction relative to the enquiry that is invoiced/credited on the day of export * n denotes an index of parts/fluids added in a job line of specific enquiry

Record

A particular line of the export that is either of indicators allowed in a record set, along with one record for the entire file among the following HE - File Header LC - Scheme Operator Address Detail FT - File Trailer Record

File Header - HE

• This record is mandatory
• This is the first line of the export file
• This line is not part of any record set, it is common for the entire file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. HE - File Header This record is required for every export file Only one such record is allowed per file This line is not part of any record set, it is common for the entire file.	Text	2	Must be "HE"	Y
2	Record Version Number	Integer	2	Must be "6"	Y
3	Scheme Operator Reference	Integer	7	ViSN Customer Account Number	Y
4	Type of Transaction	Text	1	Value must be "I" The export process combines both invoices and credits into a single file. However, in the HE Record, the "Transaction Type" field does not distinguish between them and always displays "Invoice". In the HE Record, the "Transaction Type" field serves as an indicator of the file format for export, rather than specifying the actual transaction type (invoice or credit).	Y
5	File Serial Number	Integer	8	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
6	Run Date	Integer	8	CCYYMMDD (e.g., "20031225")	Y
7	Run Time	Integer	6	HHMMSS (e.g., "232830")	Y
8	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Scheme Operator Address Detail - LC

• The inclusion of this line is controlled by the flag addLCLineForInvoice, which is configured in the lease company's scheduler.
• When addLCLineForInvoice is set to false, the LC line appears only once in the file.
• When addLCLineForInvoice is set to true, the LC line is included for each record in the file.
• If addLCLineForInvoice is not configured in the lease company's scheduler, the LC line defaults to being included for each record in the file.
• It provides details about the customer for whom the export is being generated.

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. LC - Lease Company (or) Operator (or) Scheme Operator Address Detail This record is mandatory for each record set. Only one such record is allowed per file. It includes details about the customer for whom the export is generated.	Text	2	Must be "LC"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Scheme Operator Reference	Integer	7	ViSN Customer Account Number This value will be fetched into the column at the time of export from below location in firebase - leasecompany {leaseId} leaseDetails accountNumber The value will be blank in case of the value being not present in above location	Y
4	Scheme Operator Account Name	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' If Group level setting, 'Use Direct Paybill Name' is enabled Then, Savi Perfix and Lease Company's Name for Direct Paybill will be used If Group level setting, 'Use Direct Paybill Name' is disabled Then, Savi Perfix and Lease Company's Name will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' If Group level setting, 'Use Direct Paybill Name' is enabled Then, Lease Company's Name for Direct Paybill will be used If Group level setting, 'Use Direct Paybill Name' is disabled Then, Lease Company's Name will be used For other rate card types, the value will default to the lease company's name. The name to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} leaseCompanyName	Y
5	Scheme Operator Address 1	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address	Y
6	Scheme Operator Address 2	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address	Y
7	Scheme Operator Address 3	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
8	Scheme Operator Address 4	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
9	Scheme Operator Address 5	Text	30	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
10	Scheme Operator Postcode	Text	8	When Enquiry's 'Rate Card' Type is "ViSN with DI Network and Paybill" or "ViSN Hybrid - Customer’s Network and DI Network with Paybill" And 'Supplier's Paybill' value at the time of enquiry creation was 'VISN' Then the Savi Address will be used And 'Supplier's Paybill' value at the time of enquiry creation was 'DIRECT' Then the Lease Company's Address will be used For other rate card types, the value will be used from the lease company's address. The value to be used will be stored while invoicing and fetched at time of export at following firebase location - leasecompany {leaseId} exports {year} {month} {day} enquiries {enquiryId} paybillDetailsForInvoiceExport address
11	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Transaction Header - TH

• Record is mandatory for each transaction in the record set
• More than one record can exist in each file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TH - Transaction Header Record is mandatory for each transaction in the record set More than one record can exist in each file	Text	2	Must be "TH"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	ViSN Enquiry Number	Integer	8	For invoice transactions (transaction type 'I'), the enquiry number will be populated in this column.	Y
4	Invoice Extract Analysis Ref	Integer	2	Constant "01"	Y
5	Repairer Job Number	Text	10	The enquiry number will be populated in this column
6	Vehicle Registration	Text	14	This column will contain the VRM (Vehicle Registration Mark) of the vehicle associated with the enquiry or job.	Y
7	Odometer Reading	Integer	7	This column indicates the vehicle's mileage recorded during the repair.	Y
8	Transaction Date	Integer	8	This column will contain the vehicle's check-in date at the garage. Format: CCYYMMDD (e.g., "20031225")	Y
9	Asset Number	Text	10	This column will contain the asset number associated with the vehicle in the enquiry.	Y
10	Card Number	Text	19	Blank Space
11	Driver Name	Text	40	This column will contain the name of the driver associated with the vehicle in the enquiry
12	Purchase Order Number	Text	20	Mandatory if job authorised on the ViSN platform. Purchase Order that is captured in enquiry will be populated into this column
13	Transaction Serial Number	Integer	8	Constant '1'	Y
14	Job Completion Date	Integer	8	The date when the job was closed and marked as 'Job Complete'. CCYYMMDD (e.g., "20031225").	Y
15	VIN	Text	20	This column will contain the Vehicle Identification Number (VIN) associated with the vehicle in the enquiry.
16	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Supplier/Repairer Details - RE

• This record is required in every record set
• Only one record is allowed per transaction
• Includes details of the supplier responsible for the service related to the enquiry

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. RE - Repairer Entry / Supplier Details This record is mandatory in every record set Only one record is permitted per transaction It contains the details of the supplier responsible for performing the service related to the enquiry	Text	2	Must be "RE"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	ViSN Repairer Account Number	Integer	7	DI Group Supplier ID, if no group then DI Supplier ID The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} groupId	Y
4	Supplier Account Number	Text	20	Supplier Group ID, if no group then Supplier ID The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} serviceUnits {serviceUnitObjectID} supplierId	Y
5	Supplier 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
6	Supplier Account 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
7	Supplier Account 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
8	Supplier Account 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.
9	Supplier Account 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.
10	Supplier Account 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.
11	Supplier VAT number	Text	10	VAT Number 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.	Y
12	Scheme Operator Controller ID	Text	10	Constant Blank
13	Supplier Account Address 5	Text	30	Constant Blank
14	Contact Telephone Number	Text	15	Contact phone number The value will be fetched into the column from below location in firebase - leasecompany {leaseId} suppliers {accountId} serviceUnits {serviceUnitObjectID} contact
15	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Invoice Credit Note Details - IN

• This record is required in every record set
• Each transaction can only contain one record
• Multiple records can be included in a single file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. IN - Invoice Note Details This record is required in every record set Each transaction can contain only one record Multiple records may exist within a single file	Text	2	Must be "IN"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Transaction Type	Text	1	I = Invoice	Y
4	Invoice Number	Text	20	This value is retrieved from the invoice number recorded in the invoice drawer during invoicing.	Y
5	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
6	Repairer Invoice Text	Text	16	Blank
7	Original Invoice Number	Text	20	Blank	Y
8	Original ViSN Transaction Number	Integer	8	Blank
9	Reason for Credit	Text	30	Blank
10	Scheme Operator Message	Text	80	Blank - Not In Use
11	Scheme Operator Authorisation Code	Text	10	Blank - Not In Use
12	Invoice Date	Integer	8	The date on which the invoice is generated CCYYMMDD (e.g., "20031225")	Y
13	Terms Status	Text	1	Constant 'I', I denotes `In terms` here
14	End of record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Item Line Details - IL

• Each record set must contain at least one record
• Multiple records can exist within a single transaction and in the export file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. IL - Item Line Details Each record set must include at least one record. Multiple records can be present within a single transaction. Multiple records can also exist within a single file.	Text	2	Must be "IL"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Item Number	Integer	2	This column represents the position or sequence of the specific job item within the job sheet linked to the enquiry.	Y
4	Cost Type	Text	1	Will be one of the Cost Types Cost Types F Free No charge for line (non-warranty) M Menu Price No parts/Labour split N Normal separate labour cost and parts cost W Warranty free, paid by manufacturer. T Paid for by third party Exception: For Tyre job lines, this value will always be 'M'.	Y
5	Charge Indicator	Text	1	Will be one of the Recharge Indicators Recharge Indicators P Post Warranty W Warranty R Recharge	Y
6	Quantity	Number	2.2	Value is always 1.	Y
7	Additional Information Text (or) Repairer Authorisation Text	Text	30	This column captures the customer's reason for manually authorizing a job line.
8	External Code/ViSN Job Code	Text	5	Integration code to be used in invoice exports. SMR Joblines: If the includeExternalSMRCodesInExport flag is enabled for the lease company and a matching External SMR Code is found for the jobline's description, it will be applied. This flag can be managed via the DI Admin portal on the Edit Customer screen. MOT Joblines: 28165 will be the code used for these joblines TYRE Joblines: 29128 will be the code used for these joblines SUPPLEMENTARY Joblines: 29113 will be the code used for these joblines GLASS Joblines: Existing external code saved against the job descriptions will be used If external code is not available for the job description in any of the above cases then '0'
9	Job line-Item Description	Text	90	Description of the Jobline Item. The values for this field differ based on the job line type (details provided below) MOT: Will be constant 'MOT' TYRE: A Concatenated string of Description, Brand of tyre and locations of replacement GLASS: A Concatenated string of Description, Location of Glass Change OTHER: Description of the jobline
10	Asset ID	Text	40	The asset number of the vehicle associated with the enquiry will be populated into this column
11	Full Recharge Text	Text	150	This column will contain the recharge notes entered by the customer for each job line associated with recharge details. If the content for this column consists of multiple lines, then the new lines will be replaced with a space character. If the content for this column is found to be more than 150 characters in length, it will be trimmed down to 150 characters.
12	Action code	Text	3	Default on file is code R&R
13	Reason Code	Text	3	The values for this field differ based on the job line type (details provided below) MOT: Will be constant 'RTN' denoting routine OTHER: Will be one of the Reason Codes Reason Codes 001 Below Legal Limit 002 Run Flat 003 Puncture Damage 004 Sidewall Damage 005 Driver Request 006 Tracking Damage 007 Logistics ACC Accident Damage I Administration Charge CRD Corroded CRQ Client Request CTM Contaminated DAB Abuse DAM Damage DEF Defective DST Distorted EMG Emergency FUL Fuel INS Insurance INT Initial INV Investigation LKG Leaking LOW Low Level LSE Loose LST Lost, originally supplied MSG Missing NGC Negligence NSY Noisy PKF Parking Fine PUN Puncture RCL Recall RLF Relief RTN Routine STF Stress Fracture STL Stolen STN Stone Damage STS Seasonal Tyre Swap SZD Seized UPG Upgrade VIB Vibration VND Vandalism WRN Worn WTH Weather WTY Warranty	Y
14	Goodwill Percentage	Number	3.2	Always 0.0	N
15	Labour Time	Number	5.2	When Cost Type is "N", is mandatory Will be always set to 0 for TYRE joblines This Column will be populated from labour details modal of the jobline (e.g., 99999.99)	Y
16	Labour Rate	Number	5.2	When Cost Type is "N", is mandatory Will be always set to 0 for TYRE joblines This Column will be populated from labour details modal of the jobline The labour rate is calculated by factoring in the goodwill percentage. This ensures that the final rate reflects any adjustments or considerations related to goodwill. (e.g., 99999.99)	Y
17	Number of Parts	Number	3.2	When Cost Type is "N", is mandatory The values for this field differ based on the job line type and job description type (details provided below) TYRE: Will be constant 0 MOT: Will be constant 0 OTHER - Catalogue: Will be constant 0 OTHER - Non Catalogue: No.of.parts added in the jobline (e.g., 999.99)	Y
18	Recharge Reason Code	Text	5	When Charge Indicator = "R", is mandatory. Will be one of the Recharge reason codes Recharge reason codes Damaged Tyre Miscellaneous Accident Damage Body Work Driver Abuse Policy Repairs Relief Vehicle Mechanical Repairs Servicing Warranty Repairs Tyres RFL Electrical Repairs Brake Repairs Breakdown Vandal Damage Stolen Missing Damaged
19	Recharge Amount	Number	5.2	This column will contain the recharge amount entered by the customer for each job line associated with recharge details. (e.g., 99999.99)
20	Recharge Percentage	Number	3.2	This column will contain the recharge percentage entered by the customer for each job line associated with recharge details. (e.g., 999.99)
21	Recharge Text	Text	40	This column will contain the recharge notes entered by the customer for each job line associated with recharge details. If the content for this column consists of multiple lines, then the new lines will be replaced with a space character. If the content for this column is found to be more than 40 characters in length, it will be trimmed down to 40 characters.
22	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Parts Record - IP

• Record is optional, available only if any of the job lines of the job sheet has parts/fluids added to them
• More than one record can exist in each file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. IP - Invoice (or Credit) Parts details / Parts Record Record is optional in each record set More than one record can exist in each transaction More than one record can exist in each file	Text	2	Must be "IP"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Item Number	Integer	2	This column indicates the specific job item's position (order) within the job sheet associated with the enquiry.	Y
4	Parts Number	Integer	1	always "1"	Y
5	Parts Code	Text	24	During data export, the 'Part line type' field is used to determine the content for this specific column. If the type is identified as 'P' (indicating a part), the corresponding part number is included If the type is identified as 'F' (indicating a fluid), the corresponding fluid code is placed in the column. the code would be one among available Fluid Types Fluid Types Code Label 0W20_ENGINE_OIL 0w20 Engine Oil 0W30_ENGINE_OIL 0w30 Engine Oil ADDATIVE_POUCH Addative Pouch ADDITIVE_POUCH Additive Pouch AIR_CONDITIONING_COOLANT Air Conditioning Coolant ANTIFREEZE Anti Freeze AUTOMATIC_TRANSMISSION_FLUID Automatic Transmission Fluid AXLE_OIL Axle Oil BRAKE_FLUID Brake/Clutch Fluid COOLING_LIQUID Cooling Liquid DPF_FLUID D.p.f. Fluid AD_BLUE Diesel Exhaust Fluid/AdBlue GEARBOX_OIL_MINERAL Gearbox Oil - Mineral GEARBOX_OIL_SYNTHETIC Gearbox Oil - Synthetic HYDRAULIC_FLUID Hydraulic Fluid LONG_LIFE_OIL Long Life Oil MINERAL_OIL Mineral Oil OIL_1615099980 Oil-1615099980 OIL_9734S2 Oil-9734S2 OIL_9979A7 Oil-9979A7 OTHER Other PARTIULATE_FLUID Partiulate Fluid POWER_STEERING_FLUID Power Steering Fluid REFRIGERATOR_COOLANT Refrigerator Coolant SEMI_SYNTHETIC_1 Semi Synthetic Oil SEMI_SYNTHETIC_2 Semi Synthetic Oil SUSPENSION_FLUID Suspension Fluid SYNTHETIC_1 Synthetic Oil SYNTHETIC_2 Synthetic Oil SYNTHETIC_3 Synthetic Oil SYNTHETIC_ANTI_POLLUTION_5W_30_ENG_OIL Synthetic Anti Pollution 5w-30 Eng Oil UREA Urea WASHER_LIQUID Washer Liquid
6	Parts Description	Text	30	During data export, the 'Part line type' field is used to determine the content for this specific column. If the type is identified as 'P' (indicating a part), the corresponding part name is included If the type is identified as 'F' (indicating a fluid), the corresponding fluid label is placed in the column. the code would be one among available Fluid Types Fluid Types Code Label 0W20_ENGINE_OIL 0w20 Engine Oil 0W30_ENGINE_OIL 0w30 Engine Oil ADDATIVE_POUCH Addative Pouch ADDITIVE_POUCH Additive Pouch AIR_CONDITIONING_COOLANT Air Conditioning Coolant ANTIFREEZE Anti Freeze AUTOMATIC_TRANSMISSION_FLUID Automatic Transmission Fluid AXLE_OIL Axle Oil BRAKE_FLUID Brake/Clutch Fluid COOLING_LIQUID Cooling Liquid DPF_FLUID D.p.f. Fluid AD_BLUE Diesel Exhaust Fluid/AdBlue GEARBOX_OIL_MINERAL Gearbox Oil - Mineral GEARBOX_OIL_SYNTHETIC Gearbox Oil - Synthetic HYDRAULIC_FLUID Hydraulic Fluid LONG_LIFE_OIL Long Life Oil MINERAL_OIL Mineral Oil OIL_1615099980 Oil-1615099980 OIL_9734S2 Oil-9734S2 OIL_9979A7 Oil-9979A7 OTHER Other PARTIULATE_FLUID Partiulate Fluid POWER_STEERING_FLUID Power Steering Fluid REFRIGERATOR_COOLANT Refrigerator Coolant SEMI_SYNTHETIC_1 Semi Synthetic Oil SEMI_SYNTHETIC_2 Semi Synthetic Oil SUSPENSION_FLUID Suspension Fluid SYNTHETIC_1 Synthetic Oil SYNTHETIC_2 Synthetic Oil SYNTHETIC_3 Synthetic Oil SYNTHETIC_ANTI_POLLUTION_5W_30_ENG_OIL Synthetic Anti Pollution 5w-30 Eng Oil UREA Urea WASHER_LIQUID Washer Liquid 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
7	Quantity	Number	2.2	e.g. 13.3 (for fluid) denotes 13 liters and 300 ml. 12 (for parts) denotes 12 items	Y
8	Unit Price	Number	5.2	The cost of one individual part The cost of one litre of the fluid. e.g. 99999.99	Y
9	Parts Discount Rate	Number	3.2	Percentage discount provided for the specific part or fluid e.g. 999.99	Y
10	Goodwill Percentage	Number	3.2	For fluids, the value will remain constant at 0.00 The default value for parts is 0.00, and the maximum allowed is 100.00. e.g. 999.99	N
11	Discounted Unit Price	Number	5.2	To determine the Discounted Unit Price, we first apply theunit discount percentage to the unit price. Then, we apply thegoodwill discount percentage to the discounted price to calculate the final discounted unit price. Unit Price (IP8): UP = 100 Unit Discount Percentage (IP9): UDP = 20% Discount Amount: DA = UP * (UDP/100) Discounted Amount = 100 × (20/100) = 20 Price Before Goodwill: PBG = UP - DA Price Before Goodwill = 100 - 20 = 80 Goodwill Discount Percentage(IP10): GDP = 5% Goodwill Amount: GA = PBG * (GDP/100) Goodwill Amount = 80 × (5/100) = 4 Final Net Price: FNP = PBG - GA Final Net Price = 80 - 4 = 76	Y
12	Nett Parts Price	Number	5.2	The net price is derived by calculating the total cost (unit price multiplied by quantity), then deducting the unit discount and the goodwill discount. Quantity (IP7): Q = 2 Unit Price (IP8): UP = 100 Total Unit Price: TUP = UP * Q Total Unit Price = 100 × 2 = 200 Unit Discount Percentage (IP9): UDP = 20% Discount Amount: DA = TUP * (UDP/100) Discounted Amount = 200 × (20/100) = 40 Price Before Goodwill: PBG = TUP - DA Price Before Goodwill = 200 - 40 = 160 Goodwill Discount Percentage(IP10): GDP = 5% Goodwill Amount: GA = PBG * (GDP/100) Goodwill Amount = 160 × (5/100) = 8 Final Net Price: FNP = PBG - GA Final Net Price = 160 - 8 = 152	Y
13	VAT Rate	Number	2.2	Mandatory with Invoice Note (e.g. 99.99)
14	Normal Part	Text	1	Will always be 'Y'	Y
15	Manufacturer of Part	Text	3	Blank This is mandatory if Normal Part is "N". However, ViSN currently does not export "N".
16	VAT Code	Text	1	Will be one of the VAT codes VAT codes S Standard E Exempt Z Zero Rated O Out of Scope	Y
17	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Total Line Cost Record - TL

• At least one record must exist in each record set
• More than one record can exist in each file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TL - Total Line Cost At least one record must exist in each record set for an invoice or credit More than one record can exist in each file as more than one record sets are allowed in one file	Text	2	Must be "TL"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Nett Labour Cost	Number	5.2	The values for this field differ based on the job line type and job description type (details provided below) MOT: Always 0 as no labor lines are generated for MOT job lines. TYRE: Always 0 since IL15 is 0. OTHER - Catalogue: Always 0 as no labor lines are generated for catalogue job lines. OTHER - Non Catalogue: Calculated by multiplying the time worked by the hourly rate and adjusting for the goodwill percentage for each labor line. (e.g., 99999.99)	Y
4	VAT Rate Labour	Number	2.2	Mandatory only with an invoice or credit note. If a labour line exists, this will be the VAT rate for the labour line. If no labour line exists, this will be the VAT rate for the job line. (e.g., 99.99)	Y
5	Total Nett Parts Cost	Number	5.2	The values for this field differ based on the job line type and job description type (details provided below) MOT: Will be constant 0 as no parts lines are generated for MOT job lines. TYRE: Will be constant 0 as no parts lines are generated for TYRE job lines. OTHER: For Catalogue descriptions not linked to FNP, this field will always have a value of 0. For Catalogue descriptions associated with FNP (e.g., OEM descriptions), the net price is treated as zero, resulting in a total net price of zero for these lines. Additionally, the menu price for the OEM description is added to this total. For Non-Catalogue descriptions, whether linked to FNP(MODULUS) or not , the export process calculates the total net parts cost by summing up the net price of each part line. (e.g., 99999.99)	Y
6	Total Nett Line Cost	Number	5.2	The total nett line cost is derived by adding the total net parts cost and the total net labour cost if the job line includes both parts and labour. Otherwise, it will reflect the job line's total value. (e.g., 99999.99)	Y
7	VAT Code	Text	1	Will be one of the VAT codes VAT codes S Standard E Exempt Z Zero Rated O Out of Scope	Y
8	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Total Transaction Cost Record - TC

• Required in every record set
• Limited to one record per transaction
• Multiple records can be included in an export file

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TC - Transaction Cost (total) Record A required record for every record set. Multiple records can exist in a single file as multiple record sets are permitted within one file.	Text	2	Must be "TC"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	Total Nett Labour Cost	Number	5.2	The value for this field is determined by the job line type and job description type. Refer IL16 to check the same. It is calculated by summing up the net labor costs (TL3) of all job lines in the jobsheet. The net labor cost is determined by considering the labor rate, labor hours, and applying goodwill discount. (e.g., 99999.99)	Y
4	Total Nett Parts Cost	Number	5.2	The values for this field differ based on the job line type and job description type. Refer IP12 to check the same It is calculated by summing up the net parts costs (TL5) of all job lines in the jobsheet. The net parts cost is determined by considering the parts price, quantity, and applying any unit and goodwill discounts. (e.g., 99999.99)	Y
5	Total Nett Transaction Cost	Number	5.2	This value is calculated by adding up the Total Nett Line Cost (TL6) of all lines in the jobsheet. 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
6	VAT Amount	Number	5.2	This value is calculated by adding up the vat amount of all lines in the jobsheet. (e.g., 99999.99)
7	Total Gross Labour Cost	Number	5.2	Mandatory with an invoice or credit note The final value is calculated by factoring in the total net labor cost and applying the VAT rate (e.g., 99999.99)
8	Total Gross Parts Cost	Number	5.2	Mandatory with an invoice or credit note The final value is calculated by factoring in the total net parts cost and applying the VAT rate (e.g., 99999.99)
9	Total Gross Transaction Cost	Number	5.2	Mandatory with an invoice or credit note The final value is calculated by factoring in the total net jobline cost (TL6) and applying the VAT rate (e.g., 99999.99)	Y
10	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

VAT Summary Record - VA

All the joblines in the jobsheet are grouped by the vat code.

• One record per VAT code in each Transaction
• More than one record can exist in a file
• More than one record can exist in a Transaction

Sr.No	Field Label	Data Type	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. VA - VAT summary Record	Text	2	Must be "VA"	Y
2	Record Type Version Number	Integer	2	Must be "6"	Y
3	VAT Rate	Number	2.2	Indicates the VAT rate associated with the specified VAT code. (e.g., 99.99)	Y
4	VAT Applicable Amount	Number	5.2	Represents the total cost of all joblines where the specified VAT code is applied. (e.g., 99999.99)	Y
5	VAT Amount	Number	5.2	Represents the total VAT amount for all joblines associated with the specified VAT code. (e.g., 99999.99)	Y
6	VAT Code	Text	1	Will be one of the VAT codes VAT codes S Standard E Exempt Z Zero Rated O Out of Scope	Y
7	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Transaction Trailer Record - TT

• One record must exist for each Transaction
• More than one record can exist in an export file

Sr.No	Field Label	Format	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TT - Transaction trailer Record	Text	2	Must be "TT"	Y
2	Record Version Number	Integer	2	Must be "6"	Y
3	Number of Records	Integer	5	Total number of records between Transaction Header and Transaction Trailer inclusive (excludes authorisation details)	Y
4	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

File Trailer Record - FT

• This record is mandatory
• This line does not belong to a record set, instead common for the whole file

Sr.No	Field Label	Format	Length	Notes	Mandatory
1	Record Type Indicator Record Type Indicator This serves as a unique identifier for the record, used to determine the type of record within the specified invoice or credit block. TC - File Trailer Record	Text	2	Must be "FT"	Y
2	Record Version Number	Integer	2	Must be "6"	Y
3	Number of Records	Integer	5	Total number of transactions	Y
4	End of Record Marker	Control	1	Carriage Return Code (ASCII 10)	Y

Status: Accepted
Category: Protected
Authored By: Rama on Sep 01, 2023

Revisions
03 Jun, 2024 - Resolved Documentation Discrepancy, VN-12905
23 Apr, 2024 - Update Post paybill Integration, VN-11017
09 Feb, 2024 - Update Post FNP Integration, VN-11235
11 Jan, 2024 - Change content in daily invoice export, VN-10934
20 Nov, 2023 - changes with respect to code
22 Sep, 2023 - Add Daily Invoice Export Documentation, VN-9668
26 Sep, 2024 - Update LC line dependency on addLCLineForInvoice flag, VN-14508
26 Nov, 2024 - Update External Code field notes in IL line, VN-15156
06 Dec, 2024 - Update Setup Required section and add a helpful image.
02 Apr, 2025 - Update the documentation to have separate doc for invoice and credit blocks.
07 May, 2025 - Update the calculations along with the diagrams representing how they are calculated.
09 May, 2025 - Revise Lease Company name column based on Paybill value and Direct Paybill name setting, VN-18231