CM_OH_SNP1_TBL

(SQL Table)
Index Back

Receipts with total depletions

04/21/00 WHS Copied from CM_ONHAND_TMP... used to capture onhand qty from Costing tables. 08/09/99 RML Removed cm_seq_cost due to table changed in cm_receipts. 05/11/99 RML Added field CONSIGNMENT_FLAG 05/06/99 RML Added field AS_OF_DATE - report parameter to be used when getting cost from CM_PRODCOST and CM_PERDAVG_COST. 04/12/99 RML Created for CM800-9.0 LIFO/FIFO Cost Method Enhancement - used in on-hand reports (CMS2010 and CMS2012); stores on hand quantity by receipt (filtered by report parameters) 05/28/99 RML Removed numeric consignment_flag and added char consigned_flag; decision from inventory.

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
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 INTRANSIT_FLAG Character(1) VARCHAR2(1) NOT NULL Intransit Flag
10 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
11 TRANSACTION_DATE Date(10) DATE Transaction Date
12 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
13 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
14 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
15 CM_RECEIPT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 07/99 GMG CN800-9.0:
16 CM_DEPLETE_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Depleted
17 CM_ONHAND_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/30/99 RML Changed from "onhand" to "on hand"
18 AS_OF_DATE Date(10) DATE As of Date
19 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
20 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.