BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW
Prompt Table: AM_RECV_HDR_VW
ASSET_ACQ_RCVW(SQL View) |
Index Back |
|---|---|
Asset Acquisition Dtl-ReceivgUsed for Receiver drillback |
| SELECT BUSINESS_UNIT_RECV , RECEIVER_ID , RECV_LN_NBR , RECV_DIST_LINE_NUM , RECV_SHIP_SEQ_NBR , DISTRIB_SEQ_NUM FROM PS_ASSET_ACQ_DET WHERE BUSINESS_UNIT_RECV<>' ' |
| # | 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_AM_NONVW |
| 2 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table: AM_RECV_HDR_VW |
| 3 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 5 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 6 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |