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