CV040_Onhand_Qty-V1.0

AIM

CV.040 CONVERSION DATA MAPPING FL Smidth Onhand Inventor Conver!ion

A"thor#

An!h"$ %"mar

Crea Creati tion on Date Date##

&"$ &"$ '() '() *0'* *0'*

La!t +,dated# Do-"ment Re#

/Do-"ment Reeren-e N"m

Ver!ion#

'. 0

Approvals:

/A,,rover '

/A,,rover *

CV.040 Conver!ion Data Ma,,in1

Do- Re# Error# Reeren-e !o"r-e not o"nd

Document Control

Change Record '

Date

Author

Versio n

Change Reference

'(2&"$2 *0'*

An!h"$ %"mar

Drat 'a

No Previo"! Do-"ment

032A"12 *0'*

An!h"$ %"mar

'.0

Modied 5a!ed on the revie6 -omment!.

Reviewers

Name

Position

Pa5$o S. Pere7

So$"tion Ar-hite-t2SCM

&anne Ste1emann Ste1emann Pia 8"5andt Morten!en &a-;"e$ine
8"!ine!! Lead 8a-9 O:-e O:-e 8"!ine!! Lead2 Va$5 8"!ine!! Lead2 8eth$ehem Conver!ion Mana1er Pro=e-t Pro=e-t Mana1er Mana1er A!!i!tant Mana1er.ESD Gro", or Enovia

Distribution

Onhand Inventor Conver!ion Fi$e Re# (>'0*?4@'

v. '.0 B

A,,roa-h

***'3*



Cop No!

Name

"ocation

'

Li5rar Ma!ter

Pro=e-t Li5rar

*

Pro=e-t Mana1er

( 4

Note #o $olders:

I o" re-eive an e$e-troni- -o, o thi! do-"ment and ,rint it o"t) ,$ea!e 6rite o"r name on the e;"iva$ent o the -over ,a1e) or do-"ment -ontro$ ,"r,o!e!. I o" re-eive a hard -o, o thi! do-"ment) ,$ea!e 6rite o"r name on the ront -over) or do-"ment -ontro$ ,"r,o!e!.


v. '.0 B

A,,roa-h

*(*'3(



Content!

Do-"ment Contro$....................................................................................... ii Introd"-tion............................................................................................ .... 4 P"r,o!e................................................................................................. 4 8a-91ro"nd........................................................................................... 4 S-o,e and A!!"m,tion............................................................................... > S-o,e.................................................................................................... > A!!"m,tion........................................................................................... > Pre2re;"i!ite................................................................................................ @ A,,roa-h..................................................................................................... Finan-ia$ A,,roa-h................................................................................  Data C$ean2",............................................................................................. 3 Va$idation.................................................................................................. '0 Re-on-i$iation...................................................................................... '0 Interim Pro-e!!#........................................................................................ '' Intera-e Pro-e!! Sta1e!........................................................................... '* Te-hni-a$ Inormation  Onhand Inventor................................................'( Intera-e ,arameter#........................................................................... '@ Etra-t Fi$e Lao"t.................................................................................... ' O,en and C$o!ed I!!"e! or thi! De$ivera5$e.............................................'3 O,en I!!"e!......................................................................................... '3 C$o!ed I!!"e!.......................................................................................'3 Onhand Inventor Conver!ion Fi$e Re# (>'0*?4@'

v. '.0 B

A,,roa-h

*4*'34




v. '.0 B

A,,roa-h

*>*'3>


Do- Re#

%ntroduction

Purpose An im,ortant re;"irement i! to $oad "antit on hand data rom ei!tin1 !!tem! into Ora-$e a,,$i-ation!. The "antit on hand 6i$$ 5e on$ re;"ired or tho!e item! have avai$a5$e"nre!erved ;"antit on hand.

The o5=e-tive o thi! do-"ment i! to de!-ri5e the "n-tiona$ re;"irement! or the $oadin1 o "antit on hand data rom Eterna$ !!tem! into Ora-$e. The intera-e 6i$$ -on!i!t o a Comma Se,arated Varia5$e CSVB $e tem,$ate! 5ein1 1enerated rom ei!tin1 data and made avai$a5$e Ora-$e a,,$i-ation! in an a1reed dire-tor. The $e 6i$$ then 5e $oaded Ora-$e thro"1h !tandard intera-e!.

&ac'ground The inormation in thi! do-"ment ha! 5een dened or -onver!ion o o nhand ;"antit rom At$a! H other vario"! IT !!tem! to R'*.


v. '.0 B

A,,roa-h

*@*'3@


Do- Re#

(cope and Assumption

(cope •

•

•

•

•

•

•

•

Co!tin1 method i! Avera1e -o!tin1 and mi1rated !to-9 6i$$ !ho6 -"rrent avera1e -o!t o item. It doe! not ho$d an hi!tori- -o!t. Conver!ion team 6i$$ ,rovide the ma,,in1 $e and -$ean!ed on hand data $e ma,,ed 6ith Enovia item n"m5er to 5"!ine!!. 8"!ine!! 6i$$ ,rovide !i1n2o 5eore data 6i$$ 5e $oaded into Ora-$e Prod"-tion environment. Data mi1rated 6i$$ 5e on the item -onver!ion date) It 6i$$ not mi1rate 6ith hi!tori- date. I detai$! $i9e -o"ntr o ori1in) !",,$ier and !to-9 a1in1 need to nd o"t ater mi1ration) thi! 6o"$d 5e o"t!ide ora-$e. Mi1rated on hand data 6i$$ not ho$d !"-h detai$!. No Pro=e-t !,e-i- inventor 6i$$ 5e mi1rated. Conver!ion team 6i$$ ,rovide the mi1rated on hand data rom the ora-$e !!tem in !,read!heet 6ith Enovia item n"m5er. Sim"$taneo"!$ PD8 n"m5er and Enovia item n"m5er ma,,in1 $e 6i$$ 5e ,rovided re-eived rom Enovia Team. 8"!ine!! 6i$$ 5e re-on-i$in1 the data 5a!ed on the!e * $e!. Thi! do-"ment 6i$$ in-$"de vario"! ,ro-e!! re$ated to on hand. Pro-e!! o6ner -an ,rovide more detai$!) i re;"ire re$ated to them. Conver!ion 6i$$ ta9e ,$a-e or the 6areho"!e a! ,er !heet avai$a5$e at 5e$o6 $in9 and a,,roved 5 5"!ine!!# htt,#J!2 team!ite!,ro=e-tG$o5a$ITPro=e-t!Porta$Strate1i-Pro=e-t!CenterERPR *K*01enera$K*0-ro!!25"!ine!!DataK*0Conver!ionInventor K*0Data-onver!ionK*0P$annin1K*0SheetK*0+PDATESK*0FROM K*08ET
Assumption •


v. '.0 B

The data he$d in Ora-$e i! dened a! that data re;"ired 5 Ora-$e A,,$i-ation! to !",,ort the a,,roved !!tem de!i1n a! !i1ned o 5 A,,roa-h

**'3


Do- Re#

FLSmidth "!er!. An additiona$ data re;"ired 5 non2Ora-$e !",,ortin1 !!tem! 6i$$ 5e mana1ed 5 other ,ro-ed"re! and i! do-"mented e$!e6here and not the re!,on!i5i$it o thi! ,ro=e-t or do-"ment. •

•

•

•

•


v. '.0 B

Pre2re;"i!ite! in thi! do-"ment are dened and va$idated 5 re!,e-tive o6ner. On hand data H other re$ated detai$! ,rovided 5 the 5"!ine!! i! va$idated and veried 5 re!,e-tive 5"!ine!! "!er!. Ma,,in1 o PD8 n"m5er to ne6 item n"m5er 1enerated 5 enovia i! ,rovided 5 Enovia team) 6hi-h 6i$$ Jo6 to Ora-$e in term! o item reeren-e Conver!ion. C"rrent inventor ha! on$ materia$ -o!t o item!. 8"!ine!! "!er 6i$$ red"-e the inventor in the o$d 6areho"!e !!tem) 6hen the ,rovide the on hand data d"rin1 -"t over ,eriod or mi1ration into ora-$e and !ame !ho"$d a$!o reJe-t in nan-ia$ !!tem 6ith -onver!ion a--o"nt.

A,,roa-h

*?*'3?


Do- Re#

Pre)re*uisite The o$$o6in1 ,re2re;"i!ite re;"ired or thi! intera-e to r"n# •

•

•

Enovia ha! ,"!hed a$$ the item! in the ora-$e and a!!i1ned it to a$$ the inventor or1ani7ation!. A$$ the re;"ired item! have 5een made a-tive and re;"ired attri5"te! are ",dated. A$$ re;"ired $o-ator! are dened or the a!!et !"5inventor 6ith a$$ inventor !tr"-t"re. Detai$! o 6arho"!e !tr"-t"re i! avai$a5$e at 5e $o6 $in9#

htt,#J!2 team!ite!,ro=e-tG$o5a$ITPro=e-t!Porta$Strate1i-Pro=e-t!CenterERPR*K*01 enera$K*0-ro!!25"!ine!!DataK*0Conver!ionInventorK*0Data-onver!ion K*0P$annin1K*0SheetK*0+PDATESK*0FROMK*08ET

v. '.0 B

Data ,rovided to $oad 5 5"!ine!! !ho"$d 5e a! ,er ne6 +OM rom Ora-$e. Conver!ion team 6i$$ ,rovide the Item and +OM detai$! in advan-e to 5"!ine!! to va$idate the data 5eore it! ,rovide to mi1rate.

•

Pro=e-t data i! $oaded i ,ro=e-t !,e-i- inve ntor i! re;"ired to $oad.

•

Conver!ion a--o"nt i! !et",.

A,,roa-h

*3*'33


Do- Re#

Approach

The Tran!a-tion O,en Intera-e API mt$tran!a-tion!intera-eB 6i$$ 5e "!ed to $oad the inventor rom data ,rovided in E-e$ ormat rom the $e1a- !!tem. The intermediate E-e$ $e i! !"11e!ted !o that an !ite 6i$$ 5e a5$e to "!e thi! ,ro-e!! 6itho"t re;"irin1 ,ro1rammin1 -han1e!. Intera-e 6i$$ "!e a Mi!-e$$aneo"! Re-ei,t I!!"e to ",date the inventor 5a$an-e! or the item! to 5e ,ro-e!!ed.

•

•

•

•

•

•

•

•

•

•

•


v. '.0 B

Deve$o,er! to "ti$i7ed de!i1ned $e ormat a! atta-hed in thi! do-"ment. The im,$ementation !ite 6i$$ -o$$e-t the data in the E-e$ $e tem,$ate. Deve$o,er! 6i$$ 5"i$d a !;$ ,ro-ed"re to read the in,"t $e and 6rite it to the -"!tom ta5$e. C"!tom va$idation 6i$$ 5e a,,$ied on the -"!tom ta5$e 5eore movin1 it inventor intera-e. The inventor tran!a-tion API i! r"n to $oad data into the inventor ta5$e!. Reeren-e Ora-$e man"a$ Man"a-t"rin1 API! and O,en Intera-e! Man"a$) -ha,ter @ Ora-$e Inventor O,en Intera-e! and API! Reeren-e Meta$in9 arti-$e Sam,$e QMS O,en Intera-e In!ert S-ri,t!  Eam,$e! ho6 to In!ert into Tran!a-tion O,en Intera-e ID (>>(>.' Re;"e!t !ho"$d ,ro-e!! on$ one inventor or1ani7ation re-ord 5a!ed on the MFG# Or1ani7ationID ,ro$e !e$e-ted. So"r-e 6i$$ 5e !e$e-ted Mi!-e$$aneo"! Re-ei,t i ;"antit i! ,o!itive and Mi!-e$$aneo"! I!!"e i ;"antit i! ne1ative. S!date 6i$$ 5e ta9en or tran!a-tiondate i not ,rovided. I Item n"m5er i! not o"nd in on hand date) nd the item n"m5er "!in1 -ro!! reeren-e Conver!ion 5a!ed on the PD8 n"m5er ,rovided.

•

Conver!ion ,ro1ram !ho"$d have the ,rovi!ion to on$ va$idate the data.

•

Va$idation i! ,rovided in the !e,arate !e-tion.

A,,roa-h

*'0*'3'0


Do- Re#

+inancial Approach •

PD& Number

