EN_BOM_MMC(SQL Table) |
Index Back |
|---|---|
BOM Mass Maintenance Code11/97 LAJ CN#EG750-3.0 This record stores the definition for a Mass Maintenance. All the 'search by' fields for each field on the BOM are stored in the fields beginning with "NEW_". All the values to 'change to' are stored in the fields beginning with "SRCH_". Currently all component values (except documents and attachments) are available for updating. Note: Only a maximum of 20 sequences may be defined for any one Mass Maintenance Code. 11/98 JNW CN# SF800-13 added teardown flag 04/21/99 LAJ CN#EN800-5.0 All the search fields (beginning with "SRCH_") were moved to EN_BOM_MMC_SRCH, to allow multiple search rows per mass maint sequence. 04/21/99 LAJ CN#EN800-6.0 Added fields required for updating outputs on a BOM. Added a new type field (en_bom_mmc_type) to determine if the update is to be applied to component or output fields. 04/21/99 LAJ CN#EG800-1.0 Added two new fields for allowing the user to set the effective or obsolete dates to date that will be specified later. |
| # | 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 | MASS_MAINT_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Mass Maintenance Code |
| 3 | MASS_MAINT_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Mass Maintenance Sequence
Default Value: 10 |
| 4 | EN_BOM_MMC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
02/03/99 laj cn#en800-5.0
Determines the type of mass maintenance sequence. Therefore, each sequence may have a different type. The valid choices are 'Component' or 'Output'. The type determines which BOM attributes are to be changed.
C=Component O=Output Default Value: C |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EN_BOM_MMC_EDATE | Character(3) | VARCHAR2(3) NOT NULL |
02/03/99 laj CN#EN800-5.0
Flag used in BOM Mass Maintenance when the user wishes to use the auto increment revision functionality. This flag will determine what the effective date should be set to a component/output change.
SCH=Schd Date |
| 7 | EN_BOM_MMC_ODATE | Character(3) | VARCHAR2(3) NOT NULL |
02/03/99 laj CN#EN800-5.0
Flag used in BOM Mass Maintenance when the user wishes to use the auto increment revision functionality. This flag will determine what the obsolete date should be set to a component/output change.
PRI=Prior Date SCH=Schd Date |
| 8 | NEW_COMPONENT | Character(18) | VARCHAR2(18) NOT NULL |
New Component ID
Prompt Table: MG_ITEM_VW |
| 9 | NEW_OP_SEQUENCE | Character(4) | VARCHAR2(4) NOT NULL | New Operation Sequence |
| 10 | NEW_EFF_DATE | Date(10) | DATE | New Effective Date |
| 11 | NEW_OBS_DATE | Date(10) | DATE | New Obsolete Date |
| 12 | NEW_POS_NBR | Character(4) | VARCHAR2(4) NOT NULL | New Position Number |
| 13 | NEW_QTY_PER | Character(10) | VARCHAR2(10) NOT NULL | New Quantity Per |
| 14 | NEW_QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
New Quantity Code
ASY=Assembly ORD=Order |
| 15 | NEW_YIELD | Character(5) | VARCHAR2(5) NOT NULL | Yield |
| 16 | NEW_NON_OWN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
New Non-Owned Item
Y/N Table Edit |
| 17 | NEW_SUB_SUPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
New Sub Supply Flag
Y/N Table Edit |
| 18 | NEW_INV_ITEM_HGHT | Character(16) | VARCHAR2(16) NOT NULL | Item Height |
| 19 | NEW_INV_ITEM_LEN | Character(16) | VARCHAR2(16) NOT NULL | Item Length |
| 20 | NEW_INV_ITEM_SIZE | Character(5) | VARCHAR2(5) NOT NULL | Item Size |
| 21 | NEW_INV_ITEM_VOL | Character(16) | VARCHAR2(16) NOT NULL | Volume |
| 22 | NEW_INV_ITEM_WDTH | Character(16) | VARCHAR2(16) NOT NULL | Item Width |
| 23 | NEW_INV_ITEM_WGHT | Character(16) | VARCHAR2(16) NOT NULL | Item Weight |
| 24 | NEW_UOM_DIM | Character(3) | VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table: UNITS_TBL |
| 25 | NEW_UOM_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
| 26 | NEW_UOM_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
| 27 | NEW_TRDN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/98 jnw cn# sf800-13 created new field
Y/N Table Edit |
| 28 | COMP_REV | Character(4) | VARCHAR2(4) NOT NULL | 03/29/00 ST Created new field Component Revision. |
| 29 | 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: MG_ITEM_VW |
| 30 | 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 |
| 31 | MG_CHAR_OP_SEQ | Character(4) | VARCHAR2(4) NOT NULL | 02/03/99 laj cn800-5.0 Used in BOM Mass Maintenance to store the the opeartion sequence in character format (so that we can tell the difference between the user entering 0 and nothing). |
| 32 | DATE_IN_EFFECT | Date(10) | DATE | 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 |
| 33 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 34 | MG_CHAR_QTY | Character(10) | VARCHAR2(10) NOT NULL | 03/03/99 laj cn800-5.0 Used in BOM Mass Maintenance to store the the Output Quantity in character format (so that we can tell the difference between the user entering 0 and nothing). |
| 35 | 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 |
| 36 | MG_CHAR_RES_PCT | Character(3) | VARCHAR2(3) NOT NULL | 03/03/99 laj CN#EN800-5.0 Used in BOM Mass Maintenance to store the the Resource Allocation Percentage in character format (so that we can tell the difference between the user entering 0 and nothing). |
| 37 | MG_CHAR_COST_PCT | Character(3) | VARCHAR2(3) NOT NULL | 03/03/99 laj CN#EN800-5.0 Used in BOM Mass Maintenance to store the Cost Percentage in character format (so that we can tell the difference between the user entering 0 and nothing). |