CNT_SHIPTO_VW

(SQL View)
 Index Back

Shipping Locations

06/19/2009 SK 1893227002 Resolved the issue so that voucher tax page fields displays prompt results based on accounts payable business unit.

SELECT SETID , SHIPTO_ID , EFFDT ,EFF_STATUS , DESCRSHORT , DESCR ,COPY_TO_PO , PUBLIC_FLG , DS_NETWORK_CODE , DS_NET_SETID , OPRID ,COMMENT_ID , RANDOM_CMMT_NBR , BUSINESS_UNIT_IN , BUSINESS_UNIT_RECV , PO_EXP_RECEIPT , SETID_REGION , REGION_CD FROM PS_SHIPTO_TBL

  • Related Language Record: SHIPTO_LANG

    • # 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 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

    Prompt Table: SHIPTO_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 COPY_TO_PO Character(1) VARCHAR2(1) NOT NULL Copy to Purchase Order

    Y/N Table Edit

    Default Value: N

    8 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor

    Y/N Table Edit

    Default Value: N

    9 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

    Prompt Table: DS_NETHDR_VW

    10 DS_NET_SETID Character(5) VARCHAR2(5) NOT NULL Distribution Network SetID

    Prompt Table: SP_SETID_NONVW

    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    12 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
    13 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
    14 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: SP_BUNVM_NONVW

    15 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

    Default Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV

    Prompt Table: SP_BU_PM_NONVW

    16 PO_EXP_RECEIPT Character(1) VARCHAR2(1) NOT NULL Send Expected Receipt

    Y/N Table Edit

    Default Value: N

    17 SETID_REGION Character(5) VARCHAR2(5) NOT NULL Region SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    18 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: REGION_CD_PO
    Set Control Field: SETID_REGION