BUSINESS_UNITRTV_IDRTV_LN_NBRSHIP_SEQ_NBRDefault Value: 1
INV_RTV_PRO_VW(SQL View) |
Index Back |
|---|---|
Inventory RTV Pro Numbers View |
| SELECT A.BUSINESS_UNIT , A.RTV_ID , A.RTV_LN_NBR , A.SHIP_SEQ_NBR , A.PRO_NUMBER , %subrec(PUR_USR_RTV_SBR, A) FROM PS_RTV_LN_SHIP A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 3 | RTV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
| 4 | SHIP_SEQ_NBR |
Number(5,0) | INTEGER NOT NULL |
Ship Sequence Number
Default Value: 1 |
| 5 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 6 | USER_RTV_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 7 | CUSTOM_C100_F1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 8 | CUSTOM_C100_F2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 9 | CUSTOM_C100_F3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 10 | CUSTOM_C100_F4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 11 | CUSTOM_DATE_F | Date(10) | DATE | Custom Date |
| 12 | CUSTOM_C1_F | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |