CE_PRDNCST_REQ

(SQL Table)
Index Back

Production option cost request

07/09/99 WTK CN# EN800-6.0: Created to store request data for production option costing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUMGOP_NONVW

5 AS_OF_DATE Date(10) DATE As of Date

Default Value: %DATE

6 INV_ITEM_ID_OPTION Character(1) VARCHAR2(1) NOT NULL Inventory Id Option
A=All Items
S=Single Item

Default Value: A

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

Prompt Table: CE_OWN_MAKE_VW

8 TO_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID

Prompt Table: CE_OWN_MAKE_VW

9 COST_GROUP_CD Character(6) VARCHAR2(6) NOT NULL Standard Cost Group

Prompt Table: CM_COSTGROUP

10 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

11 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
12 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler
13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
14 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.