CM_PERPAVG_ADJ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
3	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
4	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
7	CM_SEQ_COST	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number. Incremented each time the actual cost is updated.
8	CM_DT_TIMESTAMP_P	DateTime(26)	TIMESTAMP	07/99 GMG CN800-9.0:
9	CM_SEQ_NBR_P	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
10	CM_UNIT_COST_POVO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
11	CM_UNIT_COST_VO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
12	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted
15	COSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction E=Error; Cannot process N=Transaction is Not Costed P=Qualified for Purging X=Transaction Won't be Costed Y=Transaction is Costed