REFUND_MSG_LINE
(SQL Table) |
Index Back |
|---|
Refund Messages
|
Parent record: REFUND_MSG_HDR
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
BATCH_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Batch ID
|
| 3 |
REFUND_SEQ_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Refund Sequence Number
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 6 |
AV_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
ID
|
| 7 |
ELIGIBLE_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Eligible Amount
|
| 8 |
REFUND_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Refund Amount
|
| 9 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
|
| 10 |
ORG_CONTACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contact Type
|
| 11 |
ORG_LOCATION |
Number(3,0) |
SMALLINT NOT NULL |
Location Nbr
|
| 12 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 13 |
WARNING_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Warning Flag
|
| 14 |
REFUND_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Refund ID
|
| 15 |
REFUND_EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Refund External Org ID
|
| 16 |
REFUND_ORG_CONTACT |
Number(4,0) |
SMALLINT NOT NULL |
Refund Org Contact
|