| # |
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
Default Value: CUST_CONVER_HDR.BUSINESS_UNIT
Prompt Table:
SP_BUARDS_OPRVW
|
| 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 |
Initial Conversation DateTime
Default Value: CUST_CONVER_HDR.CONVER_DTTM_INIT
|
| 5 |
CONVER_DT |
Date(10) |
DATE |
Conversation Date
Default Value: CUST_CONVER_HDR.CONVER_DT
|
| 6 |
CONVER_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Conversation Sequence Number
|
| 7 |
CONVR_QUALIFIER_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Conversation Qualifier Code
BA=Buy Agremt
BI=Invoice #
CP=Cust Pay
CT=Contract
D=Document
I=Item
L=Lading
P=PO Number
PY=Payment ID
QU=Quote
RM=RMA
SC=Case Num
SO=Sale Order
Prompt Table:
%EDITTABLE8
|
| 8 |
CONVR_QUAL_FIELD |
Character(30) |
VARCHAR2(30) NOT NULL |
Conversation Qualifier Field
Prompt Table:
%EDITTABLE3
|
| 9 |
CONVR_QUAL_FIELD3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Conversation Qualifier Field3
Prompt Table:
%EDITTABLE5
|
| 10 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
Prompt Table:
%EDITTABLE6
|
| 11 |
CONVR_QUAL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Conversation Qualifier BU
Prompt Table:
%EDITTABLE4
|