UPG_MG_COST_AET

(SQL Table)
 Index Back

MFG 8.0 Costing Upgrade

12/1/99 dfl Created for LIFO/FIFO costing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 STAGED_DATE Date(10) DATE Staged Date
5 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
9 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
10 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
11 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
12 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
13 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
14 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
15 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
17 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
18 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
19 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
20 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
21 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
22 TRANSACTION_DATE Date(10) DATE Transaction Date
23 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
24 TRANSACTION_SOURCE Character(2) VARCHAR2(2) NOT NULL Transaction Source
25 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
27 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
28 INV_COST_TYPE Character(1) VARCHAR2(1) NOT NULL Costing Method
1=Average Cost
4=Non Cost
5=Actual Cost
6=Standard Cost
29 CFG_COST_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Costing
30 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
31 CM_GROUP Character(15) VARCHAR2(15) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
32 CM_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
33 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
34 CM_TYPE Character(2) VARCHAR2(2) NOT NULL 07/99 GMG CN800-9.0:
0=Non Cost
1=Actual
2=Std Cost
35 CM_FLOW Character(2) VARCHAR2(2) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
2=Lot ID
3=Serial ID
4=FIFO
5=LIFO
36 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
37 CM_NONCOST_FLAG Number(1,0) SMALLINT NOT NULL 07/99 GMG CN800-9.0:
38 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
39 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
40 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
41 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
42 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
43 QTY_STD Number(16,4) DECIMAL(15,4) NOT NULL Standard Quantity
44 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU
45 INV_ITEM_ID_WRK Character(18) VARCHAR2(18) NOT NULL Work Item ID
46 DTTM_STAMP 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.
47 SEQ_NBR2 Number(15,0) DECIMAL(15) NOT NULL Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
48 COSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process
N=Transaction is Not Costed
P=Qualified for Purging
X=Transaction Won't be Costed
Y=Transaction is Costed
49 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
50 CP Character(1) VARCHAR2(1) NOT NULL Product Configuration Field
51 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
52 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
53 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
54 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
55 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
56 MACHINE_CODE Character(10) VARCHAR2(10) NOT NULL Machine Code
57 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
58 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
59 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift
60 PRDN_AREA_CODE_TR Character(10) VARCHAR2(10) NOT NULL Production Area
61 SF_ENTRY_DATE Date(10) DATE Entry Date
62 ENTRY_DT Date(10) DATE Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
63 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
64 RTG_CODE2 Number(2,0) SMALLINT NOT NULL Routing Code
65 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
66 ACTION_FLG Character(1) VARCHAR2(1) NOT NULL Action Flag
A=Action
67 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
68 COUNTER2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Counter 2
69 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
70 COUNTER8 Number(8,0) INTEGER NOT NULL Counter - Unsigned 8