TRFTBREAK_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID
3	TRFT_SET_ID	Character(10)	VARCHAR2(10) NOT NULL	Rule Cd
4	TRFT_FEATURE_CD	Character(1)	VARCHAR2(1) NOT NULL	Feature Code 1=Freight & Transportation Lead 2=Backorder Rule Defaulting 3=Supply Sources
5	FRT_BREAK_ID	Number(10,0)	DECIMAL(10) NOT NULL	Frt Break ID Default Value: 1
6	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
8	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: TRFT_BRKUOM_VW
9	DATE_BEGIN	Date(10)	DATE NOT NULL	Start Date
10	DATE_END	Date(10)	DATE NOT NULL	End Date
11	BREAK_QTY_LOW	Number(15,4)	DECIMAL(14,4) NOT NULL	Low Quantity/Amount
12	BREAK_QTY_HIGH	Number(15,4)	DECIMAL(14,4) NOT NULL	Upper Quantity/Amount
13	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
14	FREIGHT_CHARGE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge
15	TRFT_ADJST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Freight Adjustment Type 1=Amount 2=Percent
16	FREIGHT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Freight Percent
17	DTTIME_ADDED	DateTime(26)	TIMESTAMP	Date Time Added
18	DTTIME_LAST_MAINT	DateTime(26)	TIMESTAMP	Date Time Last Maintained
19	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
20	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code