| # |
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
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: CUST_CONVER_HDR.BUSINESS_UNIT
|
| 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
|
| 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_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Conversation Status
C=Closed
N=New
O=Open
Default Value: CUST_CONVER_HDR.CONVER_STATUS
|
| 7 |
PAYMENT_PLAN |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Plan
|
| 8 |
INSTALLMENT_ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Uniquely identifies an installment item
Prompt Table:
ITEM_DSP3_VW
|
| 9 |
PAYMENT_PLN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Plan Status
A=Active
D=Draft
P=Paid
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
ENT_CUR_CD_VW
|
| 11 |
CREATE_DATE |
Date(10) |
DATE |
Creation Date
Default Value: %Date
|
| 12 |
FIRST_INSTALL_DUE |
Date(10) |
DATE |
First insatallment due date
|
| 13 |
AMOUNT_PER_MONTH |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount per month
|
| 14 |
NO_OF_MONTHS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Number of Months
|
| 15 |
PROCESSING_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing fee
F=Fixed Amount
P=Percentage of Plan Balance
Default Value: F
|
| 16 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 17 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 18 |
PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan type
A=Custom
C=Fixed Monthly Amounts
D=Number of Months
Default Value: D
|
| 19 |
USE_MONTH_END_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Use month end for installments
Y/N Table Edit
|
| 20 |
ADD_TO_LAST_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Add remainder to last installment
Y/N Table Edit
|