PROCESS_INSTANCEBUSINESS_UNITINV_ITEM_IDBOM_STATEEN=Engineering
PR=Manufacturing
BOM_TYPEPR=Production
RW=Rework
BOM_CODEEN_BOM_MMC_AFFT(SQL Table) |
Index Back |
|---|---|
BOM Mass Maint Assy Affected04/20/99 laj (CN#EN800-5.0) Temporarily stores the assemblies affected by a particular BOM mass maintenance code and sequence. This table is necessary when searching with multiple search criteria. For example, all BOMs that have A0001 and A0002 as components. It is deleted and populated by the BOM mass maintenance COBOL process, and should not have any data in it in between processes. 11/99 LAJ...Unlike other records used for processing Mass Maintenance changes, this record does not need eip_ctl_id, but can instead continue to be keyed by process_instance. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 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 |