SSF_STD_PUR_ITM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
2	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person Default Value: P
3	SSF_PURCHASE_DATE	Date(10)	DATE NOT NULL	Purchase Date
4	SSF_PURCHASE_TIME	Time(15)	TIMESTAMP NOT NULL	Purchase Time
5	SF_PMT_REF_NBR	Character(12)	VARCHAR2(12) NOT NULL	Reference Nbr
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	SSF_PUR_CATEGORY	Character(10)	VARCHAR2(10) NOT NULL	Puchase Category
9	SSF_PUR_ITEM_CODE	Character(6)	VARCHAR2(6) NOT NULL	Purchase Item Code
10	ACCOUNT_TYPE_SF	Character(3)	VARCHAR2(3) NOT NULL	Account Type
11	ITEM_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Item Type
12	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
13	FLAT_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	Flat Amount
14	SSF_QUANTITY	Number(5,0)	INTEGER NOT NULL	Quantity
15	SSF_PUR_ITEM_TOTAL	Number(17,2)	DECIMAL(16,2) NOT NULL	Item Total
16	SSF_PUR_TAX_TOTAL	Number(17,2)	DECIMAL(16,2) NOT NULL	Tax Total