File structure example
-
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.
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
|
Share with your friends: |