8"!ine!! "!er 6i$$ ,rovide inventor va$"ation re,ort or 5oth 9ind o !to-9 Sto-9 mi1ratin1 in ora-$e) Sto-9 !ta! in !o"r-e !!temB.Qe 6o"$d need to 1et the !i1n2o rom nan-e de,artment that inventor va$"ation i! mat-hin1 a! ,er GL 5eore 6e -an !tart the on hand data mi1ration. 8"!ine!! 6i$$ ,rovide the re,ort to nan-e de,artment in 5e$o6 ormat#

#otal ,uantit

•

•

Reserved ,t-,t to remain in source sstem

Available ,t,uantit going to migrate in .racle

Finan-e de,artment 6i$$ ,rovide !i1n2o on the inventor va$"ation mat-hin1 6ith GL. 8"!ine!! 6i$$ remove the avai$a5$e inventor rom !o"r-e !!tem) 6hi-h need! to mi1rate to Ora-$e. Thi! tran!a-tion !ho"$d -reate 5e$o6 a--o"ntin1 tran!a-tion in GL. So"r-eInventorAC

Cr

Conver!ionAC •

Ora-$eInventorAC


v. '.0 B

Dr

On-e on hand data i! mi1rated to Ora-$e) It 6i$$ -reate 5e$o6 a--o"ntin1 entr in GL. Conver!ionAC

•

Average unit Cost of item

Cr Dr

The!e ,ro-e!!e! 6i$$ 9no-92o a$$ the 5a$an-e in -onver!ion a--o"nt and thro"1h GL ) it inventor va$"ation !ittin1 in Ora-$e and non2ora-$e !!tem -an 5e vie6ed.

A,,roa-h

*''*'3''


Do- Re#

Data Clean)up Qareho"!e a,,roa-h to ,re,are !o"r-e !!tem) 5eore -onver!ion data -o"$ d 5e etra-ted rom !o"r-e !!tem# •

•

A$$ the "antit 6i$$ 5e ad="!ted in !o"r-e !!tem a! ,er ,h!i-a$ ;"antit. A$$ the -o!t 6i$$ 5e ad="!ted in !o"r-e !!tem) 5eore etra-tin1 data and the -han1e! 6i$$ 5e reJe-tin1 in nan-ia$ 5a$an-e in !o"r-e !!tem.

•

Com,$ete the !-ra,,in1 ,ro-e!! or a$$ ,endin1 item!.

•

Qareho"!e 5a$an-e reJe-t! -orre-t$ in nan-ia$ !!tem.

8e$o6 i! a de!-ri,tion o the data -$ean2", eort! re;"ired or the -onver!ion o on hand data# •

•

•

•

•

•

•


v. '.0 B

A,,roved and Veried Ma,,in1 $e 6i$$ 5e ,rovided 5 Enovia team) 6hi-h 6i$$ -ontain the ma,,in1 o PD8 n"m5er 6ith ne6 item n"m5er!. A$$ the item! 6hi-h 6i$$ 5e ,rovided to mi1rate 6i$$ 5e "nre!ervedavai$a5$e !to-9) 6hi-h i! etra ater "$$$in1 ei!tin1 !a$e! order!. 8"!ine!! 6i$$ ,rovide the tota$ inventor va$"ation re,ort in-$"din1 -ommitted H non2-ommitted !to-9) to ta9e !i1n2o rom nan-ia$ 5eore mi1ration. 8"!ine!! 6i$$ ,rovide the data in the a1reed ormat a! ,er tem,$ate atta-hed in thi! do-"ment. Thi! Sheet 6i$$ have on$ "nre!erved !to-9 6ith the ne6 +OM. Conver!ion team 6i$$ ,rovide detai$! to S, are Part! $ead a5o"t mi!!in1 PD8 n"m5er! rom Ora-$e H Ma,,in1 $e) 5a!ed on the data re-eived. Thi! !te, ma need to re,eat and 6i$$ a$!o 5e -arried o"t m"-h 5eore -"t2o to minimi7e the ri!9 o ndin1 !"-h item! d"rin1 -"t2o. Re;"ired Item !tat"! 6i$$ 5e -han1ed to A-tive Onhand to 5e mi1rated need to 5e red"-ed rom !o"r-e !!tem and a--o"ntin1 entr or !"-h tran!a-tion 6i$$ 5e 6ith -onver!ion a--o"nt in GL.

A,,roa-h

