|
SELECT EIP_CTL_ID ,BUSINESS_UNIT ,INV_ITEM_ID ,BOM_STATE ,BOM_TYPE ,BOM_CODE ,MG_OUTPUT_TYPE ,MG_OUTPUT_ITEM ,OP_SEQUENCE ,DATE_IN_EFFECT ,DATE_OBSOLETE ,MG_OUTPUT_QTY ,MG_OUTPUT_QTY_CODE ,MG_OUTPUT_RES_PCT ,MG_OUTPUT_COST_PCT , INCR_REL_TYPE , INCR_REL_OFFSET ,COPY_DIRECTION ,BUSINESS_UNIT_TO ,BOM_TRANSFER_STAT ,EN_MMC_UPDATE_FLG ,MASS_MAINT_CODE ,EN_MMC_SEQ_FLG01 ,EN_MMC_SEQ_FLG02 ,EN_MMC_SEQ_FLG03 ,EN_MMC_SEQ_FLG04 ,EN_MMC_SEQ_FLG05 ,EN_MMC_SEQ_FLG06 ,EN_MMC_SEQ_FLG07 ,EN_MMC_SEQ_FLG08 ,EN_MMC_SEQ_FLG09 ,EN_MMC_SEQ_FLG10 ,EN_MMC_SEQ_FLG11 ,EN_MMC_SEQ_FLG12 ,EN_MMC_SEQ_FLG13 ,EN_MMC_SEQ_FLG14 ,EN_MMC_SEQ_FLG15 ,EN_MMC_SEQ_FLG16 ,EN_MMC_SEQ_FLG17 ,EN_MMC_SEQ_FLG18 ,EN_MMC_SEQ_FLG19 ,EN_MMC_SEQ_FLG20 FROM PS_EN_TRN_OUT_TMP
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 4 |
BOM_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering
PR=Manufacturing
|
| 5 |
BOM_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
|
| 6 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
|
| 7 |
MG_OUTPUT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle).
11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
|
| 8 |
MG_OUTPUT_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
Prompt Table:
%EDITTABLE5
|
| 9 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
Prompt Table:
%EDITTABLE2
|
| 10 |
DATE_IN_EFFECT |
Date(10) |
DATE NOT NULL |
01/27/2000 RML Added "As of date" label
03/23/2004 SFC Added PRICE_LIST_DATE label
06/04/2004 SFC Added PRODUCT_PRICE_DAT label
|
| 11 |
DATE_OBSOLETE |
Date(10) |
DATE NOT NULL |
Obsolete Date
|
| 12 |
MG_OUTPUT_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item quantity on a Bill of Materials. This value is assumed to be in the UOM of the output item it's associated to.
KPN 08/23/02: Added label Quantity
|
| 13 |
MG_OUTPUT_QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
01/28/98 (CN#EN800-6.0) LAJ...Created
Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly
ORD=Order
Default Value: ASY
|
| 14 |
MG_OUTPUT_RES_PCT |
Number(3,0) |
SMALLINT NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item's resource allocation percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the inputs (components) on the BOM are used to produce the output (co-product).
|
| 15 |
MG_OUTPUT_COST_PCT |
Number(3,0) |
SMALLINT NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item's cost percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the cost to make the BOM goes to each output (co-product).
|
| 16 |
INCR_REL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
07/22/02 EGS (CN#PL880-1): Added
1=None
2=Over Time
Default Value: 1
|
| 17 |
INCR_REL_OFFSET |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
07/22/02 EGS (CN#PL880-1): Added.
|
| 18 |
COPY_DIRECTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Copy From/To
EE=Engineering to Engineering
EM=Engineering to Manufacturing
ME=Manufacturing to Engineering
|
| 19 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 20 |
BOM_TRANSFER_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
02/01/00 LAJ
Took the word "Transfer" out of the label, since we now display this field for BOM Mass Maintenance Error correction.
Also added new translate (Update) to distiguish between the EG transfer process status and the BOM Mass Maintenance Status
05/18/00 LAJ
Added new label id for BOM results. This is used by the Mass Maint staged results panelgroup.
E=Error
O=No Change
T=Transfer
U=No Errors
W=Warning
|
| 21 |
EN_MMC_UPDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Maintenance Update Flag
|
| 22 |
MASS_MAINT_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Mass Maintenance Code
|
| 23 |
EN_MMC_SEQ_FLG01 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 1
|
| 24 |
EN_MMC_SEQ_FLG02 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 2
|
| 25 |
EN_MMC_SEQ_FLG03 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 3
|
| 26 |
EN_MMC_SEQ_FLG04 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 4
|
| 27 |
EN_MMC_SEQ_FLG05 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 5
|
| 28 |
EN_MMC_SEQ_FLG06 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 6
|
| 29 |
EN_MMC_SEQ_FLG07 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 7
|
| 30 |
EN_MMC_SEQ_FLG08 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 8
|
| 31 |
EN_MMC_SEQ_FLG09 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 9
|
| 32 |
EN_MMC_SEQ_FLG10 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 10
|
| 33 |
EN_MMC_SEQ_FLG11 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 11
|
| 34 |
EN_MMC_SEQ_FLG12 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 12
|
| 35 |
EN_MMC_SEQ_FLG13 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 13
|
| 36 |
EN_MMC_SEQ_FLG14 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 14
|
| 37 |
EN_MMC_SEQ_FLG15 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 15
|
| 38 |
EN_MMC_SEQ_FLG16 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 16
|
| 39 |
EN_MMC_SEQ_FLG17 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 17
|
| 40 |
EN_MMC_SEQ_FLG18 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 18
|
| 41 |
EN_MMC_SEQ_FLG19 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 19
|
| 42 |
EN_MMC_SEQ_FLG20 |
Number(3,0) |
SMALLINT NOT NULL |
Mass Maintenance Seq Flag 20
|