PAC - Electronic Receipts Parameters

Merchant ID

Enter the Merchant ID Number provided by your financial institution.

Merchant Description

The Description provided by your financial institution.

Merchant Username / Password

This field is now redundant.  It was used for Smartapay functionality that is no longer supported.

submit_time

date/time year to seconds

M

The date and time of payment

trans_amt

money(10,2)

M

The total amount of the payment received – this must be equal to the sum:

(fee_amt + build_amt + other_amt – discount_amt).

merchant_id

char(16)

O

The merchant ID code.

batch_num

integer           

M

This is critical for TASS and must be a unique identifier for the settlement batch to which the payment belongs.

receipt_num

char(12)

O

Vendor generated receipt reference number for audit trail.

par_code

char(8)           

M

The parent's account code at the school — this will need to be validated at the point of capture.

fee_amt

money(10,2)   

M

The amount of the payment allocated to the fee account. 

Must be > 0.

build_amt

money(10,2)   

M

The amount of the payment allocated to the building fund.

Must be >= 0.

other_amt

money(10,2)   

M

The amount of the payment allocated to the GL Account setup in 'Usual Receipt Distribution Area 1' in program Finance > Parent Accounts > Setup Information > Parent Accounts Setup on the 'Receipting' tab.

Must be >= 0.

discount_amt

money(10,2)

M

The amount of the discount to be given against the fee account.

Must be >= 0.

1

Date/Time of Payment

Date/Time year to seconds

Mandatory. The date or date/ time of the payment.

Data Example for 15 July 2011 at 3:45 p.m. = '2011-07-15 15:45:00'.

Data Example for 15 July 2011 = '2011-07-15'.

2

Payment Amount

Money(10,2)

Mandatory. It must be greater than $0.00.

The total amount of the payment.

It must be equal to Distribution Amount + Tax Amount.

3

Merchant ID

Char(18)

Optional.

The Merchant's ID Code.

4

Batch Number

Integer

Mandatory.

This is critical for TASS and must be a unique identifier for the settlement batch to which the payment belongs.

5

Receipt Reference

Char(12)

Optional.

Vendor generated receipt reference number for audit trail.

6

Received From

Char(30)

Mandatory.

The full name of the payer.

7

Address Line 1

Char(30)

Optional.

Address Line 1 of the payer.

8

Address Line 2

Char(30)

Optional.

Address Line 2 of the payer.

9

Address Line 3

Char(30)

Optional.

Address Line3 of the payer.

10

Town/Suburb

Char(30)

Optional.

Town/Suburb of the payer.

11

State

Char(3)

Optional.

State of the payer.

12

Postcode

Char(10)

Optional.

Postcode of the payer.

13

Country

Char(20)

Optional.

Country of the payer.

14

Comment Text

Char(30)

Mandatory.

Information about the Payment.

(Added to Comment Line 1 when receipt is generated.)

15

GL Account Code

char(18)

Mandatory.

It must be a valid account code that is 'open'.

16

Nett Distribution Amount

Money(10,2)

Mandatory. It must be greater than or equal to $0.00.

The tax exclusive amount distributed to the GL Account.

17

Tax Amount

Money(10,2)

Mandatory. It must be greater than or equal to $0.00.

The tax amount of this payment.

18

Tax Code

char(3)

Mandatory.

It must be a valid tax code.

19

Donor Number

Integer

If there is an entry in this field it must be a valid Donor Number from the TASS.web Fundraising module.

The field becomes mandatory if:

• The GL Account used in field 15 is the 'Building Fund Account' that is set up in program Finance > Parent Accounts > Setup Information > Parent Accounts Setup on the 'Parameters' tab.
• The 'Enable Donations from Receipting' field in program Finance > Fundraising > Setup Information > Fundraising Setup on the 'Fundraising' tab is set to 'Automatic'.

20

Appeal Code

Char(4)

If there is an entry in this field it must be a valid Appeal Code from the TASS.web Fundraising Module.

The field becomes mandatory if:

• The GL Account used in field 15 is the 'Building Fund Account' that is setup in program Finance > Parent Accounts > Setup Information > Parent Accounts Setup on the 'Parameters' tab.
• The 'Enable Donations from Receipting' field in program Finance > Fundraising > Setup Information > Fundraising Setup on the 'Fundraising' tab is set to 'Automatic'.

21

Pledge Number

Integer

Optional.

If present, it must be a valid Pledge Number for the Donor Number in field 19 above (Field 19 must be not null).