RC_TAX870EU(SQL Table) |
Index Back |
---|---|
TAX870EU Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
4 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |
5 | PY_EE_PREPAY | Number(15,2) | DECIMAL(14,2) NOT NULL | Prepayments Made |
6 | PY_EE_PENALTY | Number(10,2) | DECIMAL(9,2) NOT NULL | Penalty Due |
7 | PY_EE_INTEREST | Number(10,2) | DECIMAL(9,2) NOT NULL | Interest Due |
8 | PY_EE_PNLTY_LT_FL | Number(10,2) | DECIMAL(9,2) NOT NULL | Late File Penalty |
9 | PY_ER_PREPAY | Number(15,2) | DECIMAL(14,2) NOT NULL | Prepayments Made |
10 | PY_ER_PENALTY | Number(10,2) | DECIMAL(9,2) NOT NULL | Penalty Due |
11 | PY_ER_INTEREST | Number(10,2) | DECIMAL(9,2) NOT NULL | Interest Due |
12 | PY_ER_PNLTY_LT_FL | Number(10,2) | DECIMAL(9,2) NOT NULL | Late File Penalty |
13 | PY_AVG_ANN_EMPL | Number(9,0) | DECIMAL(9) NOT NULL | Average Annual Employment |
14 | PY_QTR_WAGES_Q123 | Number(17,2) | DECIMAL(16,2) NOT NULL | Total Wages Paid During Q123 |
15 | PY_ER_Q4_PREPAY | Number(15,2) | DECIMAL(14,2) NOT NULL | Prepayments Made |
16 | PY_ER_Q4_PENALTY | Number(10,2) | DECIMAL(9,2) NOT NULL | Penalty Due |
17 | PY_ER_Q4_INTEREST | Number(10,2) | DECIMAL(9,2) NOT NULL | Interest Due |
18 | PY_ER_Q4_PNL_LT_FL | Number(10,2) | DECIMAL(9,2) NOT NULL | Late File Penalty |