CM_MOVEMENT_TMP (SQL Table)	Index Back
Movement by receipt 10/04/99 RML Added columns cm_dt_timestamp, cm_dt_timestamp_a, cm_seq_nbr, and cm_seq_nbr_a. 05/19/99 RML Created for CM800-9.0 - temporary table used to sum of depletions per receipt for a given date range. Keep tracks of receipt quantity, receipt value, deplete quantity, and depletion cost per receipt.

CM_MOVEMENT_TMP

(SQL Table)

Movement by receipt

10/04/99 RML Added columns cm_dt_timestamp, cm_dt_timestamp_a, cm_seq_nbr, and cm_seq_nbr_a. 05/19/99 RML Created for CM800-9.0 - temporary table used to sum of depletions per receipt for a given date range. Keep tracks of receipt quantity, receipt value, deplete quantity, and depletion cost per receipt.

# 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 DateTime(26) TIMESTAMP Receipt dttm.

8 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

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

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

12 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.

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

14 CM_DEPLETE_COST Number(15,4) DECIMAL(14,4) NOT NULL 05/19/99 RML Created for CM800-9.0 for Movement by Receipt Line report.

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

#	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	DateTime(26)	TIMESTAMP	Receipt dttm.
8	CM_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	CM_DT_TIMESTAMP_A	DateTime(26)	TIMESTAMP	07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
10	CM_SEQ_NBR_A	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
11	CM_RECEIPT_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	07/99 GMG CN800-9.0:
12	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.
13	CM_DEPLETE_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Depleted
14	CM_DEPLETE_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	05/19/99 RML Created for CM800-9.0 for Movement by Receipt Line report.
15	CM_ONHAND_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	08/30/99 RML Changed from "onhand" to "on hand"