PL_MM_BA_RPT

(SQL Table)
Index Back

Mass Maint Buying Agreements

01/21/03 NRA PL880 - Added to maintain reporting information for Buying Agreements affected by Mass Maintenance

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 STEP Number(2,0) SMALLINT NOT NULL Step
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
8 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
11 PLAN_SHIP_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
12 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Y/N Table Edit

13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
14 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Prompt Table: PRCSRUNCNTL