PROCESS_INSTANCECO_BANK_CDCO_ACCOUNT_NBRIAT_INDCHECK_DTCOMPANYPRENOTE_INDPAYGROUPPAY_END_DTPAYCHECK_NBREMPLIDPRIORITY$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
R_DDP001N_TXN(SQL Table) |
Index Back |
|---|---|
DDP001N Transaction Work FilePY_DIRDEP Transaction Work File - to store PPD/IAT and prenote transactions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CO_BANK_CD |
Character(11) | VARCHAR2(11) NOT NULL | Bank Code |
| 3 | CO_ACCOUNT_NBR |
Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 4 | IAT_IND |
Character(1) | VARCHAR2(1) NOT NULL | International ACH Transaction Bank (or IAT) Indicator |
| 5 | CHECK_DT |
Date(10) | DATE | Check date. |
| 6 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 7 | PRENOTE_IND |
Character(1) | VARCHAR2(1) NOT NULL | Prenote Indicator |
| 8 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 9 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 10 | PAYCHECK_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 11 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 12 | PRIORITY |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 13 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 14 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 15 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 16 | ACCOUNT_NUM | Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 17 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense |
| 18 | DEPOSIT_AMOUNT | Number(11,2) | DECIMAL(10,2) NOT NULL | Deposit Amount |