CUSTCPY_SOLDO_V

(SQL View)
 Index Back

Cust Copy-Sold-to Opt VW

.View of Sold to customer data on the customer record for copy function. Date Init. Issue # Description 062904 JJM F-CJORG-G7A99 Added VMI fields

SELECT A.SETID , A.CUST_ID , A.EFFDT , A.EFF_STATUS , A.FRT_CHRG_METHOD , A.GRACE_PRICE_DAYS , A.LABEL_FORMAT_ID2 , A.LABEL_FORMAT_ID3 , A.LOAD_PRICE_RULE , A.PROD_ID_SRC , A.PROD_SUBSTITUTE , A.PRICE_PROGRAM , A.EOEP_ARB_ID , A.RESTOCK_FEE_FLAG , A.ADJUST_BAPRC_FLG , A.VMI_ORDER_CONSOL , A.VMI_ORDER_VERIFY , A.RECEIPT_TRACK_FLG , A.UPN_TYPE_CD FROM PS_CUST_SOLDTO_OPT A WHERE %EffdtCheck(cust_soldto_opt,A,%CurrentDateIn)

  • Parent record: CUSTOMER

    • # 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 CUST_CPY_ID Character(15) VARCHAR2(15) NOT NULL Customer Copy ID
    3 ADD_DT Date(10) DATE Customer Added On
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity
    6 GRACE_PRICE_DAYS Number(3,0) SMALLINT NOT NULL Grace Pricing Discount Days
    7 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID

    Prompt Table: BCT_SHL_INV_VW

    8 LABEL_FORMAT_ID3 Character(30) VARCHAR2(30) NOT NULL Ship Container Label Format ID

    Prompt Table: BCT_SHC_INV_VW

    9 LOAD_PRICE_RULE Character(10) VARCHAR2(10) NOT NULL Load Arbitration Plan
    10 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
    C=Customer
    P=UPC
    S=System
    U=Universal

    Default Value: S

    11 PROD_SUBSTITUTE Character(1) VARCHAR2(1) NOT NULL Allow Product Substitutions
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    12 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
    13 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan
    14 RESTOCK_FEE_FLAG Character(1) VARCHAR2(1) NOT NULL Restocking Fee

    Y/N Table Edit

    Default Value: N

    15 ADJUST_BAPRC_FLG Character(1) VARCHAR2(1) NOT NULL Buying Agreement Price Flag
    N=No
    Y=Yes
    16 VMI_ORDER_CONSOL Character(1) VARCHAR2(1) NOT NULL VMI Order Consolidation
    1=Sold To Customer
    2=Ship To Customer
    3=None
    17 VMI_ORDER_VERIFY Character(1) VARCHAR2(1) NOT NULL Order Verification

    Y/N Table Edit

    Default Value: N

    18 RECEIPT_TRACK_FLG Character(1) VARCHAR2(1) NOT NULL Track Receipt

    Y/N Table Edit

    Default Value: N

    19 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type

    Prompt Table: UPN_TYPE_FS