RTV_HDR_FS

(SQL View)
 Index Back

Supplier Returns Header View


SELECT A.BUSINESS_UNIT , A.RTV_ID , A.ACTIVITY_DATE , A.ADDRESS_SEQ_NUM , A.BILL_OF_LADING , A.BUYER_ID , A.CARRIER_ID , A.CNTCT_SEQ_NUM , A.DISPATCH_FLAG , A.ENTERED_BY , A.ENTERED_DT , A.FREIGHT_TERMS , A.IN_PROCESS_FLG , A.MODIFIED_DT , A.NOTIFY_INV_MGR_FLG , A.NOTIFY_INV_STAT , A.OPRID_MODIFIED_BY , A.PROCESS_INSTANCE , A.RETURN_SETID , A.RETURN_VENDOR , A.RTV_ADJ_FEES , A.RTV_ADJ_FLG , A.RTV_ADJ_SOURCE , A.RTV_DEBIT_MEMO , A.RTV_DISPATCH_METH , A.RTV_DISPATCH_OPT , A.RTV_NOTIFY_METH , A.RTV_STATUS , A.SHIP_TYPE_ID , A.VCHR_ADJ_STATUS , A.VENDOR_ID , A.VENDOR_SETID , A.VNDR_LOC , %subrec(PUR_USR_HDR_SBR, A) FROM PS_RTV_HDR A

  • Parent Record Of RTV_COMMENTS_FS RTV_COMMENTS_HE RTV_COMMENTS_LI

    • # 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 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
    3 ACTIVITY_DATE Date(10) DATE Last Activity
    4 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: VENDOR_ADDR_VW

    5 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    6 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: BUYER_ACTIVE_VW

    7 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: CARRIER_ID_VW

    8 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
    9 DISPATCH_FLAG Character(1) VARCHAR2(1) NOT NULL Dispatch Flag

    Y/N Table Edit

    10 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
    11 ENTERED_DT Date(10) DATE Entered on
    12 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    13 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Y/N Table Edit

    Default Value: N

    14 MODIFIED_DT Date(10) DATE Date Last Modification
    15 NOTIFY_INV_MGR_FLG Character(1) VARCHAR2(1) NOT NULL Notify INV MGR

    Y/N Table Edit

    16 NOTIFY_INV_STAT Character(1) VARCHAR2(1) NOT NULL INV MGR Status

    Y/N Table Edit

    17 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.
    18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    19 RETURN_SETID Character(5) VARCHAR2(5) NOT NULL RTV (Supplier) SetID
    20 RETURN_VENDOR Character(10) VARCHAR2(10) NOT NULL Return to Vendor

    Prompt Table: VENDOR_RTV_VW

    21 RTV_ADJ_FEES Character(1) VARCHAR2(1) NOT NULL RTV Adjust Fees

    Y/N Table Edit

    22 RTV_ADJ_FLG Character(1) VARCHAR2(1) NOT NULL RTV Adjustment Voucher
    A=Create Adjustment
    N=No adjustment
    S=Stage to Pending File
    23 RTV_ADJ_SOURCE Character(1) VARCHAR2(1) NOT NULL RTV Adjust Source

    Y/N Table Edit

    24 RTV_DEBIT_MEMO Character(1) VARCHAR2(1) NOT NULL RTV Debit Memo

    Y/N Table Edit

    25 RTV_DISPATCH_METH Character(3) VARCHAR2(3) NOT NULL RTV Dispatch Method
    EDX=Electronic Document Exchange
    EML=Electronic Mail
    FAX=Fax Transmission
    PHN=Phone
    PRN=Print
    26 RTV_DISPATCH_OPT Character(1) VARCHAR2(1) NOT NULL RTV Dispatch Option
    1=Manual
    2=Dispatch When Shipped
    3=Dispatched
    9=Default to Business Unit
    27 RTV_NOTIFY_METH Character(3) VARCHAR2(3) NOT NULL RTV Notification Method
    EML=Electronic Mail
    PHN=Phone
    28 RTV_STATUS Character(1) VARCHAR2(1) NOT NULL Return Status
    C=Closed
    O=Open
    S=Shipped
    X=Cancelled
    29 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD_VW

    30 VCHR_ADJ_STATUS Character(1) VARCHAR2(1) NOT NULL Voucher Adjust Status

    Y/N Table Edit

    Default Value: N

    31 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_POVW1

    32 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    33 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    34 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    35 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    36 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    37 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    38 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    39 CUSTOM_DATE_A Date(10) DATE Custom Date
    40 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2