| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 6 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 7 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N
|
| 8 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
Default Value: N
|
| 9 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 10 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 11 |
ORDER_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Choose the Orders to Process
1=Schedule Date
2=Order Date
3=Ship Early Date
4=Orders Placed Today
|
| 12 |
QTY_REQUESTED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested Base
|
| 13 |
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
|
| 14 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 15 |
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
Prompt Table:
DEMAND_ORDER2VW
|
| 16 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
Prompt Table:
DEMAND_LINE_VW
|
| 17 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 18 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 19 |
ORDER_WHERE |
Character(100) |
VARCHAR2(100) NOT NULL |
Wild Card Where Clause
|
| 20 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 21 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 22 |
AUTO_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Ship
Y/N Table Edit
|
| 23 |
AUTO_PICK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit
|
| 24 |
ROUTE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
Prompt Table:
ROUTE_INV_VW5
|
| 25 |
WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
A unique identifier used to group together one or more delivery route codes.
Prompt Table:
WAVE_INV_VW3
|
| 26 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
Prompt Table:
DEMAND_LOAD_VW3
|
| 27 |
AUTO_SCHED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto-Scheduled Job
Y/N Table Edit
Default Value: N
|
| 28 |
COMMIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Reservations for Commits
Y/N Table Edit
Default Value: N
|
| 29 |
RESERV_COMMIT_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Reservations Commit Group
1=Demand Line
2=Order Number
3=Item ID
Default Value: 1
|
| 30 |
COMMIT_BATCH |
Number(6,0) |
INTEGER NOT NULL |
Commit Batch
Default Value: 100
|
| 31 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
DMND_CARIER4_VW
|
| 32 |
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.
Prompt Table:
DMND_CUST_ID_VW
|
| 33 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
DMND_SHP2_IN_VW
|
| 34 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
DMND_SHPTYP2_VW
|
| 35 |
LEAD_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Lead Days for Calendar
|
| 36 |
USE_LEAD_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Lead Days
1=Use Fulfillment Lead Days
2=Override Fulfillment Lead Days
3=Ignore Lead Days
Default Value: 1
|
| 37 |
SYNCH_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
0=No Synchronization Required
1=Synchronize a Business Unit
2=Synchronize an Item
3=Synchronize a Storage Location
4=Synchronize a Lot ID
5=Synchronize Item at a Stor Loc
|
| 38 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 39 |
EIP_CTL_ID_FROM |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
|
| 40 |
EIP_CTL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
|
| 41 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 42 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 43 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 44 |
MAX_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Lead Days
|
| 45 |
BUSINESS_UNIT_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Non-Joint Venture BU
|
| 46 |
SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Saturday
|
| 47 |
SUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Sunday
|
| 48 |
MON |
Character(1) |
VARCHAR2(1) NOT NULL |
Monday
|
| 49 |
TUES |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuesday
|
| 50 |
WED |
Character(1) |
VARCHAR2(1) NOT NULL |
Wednesday
|
| 51 |
THURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Thursday
|
| 52 |
FRI |
Character(1) |
VARCHAR2(1) NOT NULL |
Friday
|
| 53 |
SHIP_DAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 54 |
TODAY_DATE |
Date(10) |
DATE |
Represents the creation date for a given time set utilized in position processing.
|
| 55 |
DTTM_FROM |
DateTime(26) |
TIMESTAMP |
From Date/Time
|
| 56 |
DTTM_TO |
DateTime(26) |
TIMESTAMP |
To Date/Time
|
| 57 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 58 |
PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
|
| 59 |
MG |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing
|
| 60 |
INV_ITEM_ID_LAST |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 61 |
ATP_CUM_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Cumulative ATP Qty
|
| 62 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 63 |
ATP_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
ATP Quantity
|
| 64 |
NUMROWS |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number of Rows fetched.
|
| 65 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 66 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 67 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 68 |
ROW_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
01/23/01 SCC CN#WV802-1.0: New Field
|
| 69 |
COUNT_LINES |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Lines
|
| 70 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
|
| 71 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
|
| 72 |
QTY_PICK_OVRIDE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
|
| 73 |
FULFILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pick
|
| 74 |
QTY_ALLOCATED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Allocated quantity
|
| 75 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 76 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 77 |
QTY_BACKORDER_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Base Qty
|
| 78 |
QTY_BACKORDER |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Qty
|
| 79 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 80 |
COUNT_2 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 81 |
COUNT_3 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 82 |
FUL_BACKO_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 83 |
FUL_CNCL_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 84 |
FUL_PRTL_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 85 |
FUL_RSVED_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 86 |
FUL_ALLOC_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 87 |
FUL_SKIP_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 88 |
FUL_TEMP_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 89 |
FUL_TEMP_LN_COUNT1 |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 90 |
FUL_TEMP_LN_COUNT2 |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 91 |
BACKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
|
| 92 |
PARTIAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
|
| 93 |
SUFFICIENT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
|
| 94 |
DNP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
|
| 95 |
OVERRIDE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 96 |
ATP_SOURCE |
Character(6) |
VARCHAR2(6) NOT NULL |
This field is used in the ATP and Availability calculation to determine where the particular source or demand was fetched from. It will store the up-to-6 character mnemonic used in the associated view that fetched the data. For example, if ATP_S_PO_VW was used to fetch purchase order information, this field will contain "PO". If view ATP_D_PROMIS_VW was used to fetch promised demand information, this field will contain "PROMIS".
|
| 97 |
AVAIL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Availability Type
D=Demand
S=Supply
|
| 98 |
SCHED_DATE |
Date(10) |
DATE |
Schedule Date
|
| 99 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 100 |
SCHED_TIME |
Time(15) |
TIMESTAMP |
Schedule Time
|
| 101 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 102 |
SUPPLY_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Supply Qty
|
| 103 |
DEMAND_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Demand Qty
|
| 104 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 105 |
COMMIT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count based on Commit Level used to determine the size of a unit of work to commit to the database. A value of zero indicates include all updates in the same unit of work and do one commit at the end of each Processing Group. This count can be used to help tune at a site that is running into issues with large runs causing blocking and deadlocks on the base tables updated by the process.
|
| 106 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 107 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 108 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 109 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 110 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 111 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 112 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 113 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 114 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 115 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
|
| 116 |
NON_WIP_COMP_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Non-WIP Dependent Demand Qty
|
| 117 |
EXTRA_DEMAND |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Supply Qty
|
| 118 |
INV_ITEM_ID_SELECT |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 119 |
BUSINESS_UNIT_SEL |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit entered as a run time parameter when executing the automat
|
| 120 |
ATP_SCHED_DATE |
Date(10) |
DATE |
Schedule Date
|
| 121 |
DESTINATION_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Destination
|
| 122 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 123 |
MG_ORIG_COMP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
original component ID
|
| 124 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 125 |
PROD_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
|
| 126 |
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
|
| 127 |
YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Component Yield
|
| 128 |
YIELD_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
|
| 129 |
DT_TIMESTAMP_IUT |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 130 |
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
|
| 131 |
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
|
| 132 |
ISSUE_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
|
| 133 |
REQUIRED_DATE |
Date(10) |
DATE |
Required By
|
| 134 |
EXPECTED_DATE |
Date(10) |
DATE |
Expected By
|
| 135 |
REPLENISH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Replenish ID
|
| 136 |
QTY_PREC_STD |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal Number
W=Whole Number
|
| 137 |
ROUND_RULE_STD |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
N=Natural Round
U=Round Up
|
| 138 |
MIN_DATE |
Date(10) |
DATE |
10/09/01 EGS (CN#PL900-1): Added
|
| 139 |
MAX_DATE |
Date(10) |
DATE |
10/09/01 EGS (CN#PL900-1): Added.
|
| 140 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
|
| 141 |
INTERUNIT_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interunit BackOrders
|
| 142 |
QTY_IUT_PAR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
InterUnit Par Qty
|
| 143 |
PRIORITY_RANK |
Number(3,0) |
SMALLINT NOT NULL |
Priority rank value of demand prioritization rule
|
| 144 |
QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity
|
| 145 |
QTY_ALLOC_CURR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
New Qty Allocated
|
| 146 |
ATP_ITEM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
ATP Item Flag
|
| 147 |
DEMAND_LINE_NEW |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 148 |
ALLOC_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reservation Lead Days
|
| 149 |
KIT_PRESENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Kit Present (Y/N)
|
| 150 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 151 |
ORDER_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Order ID
|
| 152 |
IN_FL_TEMP_TBL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp Table Indicator
|