SCN_HDR_VW

(SQL View)
 Index Back

Sales Contract Header View


SELECT A.SETID ,A.CNTRCT_ID ,A.SCON_STATUS ,A.DESCR ,A.CONTRACT_TYPE_ID ,A.CURRENCY_CD ,A.CUR_RT_TYPE ,A.START_DT ,A.END_DT ,A.GRACE_DAYS ,A.GRACE_END_DT ,A.SOLD_TO_CUST_ID ,A.PROD_ID_SRC ,A.CUSTOMER_GROUP ,A.CNTCT_SEQ_NUM ,A.AMT_CNTRCT_MAX ,A.MIN_ORDER_AMT ,A.PAYMENT_METHOD ,A.PRICE_CAN_CHANGE ,A.PCT_OVER_AMT ,A.PYMNT_TERMS_CD ,A.CARRIER_ID ,A.CARRIER_ID_EXP ,A.SHIP_TYPE_ID ,A.SHIP_TYPE_ID_EXP ,A.FREIGHT_TERMS ,A.FREIGHT_TERMS_EXP ,A.FRT_CHRG_METHOD ,A.SHIP_PRIORITY_ID ,A.SHIP_PRIORITY_EXP ,A.SHIP_PARTIAL_ORD ,A.SHIP_PARTIAL_FLAG ,A.SHIP_PRIOR_FLAG ,A.SINGLE_SHIP_FLAG ,A.BCKORDR_CNCL_FLAG ,A.DEFAULT_CNTRCT ,A.ADJUST_BAPRC_FLG ,A.DATETIME_ADDED ,A.LASTUPDDTTM ,A.LAST_MAINT_OPRID FROM PS_SCON_HDR A

  • Related Language Record: SCN_HDRVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    3 SCON_STATUS Character(1) VARCHAR2(1) NOT NULL Sales Contract Status
    A=Active
    C=Closed
    H=Hold
    X=Cancelled
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CONTRACT_TYPE_ID Character(6) VARCHAR2(6) NOT NULL Buying Agreement Type

    Prompt Table: CONTRACT_TYPE

    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    7 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Prompt Table: RT_TYPE_TBL

    8 START_DT Date(10) DATE NOT NULL Start Date
    9 END_DT Date(10) DATE NOT NULL End Date
    10 GRACE_DAYS Number(3,0) SMALLINT NOT NULL Grace Days
    11 GRACE_END_DT Date(10) DATE Grace End Date
    12 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: CUST_SLD_VW

    13 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
    C=Customer
    P=UPC
    S=System
    U=Universal
    14 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

    Prompt Table: CUSTGP_SCON_VW

    15 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CNCT_SL_VW

    16 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
    17 MIN_ORDER_AMT Number(16,2) DECIMAL(15,2) NOT NULL Minimum Order Amount
    18 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
    ACH=ACH
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DD=Direct Debit
    DR=Draft
    EC=Electronic Check
    EFT=Electronic Fund Transfer
    GE=Giro - EFT
    PL=PayPal
    WIR=Wire Report
    19 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    20 PCT_OVER_AMT Number(3,0) SMALLINT NOT NULL % Over Amount
    21 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Prompt Table: AR_TRMS_VW

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

    Prompt Table: CARRIER_ID

    23 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

    Prompt Table: CARRIER_ID

    24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD

    25 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

    Prompt Table: SHIP_METHOD

    26 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    27 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    28 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity
    29 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

    Prompt Table: SHIP_PRIORITY

    30 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

    Prompt Table: SHIP_PRIORITY

    31 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
    N=Partial Order No
    Y=Partial Order Yes

    Y/N Table Edit

    Default Value: N

    32 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
    N=Ship Partial No
    Y=Ship Partial Yes

    Y/N Table Edit

    Default Value: N

    33 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
    N=Ship Prior No
    Y=Ship Prior Yes

    Y/N Table Edit

    Default Value: N

    34 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
    N=No
    Y=Yes
    35 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
    N=Cancel Backorder No
    Y=Cancel Backorder Yes

    Y/N Table Edit

    Default Value: N

    36 DEFAULT_CNTRCT Character(1) VARCHAR2(1) NOT NULL Default Contract

    Y/N Table Edit

    Default Value: N

    37 ADJUST_BAPRC_FLG Character(1) VARCHAR2(1) NOT NULL Buying Agreement Price Flag
    N=No
    Y=Yes

    Y/N Table Edit

    38 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    39 LASTUPDDTTM 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.
    40 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID