IC840 – Cart Par Location Conversion
- System
- Inventory Control (IC)
- Type
- Batch program
- Updates
- 40 tables
- References
- 71 tables
IC840 (Cart Par Location Conversion) is a Lawson Inventory Control batch program. It updates APAPPROVAL, APAUDIT, APCOMMENTS, APCONTACT, APCPYVND, APHLDINV, APVENADDR, APVENBAL and 32 more and references APACCRCODE, APAPIHIST, APAPPROVAL, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND and 63 more.
About IC840
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 form 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 System i platform: The process will take the input CSV file and edit it as if it were going through the IC81 edit form 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 (40)
| Table | Description | System |
|---|---|---|
| APAPPROVAL | Invoice Approval | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APHLDINV | Hold | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| BINGROUP | Bin Group | IC |
| BINGRPDTL | Bin Group Detail | IC |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| ICAUDIT | Item/Item Location Audit | IC |
| ICBIN | Bin Numbers | IC |
| ICCOMPANY | Inventory Company Information | IC |
| ICICLAUDIT | The IC Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company). | IC |
| ICLOCATION | Company Location | IC |
| ICLOCGRP | Location Group | IC |
| IFBCIQUEUE | No description in the Lawson data dictionary | IF |
| ITEMLOC | Item Location | IC |
| ITEMSRC | Item Source | IC |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| RQLOC | Requesting Locations | RQ |
| RQRQLAUDIT | Requesting Location Audit | RQ |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (71)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCOMMENTS | Comments | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPAYMENT | Invoice Payment | AP |
| APPROCGRP | Process Group | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLOC | Vendor Location | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| COMPONENT | User Field | IC |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| GLCODES | General Ledger Codes | IF |
| GLNLOC | No description in the Lawson data dictionary | IC |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| ICACTIVITY | Pre-Released Document Header | IC |
| ICCATEGORY | GL Account Category | IC |
| ICLBOD | No description in the Lawson data dictionary | IC |
| ICLOCGRP | Location Group | IC |
| ICTBOD | No description in the Lawson data dictionary | IC |
| ICTRANS | Inventory Transaction | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| ITEBOD | No description in the Lawson data dictionary | IC |
| ITEMGROUP | Item Group | IC |
| ITEMMAST | Item Master | IC |
| ITLBOD | No description in the Lawson data dictionary | IC |
| KITBOD | No description in the Lawson data dictionary | IC |
| KITITEM | Kit Item | IC |
| MAINVHAND | Invoice Handling Code | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHRULE | Matching Rules | MA |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| POAOCDTL | Add On Cost Detail | PO |
| POCOMPANY | Company System Master | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POMXVAL | Attribute | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVENDLOC | Vendor Location Master | PO |
| PROCUREGRP | Procurement Group | PO |
| PURCHORDER | Purchase Order Master | PO |
| RQLMXVAL | No description in the Lawson data dictionary | RQ |
| SYSTEMCODE | System Code | IF |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (14)
ACAC, ACTA, API3, API4, ICLM, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, RQBL, SLSE, SLSU