/
Radia Generic Export File Formats

Radia Generic Export File Formats

Owned by Alom Hussain (Unlicensed)
Last updated: Jul 25, 2022 by Matt Sullivan (Unlicensed)
3 min read

The Radia generic export file is as follows:

Column

Underlying Datatype

Max Length

Comments

Always Present

DiscountID

Integer

38

Surrogate PK for this discount

Y

Code

String

32

Code of the campaign this discount belongs to

N

Description

String

255

Description of the campaign this discount belongs to

N

Campaign Source

String

30

Manufacturer or Dealer

Y

Campaign Type

String

30

Type of the campaign this discount belongs to - can be configured by the Radia administrator

Y

Status

String

30

Status of the campaign this discount belongs to - can be configured by the Radia administrator

Y

Valid From

Date

8

YYYYMMDD

Y

Valid To

Date

8

YYYYMMDD

Y

Asset Type

String

3

CAR or LCV

Y

CAP ID

Integer

38

5/6 digit CAP ID

Y

CAP Code

String

20

Do not trim

N

Manufacturer

String

25

CAP Manufacturer Name

Y

CAP Manufacturer Code

String

2

CAP Manufacturer Code

Y

Model

String

50

CAP Model Name

Y

Derivative

String

50

CAP Derivative Name

N

Trim

String

50

CAP Trim Name

N

Model Year

String

50

Model Year Reference. Note that some derivatives do not have model years.

N

Amount

Number

12

0 to 999999999.99

Y

Quote Amount

Number

12

0 to 999999999.99

Y

Option Amount

Number

12

0 to 999999999.99

Y

Free Metallic Paint

String

1

Y or N

Y

Brand

String

100

Name of the brand

Y

Brand Reference

String

30

 

N

Relationship

String

255

The name of the end customer

N

Relationship Ref

String

50

End customer reference

N

Percentage

Number

5

0 to 99.99

Y

Quote Percentage

Number

5

0 to 99.99

Y

Discount Point

String

50

Off Invoice or Retrospective

Y

Include Options

String

1

Y or N

Y

Option Code

Integer

38

CAP Option Code

N

Option Category Code

Integer

38

CAP Option Category Code

N

Option Category

String

50

CAP Option Category Description

N

Option Description

String

255

CAP Option Description

N

Discount Type

String

30

Vehicle or FOC Paint or Option

Y

Default Radia exports also contain a discounts pivot file. This file combines the manufacturer and dealer discounts (if applicable) for leaseco terms only into a single line. Use of this file is entirely optional.

The Radia pivot export file is as follows:

Column

Underlying Datatype

Max Length

Comments

Always Present

Asset Type

String

3

CAR or LCV

Y

CAP ID

Integer

38

5/6 digit CAP ID

Y

CAP Code

String

20

Do not trim

N

Manufacturer

String

25

CAP Manufacturer Name

Y

CAP Manufacturer Code

String

2

CAP Manufacturer Code

Y

Model

String

50

CAP Model Name

Y

Derivative

String

50

CAP Derivative Name

N

Brand

String

100

Name of the brand

N

Model Year

String

50

Model Year Reference. Note that some derivatives do not have model years.

N

Man Amount

Number

12

0 to 999999999.99

Y

Man Perc

Number

5

0 to 99.99

Y

Man Option Perc

Number

5

0 to 99.99

Y

Man FM

String

1

Free Metallic Y or N

Y

Man Campaign

String

100

Name of the campaign that the manufacturer element of this discount comes from

Y

Man Status

String

30

Status of the campaign that the manufacturer element of this discount comes from

N

Dlr Amount

Number

12

0 to 999999999.99

N

Dlr Perc

String

5

0 to 99.99

N

Dlr Option Perc

String

5

0 to 99.99

N

Dlr FM

String

1

Free Metallic Y or N

N

Dlr Campaign

String

100

Name of the campaign that the dealer element of this discount comes from

N

Dlr Status

String

30

Status of the campaign that the dealer element of this discount comes from

N

Note: if you are consuming these files directly, please ensure that your program is built to gracefully ignore any additional columns added to either file.

 

Related content