Unclassified specification



Download 1.27 Mb.
Page2/7
Date05.05.2018
Size1.27 Mb.
#47899
1   2   3   4   5   6   7

File structure example

Supplier data record




Entity data record

Petroleum project 1 data record

Petroleum project 2 data record (maximum 999)

Production licence data record (maximum 999)

Deductible expenditure incurred data record

Calculation data record

Declaration data record

Transfer interest 1 data record

Transfer interest 2 data record

Transfer interest 3 data record

Transfer expenditure 1 data record

Transfer expenditure 2 data record

Repeat the above structure from Entity information data record for other Instalment statements / returns being reported on the same file.




File total data record




If lodging multiple instalment statements or returns for the same project they must appear in the file in chronological order.


File structure diagram




The Petroleum project 2 data record (s) and the Production licence data record (s) can be repeated to a maximum 999 times per lodgement period. If an entity needs to report more than 999 of either of these records for the same period contact the ATO on 132866 between 8.00am and 6.00pm Monday to Friday.

5 Record specifications

File Name

To assist with the easy identification of PRRT report files, it is recommended that the file name should be PRRTR or of the form PRRTR.Cnn, where there is more than one file to send. For example if there are two files to send they would be called PRRTR.C01 and PRRTR.C02.


CR, LF and EOF markers

The ATO prefers data to be supplied without carriage– return (CR), linefeed (LF) or end– of– file (EOF) markers. However, if these characters cannot be removed, the following rules apply:


EOF (if supplied)

(a) one and only one EOF character is to be supplied and must be the last character of the file.

(b) if CR/LF characters are used, one EOF character may also be supplied as the last character of the file. In this case, the last three characters of the file will be CR/LF/EOF (in that order).
CR/LF (if supplied)

(c) if CR/LF characters are supplied, they must always occur together as a coupled pair and be on the end of each record, or

(d) the CR/LF coupled pair of characters may occur on the last record as the last two characters only. In this case, all preceding records must not have CR/LF characters. A special case can occur if only one coupled pair CR/LF is used in conjunction with an EOF character where the last three characters will be CR/LF/EOF (see (b) above).
CR/LF and EOF characters are not part of the data supplied and, if used, must be additional characters to the record length.
Record length (character position 1– 4) in all records must be set to 0996.
A simple check can be used to ensure that the record length of a fixed length file is correct. The length of the file supplied to the ATO must be a multiple of the fixed record length.
For example, for files that do not contain CR/LF at the end of each record:
PRRTR file record length is 996 characters

Length of the file = 11952

11952/996 = 12 and 0 remainder

Therefore the file is OK


If length of the file PRRTR = 11954

11954/996 = 12 and 2 remainder

Therefore, there is an error in the file
For example, for files that contain CR/LF at the end of each record. This is only a check of the file length and the 996 characters must only be used for division. All record lengths in the data must be 996.
file record length is 996 characters (record 996 + CR/LF 2)

Length of the file =11976

11976/998 = 12 and 0 remainder

Therefore the file is OK


If length of the file = 11974

11974/998 = 11 and 998 remainder

Therefore, there is an error in the file
If an error in the division occurs, the file must be corrected before it is sent to the ATO.
Examples of errors that may occur:


  • One or more of the records is longer or shorter than the fixed length of 996 characters

  • There are characters at the end of the file that need to be removed. For example:

    • an extra end– of– file marker

    • an additional CR/LF (if providing CR/LF there should only be one CR/LF at the end of the file) (see above), or

    • binary zeros.

Description of terms used in data record specifications

The following tables show data records and their elements. The tables contain the following standard columns:


Character position – the start and end position of the field in the record.
Field length – the length of the data item in bytes.
Field format – the format type of the field.
A is alphabetic (A-Z) – one byte per character. This field must be in upper case and left justified. Characters not used must be blank filled.
For example, SMITH in a ten character field would be reported as SMITHbbbbb (the character b is used to indicate blanks).
AN is alphanumeric – both upper and lower case alphabetic characters are acceptable in non– specific fields only, for example, name and address fields – one byte per character. Alphanumeric fields must be left justified and characters not used must be blank filled.

For example, 10 FIRST STREET in a 20 character alphanumeric field would be reported as 10bFIRSTbSTREETbbbbb (the character b is used to indicate blanks).


In addition, unless stated elsewhere in this specification, all other standard keyboard characters are accepted in alphanumeric fields.

DT is a date in DDMMCCYY format. If the day or month components are less than 10, insert a leading zero.

For example:



      • 26 March 2013 would be reported as 26032013

      • 9 November 2012 would be reported as 09112012

If the date is mandatory it must be a valid date, otherwise see date under the optional field type on the next page.


NS is numeric special (0 – 9 and blank) – one byte per character. Numeric special fields must be right justified and characters not used must be blank filled.
All amount fields are to be reported as dollar fields and must not contain decimal points, commas or other non– numeric characters (for example $+– ). The amount must be reported in whole dollars. If an amount includes cents, the cents must be truncated (or disregarded).
For example, in a 13 character numeric (amount) field:

      • $1234.99 would be reported as bbbbbbbbb1234 (the character b is used to indicate blanks).

No entry in this field would be reported as blanks
N is numeric (0– 9) – one byte per digit. Numeric fields must be right justified and zero filled.
For example, 123456789 in an 11 digit field would be reported as 00123456789.

All amount fields are to be reported as dollar fields and must not contain decimal points, commas or other non– numeric characters (for example $+– ). The amount must be reported in whole dollars. If an amount includes cents, the cents must be truncated (or disregarded).


