FO_MCR_SO_REASO

(SQL Table)
Index Back

Reasons per SO_LINE

Master Contract Rates Non-Compliance Reasons per SO_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
4 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 EFFDT Date(10) DATE Effective Date

Default Value: %date

7 FO_MCR_REASON Character(5) VARCHAR2(5) NOT NULL Master Contract Rates Non-Compliance Reason