BC_SOLDTO_CI_VW

(SQL View)
 Index Back

BC_SOLDTO_CI_VW

This view: BC_SOLDTO_CI_VW has the same structure as the record: BC_SOLDTO_OPTS. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly.

SELECT A.BO_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.PRICE_RULE_CD , A.RESTOCK_FEE_FLAG , A.ADJUST_BAPRC_FLG , A.VMI_ORDER_CONSOL , A.RECEIPT_TRACK_FLG , %subrec(RB_AUDIT_SBR, A) FROM PS_BC_SOLDTO_OPT A

  • 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 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity
    5 GRACE_PRICE_DAYS Number(3,0) SMALLINT NOT NULL Grace Pricing Discount Days
    6 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID
    7 LABEL_FORMAT_ID3 Character(30) VARCHAR2(30) NOT NULL Ship Container Label Format ID
    8 LOAD_PRICE_RULE Character(10) VARCHAR2(10) NOT NULL Load Price Rule
    9 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product ID Source
    C=Customer Product ID
    S=System Product ID

    Default Value: S

    10 PROD_SUBSTITUTE Character(1) VARCHAR2(1) NOT NULL Product Substitute

    Y/N Table Edit

    Default Value: Y

    11 PRICE_PROGRAM Character(6) VARCHAR2(6) NOT NULL Exclusive Pricing ID
    12 PRICE_RULE_CD Character(10) VARCHAR2(10) NOT NULL Price Rule Code

    Prompt Table: RB_ARB_PLAN_VW

    13 RESTOCK_FEE_FLAG Character(1) VARCHAR2(1) NOT NULL Restocking Fee

    Y/N Table Edit

    Default Value: N

    14 ADJUST_BAPRC_FLG Character(1) VARCHAR2(1) NOT NULL Buying Agreement Price Flag

    Y/N Table Edit

    Default Value: N

    15 VMI_ORDER_CONSOL Character(1) VARCHAR2(1) NOT NULL VMI Order Consolidation
    1=Sold To Customer
    2=Ship To Customer
    3=None
    16 RECEIPT_TRACK_FLG Character(1) VARCHAR2(1) NOT NULL Receipt Verification

    Y/N Table Edit

    Default Value: N

    17 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    18 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time