CM_ONHAND2_TMP (SQL Table)	Index Back
Unit cost and on hand value 07/14/00 RML Added cm_dt_timestamp_a and cm_seq_nbr_a due to cm_onhand_tmp 08/19/99 RML Changed config_code to non-key. 08/09/99 RML Removed cm_seq_cost (cm_seq_receipt) due to table changed in cm_receipts 07/14/99 RML Changed field order - book and then item. 05/17/99 RML Added receipt and deplete quantity fields 05/06/99 RML Created for CM800-9.0 - temporary table used to store OH value and unit cost for selected or all items 03/28/01 TW CN#R-TWONG-24878 - Replaced cm_onhand_value with monetary_amount.

CM_ONHAND2_TMP

(SQL Table)

Unit cost and on hand value

07/14/00 RML Added cm_dt_timestamp_a and cm_seq_nbr_a due to cm_onhand_tmp 08/19/99 RML Changed config_code to non-key. 08/09/99 RML Removed cm_seq_cost (cm_seq_receipt) due to table changed in cm_receipts 07/14/99 RML Changed field order - book and then item. 05/17/99 RML Added receipt and deplete quantity fields 05/06/99 RML Created for CM800-9.0 - temporary table used to store OH value and unit cost for selected or all items 03/28/01 TW CN#R-TWONG-24878 - Replaced cm_onhand_value with monetary_amount.

# 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 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

5 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

7 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.

8 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:

9 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

10 INTRANSIT_FLAG Character(1) VARCHAR2(1) NOT NULL Intransit Flag

11 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

13 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

14 CM_GROUP Character(15) VARCHAR2(15) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements

15 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.

16 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

17 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

18 TRANSACTION_DATE Date(10) DATE Transaction Date

19 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

20 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

21 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

22 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

23 CM_RECEIPT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 07/99 GMG CN800-9.0:

24 CM_DEPLETE_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Depleted

25 CM_ONHAND_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/30/99 RML Changed from "onhand" to "on hand"

26 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:

27 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

28 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

29 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

#	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	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	CM_DT_TIMESTAMP_A	DateTime(26)	TIMESTAMP	07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
8	CM_SEQ_NBR_A	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
9	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
10	INTRANSIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Intransit Flag
11	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
12	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
13	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
14	CM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
15	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
16	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
17	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
18	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
19	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consigned Flag
20	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
21	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
22	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
23	CM_RECEIPT_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	07/99 GMG CN800-9.0:
24	CM_DEPLETE_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Depleted
25	CM_ONHAND_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	08/30/99 RML Changed from "onhand" to "on hand"
26	CM_UNIT_COST	Signed Number(27,15)	DECIMAL(25,15) NOT NULL	07/99 GMG CN800-9.0:
27	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
28	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
29	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line