INV_ITEM_IDORDER_NOORDER_INT_LINE_NOMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
IN_VMI_RMALN_VW(SQL View) |
Index Back |
|---|---|
IN_VMI_RMA_VWIN_VMI_RMA_VW |
| SELECT LN.BUSINESS_UNIT ,LN.INV_ITEM_ID , LN.RMA_ID , LN.RMA_LINE_NBR ,LN.QTY_RETURNED , LN.UNIT_OF_MEASURE FROM PS_RMA_LINE LN , PS_RMA_HEADER HDR WHERE HDR.BUSINESS_UNIT = LN.BUSINESS_UNIT AND HDR.RMA_ID = LN.RMA_ID AND HDR.RMA_TYPE='I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 4 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 5 | QTY_RETURNED | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned |
| 6 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |