BUSINESS_UNITSO_IDSO_LINEY/N Table Edit
RS_ASSGN_RR_VW(SQL View) |
Index Back |
|---|
| SELECT C.BUSINESS_UNIT , C.SO_ID , C.SO_LINE , C.START_DT , C.END_DT , C.EST_DAYS , C.PERIOD_DAYS , C.PART_TIME_FLG , C.CUST_ID , C.ADDRESS_SEQ_NUM , C.DISTANCE FROM %Table(RS_SO_HDR) A , %Table(RS_SO_STATUS) B , %Table(RS_SO_LINE) C WHERE %Join(COMMON_KEYS, RS_SO_STATUS B, RS_SO_HDR A) AND B.LASTUPDDTTM = ( SELECT MAX(D.LASTUPDDTTM) FROM %Table(RS_SO_STATUS) D WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.SO_ID = B.SO_ID) AND B.SO_STATUS NOT IN ('C', 'X') AND %Join(COMMON_KEYS, RS_SO_LINE C, RS_SO_HDR A) AND C.SO_LINE_STATUS NOT IN ('A', 'C') |
| # | 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 | START_DT | Date(10) | DATE | Start Date |
| 5 | END_DT | Date(10) | DATE | End Date |
| 6 | EST_DAYS | Number(5,0) | INTEGER NOT NULL | Estimated number of days |
| 7 | PERIOD_DAYS | Number(5,0) | INTEGER NOT NULL | Number of Work Days |
| 8 | PART_TIME_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Part Time
Y/N Table Edit |
| 9 | 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. |
| 10 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 11 | DISTANCE | Number(8,2) | DECIMAL(7,2) NOT NULL | Distance Traveled |