| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: A
|
| 7 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 9 |
INCL_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Component Detail
Y/N Table Edit
Default Value: Y
|
| 10 |
PS_PRINT_FIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
3/24/98 rlk - Change rftshort to "Firm" to work with run_sfs2004 panel
Y/N Table Edit
Default Value: Y
|
| 11 |
PS_PRINT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
3/26/98 rlk - Changed rftshort to "Released" to work with run_sfs2004 panel.
Y/N Table Edit
Default Value: Y
|
| 12 |
SEL_PA |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Prdn Area Schedules
Y/N Table Edit
Default Value: Y
|
| 13 |
SEL_PID |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Production IDs
Y/N Table Edit
Default Value: Y
|
| 14 |
PA_PA_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Area Select Option
A=All Production Areas
N=None
R=Range of Production Areas
Default Value: A
|
| 15 |
PA_PA_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - From
Prompt Table:
%EDITTABLE
|
| 16 |
PA_PA_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - To
Prompt Table:
%EDITTABLE
|
| 17 |
PA_ITEM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Select Option
A=All Items
N=None
R=Range of Items
Default Value: A
|
| 18 |
PA_ITEM_FROM |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - From
Prompt Table:
%EDITTABLE2
|
| 19 |
PA_ITEM_TO |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - To
Prompt Table:
%EDITTABLE2
|
| 20 |
PID_PID_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production ID Select Option
A=All Production IDs
N=None
R=Range of Production IDs
Default Value: A
|
| 21 |
PID_PID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Identifier - From
Prompt Table:
%EDITTABLE3
|
| 22 |
PID_PID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Identifier - To
Prompt Table:
%EDITTABLE3
|
| 23 |
PID_PA_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Area Select Option
A=All Production Areas
N=None
R=Range of Production Areas
Default Value: A
|
| 24 |
PID_PA_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - From
Prompt Table:
%EDITTABLE4
|
| 25 |
PID_PA_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - To
Prompt Table:
%EDITTABLE4
|
| 26 |
PID_ITEM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Selct Option
A=All Items
N=None
R=Range of Items
Default Value: A
|
| 27 |
PID_ITEM_FROM |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - From
Prompt Table:
%EDITTABLE5
|
| 28 |
PID_ITEM_TO |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - To
Prompt Table:
%EDITTABLE5
|
| 29 |
PICKING_DT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to determine the Date selection criteria used when submitting jobs to the Picking Plan.
01=Date/Time Range
02=Lead Days/Minutes
03=Today/Until
Default Value: 02
|
| 30 |
PICKING_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Days
Default Value: 0
|
| 31 |
PICKING_DT_FROM |
Date(10) |
DATE |
Picking Selection From Date
|
| 32 |
PICKING_DT_TO |
Date(10) |
DATE |
Picking Selection To Date
|
| 33 |
PICK_SHIFT_FROM |
Number(1,0) |
SMALLINT NOT NULL |
Picking Shift From
|
| 34 |
PICK_SHIFT_TO |
Number(1,0) |
SMALLINT NOT NULL |
Picking Shift To
|
| 35 |
EXCL_UNAVAIL_COMPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Unavailable Components
Y/N Table Edit
Default Value: N
|
| 36 |
COMP_SORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Components by
C=Component
O=Op Seq
Default Value: O
|
| 37 |
INCL_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
06/05/07 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 38 |
INCL_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
06/05/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 39 |
REP_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
06/05/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 40 |
REP_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
06/05/07 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 41 |
DISPLAY_PEGS |
Character(1) |
VARCHAR2(1) NOT NULL |
08/15/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 42 |
INCL_SCHED_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
07/17/07 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 43 |
MSR_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
Stock Request Priority
|
| 44 |
TRANS_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
Interunit Priority
|
| 45 |
SALES_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
06/18/07 EGS: Created
|
| 46 |
PRDN_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
06/18/07 EGS: Created
|
| 47 |
PPRD_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
06/18/07 EGS: Created
|
| 48 |
PTRD_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
06/18/07 EGS: Created
|
| 49 |
WO_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
06/18/07 EGS: Created
|
| 50 |
ATP_INCL_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether dependent demand (from a production order) should be included as demand in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 51 |
ATP_INCL_CO_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether co-products and by-products (from a production order) should be included as supply in the ATP calculation.
Y/N Table Edit
Default Value: Y
|
| 52 |
ATP_INCL_WIP |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether quantity in WIP locations should be included in the starting quantity available when calculating ATP for an item.
Y/N Table Edit
Default Value: N
|
| 53 |
ATP_INCL_UNPRMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Unpromised Demand
Y/N Table Edit
Default Value: N
|
| 54 |
ATP_INCL_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether ALM demand that is in IN_DEMAND should be included as demand in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 55 |
ATP_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field determines the window in which an order line can be ATP-reserved. If the scheduled shipment date is within today + ATP lead days, then the order line may be ATP-reserved; if the scheduled shipment date is outside this window, the order line cannot be ATP-reserved.
|
| 56 |
PAST_DUE_DMD_DAYS |
Number(5,0) |
INTEGER NOT NULL |
Past Due Demand Days
|
| 57 |
PAST_DUE_SUP_DAYS |
Number(5,0) |
INTEGER NOT NULL |
Past Due Supply Days
|
| 58 |
FUTURE_DMD_DAYS |
Number(5,0) |
INTEGER NOT NULL |
06/05/07 EGS: Created
|
| 59 |
FUTURE_SUP_DAYS |
Number(5,0) |
INTEGER NOT NULL |
06/05/07 EGS: Created
|
| 60 |
ATP_INCL_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether approved PO requisitions should be included as supply in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 61 |
DUE_DATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Redetrmine due dates flag
Y/N Table Edit
Default Value: N
|
| 62 |
ATP_INCL_PPUR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Purchase Orders
Y/N Table Edit
Default Value: N
|
| 63 |
ATP_PPUR_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Planned Purchase Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 64 |
ATP_PPUR_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Planned Purchase Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 65 |
ATP_PPUR_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Planned Purchase Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 66 |
ATP_INCL_PTRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Transfer Supply
Y/N Table Edit
Default Value: N
|
| 67 |
ATP_PTRS_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Supply Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 68 |
ATP_PTRS_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Supply Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 69 |
ATP_PTRS_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Supply Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 70 |
ATP_INCL_PTRD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Transfer Demand
Y/N Table Edit
Default Value: N
|
| 71 |
ATP_PTRD_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Demand Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 72 |
ATP_PTRD_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Demand Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 73 |
ATP_PTRD_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Demand Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 74 |
ATP_INCL_PPRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Production Supply
Y/N Table Edit
Default Value: N
|
| 75 |
ATP_PPRS_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Prdn Supply Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 76 |
ATP_PPRS_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Supply Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 77 |
ATP_PPRS_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Supply Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 78 |
ATP_INCL_PPRD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Production Demand
Y/N Table Edit
Default Value: N
|
| 79 |
ATP_PPRD_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Prdn Demand Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 80 |
ATP_PPRD_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Demand Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 81 |
ATP_PPRD_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Demand Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 82 |
ATP_INCL_EPR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Entered Status Production
Y/N Table Edit
Default Value: N
|
| 83 |
REPORT_UNREADY |
Character(1) |
VARCHAR2(1) NOT NULL |
06/07/07 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 84 |
REPORT_READY |
Character(1) |
VARCHAR2(1) NOT NULL |
06/07/07 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 85 |
UNREADY_COMP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/04/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 86 |
PROD_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 87 |
COMP_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 88 |
PRDN_MR_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
1=Readiness
2=Production Area
3=Assembly Item
4=Production
5=Start Date
Default Value: 1
|
| 89 |
PRDN_MR_SORT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
1=Readiness
2=Production Area
3=Assembly Item
4=Production
5=Start Date
|
| 90 |
PRDN_MR_SORT3 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
1=Readiness
2=Production Area
3=Assembly Item
4=Production
5=Start Date
|
| 91 |
PRDN_MR_SORT4 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
1=Readiness
2=Production Area
3=Assembly Item
4=Production
5=Start Date
|
| 92 |
PRDN_MR_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
1=Ascending
2=Descending
Default Value: 1
|
| 93 |
PRDN_MR_ORD2 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
1=Ascending
2=Descending
Default Value: 1
|
| 94 |
PRDN_MR_ORD3 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
1=Ascending
2=Descending
Default Value: 1
|
| 95 |
PRDN_MR_ORD4 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
1=Ascending
2=Descending
Default Value: 1
|
| 96 |
PRDN_MR_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 97 |
PRDN_MR_BREAK2 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 98 |
PRDN_MR_BREAK3 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 99 |
PRDN_MR_BREAK4 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 100 |
COMP_MR_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
1=Component ID
2=Buyer ID
Default Value: 1
|
| 101 |
COMP_MR_SORT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/12/07 EGS: Created
1=Component ID
2=Buyer ID
Default Value: 1
|
| 102 |
COMP_MR_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
1=Ascending
2=Descending
Default Value: 1
|
| 103 |
COMP_MR_ORD2 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
1=Ascending
2=Descending
Default Value: 1
|
| 104 |
COMP_MR_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 105 |
COMP_MR_BREAK2 |
Character(1) |
VARCHAR2(1) NOT NULL |
06/14/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 106 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 107 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 108 |
UPDATE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Meta SQL
|
| 109 |
FROM_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
From Clause
|
| 110 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 111 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 112 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 113 |
ORDERBY |
Character(254) |
VARCHAR2(254) NOT NULL |
ORDER BY
|
| 114 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 115 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 116 |
START_DMD_DATE |
Date(10) |
DATE |
06/21/07 EGS: Created
|
| 117 |
START_SUP_DATE |
Date(10) |
DATE |
06/21/07 EGS: Created
|
| 118 |
FUTURE_DMD_DATE |
Date(10) |
DATE |
06/21/07 EGS: Created
|
| 119 |
FUTURE_SUP_DATE |
Date(10) |
DATE |
06/21/07 EGS: Created
|
| 120 |
PRI_ORDER_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
06/21/07 EGS: Created
|
| 121 |
PEG_KEY_SEPARATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Pegging Key Separator
|
| 122 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 123 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 124 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 125 |
COMPONENT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
|
| 126 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 127 |
MG_ORIG_COMP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
original component ID
|
| 128 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 129 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 130 |
DMD_OPEN_QTY |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
10/04/04 EGS: Created
|
| 131 |
OP_START_DT |
Date(10) |
DATE |
Operation Start Date
|
| 132 |
OP_START_TIME |
Time(15) |
TIMESTAMP |
Operation's Start Time
|
| 133 |
TIME_ZERO |
Time(15) |
TIMESTAMP |
07/19/07 EGS: Created
|
| 134 |
YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Component Yield
|
| 135 |
CURR_SCHED_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
|
| 136 |
ISSUE_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
|
| 137 |
YIELD_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
|
| 138 |
PEND_CONSUME_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
|
| 139 |
PEND_LOSS_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
|
| 140 |
PICK_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Pending Pick Quantity
|
| 141 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 142 |
ISSUE_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
|
| 143 |
SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
|
| 144 |
BU_SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
07/26/07 EGS: Created
|
| 145 |
QTY_PRECISION |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal
W=Whole Nbr
|
| 146 |
ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down
N=Natural Round
U=Round Up
|
| 147 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 148 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 149 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 150 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 151 |
ORD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
07/18/07 EGS: Created
010=Stock Request
020=Sales Order
030=Transfer Demand
040=Work Order
050=Plan Transfer Demand
060=Plan Production Demand
070=Production Demand
110=Purchase Order
120=Requisition
130=Transfer Supply
140=Production Supply
150=Plan Purchase Order
160=Plan Transfer Supply
170=Plan Production Supply
180=Receipt
|
| 152 |
PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
|
| 153 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 154 |
SHIP_CUST_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 155 |
SCHED_DATE |
Date(10) |
DATE |
Schedule Date
|
| 156 |
SCHED_TIME |
Time(15) |
TIMESTAMP |
Schedule Time
|
| 157 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 158 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 159 |
QTY_PICK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Pick Base
|
| 160 |
QTY_PEGGED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
06/16/04 EGS: Created.
|
| 161 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 162 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 163 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 164 |
PEG_ORDER_KEY |
Character(30) |
VARCHAR2(30) NOT NULL |
Used to store the various Order Number formats in 1 field
|
| 165 |
ORDER_KEY |
Character(100) |
VARCHAR2(100) NOT NULL |
Order Key
|
| 166 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 167 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
|
| 168 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 169 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 170 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 171 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 172 |
STAGED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Staged Flag
|
| 173 |
ORD_PRIORITY |
Number(4,0) |
SMALLINT NOT NULL |
08/27/07 EGS: Created
|
| 174 |
MULTI_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
09/04/07 EGS: Created
|
| 175 |
PRDN_SCH_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
09/06/07
|
| 176 |
STAGED_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
09/06/07 EGS: Created
|
| 177 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 178 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 179 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 180 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 181 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 182 |
TOTAL_DEMAND |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Total Demand
|
| 183 |
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
|
| 184 |
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
|
| 185 |
READY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
07/10/07 EGS: Created
|