SF_SCRAPCOST2 (SQL Table)	Index Back
Assembly Scrap Costs PSG 10/9/97: If fields are added or deleted from sf_scrapcost, then a new copy of sf_scrapcost2 should be saved from sf_scrapcost. sf_scrapcost2 is used by Accounting COBOL and must always contain the exact same fields as sf_scrapcost. 07/21/99 ebn CN#CM800-9.0 Made table uniquely keyed. Added MG_PROC_INSTANCE. Made COST_ELEMENT, TRANS_DATE, and TRANS_TIME keys.

SF_SCRAPCOST2

(SQL Table)

Assembly Scrap Costs

PSG 10/9/97: If fields are added or deleted from sf_scrapcost, then a new copy of sf_scrapcost2 should be saved from sf_scrapcost. sf_scrapcost2 is used by Accounting COBOL and must always contain the exact same fields as sf_scrapcost. 07/21/99 ebn CN#CM800-9.0 Made table uniquely keyed. Added MG_PROC_INSTANCE. Made COST_ELEMENT, TRANS_DATE, and TRANS_TIME keys.

# 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 Transaction Date

7 TRANS_TIME Time(15) TIMESTAMP Transaction Time

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

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

10 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

11 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

12 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown

13 SCRAPPED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty

14 TL_SCRAP_AMT Signed Number(16,4) DECIMAL(14,4) NOT NULL This Level Scrap Amount

15 LL_SCRAP_AMT Signed Number(16,4) DECIMAL(14,4) NOT NULL Lower Level Scrap Amount

16 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct

17 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

18 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
Default Value: 1

19 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

20 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
Default Value: N

21 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
Y/N Table Edit

22 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

#	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	Transaction Date
7	TRANS_TIME	Time(15)	TIMESTAMP	Transaction Time
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
10	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
11	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
12	PRODUCTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	JNW 11/1/98 (CN#SF800-13) activated teardown xlat PR=Production RW=Rework SV=Service TD=Teardown
13	SCRAPPED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Scrapped Qty
14	TL_SCRAP_AMT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This Level Scrap Amount
15	LL_SCRAP_AMT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Lower Level Scrap Amount
16	PERCENT_COMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Scrap Prdn Pct
17	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
18	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Default Value: 1
19	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
20	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 Default Value: N
21	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Y/N Table Edit
22	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
23	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
24	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.