|
|
OE11.1 - Order Add-On Charges
**Form Purpose
Use Order Add-On Charges (OE11.1) to assign add-on charges to the order
header.
**More Information
You define add-on charges using BL09.1 (Add-On Charges). Only add-on charges
with a charge type of flat amount or percentage can be assigned to order
headers. The add-on charge goes on the first shipment out. Shipments are
created in the Lawson Warehouse application when you print a pick list.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCUSTOMER - Used to validate the Accounts Receivable customer. The open
order amount is
updated with the released order's total amount.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the customer order line is for a kit item.
Contains the components
for the kit item ordered.
COLINE - Primary detail file for this program. Used to store customer
order line
information.
COLINEUOM - Used to store item pricing for a customer order line if the
item is priced
via multiple units of measure.
COMISC - Used to store customer order/customer order line add-on
charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Primary file maintained by this program.
CXCOMPANY -
CXCPIUAVAL -
CXITEMHIST -
CXPREFITEM -
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG -
HCPATVISIT -
HOLDCODES - Used to validate the hold code. If this is the first time the
hold code is
referenced, the used flag is set.
ICCOMPANY - Used to validate the Inventory Control company.
ICHISTORY - Used to store sales history for Inventory Control items.
ICLOCATION - Used to validate the Inventory Control location.
ICLOT - Used to obtain the lot expiration date.
ICRECEIPTS - Used to record receipts of stock.
ICTRANS - Used to store transaction history for stock-on-hand quantity
updates.
ICTRANSDTL - Used to store detail transaction history for stock-on-hand
quantity updates.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify the Inventory Control item location.
Allocation of inventory to
customer orders updates the allocated and backordered
quantities.
ITSERIAL - Used to store serial numbers for serial number tracked items.
MAPOOLCNT -
MMDIST - Contains general ledger account postings for inventory
transaction.
MMUAVAL -
MXLISTHDR -
NATBALANCE - Used in the Customer Edit routine.
OEAUDIT - Used to store audits of changes to released customer orders
and order lines.
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code. If this is the first time
the freight
code is referenced, the used flag is set.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type
is referenced, the used flag is set.
OEMETHOD - Used to validate the shipping method. If this is the first
time the shipping
method is referenced, the used flag is set.
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store customer order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OESOURCE - Used to validate customer order source codes.
ORDERTYPE - Used to validate the order type. If this is the first time
the order type is
referenced, the used flag is set.
POAGMTPRIC -
POAOCDTL - Used in Purchase Order revision logic.
POAOCMAST - Used in Purchase Order revision logic.
POAOCSPRD - Used in Purchase Order revision logic.
POAUDIT - Used in Purchase Order revision logic.
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC - Used in Purchase Order revision logic.
POINTERFAC - Used in Purchase Order revision logic.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE - Used in Purchase Order revision logic.
PORETURNHD - Used in Purchase Order revision logic.
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR - Used in Purchase Order revision logic.
PURCHORDER - Used in Purchase Order revision logic.
RECAOCDTL -
REQLINE - Used in Purchase Order revision logic.
ROUTEDOC - Updated with changed values when a customer order line is
changed after the route files have been created.
ROUTEHDR - Used to edit whether the route has been created for a customer
order line.
If it has, the totals on the route files are updated with the
changed values.
ROUTESTOP - Updated with changed values when a customer order line is
changed after
the route files have been created.
RQTRANS -
SALESREP - Used to validate the sales representative. If this is the
first time the sales representative is
referenced, the used flag is set.
SHIPTO - Used to validate the ship-to code. If this is the first time
the ship-to code is
referenced, the used flag is set.
SOHDETAIL - Used to store stock-on-hand details. Lot, bin, and unit of
measure
quantities are kept on these records.
TERITORY - Used to validate the territory. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate the terms code. If this is the first time
the terms code is
referenced, the used flag is set.
TXCODEMAST - Used to validate the tax code.
TXCOMPANY - Used to validate the Tax company.
TXTAXCODE - Used to validate the tax code.
TXTAXTABLE - Used in the Sales Tax Calculation routine.
WHDEMAND - Used to validate the Warehouse demand.
WHDEMNDHDR - Used to validate the Warehouse demand header.
WORDER -
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCATSUMX -
ACCUSTOMER -
AGINGCODE - Used in the Customer Edit routine.
AMASSET - Used in the Procurement Management distribution edit routine
to edit asset codes.
AMTEMPLATE - Used in the Asset Management edit routine.
APACCRCODE - Used in the Vendor Edit routine.
APAPIHIST -
APCOMPANY - Used to validate the Accounts Payable company.
APHLDINV - Used in the Vendor Edit routine.
APINVOICE -
APPAYMENT -
APPROCLEV - Used to validate the Accounts Payable company.
APUAVAL -
APVENADDR -
APVENGROUP - Used in the Vendor Edit routine.
ARADJUST -
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Customer Edit routine.
ARCUSTGRP - Used in the Customer Edit routine.
ARCUSTTOTS - Used in the Customer Edit routine.
ARITRANS -
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR -
AROITEMS -
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS - Used in Purchase Order revision logic.
BUYCMPLOC -
BUYER - Used in Purchase Order revision logic.
BUYVENPF -
COMPONENT - Used to obtain Inventory Control definition of components for
a kit item.
CUCONV - Used in the Currency Conversion routine.
CURELAT - Used in the Currency Conversion routine.
CXBURDEN -
CXCASEPREF -
CXPTMPITEM -
EEADVANCE -
EEEXPENSE -
FOBCODE - Used in Purchase Order revision logic.
FROPTIONS -
GLADDRESS - Used in the General Ledger Account Edit routine.
GLCHART - Used in the General Ledger Account Edit routine.
GLCODES - Used in the General Ledger Account Edit routine.
GLINTCO - Used in the General Ledger Account Edit routine.
GLNAMES - Used in the General Ledger Account Edit routine.
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM -
ICBIN - Used to validate Inventory Control bins.
ICCATEGORY - Used to validate Inventory Control general ledger categories.
ICCOUT -
ICFACILITY -
ICMFGCODE -
ICMFGDIST -
ICVALUOM -
INSTATPROC -
INSTCMDTY -
INSTCTRYCD -
INSTNOTC -
INSTPORTS -
INSTREGN -
ITEMADDON - Used to create add-on charges automatically when specified
items are sold to
specific states (or optionally to any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB - Used to find item substitutes.
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL - Used to validate the major sales class.
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL - Used to validate the minor sales class.
MSDSACK - Used to store the Material Safety Data Sheet acknowledgment
date.
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price basis for
each item.
OECOMPANY - Used to edit the Billing company. If the system-generated
order number option
is set, the last order number used is incremented when an
order is added.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM - Used to validate customer item numbers.
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEINVOICE - Used in the Customer Order Delete Edit routine. Delete is not
allowed if invoices exist
for the customer order; the order can only be canceled.
OEORDDISC - Used to calculate the order-level discount amount.
OEPLCLASS - Used in the Item Pricing routine. Stores sales class level
pricing parameters.
OEPLITEM - Used in the Item Pricing routine. Stores item level pricing
parameters.
OEPRCLIST - Used in the Item Pricing routine. Stores price list pricing
parameters.
OEREASON - Used to validate the cancellation reason code.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR - Used to validate the user ID.
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN - Used in Purchase Order revision logic.
PORECADJHD -
PORECADJLN -
POVENDLOC - Used in Purchase Order revision logic.
PROCTEMPLN -
PROCUREGRP -
REASON -
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE - Used to validate standard comment codes.
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate the Warehouse process type.
WHSHLAUD -
OE11.2 - Order Comments
**Form Purpose
Use Order Comments (OE11.2) to assign comments to the order header. You can
enter free-form comments or copy comments based on a standard comment code
that you previously defined in the Lawson Billing application.
Updated Files
CUSTORDER - Comment sequence number is updated when comments are added to
an order.
OEORDCMNT - Primary file maintained by this program. Comments for an
order can be added, changed, and deleted.
Referenced Files
None.
OE11.3 - Order Standard Comments
**Form Purpose
Use Order Standard Comments (OE11.3) to copy comments assigned to a standard
comment code onto the order header. You define standard comment codes using
BL03.1 (Standard Comments).
Updated Files
None.
Referenced Files
CUSTORDER - Comment sequence number is updated when standard comments are
added to an order.
OESTDCOMM - Used to validate the standard comment code. If valid,
comments are copied to the order comment file.
OE11.4 - Line Add-On Charges
**Form Purpose
Use Line Add-On Charges (OE11.4) to assign add-on charges to a specific order
line. The add-on charge goes on the first shipment out. Shipments are created
in the Lawson Warehouse application when you print a pick list.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCUSTOMER - Used to validate the Accounts Receivable customer. The open
order amount is
updated with the released order's total amount.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the customer order line is for a kit item.
Contains the components
for the kit item ordered.
COLINE - Primary detail file for this program. Used to store customer
order line
information.
COLINEUOM - Used to store item pricing for a customer order line if the
item is priced
via multiple units of measure.
COMISC - Used to store customer order/customer order line add-on
charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Primary file maintained by this program.
CXCOMPANY -
CXCPIUAVAL -
CXITEMHIST -
CXPREFITEM -
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG -
HCPATVISIT -
HOLDCODES - Used to validate the hold code. If this is the first time the
hold code is
referenced, the used flag is set.
ICCOMPANY - Used to validate the Inventory Control company.
ICHISTORY - Used to store sales history for Inventory Control items.
ICLOCATION - Used to validate the Inventory Control location.
ICLOT - Used to obtain the lot expiration date.
ICRECEIPTS - Used to record receipts of stock.
ICTRANS - Used to store transaction history for stock-on-hand quantity
updates.
ICTRANSDTL - Used to store detail transaction history for stock-on-hand
quantity updates.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify the Inventory Control item location.
Allocation of inventory to
customer orders updates the allocated and backordered
quantities.
ITSERIAL - Used to store serial numbers for serial number tracked items.
MAPOOLCNT -
MMDIST - Contains general ledger account postings for inventory
transaction.
MMUAVAL -
MXLISTHDR -
NATBALANCE - Used in the Customer Edit routine.
OEAUDIT - Used to store audits of changes to released customer orders
and order lines.
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code. If this is the first time
the freight
code is referenced, the used flag is set.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type
is referenced, the used flag is set.
OEMETHOD - Used to validate the shipping method. If this is the first
time the shipping
method is referenced, the used flag is set.
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store customer order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OESOURCE - Used to validate customer order source codes.
ORDERTYPE - Used to validate the order type. If this is the first time
the order type is
referenced, the used flag is set.
POAGMTPRIC -
POAOCDTL - Used in Purchase Order revision logic.
POAOCMAST - Used in Purchase Order revision logic.
POAOCSPRD - Used in Purchase Order revision logic.
POAUDIT - Used in Purchase Order revision logic.
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC - Used in Purchase Order revision logic.
POINTERFAC - Used in Purchase Order revision logic.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE - Used in Purchase Order revision logic.
PORETURNHD - Used in Purchase Order revision logic.
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR - Used in Purchase Order revision logic.
PURCHORDER - Used in Purchase Order revision logic.
RECAOCDTL -
REQLINE - Used in Purchase Order revision logic.
ROUTEDOC - Updated with changed values when a customer order line is
changed after the route files have been created.
ROUTEHDR - Used to edit whether the route has been created for a customer
order line.
If it has, the totals on the route files are updated with the
changed values.
ROUTESTOP - Updated with changed values when a customer order line is
changed after
the route files have been created.
RQTRANS -
SALESREP - Used to validate the sales representative. If this is the
first time the sales representative is
referenced, the used flag is set.
SHIPTO - Used to validate the ship-to code. If this is the first time
the ship-to code is
referenced, the used flag is set.
SOHDETAIL - Used to store stock-on-hand details. Lot, bin, and unit of
measure
quantities are kept on these records.
TERITORY - Used to validate the territory. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate the terms code. If this is the first time
the terms code is
referenced, the used flag is set.
TXCODEMAST - Used to validate the tax code.
TXCOMPANY - Used to validate the Tax company.
TXTAXCODE - Used to validate the tax code.
TXTAXTABLE - Used in the Sales Tax Calculation routine.
WHDEMAND - Used to validate the Warehouse demand.
WHDEMNDHDR - Used to validate the Warehouse demand header.
WORDER -
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCATSUMX -
ACCUSTOMER -
AGINGCODE - Used in the Customer Edit routine.
AMASSET - Used in the Procurement Management distribution edit routine
to edit asset codes.
AMTEMPLATE - Used in the Asset Management edit routine.
APACCRCODE - Used in the Vendor Edit routine.
APAPIHIST -
APCOMPANY - Used to validate the Accounts Payable company.
APHLDINV - Used in the Vendor Edit routine.
APINVOICE -
APPAYMENT -
APPROCLEV - Used to validate the Accounts Payable company.
APUAVAL -
APVENADDR -
APVENGROUP - Used in the Vendor Edit routine.
ARADJUST -
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Customer Edit routine.
ARCUSTGRP - Used in the Customer Edit routine.
ARCUSTTOTS - Used in the Customer Edit routine.
ARITRANS -
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR -
AROITEMS -
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS - Used in Purchase Order revision logic.
BUYCMPLOC -
BUYER - Used in Purchase Order revision logic.
BUYVENPF -
COMPONENT - Used to obtain Inventory Control definition of components for
a kit item.
CUCONV - Used in the Currency Conversion routine.
CURELAT - Used in the Currency Conversion routine.
CXBURDEN -
CXCASEPREF -
CXPTMPITEM -
EEADVANCE -
EEEXPENSE -
FOBCODE - Used in Purchase Order revision logic.
FROPTIONS -
GLADDRESS - Used in the General Ledger Account Edit routine.
GLCHART - Used in the General Ledger Account Edit routine.
GLCODES - Used in the General Ledger Account Edit routine.
GLINTCO - Used in the General Ledger Account Edit routine.
GLNAMES - Used in the General Ledger Account Edit routine.
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM -
ICBIN - Used to validate Inventory Control bins.
ICCATEGORY - Used to validate Inventory Control general ledger categories.
ICCOUT -
ICFACILITY -
ICMFGCODE -
ICMFGDIST -
ICVALUOM -
INSTATPROC -
INSTCMDTY -
INSTCTRYCD -
INSTNOTC -
INSTPORTS -
INSTREGN -
ITEMADDON - Used to create add-on charges automatically when specified
items are sold to
specific states (or optionally to any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB - Used to find item substitutes.
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL - Used to validate the major sales class.
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL - Used to validate the minor sales class.
MSDSACK - Used to store the Material Safety Data Sheet acknowledgment
date.
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price basis for
each item.
OECOMPANY - Used to edit the Billing company. If the system-generated
order number option
is set, the last order number used is incremented when an
order is added.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM - Used to validate customer item numbers.
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEINVOICE - Used in the Customer Order Delete Edit routine. Delete is not
allowed if invoices exist
for the customer order; the order can only be canceled.
OEORDDISC - Used to calculate the order-level discount amount.
OEPLCLASS - Used in the Item Pricing routine. Stores sales class level
pricing parameters.
OEPLITEM - Used in the Item Pricing routine. Stores item level pricing
parameters.
OEPRCLIST - Used in the Item Pricing routine. Stores price list pricing
parameters.
OEREASON - Used to validate the cancellation reason code.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR - Used to validate the user ID.
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN - Used in Purchase Order revision logic.
PORECADJHD -
PORECADJLN -
POVENDLOC - Used in Purchase Order revision logic.
PROCTEMPLN -
PROCUREGRP -
REASON -
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE - Used to validate standard comment codes.
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate the Warehouse process type.
WHSHLAUD -
OE11.5 - Line Comments
**Form Purpose
Use Line Comments (OE11.5) to assign comments to order lines. You can enter
free-form comments or copy groups of comments assigned to a standard comment
code that has been defined in the Billing application.
Updated Files
COLINE - Comment sequence number is updated when comments are attached
to the line.
OEORDCMNT - Primary file maintained by this program.
Referenced Files
CUSTORDER - Used to validate the customer order number.
OE11.6 - Line Standard Comments
**Form Purpose
Use Line Standard Comments (OE11.6) to copy a set of comments assigned to a
standard comment code onto the order line. You define standard comment codes
using BL03.1 (Standard Comments).
Updated Files
None.
Referenced Files
COLINE - Comment sequence number is updated when a standard comment is
added to an order line.
OESTDCOMM - Used to validate the standard comment code. If valid,
comments are then copied to the order comment file for the line
referenced.
OE11.8 - Kit Accessories
**Form Purpose
Use Kit Accessories (OE11.8) to select accessories defined for make-to-order
kit items. Accessories are optional components for the kit.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCUSTOMER - Used to validate the Accounts Receivable customer. The open
order amount is
updated with the released order's total amount.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the customer order line is for a kit item.
Contains the components
for the kit item ordered.
COLINE - Used to store customer order line information. Accessories
chosen using this program are added as new lines on the
customer order.
COLINEUOM - Used to store item pricing for a customer order line if the
item is priced
via multiple units of measure.
COMISC - Used to store customer order/customer order line add-on
charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to validate the customer order number.
CXCOMPANY -
CXCPIUAVAL -
CXITEMHIST -
CXPREFITEM -
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG -
HCPATVISIT -
HOLDCODES - Used to validate the hold code. If this is the first time the
hold code is
referenced, the used flag is set.
ICCOMPANY - Used to validate the Inventory Control company.
ICHISTORY - Used to store sales history for Inventory Control items.
ICLOCATION - Used to validate the Inventory Control location.
ICLOT - Used to obtain the lot expiration date.
ICRECEIPTS - Used to record receipts of stock.
ICTRANS - Used to store transaction history for stock-on-hand quantity
updates.
ICTRANSDTL - Used to store detail transaction history for stock-on-hand
quantity updates.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify the Inventory Control item location.
Allocation of inventory to
customer orders updates the allocated and backordered
quantities.
ITSERIAL - Used to store serial numbers for serial number tracked items.
MAPOOLCNT -
MMDIST - Contains general ledger account postings for inventory
transaction.
MMUAVAL -
MXLISTHDR -
NATBALANCE - Used in the Customer Edit routine.
OEAUDIT - Used to store audits of changes to released customer orders
and order lines.
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code. If this is the first time
the freight
code is referenced, the used flag is set.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type
is referenced, the used flag is set.
OEMETHOD - Used to validate the shipping method. If this is the first
time the shipping
method is referenced, the used flag is set.
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store customer order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OESOURCE - Used to validate customer order source codes.
ORDERTYPE - Used to validate the order type. If this is the first time
the order type is
referenced, the used flag is set.
POAGMTPRIC -
POAOCDTL - Used in Purchase Order revision logic.
POAOCMAST - Used in Purchase Order revision logic.
POAOCSPRD - Used in Purchase Order revision logic.
POAUDIT - Used in Purchase Order revision logic.
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC - Used in Purchase Order revision logic.
POINTERFAC - Used in Purchase Order revision logic.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE - Used in Purchase Order revision logic.
PORETURNHD - Used in Purchase Order revision logic.
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR - Used in Purchase Order revision logic.
PURCHORDER - Used in Purchase Order revision logic.
RECAOCDTL -
REQLINE - Used in Purchase Order revision logic.
ROUTEDOC - Updated with changed values when a customer order line is
changed after the route files have been created.
ROUTEHDR - Used to edit whether the route has been created for a customer
order line.
If it has, the totals on the route files are updated with the
changed values.
ROUTESTOP - Updated with changed values when a customer order line is
changed after
the route files have been created.
RQTRANS -
SALESREP - Used to validate the sales representative. If this is the
first time the sales representative is
referenced, the used flag is set.
SHIPTO - Used to validate the ship-to code. If this is the first time
the ship-to code is
referenced, the used flag is set.
SOHDETAIL - Used to store stock-on-hand details. Lot, bin, and unit of
measure
quantities are kept on these records.
TERITORY - Used to validate the territory. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate the terms code. If this is the first time
the terms code is
referenced, the used flag is set.
TXCODEMAST - Used to validate the tax code.
TXCOMPANY - Used to validate the Tax company.
TXTAXCODE - Used to validate the tax code.
TXTAXTABLE - Used in the Sales Tax Calculation routine.
WHDEMAND - Used to validate the Warehouse demand.
WHDEMNDHDR - Used to validate the Warehouse demand header.
WORDER -
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCATSUMX -
ACCUSTOMER -
AGINGCODE - Used in the Customer Edit routine.
AMASSET - Used in the Procurement Management distribution edit routine
to edit asset codes.
AMTEMPLATE - Used in the Asset Management edit routine.
APACCRCODE - Used in the Vendor Edit routine.
APAPIHIST -
APCOMPANY - Used to validate the Accounts Payable company.
APHLDINV - Used in the Vendor Edit routine.
APINVOICE -
APPAYMENT -
APPROCLEV - Used to validate the Accounts Payable company.
APUAVAL -
APVENADDR -
APVENGROUP - Used in the Vendor Edit routine.
ARADJUST -
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Customer Edit routine.
ARCUSTGRP - Used in the Customer Edit routine.
ARCUSTTOTS - Used in the Customer Edit routine.
ARITRANS -
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR -
AROITEMS -
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS - Used in Purchase Order revision logic.
BUYCMPLOC -
BUYER - Used in Purchase Order revision logic.
BUYVENPF -
COMPONENT - Used to obtain Inventory Control definition of components for
a kit item.
CUCONV - Used in the Currency Conversion routine.
CURELAT - Used in the Currency Conversion routine.
CXBURDEN -
CXCASEPREF -
CXPTMPITEM -
EEADVANCE -
EEEXPENSE -
FOBCODE - Used in Purchase Order revision logic.
FROPTIONS -
GLADDRESS - Used in the General Ledger Account Edit routine.
GLCHART - Used in the General Ledger Account Edit routine.
GLCODES - Used in the General Ledger Account Edit routine.
GLINTCO - Used in the General Ledger Account Edit routine.
GLNAMES - Used in the General Ledger Account Edit routine.
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM -
ICBIN - Used to validate Inventory Control bins.
ICCATEGORY - Used to validate Inventory Control general ledger categories.
ICCOUT -
ICFACILITY -
ICMFGCODE -
ICMFGDIST -
ICVALUOM -
INSTATPROC -
INSTCMDTY -
INSTCTRYCD -
INSTNOTC -
INSTPORTS -
INSTREGN -
ITEMADDON - Used to create add-on charges automatically when specified
items are sold to
specific states (or optionally to any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB - Used to find item substitutes.
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL - Used to validate the major sales class.
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL - Used to validate the minor sales class.
MSDSACK - Used to store the Material Safety Data Sheet acknowledgment
date.
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price basis for
each item.
OECOMPANY - Used to edit the Billing company. If the system-generated
order number option
is set, the last order number used is incremented when an
order is added.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM - Used to validate customer item numbers.
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEINVOICE - Used in the Customer Order Delete Edit routine. Delete is not
allowed if invoices exist
for the customer order; the order can only be canceled.
OEORDDISC - Used to calculate the order-level discount amount.
OEPLCLASS - Used in the Item Pricing routine. Stores sales class level
pricing parameters.
OEPLITEM - Used in the Item Pricing routine. Stores item level pricing
parameters.
OEPRCLIST - Used in the Item Pricing routine. Stores price list pricing
parameters.
OEREASON - Used to validate the cancellation reason code.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR - Used to validate the user ID.
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN - Used in Purchase Order revision logic.
PORECADJHD -
PORECADJLN -
POVENDLOC - Used in Purchase Order revision logic.
PROCTEMPLN -
PROCUREGRP -
REASON -
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE - Used to validate standard comment codes.
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate the Warehouse process type.
WHSHLAUD -
OE11.9 - Substitutes
**Form Purpose
Use Substitutes (OE11.9) to replace an item that was originally ordered with
another item. You can define substitute items for each item in the Lawson
Inventory Control application.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCUSTOMER - Used to validate the Accounts Receivable customer. The open
order amount is
updated with the released order's total amount.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the customer order line is for a kit item.
Contains the components
for the kit item ordered.
COLINE - Used to store customer order line information. Substitute
items chosen become their own customer order line.
COLINEUOM - Used to store item pricing for a customer order line if the
item is priced
via multiple units of measure.
COMISC - Used to store customer order/customer order line add-on
charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to validate the customer order number.
CXCOMPANY -
CXCPIUAVAL -
CXITEMHIST -
CXPREFITEM -
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG -
HCPATVISIT -
HOLDCODES - Used to validate the hold code. If this is the first time the
hold code is
referenced, the used flag is set.
ICCOMPANY - Used to validate the Inventory Control company.
ICHISTORY - Used to store sales history for Inventory Control items.
ICLOCATION - Used to validate the Inventory Control location.
ICLOT - Used to obtain the lot expiration date.
ICRECEIPTS - Used to record receipts of stock.
ICTRANS - Used to store transaction history for stock-on-hand quantity
updates.
ICTRANSDTL - Used to store detail transaction history for stock-on-hand
quantity updates.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify the Inventory Control item location.
Allocation of inventory to
customer orders updates the allocated and backordered
quantities.
ITSERIAL - Used to store serial numbers for serial number tracked items.
MAPOOLCNT -
MMDIST - Contains general ledger account postings for inventory
transaction.
MMUAVAL -
MXLISTHDR -
NATBALANCE - Used in the Customer Edit routine.
OEAUDIT - Used to store audits of changes to released customer orders
and order lines.
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code. If this is the first time
the freight
code is referenced, the used flag is set.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type
is referenced, the used flag is set.
OEMETHOD - Used to validate the shipping method. If this is the first
time the shipping
method is referenced, the used flag is set.
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store customer order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OESOURCE - Used to validate customer order source codes.
ORDERTYPE - Used to validate the order type. If this is the first time
the order type is
referenced, the used flag is set.
POAGMTPRIC -
POAOCDTL - Used in Purchase Order revision logic.
POAOCMAST - Used in Purchase Order revision logic.
POAOCSPRD - Used in Purchase Order revision logic.
POAUDIT - Used in Purchase Order revision logic.
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC - Used in Purchase Order revision logic.
POINTERFAC - Used in Purchase Order revision logic.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE - Used in Purchase Order revision logic.
PORETURNHD - Used in Purchase Order revision logic.
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR - Used in Purchase Order revision logic.
PURCHORDER - Used in Purchase Order revision logic.
RECAOCDTL -
REQLINE - Used in Purchase Order revision logic.
ROUTEDOC - Updated with changed values when a customer order line is
changed after the route files have been created.
ROUTEHDR - Used to edit whether the route has been created for a customer
order line.
If it has, the totals on the route files are updated with the
changed values.
ROUTESTOP - Updated with changed values when a customer order line is
changed after
the route files have been created.
RQTRANS -
SALESREP - Used to validate the sales representative. If this is the
first time the sales representative is
referenced, the used flag is set.
SHIPTO - Used to validate the ship-to code. If this is the first time
the ship-to code is
referenced, the used flag is set.
SOHDETAIL - Used to store stock-on-hand details. Lot, bin, and unit of
measure
quantities are kept on these records.
TERITORY - Used to validate the territory. If this is the first time the
territory is
referenced, the used flag is set.
TERMS - Used to validate the terms code. If this is the first time
the terms code is
referenced, the used flag is set.
TXCODEMAST - Used to validate the tax code.
TXCOMPANY - Used to validate the Tax company.
TXTAXCODE - Used to validate the tax code.
TXTAXTABLE - Used in the Sales Tax Calculation routine.
WHDEMAND - Used to validate the Warehouse demand.
WHDEMNDHDR - Used to validate the Warehouse demand header.
WORDER -
Referenced Files
ACACCTCAT - Used in the Activity Management edit routines.
ACACTGRP - Used in the Activity Management edit routines.
ACACTIVITY - Used to validate the Activity Management activity
code.
ACCATSUMX -
ACCUSTOMER -
AGINGCODE - Used in the Customer Edit routine.
AMASSET - Used in the Procurement Management distribution edit routine
to edit asset codes.
AMTEMPLATE - Used in the Asset Management edit routine.
APACCRCODE - Used in the Vendor Edit routine.
APAPIHIST -
APCOMPANY - Used to validate the Accounts Payable company.
APHLDINV - Used in the Vendor Edit routine.
APINVOICE -
APPAYMENT -
APPROCLEV - Used to validate the Accounts Payable company.
APUAVAL -
APVENADDR -
APVENGROUP - Used in the Vendor Edit routine.
ARADJUST -
ARCOMP - Used to validate the Accounts Receivable company.
ARCUSTFLDS - Used in the Customer Edit routine.
ARCUSTGRP - Used in the Customer Edit routine.
ARCUSTTOTS - Used in the Customer Edit routine.
ARITRANS -
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR -
AROITEMS -
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS - Used in Purchase Order revision logic.
BUYCMPLOC -
BUYER - Used in Purchase Order revision logic.
BUYVENPF -
COMPONENT - Used to obtain Inventory Control definition of components for
a kit item.
CUCONV - Used in the Currency Conversion routine.
CURELAT - Used in the Currency Conversion routine.
CXBURDEN -
CXCASEPREF -
CXPTMPITEM -
EEADVANCE -
EEEXPENSE -
FOBCODE - Used in Purchase Order revision logic.
FROPTIONS -
GLADDRESS - Used in the General Ledger Account Edit routine.
GLCHART - Used in the General Ledger Account Edit routine.
GLCODES - Used in the General Ledger Account Edit routine.
GLINTCO - Used in the General Ledger Account Edit routine.
GLNAMES - Used in the General Ledger Account Edit routine.
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM -
ICBIN - Used to validate Inventory Control bins.
ICCATEGORY - Used to validate Inventory Control general ledger categories.
ICCOUT -
ICFACILITY -
ICMFGCODE -
ICMFGDIST -
ICVALUOM -
INSTATPROC -
INSTCMDTY -
INSTCTRYCD -
INSTNOTC -
INSTPORTS -
INSTREGN -
ITEMADDON - Used to create add-on charges automatically when specified
items are sold to
specific states (or optionally to any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB - Used to find item substitutes.
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL - Used to validate the major sales class.
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL - Used to validate the minor sales class.
MSDSACK - Used to store the Material Safety Data Sheet acknowledgment
date.
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price basis for
each item.
OECOMPANY - Used to edit the Billing company. If the system-generated
order number option
is set, the last order number used is incremented when an
order is added.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM - Used to validate customer item numbers.
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEINVOICE - Used in the Customer Order Delete Edit routine. Delete is not
allowed if invoices exist
for the customer order; the order can only be canceled.
OEORDDISC - Used to calculate the order-level discount amount.
OEPLCLASS - Used in the Item Pricing routine. Stores sales class level
pricing parameters.
OEPLITEM - Used in the Item Pricing routine. Stores item level pricing
parameters.
OEPRCLIST - Used in the Item Pricing routine. Stores price list pricing
parameters.
OEREASON - Used to validate the cancellation reason code.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR - Used to validate the user ID.
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN - Used in Purchase Order revision logic.
PORECADJHD -
PORECADJLN -
POVENDLOC - Used in Purchase Order revision logic.
PROCTEMPLN -
PROCUREGRP -
REASON -
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE - Used to validate standard comment codes.
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate the Warehouse process type.
WHSHLAUD -
INVOKED Programs
ACAC
ACCL
ACTA
API4
IFAC
IFAU
IFCU
IFOB
IFSG
SLSE
SLSU
IFLU
ACSB
API3
BLI1
BLI2
BLI3
ICCP
ICI1
ICI4
IFRS
IFSC
POCP
POIF
POIH
POI6
POI4
POI7
POI9
POIA
POIL
POIX
POIG
POII
POIJ
POI1
POIM
SLSS
|
