PROCESS_INSTANCEBUSINESS_UNITRTV_IDC=Closed
O=Open
S=Shipped
X=Cancelled
RTV_RECON_WRK1(SQL Table) |
Index Back |
|---|---|
RTV Recon Work Rec 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 4 | ACTIVITY_DATE | Date(10) | DATE | Last Activity |
| 5 | RTV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Return Status
C=Closed O=Open S=Shipped X=Cancelled |
| 6 | RTV_LINE_COUNT | Number(5,0) | INTEGER NOT NULL | RTV Line Count |
| 7 | RTV_SHIP_COUNT | Number(5,0) | INTEGER NOT NULL | RTV Shipped Line Count |