BCT_MG_CMPL_TMP(SQL Table) |
Index Back |
|---|---|
Compl/Scrap batch temp table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 3 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 4 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | DEVICE_ID | Character(10) | VARCHAR2(10) NOT NULL | Device ID |
| 7 | DEVICE_LAST_SEQ | Number(5,0) | INTEGER NOT NULL | Device Last Sequence Number |
| 8 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |
| 9 | DTTM_STAMP | 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. |
| 10 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 12 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 13 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 14 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 15 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 16 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 17 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 18 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 19 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 20 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 21 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 22 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
| 23 | UPDATE_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Back Thru Operation |
| 24 | COMPL_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
| 25 | SCRAPPED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 26 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 27 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 28 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 29 | TO_PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | To Production ID |
| 30 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 31 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 32 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 33 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 34 | SF_BOM_RTG_EFFDT | Date(10) | DATE | 12/28/98,eyz, CN#EN800-4.0, new this as a workfield in Completions for the Recipe Management feature. |
| 35 | MG_OUTPUT_SEQ | Number(4,0) | SMALLINT NOT NULL | NAS 022399 (CN# EN800-6.0) Field required for Message Agent definition of Multiple Outputs Completion. |
| 36 | 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. |
| 37 | 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 |
| 38 | MG_NEW_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. |
| 39 | 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). |
| 40 | MG_OUTPUT_COMPL | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 990105 nas (CN# EN800-6.0) This field will contain the user inputted quantity completed of a specific output within completion process. |
| 41 | BOM_QTY | Number(7,0) | INTEGER NOT NULL | 06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard. |
| 42 | MG_UNPLAN_OUTPUT | Character(1) | VARCHAR2(1) NOT NULL | 01/19/99 nas (CN#800-6.0) Created new field. |
| 43 | MG_TRANS_UOM | Character(3) | VARCHAR2(3) NOT NULL | 01/19/99 NAS (CN#800-6.0) Created new field |
| 44 | 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 |
| 45 | MG_RELATED_TRANS | Character(25) | VARCHAR2(25) NOT NULL | Related Transaction Control Id |
| 46 | SF_KANBAN_ID | Character(15) | VARCHAR2(15) NOT NULL | Kanban ID |
| 47 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |