Field

Data Type

Max Length

Format

Example

1

Client Order No

Integer

-

General Number

12345

2

Section/division

Text

150

Text

Asphalt

3

Supply Date

Date/Time

-

General Date.

MUST BE

DD/MM/YY

01/12/06

4

Details of work Site

Text

300

Text. MUST NOT include any

commas or separators

TERRICK ST

GEEBUNG

5

Work Order

Number

Text

10

Text

QJ018635

6

Docket Number/s

Text

50

Text (multiples separated by / )

422891

7

No. of

controllers

Integer

-

General Number

2

8

No. of vehicles

Integer

-

General Number

1

9

Time

Commenced

Date/Time

-

Medium Time

12 HR Clock

7:00 AM

10

Time

Finished

Date/Time

-

Medium Time

12 HR Clock

5:00 PM

11

Lunch Break

(minutes)

Integer

-

General Number

30

12

Total Hours

Integer

-

General Number

8.5

13

Hourly Rate

Integer

-

General Number

30.5

14

Controllers

Charge

Currency $

-

Currency. 2

decimal places

$185.60

15

Meal Break allowance charge

Currency $

-

Currency. 2

decimal places

$10.00

16

Vehicle / Signage Charge

Currency $

-

Currency. 2

decimal places

$120.00

17

Overnight

Signage/ plans or Other

Currency $

-

Currency. 2

decimal places

$50.75

18

Total Exc GST

Currency $

-

Currency. 2

decimal places

$234.50

19

GST

Currency $

-

Currency. 2

decimal places

$19.98

20

TOTAL

Currency $

-

Currency. 2

decimal places

$330.00

21

Supplier Invoice#

Text

10

Text

9203145