RECV_HDR_FS

(SQL View)
 Index Back

Receipt Header View

Receipt Header View

SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.BILL_OF_LADING , A.CARRIER_ID , A.CONTAINER_ID , A.COUNTRY_SHIP_FROM , A.DFLT_PACKSLIP_NO , A.DRIVER_ID , A.EIP_CTL_ID , A.ERS_FLAG , A.ERS_INV_DT_OPT , A.ERS_INV_STATUS , A.FREIGHT_TERMS , A.HOLD_ASSET , A.HOLD_INVENTORY , A.IN_PROCESS_FLG , A.INTFC_ASSET , A.INTFC_INVENTORY , A.INTFC_MG , A.INVOICE_ID , A.MATCH_CNTRL_ID , A.MATCH_PROCESS_FLG , A.MATCH_STATUS_RECV , A.NUM_OF_CARTONS , A.OPRID , A.ORIGIN , A.PALLETS_RECV , A.PALLETS_RTN , A.PO_RECEIPT_FLG , A.PORT_OF_UNLOADING , A.PRO_NUMBER , A.PROCESS_INSTANCE , A.RECEIPT_DT , A.RECEIPT_TM , A.RECV_SOURCE , A.RECV_STATUS , A.SETID , A.SHIP_DATE , A.SHIP_FROM_LOC , A.SHIPMENT_NO , A.SHIPTO_ID , A.VEHICLE_ID , A.VENDOR_ID , A.VENDOR_SETID , A.VNDR_LOC , A.POST_STATUS_RECV , %subrec(LAST_UPDATE_SBR, A) , %subrec(PUR_USR_HDR_SBR, A) FROM PS_RECV_HDR A

  • Parent Record Of VCHR_RECV_LN_VW VCHR_REC_LN_VW

    • # 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 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
    5 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
    6 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
    7 DFLT_PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Default Packing Slip value
    8 DRIVER_ID Character(10) VARCHAR2(10) NOT NULL Driver ID
    9 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    10 ERS_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Eval Rcpt Settlement

    Y/N Table Edit

    11 ERS_INV_DT_OPT Character(1) VARCHAR2(1) NOT NULL ERS Invoice Date Option
    F=Frt Terms
    R=Recv Date
    12 ERS_INV_STATUS Character(1) VARCHAR2(1) NOT NULL ERS Invoice Status
    I=Invoiced
    N=Not Invoiced
    P=Partially Invoiced
    13 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    14 HOLD_ASSET Character(1) VARCHAR2(1) NOT NULL Hold Assets

    Y/N Table Edit

    15 HOLD_INVENTORY Character(1) VARCHAR2(1) NOT NULL Hold Inventory

    Y/N Table Edit

    16 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
    17 INTFC_ASSET Character(1) VARCHAR2(1) NOT NULL Process Assets
    18 INTFC_INVENTORY Character(1) VARCHAR2(1) NOT NULL Process Inventory
    19 INTFC_MG Character(1) VARCHAR2(1) NOT NULL Process Manufacturing
    20 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    21 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
    22 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
    I=In Process
    N=No
    23 MATCH_STATUS_RECV Character(1) VARCHAR2(1) NOT NULL Match Status
    M=Matched
    N=Not Matched
    P=Partially Matched
    T=To Match
    V=Vouchered
    24 NUM_OF_CARTONS Signed Number(12,0) DECIMAL(11) NOT NULL Number of Cartons
    25 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    26 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    27 PALLETS_RECV Signed Number(10,0) DECIMAL(9) NOT NULL Pallets Received
    28 PALLETS_RTN Signed Number(10,0) DECIMAL(9) NOT NULL Pallets Returned
    29 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order
    30 PORT_OF_UNLOADING Character(10) VARCHAR2(10) NOT NULL Port Of Unloading
    31 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
    32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    33 RECEIPT_DT Date(10) DATE Received Date
    34 RECEIPT_TM Time(15) TIMESTAMP Receipt Time
    35 RECV_SOURCE Character(1) VARCHAR2(1) NOT NULL Receive Source
    1=On-line
    2=ASN
    3=Data Cllct
    4=Mobile
    36 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
    37 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    38 SHIP_DATE Date(10) DATE Item Shipping Date
    39 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location
    40 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
    41 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
    42 VEHICLE_ID Character(10) VARCHAR2(10) NOT NULL Vehicle ID
    43 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    44 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    45 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    46 POST_STATUS_RECV Character(1) VARCHAR2(1) NOT NULL Post Status Recv
    47 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
    48 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.
    49 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    50 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    51 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    52 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    53 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    54 CUSTOM_DATE_A Date(10) DATE Custom Date
    55 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2