RADV_DTL_REF(SQL Table) |
Index Back |
|---|---|
Notifications detailsRemittance / Advance Notification details already sent out |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RADVISE_KEY | Character(20) | VARCHAR2(20) NOT NULL | Remittance Advise Key |
| 3 | PARTY_ID | Character(30) | VARCHAR2(30) NOT NULL | Payee ID |
| 4 | REFERENCE_FLD | Character(40) | VARCHAR2(40) NOT NULL | Reference number |
| 5 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | PAY_DOC_ID | Character(20) | VARCHAR2(20) NOT NULL | Advice ID |
| 7 | DATE1 | Date(10) | DATE | Date |
| 8 | DATE2 | Date(10) | DATE | Date |
| 9 | DATE3 | Date(10) | DATE | Date |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | AMOUNT_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Work Field |
| 12 | AMOUNT_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Work Field |
| 13 | AMOUNT_3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 14 | AMOUNT_4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 15 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |