| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 2 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
Default Value: NEXT
|
| 3 |
PROD_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
|
| 4 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
Prompt Table:
SF_PRDN_AREA
|
| 5 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
SF_PA_IT_ID_VW
|
| 6 |
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
Default Value: PR
|
| 7 |
ORIG_PRDN_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Original Production Qty
|
| 8 |
ORIG_PRDN_END_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Expected Prdn Qty
|
| 9 |
ORIG_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Original Unit of Measure
|
| 10 |
NEW_PRDN_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Production Start Qty
|
| 11 |
EXPECTED_PRDN_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Production End Qty
|
| 12 |
NEW_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure
|
| 13 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
Prompt Table:
%EDITTABLE
|
| 14 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
Prompt Table:
%EDITTABLE2
|
| 15 |
REF_ROUTING_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
Reference Routing Item
|
| 16 |
SCHEDULING_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Scheduling Method
BWD=Backward
FWD=Forward
|
| 17 |
ORIG_START_DATE |
Date(10) |
DATE |
Original Start Date
|
| 18 |
ORIG_START_TIME |
Time(15) |
TIMESTAMP |
Original Start Time
|
| 19 |
ORIG_START_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Original Start Shift
|
| 20 |
ORIG_END_DATE |
Date(10) |
DATE |
Original Due Date
|
| 21 |
ORIG_END_TIME |
Time(15) |
TIMESTAMP |
Original DueTime
|
| 22 |
ORIG_END_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Original Due Shift
|
| 23 |
NEW_START_DATE |
Date(10) |
DATE |
Start Date
|
| 24 |
NEW_START_TIME |
Time(15) |
TIMESTAMP |
Start Time
|
| 25 |
NEW_START_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Start Shift
|
| 26 |
NEW_END_DATE |
Date(10) |
DATE |
Due Date
|
| 27 |
NEW_END_TIME |
Time(15) |
TIMESTAMP |
Due Time
|
| 28 |
NEW_END_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Due Shift
|
| 29 |
PRDN_START_DATE |
Date(10) |
DATE |
Prdn Start Date
|
| 30 |
PRDN_START_TIME |
Time(15) |
TIMESTAMP |
Prdn Start Time
|
| 31 |
PRDN_START_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Prdn Start Shift
|
| 32 |
PRDN_DUE_DATE |
Date(10) |
DATE |
Prdn Due Date
|
| 33 |
PRDN_DUE_TIME |
Time(15) |
TIMESTAMP |
Prdn Due Time
|
| 34 |
PRDN_DUE_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Prdn Due Shift
|
| 35 |
REVISION |
Character(4) |
VARCHAR2(4) NOT NULL |
01/27/2000 RML Added "As of" label
Prompt Table:
EN_REV_SRCH
|
| 36 |
COMPLETED_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Completed Qty
|
| 37 |
SCRAP_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Scrapped Qty
|
| 38 |
ADJ_FIXED_SCRAP |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Adjusted Fixed Scrap Qty
|
| 39 |
PERCENT_COMP |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Scrap Prdn Pct
|
| 40 |
COMP_CLOSE_DT |
Date(10) |
DATE |
Date of Completion
|
| 41 |
COMP_CLOSE_TIME |
Time(15) |
TIMESTAMP |
Time of Completion
|
| 42 |
LAB_CLOSE_DT |
Date(10) |
DATE |
Labor Close Date
|
| 43 |
LAB_CLOSE_TIME |
Time(15) |
TIMESTAMP |
Labor Close Time
|
| 44 |
ACCTG_CLOSE_DT |
Date(10) |
DATE |
Accounting Close Date
|
| 45 |
ACCTG_CLOSE_TIME |
Time(15) |
TIMESTAMP |
Accounting Close Time
|
| 46 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 47 |
MA_PRDN_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes
Y/N Table Edit
|
| 48 |
PLAN_CHANGE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Indicator (Planning)
Y/N Table Edit
Default Value: Y
|
| 49 |
NET_CHANGE_EP |
Character(1) |
VARCHAR2(1) NOT NULL |
Enterprise Planning Net Change
Y/N Table Edit
Default Value: Y
|
| 50 |
PLAN_FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
Default Value: N
|
| 51 |
LINK_TO_OM |
Character(1) |
VARCHAR2(1) NOT NULL |
Link to Order Management
Y/N Table Edit
Default Value: N
|
| 52 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 53 |
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
|
| 54 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 55 |
CP_COMP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Component Sequence Field
|
| 56 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table:
CP_CONFIG_VW
|
| 57 |
PRINT_DOC |
Character(2) |
VARCHAR2(2) NOT NULL |
Print Prdn Documents
10=Do not Print
20=Ready for Printing
30=Printed
|
| 58 |
PRINT_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Print Count
Default Value: 0
|
| 59 |
PRDN_CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Production Created DateTime
|
| 60 |
LAST_DTTM_UPDATE |
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.
|
| 61 |
PROD_PRCS_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
3/1/99 crc CN#PL800-10.0 FPO added 2 new flags(T and U) for remote cal
C=Delete Comp List & Reschedule
D=Delete Comp List Only
N=No Action
R=Reschedule Only
S=Start Release -S
T=Start Release -T
U=Start Release -U
Default Value: N
|
| 62 |
NEW_REVISION |
Character(4) |
VARCHAR2(4) NOT NULL |
New Revision
|
| 63 |
PROCESSED_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Processed Code
E=Processed with Error
I=In Process
N=Not Processed
Y=Processed
Default Value: N
|
| 64 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 65 |
FROZEN_SUBSTITUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Substitutes
B=Both
N=No
Y=Yes
Default Value: N
|
| 66 |
TRDN_ORIG_PID |
Character(10) |
VARCHAR2(10) NOT NULL |
1/1/99 jnw (CN#SF800-13) added field
|
| 67 |
SERIAL_IN_PRDN |
Character(1) |
VARCHAR2(1) NOT NULL |
Serial in Production
Y/N Table Edit
Default Value: MASTER_ITEM_TBL.SERIAL_IN_PRDN
|
| 68 |
CUM_YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Expected Yield %
Default Value: 100
|
| 69 |
SF_YIELD_COST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Yield Cost Flag
Y/N Table Edit
Default Value: N
|
| 70 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|