CUST_SOLDTO_OPT

(SQL Table)
 Index Back

Sold-to Customer Options

This table stores the processing information and defaults associated with the Sold To customer. The grace days is used to extend a price to a customer after it's expiration date. The flag for product substitutions indicates whether or not this customer accepts substitutes for products ordered. The Part Num flag indicates whether the customer orders using thier part number or the System product ID. Note: Any field changes made to this record should also be made to sub-record CUST_SLDOPT_SBR Date Init. Issue # Description 081401 JJM DI_EDWONG-17 Inverted CUST_ID, SETID in index 062904 JJM F-CJORG-G7A99 Added VMI fields 072704 JJM R-CJORG-92K66 Added ADJUST_BAPRC_FLG

  • 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_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: CUSTOMER

    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan

    Prompt Table: EOEP_ARB_SO_VW

    6 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity
    7 GRACE_PRICE_DAYS Number(3,0) SMALLINT NOT NULL Grace Pricing Discount Days
    8 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID

    Prompt Table: BCT_SHL_INV_VW

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

    Prompt Table: BCT_SHC_INV_VW

    10 LOAD_PRICE_RULE Character(10) VARCHAR2(10) NOT NULL Load Arbitration Plan

    Prompt Table: EOEP_ARB_LP_VW

    11 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
    C=Customer
    P=UPC
    S=System
    U=Universal

    Default Value: S

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

    Y/N Table Edit

    Default Value: Y

    13 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL

    Prompt Table: EOEP_ARB_PR_VW

    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

    Default Value: 2

    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

    20 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
    21 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.
    22 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID