Purpose of all the Date and Time Stamp Fields and Sequence Numbers in the PS_CM_DEPLETE Table

(Doc ID 637745.1)

Last updated on AUGUST 12, 2016

Applies to:

PeopleSoft Enterprise SCM Manufacturing - Version 8.4 and later
PeopleSoft Enterprise SCM Cost Management - Version 7.5 and later
PeopleSoft Enterprise SCM Inventory - Version 7.5 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 200961702



Goal

What is the difference between the following fields in the PS_CM_DEPLETE table:

DT_TIMESTAMP
SEQ_NBR
CM_DT_TIMESTAMP
CM_DT_TIMESTAMP_A
CM_SQR_NBR
CM_SQR_NBR_A
TRANSACTION_DATE
CM_ORIG_TRANS_DATE
CM_DT_TIMESTAMP_P
CM_SEQ_NBR_P
CM_DTTM_IN_EFFECT
CM_DTTM_STAMP

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms