PO_FRT_MISC_SUM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	PO_STG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used in conjunction with PO_STG_ID to make a unique key on the stage tables. O=Other R=Requisition
5	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
6	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
7	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
8	ADJ_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Adjustment Type BAS=Base CNT=Contract FRT=Freight OTH=Other TAX=Tax TBL=Table
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
11	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
12	FREIGHT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
13	FREIGHT_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
14	FREIGHT_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
15	FREIGHT_AMT_TOT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
16	FRT_AMT_TOT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
17	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
18	MISC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
19	MISC_AMT_NP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
20	MISC_AMT_NP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Misc. Amount
21	MISC_AMT_TOT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
22	MISC_AMT_TOT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
23	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
24	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
25	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.