urchas|ng Usefu| Scr|pt

Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 2 of 14

@ab|e of Content


1 kev|s|ons 3
2 Introduct|on 3
3 Deta||s 3



Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 3 of 14

1 kev|s|on n|story
1racklng of all revlslons of Lhls documenL requlres a revlslon number Lhe daLe of Lhe revlslon and commenLs Lo
lndlcaLe Lhe changes made
kev|s|on Date Ld|tor Changes
100 2SepL2011 1eang MM lnlLlal creaLlon of Lhe documenL








2 Introduct|on
1hls documenL deLalls Lhe useful scrlpL used Lo exLracL Lhe 8/C daLa

3 Deta||s

31 Check not|f|cat|on for a spec|f|c k]C
SLLLC1 *
l8CM
ASWl_nC1lllCA1lCnS
WPL8L 1 1
and sub[ecL llke MA883018143

noLe 8eplace MA883018143 wlLh C or 8 number


32 Check |cata|ogs re|ated data
selecL LlprL_lLem_ld Llplanguage Llporg_ld Llpsuppller_ld LlplLem_source_Lype Llpsearch_Lype
Llpprlmary_caLegory_ld Llpprlmary_caLegory_name
LlplnLernal_lLem_ld LlplnLernal_lLem_numLlpsuppller Llpsuppller_parL_num
LlpSuLlL8_A81_Auxlu LlpmanufacLurer LlpmanufacLurer_parL_num
LlpdescrlpLlon
1LnuM_8ASL_A118l8u1L11LnuM_8ASL_A118l8u1L21LLexL_8ASL_A118l8u1L1
LlprequesL_ld LlpcreaLed_by LlplasL_updaLed_by LlplasL_updaLe_daLe LlpcreaLlon_daLe
clpprlce_Lype clporg_ld clpunlL_prlce clpcurrency clpunlL_of_measure clcaLalog_name
clorg_ld
from
apps lCx_CA1_l1LMS_1L Llp
lnner [oln appslCx_CA1_l1LM_8lCLS clp on clprL_lLem_ldLlprL_lLem_ld
lnner [oln appslCx_CA1_l1LMS_8 cl on clrL_lLem_ldLlprL_lLem_ld
where Llporg_ld86

noLe 8eplace 86 wlLh Cu ld wlsh Lo exLracL

33 Check Approved ks but w|th no C created (outstand|ng ks)
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 4 of 14

SLLLC1
prl* prhsegmenL1 prhcreaLlon_daLe prhAuLhorlzaLlon_sLaLus
l8CM
appsC_8LCulSl1lCn_LlnLS_ALL prl
lnnL8 !Cln appsC_8LCulSl1lCn_PLAuL8S_ALL prh Cn prl8LCulSl1lCn_PLAuL8_lu
prh8LCulSl1lCn_PLAuL8_lu
WPL8L prlllne_locaLlon_ld ls null
and prhAuLhorlzaLlon_sLaLusA8CvLu


34 @o set sess|on date format
alLer sesslon seL nls_daLe_formaL mmddyyyy hh24mlss


3S Lxtract ks wh|ch pend|ng at a spec|f|cs emp|oyees approva|
SLLLC1 rhasegmenL1appSLCuLnCL_nuM appA8CvL8_lu perluLL_nAML
appA8CvL8_1?L appS1A1uS appCCMMLn1S
app* per*
l8CM ASC_A8CvAL_LlS1_LlnLS app
lnnL8 !Cln ASC_A8CvAL_LlS1_PLAuL8S alh Cn appA8CvAL_LlS1_PLAuL8_lu
alhA8CvAL_LlS1_PLAuL8_lu
lnnL8 !Cln ASC_8LCulSl1lCn_PLAuL8S_ALL rha Cn alhWl_l1LM_kL? rhaWl_l1LM_kL?
LLl1 Cu1L8 !Cln ASL8_LCLL_v7 per Cn appA8CvL8_lu perL8SCn_lu
WPL8L
rhaauLhorlzaLlon_sLaLusln 8CCLSS Anu C8C_lu86 and person_ld3633
C8uL8 8? appSLCuLnCL_nuM

noLe 8eplace 86 wlLh Cu ld wlsh Lo exLracL person_ld wlLh Lhe pendlng approver and Lhe ln 8CCLSS wlLh
Lhe 8 auLhorlzaLlon process


36 Check the status of a emp|oyee |n the workf|ow
SLLLC1 *
l8CM
ASWl_LCCAL_8CLLS
WPL8L 1 1
Anu uL8(ulSLA?_nAML) LlkL ZAlnA8 8ln1l MAnAl

noLe 8eplace ZAlnA8 8ln1l MAnAl wlLh Lhe employee name





37 Check LkkD [ob h|story]status
SLLLC1
lCuSL8_CCnCu88Ln1_8CC8AM_nAMLluuSL8_nAML lC88LCuLS1_lu
lC8A8Ln1_8LCuLS1_lu
lC8PASL_CCuL lC8S1A1uS_CCuL lC88LCuLS1_uA1L lC8AC1uAL_S1A81_uA1L
lC8AC1uAL_CCMLL1lCn_uA1L
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page S of 14

lC8CCMLL1lCn_1Lx1lC8A8CuMLn1_1Lx1 lC88LSCnSl8lLl1?_lu
l8CM
ASlnu_CCnCu88Ln1_8LCuLS1S lC8 ASlnu_CCnCu88Ln1_8CC8AMS_1L
lCASlnu_uSL8 lu
WPL8L
lC8AC1uAL_S1A81_uA1L 8L1WLLn 10082010 000000 Anu 10102010 233939
Anu lCCCnCu88Ln1_8CC8AM_lu lC8CCnCu88Ln1_8CC8AM_lu
Anu lC88LCuLS1Lu_8? luuSL8_lu
Anu lCuSL8_CCnCu88Ln1_8CC8AM_nAML llke Wu lnvenLory lnbound 1ransacLlon lmporL
and luuSL8_nAML MAL_LM1l

noLe 8eplace sLarL daLe and end daLe program name and user name


38 Check the emp|oyee and re|ated user data
selecL ouser_nameflasL_namefeffecLlve_end_daLefemall_addressfemployee_number
from
per_people_f f fnd_user o
where femployee_number MAL43280
and fperson_ld oemployee_ld (+)
and fperson_Lype_ld 6

noLe 8eplace MAL43280 wlLh employee lu


39 |st out C |nformat|on k |nformat|on for a |cata|og contract number

selecL pohsegmenL1prhsegmenL1 as 8numprlllne_locaLlon_lu prlcreaLlon_daLe prl*
from appspo_requlslLlon_llnes_all prl
lefL ouLer [oln appspo_requlslLlon_headers_all prh on prlrequlslLlon_header_ldprhrequlslLlon_header_ld
lefL ouLer [oln appspo_llne_locaLlons_all poll on prlllne_locaLlon_ldpollllne_locaLlon_ld
lefL ouLer [oln appspo_llnes_all pol on pollpo_llne_ldpolpo_llne_ld
lefL ouLer [oln appspo_headers_all poh on polC_header_ldpohC_header_ld
where blankeL_po_header_ld493444

noLe 8eplace 493444 wlLh Lhe conLracL purchase agreemenL's header lu

310 Check k Approva| |st

SLLLC1 rhasegmenL1 appCCMMLn1S app* per*
l8CM ASC_A8CvAL_LlS1_LlnLS app
lnnL8 !Cln ASC_A8CvAL_LlS1_PLAuL8S alh Cn appA8CvAL_LlS1_PLAuL8_lu
alhA8CvAL_LlS1_PLAuL8_lu
lnnL8 !Cln ASC_8LCulSl1lCn_PLAuL8S_ALL rha Cn alhWl_l1LM_kL? rhaWl_l1LM_kL?
LLl1 Cu1L8 !Cln ASL8_LCLL_v7 per Cn appA8CvL8_lu perL8SCn_lu
WPL8L rhaSLCMLn11 86189064

noLe 8eplace 86189064 wlLh Lhe 8 number



Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 6 of 14

311 Check the data |n emp|oyee stag|ng tab|e (nk orac|e |nterface)
selecL *
from appsapxwd_psfL_emp_sLaglng


312 @o check a Cs act|on h|story
selecL pohasegmenL1 ah*
from
appspo_acLlon_hlsLory ah
lnner [oln appspo_headers_all poha on pohapo_header_ldahob[ecL_ld
where
pohasegmenL1MA883018143

noLe 8eplace MA883018143 wlLh Lhe C number


313 @o check the report|ng superv|sor for an emp|oyee
selecL ppflasL_nameppfemployee_numberass*
from appsL8_ASSlCnMLn1S_v7 ass
lnner [oln appsper_people_f ppf on ppfperson_ldassperson_ld
where
ppfemployee_number'MAL34141'

noLe 8eplace MAL34131 wlLh Lhe employee number




314 @o check the k@]Invo|ce |nfor for a C
SLLLC1 rshrecelpL_numspay_on_code rLxnsorganlzaLlon_ld rLxnsLransacLlon_Lype
rLxnslnvolce_sLaLus_codeald1dlsLrlbuLlon_llne_numberrslquanLlLy_recelved
ald1lnvolce_ld
decode(ald1lnvolce_ldnullnull
(selecL lnvolce_num from appsap_lnvolces_all l where llnvolce_ld ald1lnvolce_ld)) lnvolce_num
decode(ald1lnvolce_ldnullnull
(selecL Cancelled_daLe from appsap_lnvolces_all l where llnvolce_ld ald1lnvolce_ld))
Cancelled_daLe
rsllLem_descrlpLlon rLxnsLransacLlon_daLeald1accounLlng_daLeald1perlod_name
phsegmenL1 po_numberpvvendor_name pvsegmenL1 vendor_number phpo_header_ld
l8CM
appsrcv_LransacLlons rLxns
appsrcv_shlpmenL_headers rsh
appsrcv_shlpmenL_llnes rsl
appspo_headers_all ph
appspo_vendor_slLes_all s
appspo_vendors pv
appsap_lnvolce_dlsLrlbuLlons_all ald1
WPL8L rLxnsLransacLlon_Lype 8LCLlvL
Anu rLxnsshlpmenL_header_ld rshshlpmenL_header_ld
Anu rLxnsshlpmenL_header_ld rslshlpmenL_header_ld
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 7 of 14

Anu rLxnsshlpmenL_llne_ld rslshlpmenL_llne_ld
Anu rshrecelpL_num ln (143687)
and phsegmenL1MAA81016039
Anu rLxnsvendor_ld pvvendor_ld
Anu rLxnspo_header_ld phpo_header_ld
Anu rLxnsvendor_ld svendor_ld
Anu rLxnsvendor_slLe_ld svendor_slLe_ld
Anu spay_on_code 8LCLl1
Anu rLxnsLransacLlon_ld ald1rcv_LransacLlon_ld(+)
and rLxnsorganlzaLlon_ld 108

noLe 8eplace MAA81016039 wlLh Lhe C number


31S Check LkDkL [ob h|story]status (arch|ve tab|e)
SLLLC1 lCuSL8_CCnCu88Ln1_8CC8AM_nAMLluuSL8_nAML lC88LCuLS1_lu
lC8A8Ln1_8LCuLS1_lu
lC8PASL_CCuL lC8S1A1uS_CCuL lC88LCuLS1_uA1L lC8AC1uAL_S1A81_uA1L
lC8AC1uAL_CCMLL1lCn_uA1L
lC8CCMLL1lCn_1Lx1lC8A8CuMLn1_1Lx1
l8CM
ASlnu_CCnCu88Ln1_8LCuLS1_A8CPlvL lC8ASlnu_CCnCu88Ln1_8CC8AMS_1L
lCASlnu_uSL8 lu
WPL8L
lCuSL8_CCnCu88Ln1_8CC8AM_nAML llke Wu updaLe lLem ALLrlbuLe
Anu lCCCnCu88Ln1_8CC8AM_lu lC8CCnCu88Ln1_8CC8AM_lu
and lC8AC1uAL_CCMLL1lCn_uA1L 8L1WLLn 01022009 000000 Anu 01032009 233939
Anu lC88LCuLS1Lu_8? luuSL8_lu
Anu luuSL8_nAML AWC8xlnv

noLe 8eplace Wu updaLe lLem ALLrlbuLe wlLh program name sLarL and end daLe and AWC8xlnv
wlLh user name


316 @o check workf|ow ro|e for an ema|| address

SLLLC1 *
l8CM appswf_roles
WPL8L emall_address cusLorder[malayslaxyraLexcom

noLe 8eplace cusLorder[malayslaxyraLexcom wlLh user emall address

317 @o ceck ema|| preference or ro|e for an user

SLLLC1 uuser_name rnoLlflcaLlon_preference remall_address
l8CM appsfnd_user u appswf_local_roles r
WPL8L rname uuser_name
and uuser_name lS_WAvLLnC_MAL

noLe 8eplace lS_WAvLLnC_MAL wlLh user name


Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 8 of 14

318 @o check users w|th spec|f|c respons|b|||ty

selecL furgd* fnd* from appsfnd_user fnd
lnner [oln appsfnd_user_resp_groups_dlrecL furgd on furgduser_ldfnduser_ld
lnner [oln appslnu_8LSCnSl8lLl1?_1L frLl on frLlresponslblllLy_ldfurgdresponslblllLy_ld
where frLlresponslblllLy_name llke MAL C l1


319 @o check k deta||s

selecL prha* prla* prda*
from appsC_8equlslLlon_headers_all prha
lnner [oln appspo_8equlslLlon_llnes_all prla on
prlarequlslLlon_header_ldprharequlslLlon_header_ld
lnner [oln appspo_8eq_dlsLrlbuLlons_all prda on prdarequlslLlon_llne_ldprlarequlslLlon_llne_ld
where prhasegmenL111M001231

noLe 8eplace 11M001231 wlLh 8 number


320 @o check C deta||s

selecL pohasegmenL1 pola* from appsC_PLaders_all poha
lnner [oln appspo_llnes_all pola on polapo_header_ldpohapo_header_ld
lnner [oln appspo_llne_locaLlons_all polla on pollapo_llne_ldpolapo_llne_ld
lnner [oln appspo_dlsLrlbuLlons_all poda on podallne_locaLlon_ldpollallne_locaLlon_ld
where pohasegmenL1'MAA81016039'

noLe 8eplace MAA81016039 wlLh C number

321 @o ||st out cap|ta| k

selecL prhasegmenL1prda*
from appsC_8equlslLlon_headers_all prha
lnner [oln appspo_8equlslLlon_llnes_all prla on
prlarequlslLlon_header_ldprharequlslLlon_header_ld
lnner [oln appspo_8eq_dlsLrlbuLlons_all prda on prdarequlslLlon_llne_ldprlarequlslLlon_llne_ld
where prdaaLLrlbuLe1C

322 @o check the |tem cost |nfo

selecL a*lsegmenL1lllsL_prlce_per_unlL
lmLl_LransacLlons_enabled_flaglsLock_enabled_flag lcosLlng_enabled_flag
from
appscsL_lLem_cosLs a appsmLl_sysLem_lLems l
where lorganlzaLlon_ld 108
and (lsegmenL1 2060771823300 or lsegmenL1 2060771767300)
and lorganlzaLlon_ld aorganlzaLlon_ld
and llnvenLory_lLem_ld alnvenLory_lLem_ld
and acosL_Lype_ld 1 1 lrozen

noLe 8eplace 108 wlLh lnv org ld 2060771823300 2060771767300 wlLh lLem number
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 3 of 14

323 @o check vacat|on ru|e and work||st for a user

SLLLC1
A8AML1L81 AS CranL lr
C8An1LL_kL? AS CranL 1o
S1A81_uA1L
Lnu_uA1L
l8CM
ASlnu_C8An1S
WPL8L
A8AML1L81 CnC_PA

noLe 8eplace CnC_PA wlLh user name


C8An1 vACA1lCn 8uLL
AC1lCn lC8WA8u uelegaLe your response
AC1lCn 18AnSlL8 1ransfer noLlflcaLlon ownershlp
SLLLC1
rr8uLL_lu
rrAC1lCn
rr8CLL lorwarded lrom
rrAC1lCn_A8CuMLn1 lorwarded 1o
rr8LCln_uA1L
rrLnu_uA1L
rr8uLL_CCMMLn1
rr*
l8CM
ASWl_8Cu1lnC_8uLLS rr
WPL8L
S?SuA1L 8L1WLLn rr8LCln_uA1L1 Anu nvL(rrLnu_uA1LS?SuA1L+1)
Anu rr8CLL 1L?_S
C8uL8 8?
rr8uLL_lu

noLe 8eplace 1L?_S wlLh user name



324 @o ||st out the va|ue for C Item category (or f|exf|e|d) segment va|ue

selecL ffsvsegmenL_name ffvv*
from appslnu_lLLx_vALuLS_vL ffvv
lnner [oln appslnu_lu_lLLx_SLCMLn1S_vL ffsv on ffsvflex_value_seL_ldffvvflex_value_seL_ld
where
(ffsvsegmenL_nameurchaslng SubClass or ffsvsegmenL_nameurchaslng Class
or ffsvsegmenL_nameA8C Class )


32S @o ||st out k and C data by C number
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 10 of 14

selecL prhasegmenL1 poha* from appsC_PLaders_all poha
lnner [oln appspo_llnes_all pola on polapo_header_ldpohapo_header_ld
lnner [oln appspo_llne_locaLlons_all polla on pollapo_llne_ldpolapo_llne_ld
lnner [oln appspo_dlsLrlbuLlons_all poda on podallne_locaLlon_ldpollallne_locaLlon_ld
lnner [oln appspo_8equlslLlon_llnes_all prla on prlallne_locaLlon_ldpollallne_locaLlon_ld
lnner [oln appsC_8equlslLlon_headers_all prha on
prlarequlslLlon_header_ldprharequlslLlon_header_ld
lnner [oln appspo_8eq_dlsLrlbuLlons_all prda on prdarequlslLlon_llne_ldprlarequlslLlon_llne_ld
where pohasegmenL110008982

noLe 8eplace 10008982 wlLh C number

326 @o ||st out C Item Category comb|nat|on and category ID

selecL *
from M1L_CA1LCC8lLS_v
where
sLrucLure_ld101

327 @o ||st out rece|v|ng h|story for a C

SLLLC1
*
pohC_PLAuL8_lu
pohC8C_lu
pohSLCMLn11
poh8LvlSlCn_nuM
poh1?L_LCCku_CCuL
pohvLnuC8_lu
(SLLLC1 vLnuC8_nAML l8CM ASC_vLnuC8S WPL8L vLnuC8_lu pohvLnuC8_lu) AS
vLnuC8_nAML
pohvLnuC8_Sl1L_lu
(SLLLC1 vLnuC8_Sl1L_CCuL l8CM ASC_vLnuC8_Sl1LS_ALL WPL8L vLnuC8_Sl1L_lu
pohvLnuC8_Sl1L_lu) AS vLnuC8_Sl1L
pohAu1PC8lZA1lCn_S1A1uS
pohA?_Cn_CCuL
pohuCCuMLn1_C8LA1lCn_ML1PCu
pohSu8Ml1_uA1L
pohA8CvLu_uA1L
pohCLCSLu_uA1L
pohS1A81_uA1L
pohLnu_uA1L
posnLLu_8?_uA1L
pos8CMlSLu_uA1L
pohCLCSLu_CCuL
polC_LlnL_lu
poll1LM_uLSC8l1lCn
polCuAn1l1?
polunl1_8lCL
caLsegmenL1 || || caLsegmenL2 || || caLsegmenL3 AS CA1LCC8?
rcv18AnSAC1lCn_1?L
rcv18AnSAC1lCn_uA1L
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 11 of 14

rcvuLS1lnA1lCn_1?L_CCuL
rcvSu8lnvLn1C8?
rcvCuAn1l1?
rcvh 8LCLl1_nuM
rcvhSPlMLn1_nuM
rcvhACklnC_SLl
l8CM
ASC_PLAuL8S_ALL poh
lnnL8 !Cln ASC_LlnLS_ALL pol Cn pohC_PLAuL8_lu polC_PLAuL8_lu
lnnL8 !Cln ASC_LlnL_LCCA1lCnS_ALL pos Cn pohC_PLAuL8_lu posC_PLAuL8_lu
Anu polC_LlnL_lu posC_LlnL_lu
lnnL8 !Cln ASC_ulS18l8u1lCnS_ALL pod Cn pohC_PLAuL8_lu podC_PLAuL8_lu Anu
polC_LlnL_lu podC_LlnL_lu
LLl1 Cu1L8 !Cln AS8Cv_18AnSAC1lCnS rcv Cn podC_ulS18l8u1lCn_lu
rcvC_ulS18l8u1lCn_lu
LLl1 Cu1L8 !Cln AS8Cv_SPlMLn1_PLAuL8S rcvh Cn rcvSPlMLn1_PLAuL8_lu
rcvhSPlMLn1_PLAuL8_lu
LLl1 Cu1L8 !Cln ASM1L_CA1LCC8lLS_8 caL Cn polCA1LCC8?_lu caLCA1LCC8?_lu
WPL8L 1 1
Anu pohSLCMLn11 ln (MMCn4000008)

noLe 8eplace MMCn4000008 wlLh C number


328 @o ||st out un|t of measurement used

SelecL * from appsM1L_unl1S_Cl_MLASu8L_vL


329 @o ||st out operat|ng un|t

SelecL * from appshr_operaLlng_unlLs


330 @o |n|t|a||ze the operat|ng un|t used

begln
fnd_cllenL_lnfoseL_org_conLexL(86)
end

noLe 8eplace 86 wlLh operaLlng unlL ld


331 @o ||st out operat|ng un|t

selecL organlzaLlon_ld organlzaLlon_code organlzaLlon_name operaLlng_unlL from
appsorg_organlzaLlon_deflnlLlons


332 @o ||st out buyers
selecL fnduser_name ppffull_name ppfemployee_number pa* from appsC_ACLn1S pa
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 12 of 14

lnner [oln appsper_people_f ppf on ppfperson_ldpaagenL_ld
lnner [oln appsfnd_user fnd on fndemployee_ldppfperson_ld


333 @o ||st out C ||ne type

selecL * from appspo_llne_Lypes_Ll


334 @o ||st out payment term

selecL * from appsA_1L8MS_1L


33S @o ||st out charge of account comb|nat|on

selecL * from apps CL_CCuL_CCM8lnA1lCnS

336 @o ||st out da||y currency rate for Mk
selecL * from appsCL_uAlL?_8A1LS
where from_currencyM?8


337 @o ||st out C acceptance data

selecL * from appsC_ACCL1AnCLS poa
lnner [oln appspo_headers_all poha on pohapo_header_ldpoapo_header_ld
where pohasegmenL1MA883018143


noLe 8eplace MA883018143 wlLh C number


338 @o ||st out C]k attachment

selecL * from lnu_A11ACPLu_uCCS_lC8M_vL fadfv
lnner [oln appspo_headers_all poha on pohapo_header_ldfadfvpk1_value
where pohasegmenL1MA883018143

noLe 8eplace MA883018143 wlLh C number


339 @o ||st out charge of account segment va|ue


SLLLC1 Alu_lLLx_S18uC1u8L_CCuL
8lu_lLLx_CCuL
LLAnCuACL
ulLLx_vALuL
LuLSC8l1lCn
LlLLx_vALuL_MLAnlnC
8lLLx_vALuL_SL1_lu
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 13 of 14

8ALlCA1lCn_CCLuMn_nAML
8SLCMLn1_nAML
ClLLx_vALuL_SL1_nAML
ulLLx_vALuL_lu
l8CM ASfnd_ld_flex_sLrucLures A
ASfnd_ld_flex_segmenLs 8
ASfnd_flex_value_seLs C
ASfnd_flex_values u
ASfnd_flex_values_Ll L
WPL8L Alu_lLLx_nuM8lu_lLLx_nuM
Anu Alu_lLLx_CCuLCL#
Anu 8lu_lLLx_CCuLCL#
Anu 8lLLx_vALuL_SL1_luClLLx_vALuL_SL1_lu
Anu ClLLx_vALuL_SL1_luulLLx_vALuL_SL1_lu
Anu ulLLx_vALuL_luLlLLx_vALuL_lu
Anu AALlCA1lCn_lu ln (101201)
Anu LLAnCuACLuS
Anu bld_flex_codeCL#
C8uL8 8? Alu_lLLx_S18uC1u8L_CCuL




340 @o ||st out vendor]supp||er for WDM CU


selecL
dvendor_name
dsegmenL1 CSL_number
evendor_slLe_code
eaddress_llne1
eaddress_llne2
eaddress_llne3
eclLy
esLaLe
ezlp
eprovlnce
ecounLry
subsLr(eaLLrlbuLe1413)
dlasL_updaLe_daLe
dlasL_updaLed_by
dcreaLlon_daLe
dcreaLed_by
dseL_of_books_ld
evendor_slLe_code
evendor_slLe_code_alL
epurchaslng_slLe_flag
epay_slLe_flag
eaddress_llne1
eaddress_llneS_alL
eaddress_llne2
eaddress_llne3
Purchasing Useful Script

Revision 1.00

estern Digital Proprietary and Confidential Page 14 of 14

eclLy
esLaLe
ezlp
eprovlnce
ecounLry
ephone
ecusLomer_num
eshlp_Lo_locaLlon_ld
eblll_Lo_locaLlon_ld
eshlp_vla_lookup_code
efrelghL_Lerms_lookup_code
epaymenL_meLhod_lookup_code
eLerms_daLe_basls
eaccLs_pay_code_comblnaLlon_ld
eprepay_code_comblnaLlon_ld
epaymenL_prlorlLy
eLermS_ld
elnvolce_amounL_llmlL
epay_daLe_basls_lookup_code
elnvolce_currency_code
epaymenL_currency_code
ehold_unmaLched_lnvolces_flag
eap_Lax_roundlng_rule
eauLo_Lax_calc_flag
eauLo_Lax_calc_overrlde
eaddress_llne4
ecounLy
emaLch_opLlon
l8CM Cpo_vendors u
CC_vLnuC8_Sl1LS_ALL L
WPL8L Lvendor_ld uvendor_ld
Anu org_ld ln (86)