CUST_SHIPTO_OPT

(SQL View)
 Index Back

Ship To Customer Options

This table stores the shipping related information associated with a customer. This information will be defaulted to the quotation and sales order during processing.

SELECT A.SETID , A.CUST_ID , B.EFFDT , B.EFF_STATUS , B.SHIP_TYPE_ID , B.SHIP_TYPE_ID_EXP , B.SHIP_PRIOR_FLAG , B.SHIP_PARTIAL_FLAG , B.BCKORDR_CNCL_FLAG , B.LANGUAGE_CD , B.SHIP_PRIORITY_ID , B.DS_NETWORK_CODE , B.ROW_LASTMANT_OPRID , %DatePart(B.ROW_LASTMANT_DTTM) , B.FREIGHT_TERMS , B.FREIGHT_TERMS_EXP , B.SHIP_EARLY_DAYS , B.SHIP_LATE_DAYS , B.SHIP_PARTIAL_ORD , B.STORE_NUMBER , B.NAFTA_REQ_EXP , B.CCI_REQ_EXP , B.SED_REQ_EXP , B.COO_REQ_EXP , B.AERP , B.INSURANCE_REQD , B.MILITARY_FLG , B.EXPORT_ORDER_FLG , B.CARRIER_ID , B.CARRIER_ID_EXP , B.SHIP_PRIORITY_EXP , B.SINGLE_SHIP_FLAG , B.LABEL_FORMAT_ID2 , B.LABEL_FORMAT_ID3 , B.ALLOW_OVERPICK_FLG , B.MAX_PICK_TOLERANCE , B.STOCKOUT_RATE , B.VMI_REORDER_CHK , B.RANGE_PCT , B.VMI_CUST_FLG , B.VMI_MANAGER , B.BUSINESS_UNIT_OM , B.BUSINESS_UNIT_IN , B.REORD_QTY_OPTION , B.REPL_CALC_PERIOD , B.SELL_CONSIGNED_FLG , B.LOT_CONTROL , B.SERIAL_CONTROL , B.CONTAINER_CONTROL , B.STAGED_DATE_CNTRL , B.DEFAULT_PO FROM PS_RB_INT_CUSTOMER A , PS_BC_SHIPTO_OPT B WHERE A.BO_ID=B.BO_ID

  • Parent record: CUSTOMER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
    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 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    6 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
    7 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
    N=Ship Prior No
    Y=Ship Prior Yes

    Default Value: Y

    8 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL field controls whether or not we allow partial shipments
    N=Single Shipment
    Y=Ship as Items Available

    Default Value: Y

    9 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to determine if the backorder should be canceled for this inventory item.
    N=Cancel Backorder No
    Y=Cancel Backorder Yes

    Default Value: N

    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: PSOPTIONS.LANGUAGE_CD

    11 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
    12 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network code - from ASN EIP
    13 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.
    14 DATE_LAST_MAINT Date(10) DATE This field determines the date of last maintenance.
    15 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    16 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
    17 SHIP_EARLY_DAYS Number(4,0) SMALLINT NOT NULL Number of Days Early
    18 SHIP_LATE_DAYS Number(4,0) SMALLINT NOT NULL Days Allowed After Request Dt
    19 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
    N=Partial Order No
    Y=Partial Order Yes

    Default Value: Y

    20 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
    21 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    22 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    23 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    24 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    25 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm
    26 INSURANCE_REQD Character(1) VARCHAR2(1) NOT NULL Insurance Required

    Y/N Table Edit

    Default Value: N

    27 MILITARY_FLG Character(1) VARCHAR2(1) NOT NULL Military End User Flag

    Y/N Table Edit

    Default Value: N

    28 EXPORT_ORDER_FLG Character(1) VARCHAR2(1) NOT NULL Flag Orders for Export

    Y/N Table Edit

    Default Value: N

    29 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    30 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
    31 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
    32 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
    N=No
    Y=Yes
    33 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID
    34 LABEL_FORMAT_ID3 Character(30) VARCHAR2(30) NOT NULL Ship Container Label Format ID
    35 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.

    Y/N Table Edit

    Default Value: N

    36 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.
    37 STOCKOUT_RATE Number(4,1) DECIMAL(3,1) NOT NULL Desired Stock-In Probability
    38 VMI_REORDER_CHK Character(1) VARCHAR2(1) NOT NULL Reorder Range Check

    Default Value: N

    39 RANGE_PCT Number(2,0) SMALLINT NOT NULL Reorder Range Percentage
    40 VMI_CUST_FLG Character(1) VARCHAR2(1) NOT NULL VMI Enabled Customer

    Default Value: N

    41 VMI_MANAGER Character(30) VARCHAR2(30) NOT NULL VMI Manager
    42 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
    43 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    44 REORD_QTY_OPTION Character(2) VARCHAR2(2) NOT NULL Reorder Quantity Option
    1=EOQ
    2=Min/Max
    3=AOQ
    4=Static Reorder Qty
    45 REPL_CALC_PERIOD Number(3,0) SMALLINT NOT NULL Replenish Calc Period (Days)
    46 SELL_CONSIGNED_FLG Character(1) VARCHAR2(1) NOT NULL Goods Consigned at Customer

    Default Value: N

    47 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control

    Default Value: N

    48 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control

    Default Value: N

    49 CONTAINER_CONTROL Character(1) VARCHAR2(1) NOT NULL Container Control

    Default Value: N

    50 STAGED_DATE_CNTRL Character(1) VARCHAR2(1) NOT NULL Staged Date Control

    Default Value: N

    51 DEFAULT_PO Character(25) VARCHAR2(25) NOT NULL Customer PO Number