SAR_IDVC_TYPEC=Customer
R=My Contacts
V=Supplier
VC_IDCONTACT_IDDefault Value: NEXT
RE_SAR_CONTACT(SQL Table) |
Index Back |
|---|---|
SAR ContactSAR Contact |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAR_ID |
Character(15) | VARCHAR2(15) NOT NULL | SAR ID |
| 2 | VC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Vendor or Customer flag
C=Customer R=My Contacts V=Supplier |
| 3 | VC_ID |
Character(15) | VARCHAR2(15) NOT NULL | Vendor or Customer ID |
| 4 | CONTACT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Default Value: NEXT |