BUSINESS_UNITRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRDISTRIB_LINE_NUMN=No
Y=Yes
RECV_SUBCTRD_VW(SQL View) |
Index Back |
|---|---|
Subcontracted ReceiverView of subcontracted items for ppv |
| SELECT RVDST.BUSINESS_UNIT , RVDST.RECEIVER_ID , RVDST.RECV_LN_NBR , RVDST.RECV_SHIP_SEQ_NBR , RVDST.DISTRIB_LINE_NUM , RVDST.DST_ACCT_TYPE , RVDST.BUSINESS_UNIT_GL , RVDST.CURRENCY_CD_BASE , RVDST.RT_TYPE , RVDST.RATE_MULT , RVDST.RATE_DIV , RVDST.MERCH_AMT_BSE , RVSHP.BUSINESS_UNIT_IN , PRDID.PRODUCTION_ID , PRDID.OP_SEQUENCE , PRDID.SUBCONTRACTED FROM PS_RECV_LN_SHIP RVSHP , PS_RECV_LN_DISTRIB RVDST , PS_PO_SF_OP_LIST PRDID WHERE RVSHP.BUSINESS_UNIT = RVDST.BUSINESS_UNIT AND RVSHP.RECEIVER_ID = RVDST.RECEIVER_ID AND RVSHP.RECV_LN_NBR = RVDST.RECV_LN_NBR AND RVSHP.BUSINESS_UNIT_IN = PRDID.BUSINESS_UNIT AND RVSHP.PRODUCTION_ID = PRDID.PRODUCTION_ID AND RVSHP.OP_SEQUENCE = PRDID.OP_SEQUENCE AND PRDID.SUBCONTRACTED = 'Y' AND RVDST.BUSINESS_UNIT_IN = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 5 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 6 | DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 7 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 8 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 9 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 10 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 11 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 12 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 13 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 14 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 15 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 16 | SUBCONTRACTED | Character(1) | VARCHAR2(1) NOT NULL |
Subcontracted
N=No Y=Yes |