CB_SETID_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	TOL_AMT_OVER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Over Tolerance Amount
3	TOL_AMT_UNDER	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Under Tolerance Amount
4	TOL_PCT_OVER	Number(6,2)	DECIMAL(5,2) NOT NULL	Over Tolerance Percent
5	TOL_PCT_UNDER	Number(6,2)	DECIMAL(5,2) NOT NULL	Under Tolerance Percent
6	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " Prompt Table: CURRENCY_CD_TBL
7	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
8	CB_MANAGER_ID	Character(30)	VARCHAR2(30) NOT NULL	Claimback Mgr ID Prompt Table: CB_USER_SEC_VW
9	CB_MANAGER_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Notify Claimback Manager Y/N Table Edit Default Value: Y
10	CB_SETTLE_MGR	Character(30)	VARCHAR2(30) NOT NULL	Claimback Settlement Manager ID Prompt Table: CB_SETMGDEFN_VW
11	CB_SETTLE_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Notify Settlement Manager Y/N Table Edit Default Value: Y
12	CB_CONTRACT_PREFIX	Character(3)	VARCHAR2(3) NOT NULL	Claimback Contract Prefix Prompt Table: CB_CNTRCTSEQ_VW
13	CB_CLAIM_PREFIX	Character(3)	VARCHAR2(3) NOT NULL	Claim Prefix Prompt Table: CB_CLAIMSEQ_VW
14	SCHEDULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID Prompt Table: SCHEDULE_TBL
15	CB_APPLY_SOE	Character(1)	VARCHAR2(1) NOT NULL	Automatically Apply F=First To Expire L=Largest Claimback Amount N=None Default Value: L
16	CB_STOP_AT_MAX	Character(1)	VARCHAR2(1) NOT NULL	Stop Apply At Max Quantity Y/N Table Edit Default Value: N