REFUND_CC_MSGS

(SQL Table)
Index Back

Credit Card Refund Messages

# 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: BUS_UNIT_TBL_SF

2 BATCH_ID_CC Character(12) VARCHAR2(12) NOT NULL Batch ID used for processing refunds via the CyberSource Credit Card Interface

Prompt Table: BATCH_ID_CC_VW2

3 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
7 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
E=Error
M=Message
W=Warning