| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: CUST_CONVER_HDR.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUARDS_NONVW
|
| 3 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Default Value: CUST_CONVER_HDR.CUST_ID
Prompt Table:
CUSTOMER
|
| 4 |
CONVER_DTTM_INIT |
DateTime(26) |
TIMESTAMP NOT NULL |
Initial Conversation DateTime
Default Value: CUST_CONVER_HDR.CONVER_DTTM_INIT
|
| 5 |
CONVER_DT |
Date(10) |
DATE NOT NULL |
Conversation Date
Default Value: CUST_CONVER_HDR.CONVER_DT
|
| 6 |
CONVER_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Conversation Sequence Number
|
| 7 |
CONVER_DTTM |
DateTime(26) |
TIMESTAMP NOT NULL |
Conversation DateTime
Default Value: %datetime
|
| 8 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
PSOPRDEFN_SRCH
|
| 10 |
CONVER_VISIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Visible
Y/N Table Edit
|
| 11 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
AR_CONVRSND_SCR
|
| 12 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 13 |
EMAIL_DATETIME |
DateTime(26) |
TIMESTAMP |
Email DateTime
|
| 14 |
ORIGIN_CONV |
Character(3) |
VARCHAR2(3) NOT NULL |
Conversation Origin
EBI=eBill
INT=Internal
Default Value: INT
|
| 15 |
LAST_UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime
|
| 16 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
Default Value: PPLSFT
|
| 17 |
EB_UNREAD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Unread
Y/N Table Edit
Default Value: Y
|