SPF_WO_PO_DTL

(SQL Table)
Index Back

Work Order Purchase Order

Work Order Purchase Order Detail

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
9 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
10 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
11 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number