SF_TRDN_TMP(SQL Table) |
Index Back |
|---|---|
Teardown Original Prdn Search11/23/98 jnw (CN#SF800-13) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table: CP_CONFIG_VW |
| 2 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Lot ID
Prompt Table: SF_TRDN_LOT_VW |
| 3 | IS_DATE_SELECTED | Character(1) | VARCHAR2(1) NOT NULL |
Scheduled Release Date
A=All N=No R=Range Y=Yes Default Value: Y |
| 4 | PRDN_DUE_FROM_DT | Date(10) | DATE |
Production Due From Date
Prompt Table: SF_TRDN_DATE_VW |
| 5 | PRDN_DUE_TO_DT | Date(10) | DATE |
Production Due To Date
Prompt Table: SF_TRDN_DATE_VW |
| 6 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 7 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL |
Serial ID
Prompt Table: SF_TRDN_SER_VW |
| 8 | TRDN_PID_SEL | Character(1) | VARCHAR2(1) NOT NULL | 1/1/99 jnw (cn#sf800-13) added field |
| 9 | TRDN_SRCH_FILE | Character(1) | VARCHAR2(1) NOT NULL |
01/25/99 jnw (CN#SF800-13) created field
I=Completion History P=Production ID Date Default Value: I |