REFUND_CC_INFO(SQL Table) |
Index Back |
|---|---|
Refund Credit Card Info |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | REFUND_NBR |
Number(12,0) | DECIMAL(12) NOT NULL |
Refund Nbr
Prompt Table: REFUND_HDR |
| 3 | LINE_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL |
Line Sequence Nbr
Prompt Table: REFUND_DTL |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
| 5 | CREDIT_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | Card Number |
| 6 | CREDIT_CARD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Credit Card Type
AE=American Express DC=Diners' Club DI=Diners Club MC=MasterCard VI=VISA |
| 7 | CREDIT_CARD_EXP_DT | Date(10) | DATE | Expiration Date |
| 8 | CREDIT_CARD_ISSUER | Character(20) | VARCHAR2(20) NOT NULL | Credit Card Issuer |
| 9 | CREDIT_CARD_HOLDER | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Holder |