Vehicle_Image | image | — | |
Work_drive_ID | text | — | |
Make | picklist | — | Values: APRLIA / AUDI / BENELLI / BMW / CFM / CHRYSLER / DUCATI / FORD / FERRARI / HARLEY / HOLDEN / HONDA / HUSQV / HYUNDAI / ISUZU / IVECO / JAGUAR / KAWASAKI / KIA / KTM / KYMCO / LAND ROVER / LAMBORGHINI / LDV / LEXUS / MAZDA / MASERATI / MERCEDES-BENZ / MG / MINI / MITSUBISHI / NISSAN / PEUGEOT / PIAGGIO / PORSCHE / RENAULT / ROYAL ENFIELD / SKODA / SUBARU / SUZUKI / SYM / TESLA / TOYOTA / VOLKSWAGEN / VOLVO / YAMAHA; allows custom "other" value; private field |
Model | picklist | — | Values: Falcon / C200 / GLC200 / 308 / 125CC / 200 DUKE / 3 SERIES / 300C / 320I / 330i / 4 SERIES / A1 / A250 / A3 / A4 / ACCENT / ACCO / ACCORD / ALTO / AMAROK / ARTEON / ASX / AURION / B180 / BALENO / BARINA / BN 302 / C63 / CAMRY / CANTO / CARNIVAL / CB250 CB / CB300F / CBR / CBR603A / CERATO / CITY / CIVIC / CL63 / CLAS09A / CLASSIC 125 / CLASSIC 150 / CLIO / COLT / COMMODORE / COOPER / COROLLA / COUNTRYMAN / CRUZE / CR-V / CT200H / CX3 / CX5 / CX9 / DIO / DUALIS / DYNA LOW RIDER / E CLASS / E280 / ELANTRA / EX250 / EX300A / EXPRESS / EZ06A / FORTUNER / F-PACE / FREELANDER 2 / FXDS12 / G10 / GLA250 / GLA45 / GLB250 / GLC250 / GLC43 / GLC63A / GLE450 / GLH112 / GLH125SH / GOLF / GOLF GTI / GS500 / HIACE / HILUX / HILUX 4 / HR-V / i30 / i45 / iLOAD / IMAX / IMIEV / IMPREZA / IS250 / IS350 / IX35 / JAZZ / JETTA / JUKE / KLUGER / LANCER / LANDCRUISER 300 SERIES / LBD80 / LEGEND / LIBERTY / M-AMG A / M-AMG C / MASTER / MAZDA2 / MAZDA3 / MG3 / MICRA / MIRAGE / Model 3 / MTN315 / NAVARA / NMAX 155 ABS / NSC110 / NSC114 / OCTAVIA / ORBIT 125 / OUTBACK / OUTLANDER / Panigale / PASSAT / PCX150 / PILE18 / PRIUS C / PSI M77 / PULSAR / Q5 / RANGE ROVER / RANGER / RAV4 / RIO / ROOMSTE / RX330 / RX450H / S3 / S350 / SANTA FE / SELTOS / SORENTO / SPORTAGE / SPRINT / SPRINTER / STONIC / SV6320 / SWIFT / T60 / TAYCAN / TIIDA / TOUAREG / TRANSPORTER / TRIBECA / TRITON / TRUCK / TUCSON / UMIB15 / VBA / VELOSTER / VTR / VTR250 / VULCAN / X1 / X3 / X5 / XC60 / XTRAIL / XV250 / YARIS / YARIS CROSS / YZF / YZF-15 / ZS; allows custom "other" value; private field |
Model_and_Build_Date | text | — | |
Build_Date1 | text | — | |
Compliance_Date1 | text | — | |
Auto_Grab | checkbox | — | Default: false |
HVIS | picklist | — | Values: Yes / No |
HVIS_Reminder_Sent | checkbox | — | Default: false |
Make_and_Body | text | — | |
Grounded_Reason_Box_Report | textarea | — | |
Repair_Shop | text | — | |
Damaged_Date12 (displayname "Fleet - Sent to Repair Date") | date | — | |
Return_Date (displayname "Fleet - Repair Completed Date") | date | — | |
Repair_ETA (displayname "Fleet - Repair ETA Date") | date | — | |
Vehicle_Sub_location | picklist | Location_Sub_Location_V1 (filtered) | |
Other_Location | text | — | |
Rental_Vehicle_Location | text | — | |
Staff_Use_Vehicles | picklist | Staff_Use_Vehicles (↔ Add_Car) | Private field |
IMO_Car_Detailers (displayname "IMO (Car Detailers)") | picklist | Detailing_Report | Private field |
Number | number | — | |
Imageinput_Barcode_image (displayname "QR Code") | image | — | Private field |
QR_Code | qrcode | — | Value: ${Work_drive_ID} |
Days_since_last_rental | formula | — | Formula: TODAY − Last_Rental_Date; hidden field |
Update_Vehicle_Details | picklist | — | Values: Yes / No; private field |
Xero_Status | picklist | — | Values: Trading Stock / Sold / Fixed Assets |
Update_Parts | picklist | — | Values: Yes / No |
Fleet_Parts2 (displayname "Fleet Parts") | subform (columns: Part_Type, Part_Number) | — | Part_Type values: Oil Filter / Air Filter / Fuel Filter / Cabin Filter / Front Pads / Front Rotors / Rear Pads / Rear Rotors |
Rate_Plan | picklist | Rate_Plan | Private field |
Daily_Rate_Ex_GST (must have) | AUD (currency) | — | |
Vehicle_Class (must have) | picklist | — | Values: Standard / Premium |
Excess_Reduction | AUD (currency) | — | |
Update_Rates | picklist | — | Values: Yes / No; private field |
Rental_Daily_Rate_Ex_GST | AUD (currency) | — | |
Fees | AUD (currency) | — | |
Excess_Reduction1 | AUD (currency) | — | |
Rental_Start_Date | date | — | |
Rental_Return_Date | date | — | |
Total_Amount | AUD (currency) | — | |
Accessories1 (displayname "Accessories") | list | — | Values: Tow Bar / Roof Rack / Reverse Camera |
Spare_Key | picklist | — | Values: Yes / No |
Log_Book | picklist | — | Values: Yes / No |
Update_Accessories | picklist | — | Values: Yes / No; private field |
Available_Finance | checkbox | — | Default: false |
Finance_Type | picklist | — | Values: Chattel Mortgage / Finance Lease / Operating Lease / Purchased Outright / Pending Finance / Cross Hire / Finance Paid Out |
Finance_Company1 (displayname "Finance Company") | picklist | Financier | Allows adding new entries |
Broker | picklist | Broker | Allows adding new entries |
Finance_Company | picklist | — | Values: Australian Motorcycle and Marine Finance Pty. Ltd. / Bank of QLD / BMW AUSTRALIA FINANCE LIMITED / CAPITAL FINANCE AUSTRALIA LIMITED / CGEC HOLDING PTY LTD / CREDIT CORP SERVICES PTY LIMITED / DREAM CAR AUSTRALIA PTY LTD / EURO ST CAR HIRE / FIRSTMAC ASSET FUNDING PTY LIMITED / FLEET PARTNERS / FLEXICOMMERCIAL PTY LTD / FULL OWNERSHIP / LATITUDE AUTOMOTIVE FINANCIAL SERVICES / MACQUARIE LEASING PTY LTD / MERCEDES-BENZ FINANCIAL SERVICES AUSTRALIA PTY LTD / METRO FINANCE PTY LIMITED / MONEYME FINANCIAL GROUP PTY LTD / NATIONAL AUSTRALIA BANK LIMITED / NISSAN FINANCIAL SERVICES AUSTRALIA PTY LTD / ORIX / DE LAGE LANDEN PTY LIMITED / PEPPER ASSET FINANCE PTY LTD / QUEST FINANCE AUSTRALIA PTY LTD / SECURE FUNDING PTY LTD / TOYOTA FINANCE AUSTRALIA LTD / WESTPAC BANKING CORPORATION / SHIFT FINANCIAL / AUTOMOTIVE FINANCIAL SERVICES / RESIMAC ASSET FINANCE PTY LTD; allows custom "other" value; private field |
Application_No | text | — | |
Contract_Number | text | — | |
Contract_Start_Date | date | — | |
Contract_End_Date | date | — | |
Per_Vehicle_Finance_Amount | AUD (currency) | — | |
Contract_Term_Months | formula | — | Formula: rounded months between Contract_Start_Date and Contract_End_Date |
Start_KM_s | number | — | |
Months_Run | formula | — | Formula: rounded months since Contract_Start_Date |
Months_to_Run | formula | — | Formula: rounded months until Contract_End_Date |
Dealer | picklist | — | Values: ACKO'S INTERIOR LINNING PTY LTD / BMW Sydney / Heartland / Hunter / Peninsula Motor Group / Penrith City / Phil Gilbert / Ryde Kia / Sci-Fleet / TQY / Von Bibra Auto Group / Northshore Mitsubishi / Car Connect; allows custom "other" value; private field |
GST_Per_Invoice | AUD (currency) | — | |
LCT | AUD (currency) | — | |
Residual_Value_Inc_GST | AUD (currency) | — | |
Monthly_Payment_Inc_GST | AUD (currency) | — | |
Loan_Establishment_Fee_Loan_Processing_Fee | AUD (currency) | — | |
Multiple_Vehicles_of_Total | percentage | — | |
Per_Vehicle_Monthly_Direct_Debit | AUD (currency) | — | |
Per_Vehicle_Residual | AUD (currency) | — | |
Per_Vehicle_Establishment_Fee | AUD (currency) | — | |
Monthly_Processing_Cost | AUD (currency) | — | |
Total_Amount_Loaned | AUD (currency) | — | |
Interest_Rate | percentage | — | |
Date_of_1st_Payment | date | — | |
Total_Amount_Payable | AUD (currency) | — | |
Amount_Owing | AUD (currency) | — | |
Final_Payout_Amount | AUD (currency) | — | |
Final_Payout_Due_Date | date | — | |
Total_Monthly_Installments | formula | — | Formula: months × Monthly_Payment_Inc_GST |
Total_Monthly_Repayments_Interest | formula | — | Formula: (months × Monthly_Payment_Inc_GST) + Residual_Value_Inc_GST; hidden field |
Total_Payments_Interest | AUD (currency) | — | |
Total_Number_of_Monthly_Installments_including_balloon_payment | number | — | |
Total_Paid_to_Date | formula | — | Formula: (Per_Vehicle_Monthly_Direct_Debit + Monthly_Processing_Cost) × months run |
Total_Interest_Cost | formula | — | Formula: (months × Monthly_Payment_Inc_GST) + Residual_Value_Inc_GST − On_Road_Costs |
Total_Interest_Processing_Cost | AUD (currency) | — | |
Current_Payout_Figure | AUD (currency) | — | |
Monthly_Direct_Debit | AUD (currency) | — | |
Date_Added_to_Fleet | date | — | |
Date_Removed_from_Fleet | date | — | |
party_Financier (displayname "3rd Party Financier") | text | — | |
Linked_Vehicles | list | Add_Car (self-referencing) | |
Update_Lease_Details | picklist | — | Values: Yes / No; private field |
Financier_Document1 (displayname "Lease Schedule") | image | — | |
Dealer_Invoice1 | image | — | |
PPSR | image | — | |
CC_PPSR_Certificate | upload file | — | |
CC_PPSR_Registration_Number | text | — | |
CC_PPSR_Registered_by | picklist | test_claims_management_portal.User | |
CC_PPSR_Date_Obtained | date | — | |
CC_PPSR_Date_Discharged | date | — | |
Payout_Letter | image | — | |
Roadside_Assistance | image | — | |
Amortisation_Schedule | image | — | |
Cross_Hire_Invoice_Document | image | — | |
Update_Documents | picklist | — | Values: Yes / No; private field |
Rego_CTP_Renewals | subform (columns: Currency, Payment_Type, Document, Date_field, Notes) | — | Payment_Type values: Rego / CTP / Comprehensive Insurance; allows custom "other" value |
GST_Claimed | picklist | — | Values: FY19-Q4 / FY20-Q1 / FY20-Q2 / FY20-Q3 / FY20-Q4 / FY21-Q1 / FY21-Q2 / FY21-Q3 / FY21-Q4 / FY22-Q1 / FY22-Q2 / FY22-Q3 / FY22-Q4 / FY23-Q1 / FY23-Q2 / FY23-Q3 / FY23-Q4 / FY24-Q1 / FY24-Q2 / FY24-Q3 / FY24-Q4 / FY25-Q1 / FY25-Q2 |
GST_Amount_Claimed | AUD (currency) | — | |
Update_BAS | picklist | — | Values: Yes / No; private field |
Vehicle_Maintenance_ID | picklist | Vehicle_Maintenance (↔ Add_Car) | Private field |
Last_Service_KM_s | number | — | |
Services_Carried_Out_KM_s | number | — | |
Service_Due_Date | date | — | |
Days_Until_Service_Due | formula | — | Formula: days between today and Service_Due_Date |
Service_Due_KM_s | number | — | |
KM_s_Until_Next_Service | formula | — | Formula: Service_Due_KM_s − Current_KM_s |
Registration_Due_Date | date | — | |
Days_Until_Registration_Due | formula | — | Formula: days between today and Registration_Due_Date |
Pink_Slip_Required | picklist | — | Values: Yes / No |
QR_Code_Sticker_Added | picklist | — | Values: Yes / No; default: No |
Update_Maintenance_Details | picklist | — | Values: Yes / No; private field |
Page_View | picklist | — | Values: d / m; private field |
Refresh_Screen | picklist | — | Values: Yes / No; private field |
Acquisition_Type | picklist | — | Values: Claim / Purchase |
Dealer1 (displayname "Dealer") | picklist | Dealers | Allows adding new entries |
Vehicle_Invoice_Number | text | — | |
Vehicle_Invoice_Date | date | — | |
On_Road_Costs (displayname "Dealer Invoice Value") | AUD (currency) | — | |
Claim_Value | AUD (currency) | — | |
party_Encumbered (displayname "3rd Party Encumbered") | picklist | — | Values: Yes / No |
rd_Party_Financier (displayname "3rd Party Financier") | picklist | rd_Party_Financier | Allows adding new entries |
party_Finance_Owing (displayname "3rd Party Finance Owing") | text | — | |
Payout_Date | date | — | |
Date_paid_out | date | — | |
Registered_To | picklist | — | Values: BYZANTINE INVESTMENTS / FLEET PARTNERS / NO REGO PAPERS / TQY / CLIENT (SELLER) / PENDING DELIVERY |
Registration_Type1 | text | — | |
Disposal_type | picklist | — | Values: Sale / Write Off |
Disposal_KMs | number | — | |
Disposal_Form_Type | text | — | |
Purchasers_Details | textarea | — | |
Disposal_Date | date | — | |
Sale_Price | INR (currency) | — | |
By_Who | picklist | Users (built-in) | Personal data field |
Update_disposal_details | picklist | — | Values: Yes / No; private field |
Reserved_On | datetime | — | |
Reservered_By_Email | email | — | Personal data field |
Reserved_By | picklist | test_claims_management_portal.User | |
Fleet_Notes | textarea | — | |
Retail_Value | AUD (currency) | — | |
Trade_In_Value | AUD (currency) | — | |
Date_of_Valuation | date | — | |
Vehicle_Registration_State | text | — | |
Auto_Grab_API_Log | picklist | test_claims_management_portal.Auto_Grab_API_Log | |
Vehicle_Color | text | — | |
Repair_Shop1 (displayname "Repair Shop") | picklist | test_claims_management_portal.Repairers | |
Cleaning_Service | picklist | Cleaning_Service | |
Crash_Claim_HQ | picklist | Crash_Claim_HQ | |
Customer_Vehicle_Locations | picklist | Customer_Vehicle_Locations | |
Internal_Mechanical_locations | picklist | Internal_Mechanical_locations | |
Decal_Locations | picklist | Location_Sub_locations (filtered) | Filtered lookup: Locations.Place_Name == "Decal" |
Tyres_Location | picklist | Location_Sub_locations (filtered) | Filtered lookup: Locations.Place_Name == "Tyres" |
On_Hire_Date | date | — | |
Free_Hire_Off_Date_and_Time | datetime | — | |
Migrate_Vehicle_Location | checkbox | — | Default: false |
QR_Code_Rec_id (displayname "QR Code") | qrcode | — | Value links to Quick Actions Page by fleet ID |
Vehicle_Location | picklist | Rental_Vehicle_Location | Allows adding new entries |
On_Hire_Days | formula | — | Formula: days between On_Hire_Since_Date_and_Time and Free_Hire_Off_Date_and_Time; hidden field |
On_Hire_Since_Date_and_Time | datetime | — | |
Free_Hire_Record | picklist | Free_Hire | |
Vehicle_Purchase | picklist | Vehicle_Purchase | |
Fleet_Movement_Status | picklist | — | Values: Awaiting Pick-Up / Vehicle Picked-Up / Vehicle Dropped-Off |
Customer_Vehicle_Status | picklist | — | Values: Pending Collection From Client / On Site - Crash Claim / On Site - Repairer / Returned To Client / Tow Yard / At Cleaning Service |
Latest_Vehicle_Movement_Id | picklist | Vehicle_Movement | |
Start_Rental_Kms | number | — | |
End_Rental_KM_s | number | — | |
Latest_Vehicle_Pickup_Id | picklist | Fleet_Vehicle_Pick_Up | |
Free_Hire_Accident_app | picklist | test_claims_management_portal.Free_Hire | |
Advice_on_what_was_done_during_the_service | textarea | — | |
Mechanical_Wheel_Issue | checkbox | — | Default: false |
Issue_Raised_Date_and_Time | datetime | — | |
Issue_Notes | textarea | — | |
Issue_Raised_By | picklist | test_claims_management_portal.User | |
Mechanical_Issue_Status | picklist | — | Values: Issue Raised / Issue Resolved |
Issue_Resolved_Date_and_Time | datetime | — | |
Issue_Resolved_By | picklist | test_claims_management_portal.User | |
Upate_Action | picklist | — | Values: Fixed on the spot / Order parts |
What_did_you_do_to_fix_it | textarea | — | |
What_parts_are_needed | textarea | — | |
Latest_Cliq_Message_ID_Internal_Movement | text | — | |
Stocktake_Status | picklist | — | Values: Yes / No; default: No |
Is_Migrated | checkbox | — | Default: false |
Electrical | checkbox | — | Default: false |
Electrical_Sub_Options | list | — | Values: Wing Mirrors / Windows / Sensors / Cameras |
Electrical_Issue_Status | picklist | — | Values: Requested / Completed |
Wheel_Repairs | checkbox | — | Default: false |
Wheel_Alignment_Status | picklist | — | Values: Requested / Completed |
Wheel_Alignment | checkbox | — | Default: false |
Wheel_Repair_Status | picklist | — | Values: Requested / Completed; allows custom "other" value |
Glass_Repairs | checkbox | — | Default: false |
Glass_Repairs_Options | picklist | — | Values: Urgent / None Urgent |
Glass_Repair_Status | picklist | — | Values: Requested / Completed |
In_For_Service_Date | date | — | |
Vehicle_Checklist | picklist | Fleet_Checklist | |
Service_Due_Sticker | picklist | — | Values: Yes / No |
Crash_Claim_Sticker | picklist | — | Values: Yes / No |
No_Smoking_Sticker | picklist | — | Values: Yes / No |
Floor_Mats | picklist | — | Values: Yes / No |
Key | picklist | — | Values: Yes / No |
Key_Battery | picklist | — | Values: Yes / No |
Toll_Tag_Holder | picklist | — | Values: Yes / No |
Cleaned | picklist | — | Values: Yes / No |
Tyre_Condition | picklist | — | Values: Good / Bad |
Which_Tyre | list | — | Values: Front D/S / Front P/S / Rear D/S / Rear P/S |
Spare_Tyre | picklist | — | Values: Yes / No |
Mechanical_Issues | picklist | — | Values: Yes / No |
Mechanical_Issue_Notes | textarea | — | |
Existing_Damage | picklist | — | Values: Yes / No |
Damage_Photo_1 | image | — | |
Image1 | image | — | |
Damage_Photo_2 | image | — | |
Damage_Photo_3 | image | — | |
Damage_Photo_4 | image | — | |
Vehicle_checklist_Notes (displayname "Notes") | textarea | — | |
Latest_Loan_Car_Accident_File_Number | picklist | test_claims_management_portal.Claim_Form | |
Cleaning_Service_Name | picklist | Cleaning_Service | |
Cleaning_Service_Status | picklist | — | Values: In Service / Service Completed / Service Not Completed |
Date_Sent_to_cleaning_service | datetime | — | |
Service_Completed_Date_and_Time | datetime | — | |
Reason_For_Not_Completed | textarea | — | |
Repair_Completed_Date | date | — | |
How_Acquired | text | — | Default: "P" |
Type_and_Serial_Number_of_Disposal_form | text | — | Default: "Form 5 1913" |
Entry_Number | number | — | |