EN_BOM_MMC_SRCH(SQL Table) |
Index Back |
|---|---|
BOM Mass Maint Code Search04/21/99 LAJ CN#EN800-5.0 All the search fields (beginning with "SRCH_") were moved from en_bom_mmc to here, to allow multiple search rows per mass maint code. This is a child record to en_bom_mmc and therefore has the same keys, plus one new one (en_bom_mmc_src_seq). This new key was necessary since the user is not required to enter the srch_component (or any of the other search fields). 04/21/99 LAJ CN#EN800-6.0 Added fields required for searching for outputs on a BOM. Added a new update field (en_bom_mmc_upd) to determine if the update is to be applied to component this particular component/output or not. Note: Only a maximum of 20 sequences may be defined for any one Mass Maintenance Code. |
| # | 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_SRC_SEQ |
Number(3,0) | SMALLINT NOT NULL |
04/23/99 LAJ CN#EN800-5.0
This is a new key for the search record in BOM Mass Maintenance. Since none of the fields are required on the component/output search panel, a new key was needed to allow multiple search rows.
Default Value: 1 |
| 5 | EN_BOM_MMC_UPD | Character(1) | VARCHAR2(1) NOT NULL |
02/03/99 laj cn800-5.0
Flag used in BOM Mass Maintenance to determine if this component or output, that is being used as a search criteria, should also be updated in the process
Y/N Table Edit Default Value: N |
| 6 | SRCH_COMPONENT | Character(18) | VARCHAR2(18) NOT NULL |
Search Component ID
Prompt Table: EN_BOM_MMCE_VW |
| 7 | SRCH_OP_SEQUENCE | Character(4) | VARCHAR2(4) NOT NULL | Search Operation Sequence |
| 8 | SRCH_EFF_DATE | Date(10) | DATE | Search Effective Date |
| 9 | SRCH_OBS_DATE | Date(10) | DATE | Search Obsolete Date |
| 10 | SRCH_POS_NBR | Character(4) | VARCHAR2(4) NOT NULL | Search Position Number |
| 11 | SRCH_QTY_PER | Character(10) | VARCHAR2(10) NOT NULL | Search Quantity |
| 12 | SRCH_QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Search Quantity Code
ASY=Assembly ORD=Order |
| 13 | SRCH_YIELD | Character(5) | VARCHAR2(5) NOT NULL | Search Yield |
| 14 | SRCH_NON_OWN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Non Owned Item
Y/N Table Edit |
| 15 | SRCH_SUB_SUPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Search Sub Supply Flag
Y/N Table Edit |
| 16 | SRCH_INV_ITEM_HGHT | Character(16) | VARCHAR2(16) NOT NULL | Item Height |
| 17 | SRCH_INV_ITEM_LEN | Character(16) | VARCHAR2(16) NOT NULL | Item Length |
| 18 | SRCH_INV_ITEM_SIZE | Character(5) | VARCHAR2(5) NOT NULL | Item Size |
| 19 | SRCH_INV_ITEM_VOL | Character(16) | VARCHAR2(16) NOT NULL | Volume |
| 20 | SRCH_INV_ITEM_WDTH | Character(16) | VARCHAR2(16) NOT NULL | Item Width |
| 21 | SRCH_INV_ITEM_WGHT | Character(16) | VARCHAR2(16) NOT NULL | Item Weight |
| 22 | SRCH_UOM_DIM | Character(3) | VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table: UNITS_TBL |
| 23 | SRCH_UOM_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
| 24 | SRCH_UOM_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
| 25 | SRCH_TRDN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/98 jnw cn# sf800-13 created new field
Y/N Table Edit |
| 26 | COMP_REV | Character(4) | VARCHAR2(4) NOT NULL | 03/29/00 ST Created new field Component Revision. |
| 27 | 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: EN_BOM_MMCO_VW |
| 28 | 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 |
| 29 | 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). |
| 30 | 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 |
| 31 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 32 | 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). |
| 33 | 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 |
| 34 | 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). |
| 35 | 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). |