SPL_VIOLATN_DMD(SQL Table) |
Index Back |
|---|---|
Show Supply/Demand Wrk RecShow Supply/Demand Wrk Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SPL_ROW_NUMBER |
Number(9,0) | DECIMAL(9) NOT NULL | Row Number |
| 3 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 4 | LEVEL_NUM |
Number(3,0) | SMALLINT NOT NULL | Level |
| 5 | PARENT_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Parent Node Number |
| 6 | NODE_ID |
Number(8,0) | INTEGER NOT NULL | Installed Node |
| 7 | PL_MRP_ORDER_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Used by the MRP Detail Report/Online Inquiry
010=Purchase 011=Completed Purchase 020=Production 030=Transfer 040=Planned Purchase 050=Planned Production 060=Planned Transfer 070=Stock Request 080=Quote 090=Sales Order 100=Buying Agreement 110=Extra Demand 120=Net Forecast 130=Starting Balance |
| 8 | PL_ORDER_KEY |
Character(25) | VARCHAR2(25) NOT NULL | Used to store the various Order Number formats in 1 field |
| 9 | PL_LINE_KEY |
Character(30) | VARCHAR2(30) NOT NULL | Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field. |
| 10 | PLAN_DUE_DTTM | DateTime(26) | TIMESTAMP | Planning Due Date/Time |
| 11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 12 | PL_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 13 | REFERENCE | Character(30) | VARCHAR2(30) NOT NULL | Field to show when a variable is a reference variable. |
| 14 | 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 |
| 15 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 16 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 17 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 18 | SPL_SOURCE_ID | Character(1) | VARCHAR2(1) NOT NULL | Source Table |
| 19 | SPL_VIOLATIONS_CNT | Number(7,0) | INTEGER NOT NULL | Violations Count |
| 20 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |