GPAU_SUPEC_TRAN(SQL Table) |
Index Back |
---|---|
GPAU - SuperEC Trans DetailsThis record is created by the SuperEC Process each time a message file is created. It contains information related to the payment. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity | |
3 | Date(10) | DATE | Date From | |
4 | Date(10) | DATE | Previous Period Date To | |
5 | Character(18) | VARCHAR2(18) NOT NULL | GPAU - Payment reference number used in SuperEC processing. | |
6 | Number(15,0) | DECIMAL(15) NOT NULL | GPAUS - used to indicate that a SuperEC file is a replacement for a previous file that had errors. | |
7 | Character(30) | VARCHAR2(30) NOT NULL | GPAUS - Used as an identifier on a SuperEC message file. | |
8 | DateTime(26) | TIMESTAMP | GPAUS - Unique reference used in SuperEC processing to identify the message file to the receiver and the sender. | |
9 | Number(15,0) | DECIMAL(15) NOT NULL | GPAUS - Unique reference used in SuperEC processing to identify the SuperEC message file to both the sender and receiver. | |
10 | Character(1) | VARCHAR2(1) NOT NULL |
GPAUS - Flag to indicate if the SuperEC message file to be created is a replacement for a file with errors.
Y/N Table Edit Default Value: N |
|
11 | Character(1) | VARCHAR2(1) NOT NULL |
GPAUS - In SuperEC processing, when this field is checked it indicates to the receiver of the SuperEC message file that the file is a replacement for one that was previously lost.
Y/N Table Edit Default Value: N |
|
12 | 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. |
13 | GPAU_ACKREQUEST | Character(1) | VARCHAR2(1) NOT NULL | GPAUS - Indicator for SuperEC processing. When checked it means that the sender wishes to receive an acknowledgement after a SuperEC message file is sent. |
14 | GPAU_TESTINDICATOR | Character(1) | VARCHAR2(1) NOT NULL | GPAUS - Indicates if a SuperEC message file is a test file only. Used in SuperEC processing. |