CM_VARIANCES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
4	DT_TIMESTAMP	DateTime(26)	TIMESTAMP NOT NULL	Date Timestamp
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	CM_DT_TIMESTAMP_A	DateTime(26)	TIMESTAMP NOT NULL	07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
7	CM_SEQ_NBR_A	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
8	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
9	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
10	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
11	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
12	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
13	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
14	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag
15	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
16	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	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