|
|
IC840 - Cart Par Location Conversion
**Form Purpose
Run Cart Par Location Conversion (IC840) to import the cart/par location CSV
conversion file.
**Processing Effect
For UNIX/Windows platforms:
The process will take the input CSV file and
edit it as if it were going through the IC81 edit screen in Inventory Control
before then updating the following tables: RQLOC, ICLOCATION, BINGROUP,
ITEMLOC, ICBIN, and BINGRPDTL.
ICCATEGORY, ICLOCATION, ITEMMAST are tables that will need to be populated
with data prior to running the conversion job. The GL and AP applications also
need to be set up.
ITEMLOC must exist for replenishment locations. If the ITEMLOC record exists
for the location already the record will be updated with information from the
input CSV file no matter what.
As discussed, the ICLOCATION conversion will include the cart and par
locations which will than allow the GL category conversion to execute properly
and this conversion job will just update the ICLOCATION.
For iSeries platform:
The process will take the input CSV file and edit
it as if it were going through the IC81 edit screen in Inventory Control
before then updating the following tables: DBRQRQL, DBICICL, DBICBGR, DBICITL,
DBICICB, and DBICBGD.
DBICICA, DBICICL, DBICITE are tables that will need to be populated with data
prior to running the conversion job. The GL and AP applications also need to
be set up.
DBICITL must exist for replenishment locations. If the DBICITL record exists
for the location already the record will be updated with information from the
input CSV file no matter what.
As discussed, the DBICICL conversion will include the cart and par locations
which will than allow the GL category conversion to execute properly and this
conversion job will just update the DBICICL.
Updated Files
APAPPROVAL -
APAUDIT -
APCOMMENTS -
APCONTACT -
APCPYVND -
APHLDINV -
APVENADDR -
APVENBAL -
APVENCERT -
APVENGROUP -
APVENLOC -
APVENMAST -
APVENPAY -
BINGROUP -
BINGRPDTL -
CBBANKINST -
CBCASHCODE -
CKPOINT -
CUSTDESC -
ICBIN -
ICCOMPANY -
ICLOCATION -
ITEMLOC -
ITEMSRC -
MXLISTHDR -
MXLISTMBR -
POVENDLOC -
POVENDOR -
RQLOC -
TXCODEMAST -
TXCOMPANY -
TXTAXCODE -
TXTAXTABLE -
Referenced Files
APACCRCODE -
APAPPROVAL -
APAUTHOR -
APCOMMENTS -
APCOMPANY -
APCONTACT -
APCPYVND -
APDISCCODE -
APDISTHDR -
APHLDINV -
APHOLDCODE -
APINCCODE -
APINVOICE -
APPAYMENT -
APPROCGRP -
APUSRFLDEF -
APVENBAL -
APVENCERT -
APVENCLASS -
APVENLOC -
APVNMXVAL -
ARCUSTGRP -
CBUSER -
CBUSRCLASS -
CUCONV -
CURELAT -
EEADVANCE -
EEAPPROVAL -
EEEXPENSE -
GLCODES -
GLSYSTEM -
ICCATEGORY -
INSTCTRYCD -
INSTREGN -
ITEMMAST -
MAINVHAND -
MAMATCHTBL -
MAMSGTOL -
MAMTCHRULE -
MAPOOLCNT -
MXCATDEF -
MXELEMENT -
MXLISTDTL -
MXOBJCAT -
POAOCDTL -
POVAGRMTHD -
POVENDLOC -
PROCUREGRP -
PURCHORDER -
TXTAXRATE -
INVOKED Programs
ACAC
ACCL
ACTA
API4
IFAC
IFAU
IFCU
IFOB
IFSG
SLSE
SLSU
IFLU
API3
|
