SHIPTO_LOC_EVW

(SQL View)
Index Back

Ship To Location eView

EIP view to support loading and changing Locations and Ship To Locations.

SELECT A.SETID , A.SHIPTO_ID , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.DS_NETWORK_CODE , A.DS_NET_SETID , A.BUSINESS_UNIT_IN , A.BUSINESS_UNIT_RECV , A.PO_EXP_RECEIPT , A.SETID_REGION , A.REGION_CD , ' ' , A.COPY_TO_PO , A.PUBLIC_FLG , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_SHIPTO_TBL A

  • Related Language Record: SHIPTO_LOCEVWLG
  • # 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 Effective Date

    Default Value: %date

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

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

    Prompt Table: DS_NETHDR_VW

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

    Prompt Table: SP_SETID_NONVW

    9 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: SP_BUIN_NONVW

    10 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

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    13 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

    14 COMMENTS_2000 Long Character CLOB Comment Text
    15 COPY_TO_PO Character(1) VARCHAR2(1) NOT NULL Copy to Purchase Order

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    17 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description
    18 BUILDING Character(10) VARCHAR2(10) NOT NULL Building #
    19 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor #
    20 SECTOR Character(10) VARCHAR2(10) NOT NULL Sector
    21 JURISDICTION Character(5) VARCHAR2(5) NOT NULL Jurisdiction
    22 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
    23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    24 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    25 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    26 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    27 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    28 CITY Character(30) VARCHAR2(30) NOT NULL City
    29 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    30 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    31 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    32 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    33 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    34 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    35 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    36 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    37 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    38 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    39 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    40 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
    41 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    42 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
    43 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    44 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID

    Prompt Table: BCT_SHL_INV_VW
    Set Control Field: LABEL_FORMAT_ID2

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

    Prompt Table: BCT_SHC_INV_VW
    Set Control Field: LABEL_FORMAT_ID3

    46 USG_LBL_FORMAT_ID Character(30) VARCHAR2(30) NOT NULL Item Usage Label Format

    Prompt Table: BCT_USG_INV_VW
    Set Control Field: USG_LBL_FORMAT_ID