RECIPIENT_IDGPSG_RCP_GROUP_IDPAY_ENTITYGPSG_RCPPAY_FTR(SQL Table) |
Index Back |
|---|---|
Recipient Payment File - FTRFooter line of Recipient Payment File |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECIPIENT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
| 2 | GPSG_RCP_GROUP_ID |
Character(10) | VARCHAR2(10) NOT NULL | The Group ID is an identifier that has been assigned to the Pay Entity by a recipient. It is used when reporting payments to recipients to identify the company the payments are from. |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 4 | PAYMENT_DT | Date(10) | DATE NOT NULL | Payment Date |
| 5 | GPSG_TT_PAY_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Total Payment Amount |
| 6 | GPSG_TT_COMM_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Commission Amount |
| 7 | GPSG_TT_NET | Number(11,2) | DECIMAL(10,2) NOT NULL | Total Net Amount |