GPAU_THIRD_PRTY(SQL Table) |
Index Back |
---|---|
Third Party details AUSContains the Third Party details related to SuperStream reporting |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Third Party ID | |
2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | GPAU_REGISTERED_NM | Character(200) | VARCHAR2(200) NOT NULL | This is the pay entity's registered name (company registered name). |
5 | GPAU_ABN | Character(11) | VARCHAR2(11) NOT NULL | A unique number used by the ATO to identify a contractor. |
6 | GPAU_USI | Character(15) | VARCHAR2(15) NOT NULL | Unique Superannuation identifier |
7 | GPAU_CONTACT_ID | Character(11) | VARCHAR2(11) NOT NULL |
This is the contact person for reporting requirements.
Prompt Table: POI_SEC_SRCH |
8 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |
9 | GPAU_CLRHOUSE | Character(1) | VARCHAR2(1) NOT NULL |
Field holds the value to indicate if the recipient is a clearing House or not.
Y/N Table Edit Default Value: N |
10 | GPAU_LODGEMENT_REF | Character(50) | VARCHAR2(50) NOT NULL | This field is used in the AE program GPAU_EFT_CMX. |