For example, in an 11 character numeric (amount) field:

      • $1234.99 would be reported as 00000001234

      • $122.16 would be reported as 00000000122

      • $567.00 would be reported as 00000000567, and

      • $00.00 would be reported as 00000000000.


Field type – codes used are:
M Mandatory field that must be provided. For single character mandatory fields, a blank (space) is NOT a valid value.

ALPHA: field must not start with a blank or be blank filled

ALPHANUMERIC: field must not start with a blank or be blank filled

NUMERIC: field must not start with a blank and may be zero filled

DATE: field must not be zero filled.
O Optional field that must be made available by the software developer for the entity to complete. Entities must complete the field if the data is available.

ALPHA: if not present, field must be blank filled

ALPHANUMERIC: if not present, field must be blank filled

NUMERIC: if not present, field must be zero filled

DATE: if not present, field must be zero filled.

C Conditional field that must be made available by the software developer for the entity to complete. Entities must complete the field as specified.
S For use by the ATO. It must be blank filled and must not contain binary zeros.
Field name – a brief description of the field.
Reference number – the definition reference number. These definitions can be found in Field definitions and edit rules (page 28).

Supplier data record



Character position

Field length

Field format

Field type

Field name

Reference

number

1– 4

4

N

M

Record length (=0996)

6.1

5-17

13

AN

M

Record identifier (=IDENTREGISTER)

6.2

18-27

10

AN

M

Report specification version number (=PRRTAV01.0)

6.3

28-38

11

N

M

Supplier Australian business number (ABN)

6.4

39-39

1

A

M

Run type (=T or P)

6.5

40-47

8

DT

M

File creation date (DDMMCCYY)

6.6

48-63

16

AN

O

Supplier file reference

6.7

64-64

1

A

M

Type of return media (=N or P)

6.8

65-264

200

AN

M

Supplier name

6.9

265-314

50

AN

M

Supplier contact name

6.10

315-329

15

AN

M

Supplier contact phone number

6.11

330-379

50

AN

M

Supplier contact position held

6.12

380-387

8

AN

C

Registered tax agent number

6.13

388-425

38

AN

M

Supplier street address line 1

6.14

426-463

38

AN

O

Supplier street address line 2

6.14

464-490

27

AN

M

Supplier street address suburb, town or locality

6.15

491-493

3

A

M

Supplier street address state or territory

6.16

494-497

4

N

M

Supplier street address postcode

6.17

498-517

20

AN

C

Supplier street address country

6.18

518-555

38

AN

C

Supplier postal address line 1

6.19

556-593

38

AN

O

Supplier postal address line 2

6.19

594-620

27

AN

C

Supplier postal address suburb, town or locality

6.20

621-623

3

A

C

Supplier postal address state or territory

6.21

624-627

4

N

C

Supplier postal address postcode

6.22

628-647

20

AN

C

Supplier postal address country

6.23

648-723

76

AN

O

Supplier email address

6.24

724-996

273

A

S

Filler

6.25

Entity data record

Character position

Field length

Field format

Field type

Field name

Reference number

1-4

4

N

M

Record length (=0996)

6.1

5-14

10

AN

M

Record identifier (=ENTITYDATA)

6.26

15-25

11

N

M

Entity Australian business Number (ABN)

6.27

26-34

9

N

O

Entity Tax file number (TFN)

6.28

35-51

17

AN

M

PRRT registration number

6.29

52-251

200

AN

M

Legal name of entity

6.30

252-451

200

AN

O

Previous legal name of entity

6.31

452-455

4

N

M

Financial year (CCYY)

6.32

456-456

1

N

M

Report type (= 1, 2, 3 or 4)

6.33

457-457

1

A

C

Amendment indicator (= O, A or R)

6.34

458-459

2

N

C

Amendment or revision number

6.35

460-465

6

N

O

BSB code

6.36

466-474

9

N

C

Account number

6.37

475-506

32

AN

C

Account Name

6.38

507-507

1

A

C

The account is held by (E, J, T, L, A)

6.39

508-508

1

A

M

Have any of the entity’s address details changed since it last notified the ATO (= Y or N)

6.40

509-546

38

AN

C

Entity street address line 1

6.41

547-584

38

AN

C

Entity street address line 2

6.41

585-611

27

AN

C

Entity street address suburb, town or locality

6.42


612-614

3

A

C

Entity street address state or territory

6.43

615-618

4

N

C

Entity street address postcode

6.44

619-638

20

AN

C

Entity street address country

6.45

639-676

38

AN

C

Entity postal address line 1

6.46

677-714

38

AN

C

Entity postal address line 2

6.46

715-741

27

AN

C

Entity postal address suburb, town or locality

6.47

742-744

3

A

C

Entity postal address state or territory

6.48

745-748

4

N

C

Entity postal address postcode

6.49

749-768

20

AN

C

Entity postal address country

6.50

769-769

1

A

C

If this is an onshore project is the entity the head Company of a consolidated group or MEC for PRRT (Y or N)

6.51

770-770

1

A

C

First return for this project (=Y or N)

6.52

771-771

1

A

C

Final return for this project (=Y or N)

6.53

772-773

2

A

C

Reason for final return (= ST, CP, CD, OT)

6.54

774-873

100

AN

C

Reason for final return OT

6.55

874-874

1

A

M

Have the entity’s petroleum project or combined petroleum project details changed (=Y or N)

6.56

875-996

122

A

S

Filler

6.25


Download 1.27 Mb.

Share with your friends:
1   2   3   4   5   6   7




The database is protected by copyright ©ininet.org 2024
send message

    Main page