*'**'3'*


Do- Re#

•


v. '.0 B

C$ean!ed onhand data 6i$$ 5e mi1rated to ora-$e 5 ea-h 6areho"!e ater va$idation i! ,a!!ed on it) "!in1 the -onver!ion a--o"nt a! ,rovided 5 nan-e.

A,,roa-h

*'(*'3'(


Do- Re#

Validation Fo$$o6in1 va$idation !ho"$d 5e -he-9ed and data !ho"$d not ,ro-e!!) an vio$ation !ho"$d 5e !ho6n in the o"t,"t $e.

•

Item i! va$id or the 6areho"!e) I PD8 n"m5er i! ,rovided) -orre!,ondin1 item n"m5er 6i$$ 5e derived 5a!ed on the item -ro!! reeren-e.

•

+OM i! va$id or -orre!,ondin1 item.

•

Item -o!t i! non2ne1ative.

•

Materia$) Materia$ Overhead) OSP) Re!o"r-e and overhead -o!t !"m i! e;"iva$ent to +nit -o!t.

•

S"5inventor i! va$id or Qareho"!e and item.

•

Lo-ator i! va$id or 6areho"!e) !"5inventor and item.

•

Pro=e-t and ta!9 i! va$id i ,rovided.

•

Rea!on -ode i! va$id.

Reconciliation

Ma,,in1 !heet and Etra-t 6i$$ 5e ,rovided rom Ora-$e. Ma,,in1 !heet 6i$$ -ontain the ma,,in1 o PD8 n"m5er 6ith ne6 item n"m5er. Etra-t $e 6i$$ 9ee, the ne6 item n"m5er) "antit) Qareho"!e) S"5inventor) "nit -o!t and $o-ator inormation.

8"!ine!! 6i$$ re-on-i$e the data 5a!ed on the etra-t to ,rovide the !i1n o.


v. '.0 B

A,,roa-h

*'4*'3'4


Do- Re#

%nterim Process: Thi! ,ro-e!! 6i$$ 5e "ti$i7in1 ater R* $ive and 6hi$e 5"!ine!! 6i$$ 5e ,ro-e!!in1 their -"!tomer order! rom their o$d !!tem and rom Ora-$e !im"$taneo"!$. The method to ,ro-e!! order i! not in !-o,e o thi! do-"ment. In thi! !e-tion 6e are trin1 to 5rie the ,ro-e!! in non ora-$e !!tem to "$$$ -"!tomer order) 6hi$e ora-$e i! $ive and on hand i! divided 5et6een ora-$e and non ora-$e !!tem.

There are o$$o6in1 !-enario ,o!!i5$e ater 1o $ive in Ora-$e) 6hi$e "$$$in1 demand#

(r! No!

(cenario

Process

/

+ul0lling the .riginal sales order

.rder will be processed in old sstem! "i'e its happening currentl!

1

(ales order gets cancelled

Cancel the (ales order in source sstem and transfer the *uantit to .racle

2

(ales order *uantit is reduced b customer

(hip the re*uired *uantit from source sstem and transfer rest *uantit to .racle!

3

(ales order *uantit is increased b customer

Chec' if su4cient *uantit is available in source sstem! %f not5 a process will be re*uired to reduce the re*uire *uantit from oracle and migrate same in source sstem to ful0ll the sales order!


v. '.0 B

A,,roa-h

*'>*'3'>


Do- Re#

%nterface Process (tages On
'. Gather "antit on hand detai$! or tho!e item! have ;"antit on hand 6hen -"to. *. Qrite detai$! to intera-e $e. (. Pa!! -om,$eted $e to the DATA dire-tor. MISCDIRINVO<in. 4. Im,ort to Ora-$e a,,!. i. In!ert the data into a !ta1in1 ta5$e ii. Find Enovia item n"m5er or -orre!,ondin1 PD8 n"m5er. iii. Va$idate i the data i! O9 then move to Ora-$e o,en intera-e iv. Perorm Ora-$e !tandard API to 5rin1 the ;"antit on hand data into Ora-$e ma!ter ta5$e >. I an error! are o"nd move $e to MISCDIRINVO<o"terror and re!o$ve error!. @. I the $e i! ,ro-e!!ed !"--e!!"$$ move $e to MISCDIRINVO<o"t,ro-e!!ed.


v. '.0 B

A,,roa-h

*'@*'3'@


Do- Re#

#echnical %nformation 6 .nhand %nventor (ample (," for "oading %nterface #able From API do-"ment!B Insert into mtl_transactions_interface( transaction_uom, transaction_date, source_code, source_line_id, source_header_id, process_flag , transaction_mode , lock_flag , locator_id , last_update_date , last_updated_by , creation_date , created_by , inventory_item_id , subinventory_code, organization_id, transaction_quantity , primary_quantity , transaction_type_id , dst_segment1, dst_segment2, dst_segment3, dst_segment, dst_segment!, transaction_interface_id" #$%&' ( )'a), **transaction uom +$-', **transaction date ).iscellaneous /eceipt), **source code 00, **source line id 00, **source header id 1, **process flag 3 , **transaction mode 2 , **lock flag 1201 , **locator id +$-' , **last update date , **last updated by +$-' , **creation date , **created by 1121 , **inventory item id )4I),**rom subinventory code 1, **organization id 1, **transaction quantity 1, **5rimary quantity 2, **transaction type id Onhand Inventor Conver!ion Fi$e Re# (>'0*?4@'

v. '.0 B

A,,roa-h

*'*'3'


Do- Re#

)1), **segment1 account combination )!2), **segment2 account combination )!2!), **segment3 account combination )), **segment account combination )), **segment! account combination 000 6transaction interface id "7

(upporting %nformation

From API do-"ment!B

O,en Tran!a-tion Intera-e Ora-$e Inventor ,rovide! an o,en intera-e or o" to $oad tran!a-tion! rom eterna$ a,,$i-ation! and eeder !!tem!. The!e tran!a-tion! -o"$d in-$"de !a$e! order !hi,ment tran!a-tion! rom an Order Mana1ement !!tem other than Ora-$e Order Mana1ement) or the -o"$d 5e !im,$e materia$ i!!"e!) re-ei,t!) or tran!er! $oaded rom data -o$$e-tion devi-e!. The o$$o6in1 tran!a-tion t,e! are !",,orted 5 thi! intera-e# U Inventor i!!"e! and re-ei,t! in-$"din1 "!er2dened tran!a-tion t,e!B U S"5inventor tran!er! U Dire-t interor1ani7ation tran!er! U Intran!it !hi,ment! U QIP -om,onent i!!"e! and ret"rn! U QIP a!!em5$ -om,$etion! and ret"rn! U Sa$e! order !hi,ment! U Inventor avera1e -o!t ",date! U LPN Pa-9 U +n,a-9 U S,$it Tran!a-tion! U Inventor Lot S,$it Mer1e Tran!$ate Tran!a-tion! Thi! intera-e i! a$!o "!ed a! an inte1ration ,oint 6ith Ora-$e Order Mana1ement or !hi,ment tran!a-tion!. Ora-$e Order Mana1ement! Inventor Intera-e ,ro1ram ,o,"$ate! the intera-e ta5$e! 6ith tran!a-tion! !"5mitted thro"1h the Conrm Shi,ment! 6indo6. o" m"!t 6rite the $oad ,ro1ram that in!ert! a !in1$e ro6 or ea-h tran!a-tion into the MTLTRANSACTIONSINTERFACE ta5$e. For materia$ movement o item! that are "nder $ot or !eria$ -ontro$) o" m"!t a$!o in!ert ro6! into MTLTRANSACTIONLOTSINTERFACE and MTLSERIALN+M8ERSINTERFACE re!,e-tive$. I o" in!ert QIP a!!em5$-om,$etion tran!a-tion! that -om,$ete or ret"rn =o5 a!!em5$ie!) o" m"!t a$!o in!ert ro6! into the CSTCOMPSNAP INTERFACE ta5$e i the or1ani7ation reeren-ed "!e! avera1e -o!tin1. The !!tem "!e! thi! inormation to -a$-"$ate -om,$etion -o!t. Onhand Inventor Conver!ion Fi$e Re# (>'0*?4@'

v. '.0 B

A,,roa-h

*'?*'3'?


Do- Re#

There are t6o mode! o" -an "!e to ,ro-e!! o"r tran!a-tion! thro"1h the intera-e. In the r!t ,ro-e!!in1 mode) o" ,o,"$ate the intera-e ta5$e on$. Then the Tran!a-tion Mana1er ,o$$! the intera-e ta5$e a!n-hrono"!$ $oo9in1 or tran!a-tion! to ,ro-e!!) 1ro",! the tran!a-tion ro6!) and $a"n-he! a Tran!a-tion Qor9er to ,ro-e!! ea-h 1ro",. In the !e-ond ,ro-e!!in1 mode) o" in!ert the ro6! in the intera-e ta5$e and -a$$ a Tran!a-tion Qor9er dire-t$) ,a!!in1 the 1ro", identier o the intera-ed tran!a-tion! a! a ,arameter !o that the 6or9er -an re-o1ni7e 6hi-h !"5!et o tran!a-tion! to ,ro-e!!.


v. '.0 B

A,,roa-h

*'3*'3'3


Do- Re#

Tar1et A,,$i-ation# INV 8"!ine!! O5=e-t # Onhand Inventor Pre,ared 5#

7/8

718

728

Ref! 

#arget Application #able

#arget Application #able Column

'

738

798

#arget Not Column Null? Datat pe

78

7;8

78

7=8

(ource (stem +ile Name

(ource (stem +ield Name

(ource (stem +ield Datatp e

Default Value

mt$tran!a-tion!intera Tran!a-tionintera-ei N"m -e d

Tran!a-tionheaderid

N"m

Tran!a-tionint era-eid

So"r-e-ode

Var(0 e! B

WinvX

So"r-e$ineid

N"m

e!


So"r-eheaderid

N"m

e!


Pro-e!!Ja1

N"m

e!

'

N"m

e!

(

Tran!a-tionmode Va$idationre;"ired

N"m

'

Lo-9Ja1

N"m

*

La!t",dateDate

Date

e!

La!t",dated5

N"m

e!

Created5

N"m

e!

Creationdate

Date

e!

Item!e1ment'

Var*

S-hed"$eJa1

N"m

Revi!ion

Var*

Or1ani7ationid

N"m

e!

Qareho"!e

Va$i -od

Tran!a-tion;t

N"m

e!

"antit

0

Primar;t


v. '.0 B

Mt$materia$tr an!a-tion!!.ne tva$

Enovia Item N"m5er

Ei to t *

N"m

t -od A,,roa-h

**0*'3*0


Do- Re#

7/8

718

728

Ref! 



738

798


Tran!a-tion"om

Var*

e!

Tran!a-tiondate

Date

e!

78

7;8

78

7=8




Default Value

+OM S!date

A--t,eriodid

N"m

S"5inventor-ode

Var*

S"5inventor

LOCATORNAME

Var*

Lo-ator

Lo-!e1ment'

Var*

Tran!a-tiont,eid

N"m

Va$i

Der -a$ tra Va$i -od or1

e!

Tran! T,e Y WMi!-e$$aneo"! re-ei,tX or ,o!itive ;"antit and Mi!-e$$aneo"! I!!"e or Ne1ative ;"antit

Di!tri5"tiona--o"ntid N"m

Pro=e-tid Ta!9id

N"m

Pro=e-t

N"m

Ta!9

So"r-e$otN"m

Var*

Rea!onid

N"m

TRANSACTIONREFERE Var* NCE


v. '.0 B

GL ID

Attri5"te-ate1or

Var*

Attri5"te'

Var*

Attri5"te*

Var*

Attri5"te(

Var*

Attri5"te4

Var*

Attri5"te>

Var*

Ch -on i $o ite Rea!on-ode Comment!

A,,roa-h

**'*'3*'


Do- Re#

7/8

718

728

Ref! 



738

798


Mt$tran!a-tion!$ot!int Tran!a-tion!intera-ei era-e d

78

7;8

78

7=8




Default Value

e!


,rod"-t-ode

WinvX

La!t",datedate

e!

!!date

La!t",dated5

e!

+!erid

Creationdate

e!

!!date

Created5

e!

+!erid

Tran!a-tion;"antit

e!

Tran!a-tion-o!t

"antit +nit Co!t

Primar;"antit LotN"m5er

e!

Prod"-ttran!a-tionid


Lote,irdate

%nterface parameter:


v. '.0 B

Parameter Name

Re*uired ?

Fi$e Name

e!

Conver!ion A--o"nt

e!

Va$idate On$

No

A,,roa-h

****'3**


Do- Re#

@tract +ile "aout 8e$o6 i! a ta5$e do-"mentin1 the etra-t $e !-hema.

On-Hand Template.xls

Required or Optional Description

Field Name

Warehouse

Required

Inventory organization code in which the assembly item exists !alue in template must match a " character inventory organization code as de#ined in the Oracle database

$D% Number

Required

&tlas item number Item number must be already existing in the organization speci#ic, otherwise program will error out

I'()*N+)%(R

Optional

+O)

Required

+nit o# measure

-+&N'I'.

Required

+nresrved/&vailable quantity required to migrated in Oracle

0+%IN!(N'OR.

Required

!alid subinventory #or the warehouse

Required

1ocator in#ormation #or the item, Which contains &rea, Row, Rac3 4 %in details

1O2&'OR Onhand Inventor Conver!ion Fi$e Re# (>'0*?4@'

v. '.0 B

A,,roa-h

**(*'3*(


$RO5(2' '&07

+nit 2ost

Do- Re#

Optional

!alid $ro6ect #or the organization 'his is not applicable #or Denmar3 and %ethlehem

Optional

!alid tas3 #or the $ro6ect provided 'his is not applicable #or Denmar3 and %ethlehem

Required

'otal item cost #or the speci#ic item, user to provide, it is in #unctional currency which is D77 #or Denmar3 and +08 #or %ethlehem )aterial cost

'his is applicable to all the items, the value #or material cost must be lesser or equal to the item unit cost )aterial 2ost

Required

)aterial Overhead 2ost

)aterial Overhead

Optional

2urrently F10midth is not using any material overhead Outside $rocessing 2ost

'his is only applicable to semi9#inished or #inished items which have outside processing operation in their routing, the value #or O0$ cost must be less to the item unit cost O0$

Optional Resource 2ost

'his is only applicable to semi9#inished or #inished items which have resource usage incurred in WI$, the value #or Resource cost must be less to the item unit cost Resource

Optional

Overhead

Optional

Overhead 2ost

'his is only applicable to semi9#inished or #inished items which have overhead usage incurred in WI$, Onhand Inventor Conver!ion Fi$e Re# (>'0*?4@'

v. '.0 B

A,,roa-h

**4*'3*4


Do- Re#

the value #or Overhead cost must be less to the item unit cost

R(&0ON*2OD(

Optional

!alid reason code

2O))(N'0

Optional

&ny comments need to provide #or the transaction




v. '.0 B

A,,roa-h

**>*'3*>


Do- Re#

.pen and Closed %ssues for this Deliverable

.pen %ssues

%D

%ssue

'

Resolution

Responsibilit

#arget Date

Lead time need to ,rovide to add an item in Enovia and ,"!h !ame to Ora-$e.

Car!ten Gie!e$Ratha9ri!hn an &aa5a$an

T8D

*

C"rrent on hand data 6ith PD8 n"m5er H +OM re;"ired to mi1rated need to ,rovide 5 5"!ine!!) To ma9e a ,re2 -he-9 on mi!!in1 item! in Enovia

Pia 8"5andt Morten!en

042A"12*0'*

(

Lo-ator Va$"e! need to de-ided and !et", in !!tem.

Pa5$o S. Pere7

T8D

4

In ve ntor  Ad= "!tment Pro-e!! need to !et", ater R* 1o $ive to move the inventor 5et6een Ora-$e and o$d !!tem a! ,er interim ,ro-e!! re;"irement.

Pa5$o S. Pere7

T8D

>

S,are ,art! $ead to 5e anno"n-ed

Tom <&en!en

T8D

@

Co"ntr o Ori1in to mi1rate 6ith on hand data and !ho"$d 5e a5$e to ,rovide detai$! rom Ora-$e.

Pa5$o S. Pere7

T8D

%mpact Date

Closed %ssues

%D

%ssue

Resolution


v. '.0 B

Responsibilit

#arget Date

%mpact Date

A,,roa-h

**@*'3*@



v. '.0 B

Do- Re#

A,,roa-h

***'3*

CV040_Onhand_Qty-V1.0

Recommend Documents