BC_SHPTO_OPT_VW

(SQL View)
 Index Back

Ship To Options

This table stores the shipping related information associated with a business contact. This information will be defaulted to the quotation and sales order during processing. It is only applicable to Business Contacts that are customers (as indicated by the customer flag on BC).

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

  • Parent record: BC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    5 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
    6 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

    7 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

    8 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

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

    Default Value: PSOPTIONS.LANGUAGE_CD

    10 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
    11 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network code - from ASN EIP
    12 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    13 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
    14 SHIP_EARLY_DAYS Number(4,0) SMALLINT NOT NULL Number of Days Early
    15 SHIP_LATE_DAYS Number(4,0) SMALLINT NOT NULL Days Allowed After Request Dt
    16 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
    N=Partial Order No
    Y=Partial Order Yes

    Default Value: Y

    17 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
    18 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    26 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    27 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
    28 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
    29 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
    N=No
    Y=Yes

    Y/N Table Edit

    30 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID
    31 LABEL_FORMAT_ID3 Character(30) VARCHAR2(30) NOT NULL Ship Container Label Format ID
    32 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

    33 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.
    34 STOCKOUT_RATE Number(4,1) DECIMAL(3,1) NOT NULL Desired Stock-In Probability
    35 VMI_REORDER_CHK Character(1) VARCHAR2(1) NOT NULL Reorder Range Check

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

    48 DEFAULT_PO Character(25) VARCHAR2(25) NOT NULL Customer PO Number
    49 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    50 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.