GPDE_TX_XMLEMPL(SQL Table) |
Index Back |
---|---|
Employees per TX01 TicketThis record stores the various employees per a given ticket for the TX01 (German tax statement). We need to store this to be able to compare whether or not another run is trying to run for the exact same population. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPDE_ELSTER_TKT | Character(20) | VARCHAR2(20) NOT NULL | Ticket number returned from ELSTER messaging process representing a particular group of tax statement data sent to ELSTER. |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |