RECV_HDR_SVW

(SQL View)
 Index Back

Receiver Header

Receiver Header

SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.BILL_OF_LADING , A.CARRIER_ID , %Coalesce(A.LAST_DTTM_UPDATE, %datetimein('1900-01-01-00.00.00.000000')) , A.OPRID , A.ORIGIN , A.PO_RECEIPT_FLG , A.RECV_SOURCE , A.RECEIPT_DT , A.RECV_STATUS , A.RECV_STATUS , A.SETID , A.SHIPMENT_NO , A.VENDOR_ID , A.VENDOR_SETID , B.DESCR , D.SETID , A.BUSINESS_UNIT , ' ' , A.RECEIPT_DT , %Substring(%Cast(A.RECEIPT_DT, Date, Character), 1, 4) , %Substring(%Cast(A.RECEIPT_DT, Date, Character), 9, 2) , %Substring(%Cast(A.RECEIPT_DT, Date, Character), 6, 2) , %Substring(%Cast(A.RECEIPT_DT, Date, Character), 6, 2) , V.VENDOR_ID , V.NAME1 , V.NAME1 , V.NAME2 , V.VENDOR_NAME_SHORT , %Coalesce(V.SES_VN_ATTR_L_DTTM, %datetimein('1900-01-01-00.00.00.000000')) FROM PS_RECV_HDR A , PS_BUS_UNIT_TBL_FS B , PS_SET_CNTRL_REC D , PS_VENDOR V WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.REC_GROUP_ID = 'DS_02' AND D.RECNAME = 'CARRIER_ID' AND V.SETID = A.VENDOR_SETID AND V.VENDOR_ID = A.VENDOR_ID

  • Related Language Record: RECV_HDR_SLVW

    • # 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_PM.BUSINESS_UNIT_RECV

    Prompt Table: SP_BU_PM_NONVW

    2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

    Default Value: NEXT

    3 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    4 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: CARRIER_ID_VW

    5 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    7 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Default Value: OPR_DEF_TBL_PM.ORIGIN

    8 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order
    9 RECV_SOURCE Character(1) VARCHAR2(1) NOT NULL Receive Source
    1=On-line
    2=ASN
    3=Data Cllct
    4=Mobile
    10 RECEIPT_DT Date(10) DATE NOT NULL Received Date

    Default Value: %date

    11 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
    C=Closed Receipt
    H=Hold Receipt
    M=Moved to Destination
    N=PO Not Received
    O=Open
    P=PO Partially Received
    R=Fully Received
    X=Canceled
    12 RECV_INQ_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
    C=Closed
    H=Hold
    M=Moved
    O=Open
    R=Received
    X=Canceled
    13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    14 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
    15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_POVW1

    16 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 SETID_CARRIER Character(5) VARCHAR2(5) NOT NULL Carrier Setid
    19 DESCR120 Character(120) VARCHAR2(120) NOT NULL Description
    20 FUNC_AREA Character(30) VARCHAR2(30) NOT NULL For PTSF
    21 SES_DOCUMENT_DATE Date(10) DATE Document Date
    22 SES_YEAR Character(4) VARCHAR2(4) NOT NULL Document Date Hierarchy
    23 SES_DAY Character(2) VARCHAR2(2) NOT NULL Day
    24 SES_MONTH Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    25 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    26 SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL Supplier ID
    27 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    28 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1
    29 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    30 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    31 SES_VN_ATTR_L_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTime specific for vendor attributes such as vendor name, vendor location, vendor phone and vendor contact.