COMMON_IDSA_ID_TYPEO=Organization
P=Person
SF_PMT_REF_NBRSEQUENCE_NBR_31=Authorize
2=Authorize and Capture
3=Capture
4=Credit
5=eCheck Debit
6=eCheck Credit
91=Request Token
92=Authorize and Capture
93=Hosted Payment Credit
SSF_PAYMENT_RPL(SQL Table) |
Index Back |
|---|---|
SF Electronic Payments ReplyStore the reply field Request Token |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 2 | SA_ID_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 3 | SF_PMT_REF_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Reference Nbr |
| 4 | SEQUENCE_NBR_3 |
Number(3,0) | SMALLINT NOT NULL | Sequence Nbr |
| 5 | CR_CARD_RQST_TOKN | Long Character(256) | VARCHAR2(256) | Credit Card Request Token |
| 6 | CR_CARD_TRANS_LAST | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Requested
1=Authorize 2=Authorize and Capture 3=Capture 4=Credit 5=eCheck Debit 6=eCheck Credit 91=Request Token 92=Authorize and Capture 93=Hosted Payment Credit |