CM_MATCHED_BOOK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
3	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
4	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
6	MISC_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
7	CM_SEQ_COST	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number. Incremented each time the actual cost is updated.
8	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
9	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
10	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
11	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
12	CM_UNIT_COST_PO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
13	CM_UNIT_COST_POVO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
14	CM_UNIT_COST_VO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
15	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
16	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
17	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
18	CM_DTTM_IN_EFFECT	DateTime(26)	TIMESTAMP	Date Timestamp
19	CM_DTTM_STAMP	DateTime(26)	TIMESTAMP	Date Timestamp
20	CM_SEQ_RECEIPT	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number