REFUND_CC_MSGS(SQL Table) |
Index Back |
---|---|
Credit Card Refund Messages |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_SF |
|
2 | 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 | Number(12,0) | DECIMAL(12) NOT NULL | Refund Nbr | |
4 | Number(3,0) | SMALLINT NOT NULL | Line Sequence Nbr | |
5 | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. | |
6 | 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 |