CM_CST_PSCPU_VW (SQL View)	Index Back
Costed Assy Scrap Update View 07/21/99 ebn CN#CM800-9.0 New table for accounting line generation to update SF_SCRAPCOSTB records.

CM_CST_PSCPU_VW

(SQL View)

Costed Assy Scrap Update View

07/21/99 ebn CN#CM800-9.0 New table for accounting line generation to update SF_SCRAPCOSTB records.

SELECT mg_proc_instance , business_unit , production_id , op_sequence , cost_element , trans_date , trans_time , seq_nbr , revalue_flag , cm_book , '250' , posted_flag , process_instance , process_flag , ' ' FROM PS_SF_SCRAPCOSTB WHERE posted_flag = 'N' AND revalue_flag = 'N' AND cm_cost_mode = 'L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

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

6 TRANS_DATE Date(10) DATE NOT NULL Transaction Date

7 TRANS_TIME Time(15) TIMESTAMP NOT NULL Transaction Time

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

9 REVALUE_FLAG Character(1) VARCHAR2(1) NOT NULL Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit

10 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

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

12 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted

13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

14 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

15 ADJUST_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
4	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
5	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
6	TRANS_DATE	Date(10)	DATE NOT NULL	Transaction Date
7	TRANS_TIME	Time(15)	TIMESTAMP NOT NULL	Transaction Time
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	REVALUE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. Y/N Table Edit
10	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
11	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
12	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
15	ADJUST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Type 0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV