SF_NEG1_TMP(SQL Table) |
Index Back |
|---|---|
Negative Compl Tmp12/31/1998 whs (CN# SF800-4.0) New STORAGE_AREA.FieldChange code to hide/unhide storage levels. 02/15/99, ssn, CN#EN800-6.0, Added a key field 'op_sequence' to support mulitple outputs, Added fields start_row, end_row 08/15/99 MDS CN#SF800-13.0: Replaced location views SF_PHYINxxxx_VW with %EDITTABLE6-10. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | STAGED_DATE |
Date(10) | DATE | Staged Date |
| 3 | INV_LOT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 6 | 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 |
| 7 | CONTAINER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 8 | STORAGE_AREA |
Character(5) | VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table: %EDITTABLE6 |
| 9 | STOR_LEVEL_1 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table: %EDITTABLE7 |
| 10 | STOR_LEVEL_2 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table: %EDITTABLE8 |
| 11 | STOR_LEVEL_3 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table: %EDITTABLE9 |
| 12 | STOR_LEVEL_4 |
Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table: %EDITTABLE10 |
| 13 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 14 | SELECT_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Return Qty |
| 15 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 16 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 17 | NETTABLE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Nettable |
| 18 | WIP_LOC_FLG | Character(1) | VARCHAR2(1) NOT NULL | WIP Location Flag |
| 19 | START_ROW | Number(9,0) | DECIMAL(9) NOT NULL | Start Row Number |
| 20 | END_ROW | Number(9,0) | DECIMAL(9) NOT NULL | End Row Number |