RECV_LNASST_SVW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.DISTRIB_LINE_NUM , A.DISTRIB_SEQ_NUM , A.ASSET_ID , (CASE WHEN A.LOT_ID = ' ' THEN %Substring(X1.MESSAGE_TEXT, 1, 15) ELSE A.LOT_ID END) , (CASE WHEN A.MODEL = ' ' THEN %Substring(X1.MESSAGE_TEXT, 1, 30) ELSE A.MODEL END) , (CASE WHEN A.SERIAL_ID = ' ' THEN %Substring(X1.MESSAGE_TEXT, 1,20) ELSE A.SERIAL_ID END) , (CASE WHEN A.TAG_NUMBER = ' ' THEN %Substring(X1.MESSAGE_TEXT, 1, 12) ELSE A.TAG_NUMBER END) FROM PS_RECV_LN_ASSET A , PSMSGCATDEFN X1 WHERE X1.MESSAGE_SET_NBR = 18130 AND X1.MESSAGE_NBR = 18001 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 5 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 6 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
| 7 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 8 | LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 9 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
| 10 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 11 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |