AP_DM_BU

(SQL View)
 Index Back

Company Code view

Company code view

SELECT a.business_unit , a.business_unit_gl , b.currency_cd , a.db_number , c.descr , c.descrshort , a.location , e.building , e.floor , e.sector , e.jurisdiction , e.attn_to , %subrec(ADDRESS_SBR, e) , ' ' , a.hide_sut_flg , a.hide_vat_flg , a.shipto_id FROM ps_bus_unit_tbl_ap a , ps_bus_unit_opt_ap b , ps_bus_unit_tbl_fs c , ps_set_cntrl_rec d , PS_LOCATION_TBL e , ps_set_cntrl_rec f WHERE a.business_unit = c.business_unit AND a.business_unit = d.setcntrlvalue AND d.rec_group_id = 'AP_01' AND d.recname = 'BUS_UNIT_OPT_AP' AND d.setid = b.setid AND b.eff_status = 'A' AND b.effdt = ( SELECT MAX(bb.effdt) FROM ps_bus_unit_opt_ap bb WHERE bb.setid = b.setid AND bb.effdt <= %CurrentDateIn) AND a.business_unit = f.setcntrlvalue AND f.rec_group_id = 'FS_26' AND f.recname = 'LOCATION_TBL' AND f.setid = e.setid AND e.location = a.location AND e.eff_status = 'A' AND e.effdt = ( SELECT MAX(ee.effdt) FROM PS_LOCATION_TBL ee WHERE ee.setid = e.setid AND ee.location = e.location AND ee.effdt <= %CurrentDateIn) AND b.enable_dcm_flg = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
4 DB_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 BUILDING Character(10) VARCHAR2(10) NOT NULL Building #
9 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor #
10 SECTOR Character(10) VARCHAR2(10) NOT NULL Sector
11 JURISDICTION Character(5) VARCHAR2(5) NOT NULL Jurisdiction
12 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
18 CITY Character(30) VARCHAR2(30) NOT NULL City
19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

30 VAT_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL VAT Registration ID
31 HIDE_SUT_FLG Character(1) VARCHAR2(1) NOT NULL Hide Sales Use Tax
32 HIDE_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Hide Value Added Tax
33 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location