BUSINESS_UNITSO_IDSO_LINEHIST_SEQBUS=More business sold to
DAT=Data entry error
DIS=Dissatisfaction of service
INI=INI
POS=Positions(s) Filled by compet.
REQ=Changes in project requirement
FO_SO_LN_QTY_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , SO_ID , SO_LINE , HIST_SEQ , FO_OLD_QTY , FO_NEW_QTY , REQUEST_DT , CHANGE_REASON , COMMENT1 , LAST_UPDATED_BY , LAST_UPDATE_DTTM FROM PS_FO_SO_LINE_QTY |
| # | 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 | HIST_SEQ |
Number(9,0) | DECIMAL(9) NOT NULL | History sequence number |
| 5 | FO_OLD_QTY | Number(11,0) | DECIMAL(11) NOT NULL | Old Quantity |
| 6 | FO_NEW_QTY | Number(11,0) | DECIMAL(11) NOT NULL | New Quantity |
| 7 | REQUEST_DT | Date(10) | DATE | Request Date |
| 8 | CHANGE_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Change Reason
BUS=More business sold to DAT=Data entry error DIS=Dissatisfaction of service INI=INI POS=Positions(s) Filled by compet. REQ=Changes in project requirement |
| 9 | COMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 10 | LAST_UPDATED_BY | Character(30) | VARCHAR2(30) NOT NULL | LastUpdatedUser |
| 11 | LAST_UPDATE_DTTM | 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. |