BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_FS_NONVW
RECEIVER_IDPrompt Table: INV_RECV_HDR
RECV_LN_NBRDefault Value: 1
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: INV_UOM_VW
TD_INVRECVLN_VW(SQL View) |
Index Back |
|---|---|
RMA Receipt Line |
| SELECT BUSINESS_UNIT , RECEIVER_ID , RECV_LN_NBR , QTY_INV_RECV , %DatePart(RECEIPT_DTTM) , RMA_ID , RMA_LINE_NBR , SOURCE_BUS_UNIT , UNIT_OF_MEASURE , UNIT_MEASURE_STD FROM PS_INV_RECV_LN WHERE RMA_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_FS_NONVW |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table: INV_RECV_HDR |
| 3 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | QTY_INV_RECV | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Received |
| 5 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 6 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 7 | RMA_LINE_NBR | Number(5,0) | INTEGER NOT NULL |
RMA Line Number
Default Value: 1 |
| 8 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 9 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_UOM_VW |
| 10 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |