GPAU_PMTDTL_TMP

(SQL Table)
Index Back

GPAU - SuperEC Payment Dtls

This temporary table stores total payment details for the period being processed prior to writing the details out to the SuperEC message file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
3 GPAU_PAYMENTTYPE Character(12) VARCHAR2(12) NOT NULL GPAU - Payment Type
4 GPAU_SENDTRANSDATE DateTime(26) TIMESTAMP GPAUS - Unique reference used in SuperEC processing to identify the message file to the receiver and the sender.
5 GPAU_PYMNT_AMT Number(16,2) DECIMAL(15,2) NOT NULL GPAUS - Used to store the payment amount of Super Contributions made to a Super Fund Administrator in the period for which SuperEC reporting is being undertaken.
6 GPAU_PAYREFNUM Character(18) VARCHAR2(18) NOT NULL GPAU - Payment reference number used in SuperEC processing.
7 GPAU_ABN Character(11) VARCHAR2(11) NOT NULL A unique number used by the ATO to identify a contractor.