| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUMGOP_NONVW
|
| 2 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
Prompt Table:
SF_PRDN_AREA
|
| 3 |
PRDN_DUE_SHIFT |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Prdn Due Shift
|
| 4 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
SF_PA_NOID_VW
|
| 5 |
DATE_IN_EFFECT |
Date(10) |
DATE |
01/27/2000 RML Added "As of date" label
03/23/2004 SFC Added PRICE_LIST_DATE label
06/04/2004 SFC Added PRODUCT_PRICE_DAT label
|
| 6 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
|
| 7 |
QTY_MONDAY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Monday Production Quantity
Prompt Table:
SF_PA_AREA_QTY
|
| 8 |
QTY_TUESDAY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Tuesday Production Quantity
Prompt Table:
SF_PA_AREA_QTY
|
| 9 |
QTY_WEDNESDAY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Wednesday Production Quantity
Prompt Table:
SF_PA_AREA_QTY
|
| 10 |
QTY_THURSDAY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Thursday Production Quantity
Prompt Table:
SF_PA_AREA_QTY
|
| 11 |
QTY_FRIDAY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Friday Production Quantity
Prompt Table:
SF_PA_AREA_QTY
|
| 12 |
QTY_SATURDAY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Saturday Production Quantity
Prompt Table:
SF_PA_AREA_QTY
|
| 13 |
QTY_SUNDAY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Sunday Production Quantity
Prompt Table:
SF_PA_AREA_QTY
|
| 14 |
TIME_MONDAY |
Time(15) |
TIMESTAMP |
Monday Time
|
| 15 |
TIME_TUESDAY |
Time(15) |
TIMESTAMP |
Time Tuesday
|
| 16 |
TIME_WEDNESDAY |
Time(15) |
TIMESTAMP |
Time Wednesday
|
| 17 |
TIME_THURSDAY |
Time(15) |
TIMESTAMP |
Time Thursday
|
| 18 |
TIME_FRIDAY |
Time(15) |
TIMESTAMP |
Time Friday
|
| 19 |
TIME_SATURDAY |
Time(15) |
TIMESTAMP |
Time Saturday
|
| 20 |
TIME_SUNDAY |
Time(15) |
TIMESTAMP |
Time Sunday
|
| 21 |
NEW_DT_MONDAY |
Date(10) |
DATE |
New Date Monday
|
| 22 |
NEW_DT_TUESDAY |
Date(10) |
DATE |
New Date Tuesday
|
| 23 |
NEW_DT_WEDNESDAY |
Date(10) |
DATE |
New Date Wednesday
|
| 24 |
NEW_DT_THURSDAY |
Date(10) |
DATE |
New Date Thursday
|
| 25 |
NEW_DT_FRIDAY |
Date(10) |
DATE |
New Date Friday
|
| 26 |
NEW_DT_SATURDAY |
Date(10) |
DATE |
New Date Saturday
|
| 27 |
NEW_DT_SUNDAY |
Date(10) |
DATE |
New Date Sunday
|
| 28 |
NEW_SH_MONDAY |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
02/10/98 SCC CN#SCHEW-FP9MS: New field
|
| 29 |
NEW_SH_TUESDAY |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
02/10/98 SCC CN#SCHEW-FP9MS: New field
|
| 30 |
NEW_SH_WEDNESDAY |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
02/10/98 SCC CN#SCHEW-FP9MS: New field
|
| 31 |
NEW_SH_THURSDAY |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
02/10/98 SCC CN#SCHEW-FP9MS: New field
|
| 32 |
NEW_SH_FRIDAY |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
02/10/98 SCC CN#SCHEW-FP9MS: New field
|
| 33 |
NEW_SH_SATURDAY |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
02/10/98 SCC CN#SCHEW-FP9MS: New field
|
| 34 |
NEW_SH_SUNDAY |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
02/10/98 SCC CN#SCHEW-FP9MS: New field
|
| 35 |
FLAG_MONDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Monday
Y/N Table Edit
Default Value: N
|
| 36 |
FLAG_TUESDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Tuesday
Y/N Table Edit
Default Value: N
|
| 37 |
FLAG_WEDNESDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Wednesday
Y/N Table Edit
Default Value: N
|
| 38 |
FLAG_THURSDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Thursday
Y/N Table Edit
Default Value: N
|
| 39 |
FLAG_FRIDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Friday
Y/N Table Edit
Default Value: N
|
| 40 |
FLAG_SATURDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Saturday
Y/N Table Edit
Default Value: N
|
| 41 |
FLAG_SUNDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Sunday
Y/N Table Edit
Default Value: N
|
| 42 |
REF_ROUTING_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
Reference Routing Item
|