SF_PMT_REF_NBRDefault Value: 0
SEQNUMO=Organization
P=Person
BDT=Birthdate
NID=National ID Number
NOA=No Authentication
PIN=PIN
SF_PAYMENT_AUTH(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SF_PMT_REF_NBR |
Character(12) | VARCHAR2(12) NOT NULL |
Reference Nbr
Default Value: 0 |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 4 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 5 | EC_AUTH_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Authentication Method
BDT=Birthdate NID=National ID Number NOA=No Authentication PIN=PIN |
| 6 | EC_AUTH_KEY | Character(10) | VARCHAR2(10) NOT NULL | Authentication Key |
| 7 | AGREEMENT_DT | Date(10) | DATE | Agreement Date |
| 8 | AGREEMENT_TEXT | Long Character | CLOB | Agreement Text |