BUSINESS_UNITRTV_IDRTV_LN_NBRRTV_DISTRIB_NUMC=Closed
O=Open
S=Shipped
X=Cancelled
INV_RTV_DIST_VW(SQL View) |
Index Back |
|---|---|
Inventory RTV Selection View - |
| SELECT A.BUSINESS_UNIT , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.QTY_AM_SHIP_SUOM , A.QTY_AM_SHIP_VUOM , A.SHIP_DATE , A.RTV_DIST_STATUS FROM PS_RTV_LN_DISTRIB 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 | RTV_DISTRIB_NUM |
Number(5,0) | INTEGER NOT NULL | RTV Distribution Number |
| 5 | QTY_AM_SHIP_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Returned Base |
| 6 | QTY_AM_SHIP_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Supplier Shipped Qty |
| 7 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 8 | RTV_DIST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
RTV Distribution Status
C=Closed O=Open S=Shipped X=Cancelled |