PROMISE_DT_OPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	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. Prompt Table: CUSTOMER
3	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group Prompt Table: AR_CUSTGP_VW
4	TOLERANCE_DAYS	Number(6,0)	INTEGER NOT NULL	CWB Tolerance Days
5	TOLERANCE_PAY	Number(2,0)	SMALLINT NOT NULL	CWB Payment Tolerance Amount
6	PROMISE_ACTION	Character(4)	VARCHAR2(4) NOT NULL	CWB Broken Promise Action Prompt Table: ACTION_TBL
7	USER_OTD	Character(1)	VARCHAR2(1) NOT NULL	CWB User Override Tolerance Days Y/N Table Edit
8	USER_OPA	Character(1)	VARCHAR2(1) NOT NULL	CWB User Override Promise Action Y/N Table Edit
9	USER_OTP	Character(1)	VARCHAR2(1) NOT NULL	CWB User Override Tolerance Percent Y/N Table Edit