RECV_LNSHIP_SVW

(SQL View)
 Index Back

PTSF view of recv_ln_ship


SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.BUSINESS_UNIT_PO , A.CATEGORY_ID , A.CONFIG_CODE , A.DESCR254_MIXED , A.DUE_DT , A.INV_ITEM_ID , A.INVOICE_ID , A.ITM_ID_VNDR , A.ITM_SETID , A.LOT_CONTROL , A.MFG_ID , A.MFG_ITM_ID , A.UPN_ID , A.ORIG_INV_ITEM_ID , A.PACKSLIP_NO , A.PO_GROUP_ID , A.PO_ID , A.PRIMARY_UNIT , A.PRODUCTION_ID , A.RECEIPT_DTTM , A.RECV_LN_MATCH_OPT , A.RECV_SHIP_STATUS , A.SERIAL_CONTROL , A.SERIAL_STATUS , A.SHIPTO_ID , A.MOVE_STAT_AM , B.DESCR , B.DESCRSHORT FROM PS_RECV_LN_SHIP A ,PS_SHIPTO_TBL B WHERE B.SETID = ( SELECT SETID FROM PS_RECV_HDR D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.RECEIVER_ID = A.RECEIVER_ID) AND B.SHIPTO_ID = A.SHIPTO_ID AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_SHIPTO_TBL B2 WHERE B2.SETID = B.SETID AND B2.SHIPTO_ID = B.SHIPTO_ID AND B2.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

  • Related Language Record: RECV_LNSHIP_SLV

    • # 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 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    6 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    7 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    9 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    11 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    12 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    13 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    14 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    15 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    16 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    17 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
    18 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
    19 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
    20 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    21 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    22 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
    N=No
    Y=Yes
    23 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    24 RECEIPT_DTTM DateTime(26) TIMESTAMP Receipt Datetime
    25 RECV_LN_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Receipt Match Status
    F=Matched
    N=No Match
    P=Partial
    26 RECV_SHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Schedule Status
    C=Closed
    H=Hold
    O=Open
    R=Received
    X=Canceled
    27 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    28 SERIAL_STATUS Character(1) VARCHAR2(1) NOT NULL Serial Status
    C=Complete
    I=Incomplete
    29 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
    30 MOVE_STAT_AM Character(1) VARCHAR2(1) NOT NULL AM Move Status
    M=Moved
    N=N/A
    P=Pending
    31 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    32 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description