SF_EARNCONCOSTB (SQL Table)	Index Back
Earned Conversion Cost Books 07/21/99 ebn CN#CM800-9.0 Added for LIFO/FIFO Enhancement. This table tracks all the cost books for which accounting lines should be generated for each SF_EARNCONCOST record.

SF_EARNCONCOSTB

(SQL Table)

Earned Conversion Cost Books

07/21/99 ebn CN#CM800-9.0 Added for LIFO/FIFO Enhancement. This table tracks all the cost books for which accounting lines should be generated for each SF_EARNCONCOST record.

# 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 CONVERSION_TYPE Character(4) VARCHAR2(4) NOT NULL Conversion Type
1100=Lab Setup
1200=Lab Fixed
1300=Labor Run
1400=Lab PostPr
1500=Mach Setup
1600=Mach Fixed
1700=Mach Run
1800=MC PostPrd
2100=Ovhd 1
2200=Ovhd 2
2300=Ovhd 3
2400=Ovhd 4

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

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

12 CM_COST_MODE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
L=Live
S=Simulated

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

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

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

16 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

17 CE_POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Posted
6=Cost for 661
N=Cost Pending Calculation
Y=Cost Calculated

18 CM_LABOR_METHOD Character(2) VARCHAR2(2) NOT NULL Labor Cost Method
0=Not Applicable
11=Standard Time-Conversion Rate
12=Standard Time-Crew Rate
21=Actual Time-Conversion Rate
22=Actual Time-Crew Rate

19 CM_MACHINE_METHOD Character(2) VARCHAR2(2) NOT NULL Machine Cost Method
0=Not Applicable
11=Standard Time-Conversion Rate
21=Actual Time-Conversion Rate

20 CM_METHOD Character(2) VARCHAR2(2) NOT NULL 8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
1=Actual Cost
6=Perpetual Weighted Average
7=Periodic Weighted Average
8=Value at Current Standard
9=Retroactive Perpetual Average

21 CM_MFG_ITEM_FLG Number(3,0) SMALLINT NOT NULL 02/23/99 Created for Release 8 - CM800-9.0 by RML

#	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	CONVERSION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Conversion Type 1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4
10	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 Default Value: N
11	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
12	CM_COST_MODE	Character(1)	VARCHAR2(1) NOT NULL	07/99 GMG CN800-9.0: L=Live S=Simulated
13	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Y/N Table Edit Default Value: N
16	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
17	CE_POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Posted 6=Cost for 661 N=Cost Pending Calculation Y=Cost Calculated
18	CM_LABOR_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Labor Cost Method 0=Not Applicable 11=Standard Time-Conversion Rate 12=Standard Time-Crew Rate 21=Actual Time-Conversion Rate 22=Actual Time-Crew Rate
19	CM_MACHINE_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Machine Cost Method 0=Not Applicable 11=Standard Time-Conversion Rate 21=Actual Time-Conversion Rate
20	CM_METHOD	Character(2)	VARCHAR2(2) NOT NULL	8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements 0=Non Cost 1=Actual Cost 6=Perpetual Weighted Average 7=Periodic Weighted Average 8=Value at Current Standard 9=Retroactive Perpetual Average
21	CM_MFG_ITEM_FLG	Number(3,0)	SMALLINT NOT NULL	02/23/99 Created for Release 8 - CM800-9.0 by RML