|
OE30.1 - Returns
**Form Purpose
Use Returns (OE30.1) to create return documents for order lines that the
customer returned or rejected. Returns against an order and/or invoice are
only allowed after the invoice is printed via BL122 (Invoice and Register
Print).
**Processing Effect
Before releasing the return, you must decide if you want the goods returned
to stock. If you return the goods to stock, journal entries debit and credit
the accounts receivable, sales, Cost of Goods Sold, and inventory accounts. If
you want to create a scrap account instead, enter the scrap account when
creating the return. If the credit is not a return-to-stock, only accounts
receivable and sales are debited and credited.
When you release the return, the application creates a credit memo. You can
update the credit memo on BL20.1 (Invoice Entry). If you delete the credit
memo, the accounts receivable and sales accounts are not affected.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
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.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store detail transaction history for stock on hand
quantity updates of inventory tracked items. Detail includes
bins, lots, serial numbers, and multiple units of measure.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details.
When copying an invoice to create a return, details are copied
from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines.
When copying an invoice to create a return, lines are copied
from this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
When copying an invoice to create a return, information is
copied from this file to the return header.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple unit of measure quantities are kept on this file.
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD -
OE30.2 - Return Lines
**Form Purpose
Use Return Lines (OE30.2) to enter line detail to return headers. This is the
second form used to return items. You can only create returns after the
invoice has been printed by BL122 (Invoice and Register Print).
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the order line is for a kit item. Contains the
components for the kit item ordered.
COLINE - Used to store customer order line information.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store transaction history for stock on hand quantity
updates of inventory tracked items.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details.
When copying an invoice to create a return, details are copied
from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines.
When copying an invoice to create a return, lines are copied
from this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
When copying an invoice to create a return, information is
copied from this file to the return header.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to verify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple unit of measure quantities are kept on this file.
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD -
OE30.3 - Return Line Detail
**Form Purpose
Use Return Line Detail (OE30.3) to enter detail information for a return
line. All information is optional. However, for catchweight items, both the
stock and secondary quantity must be entered.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the order line is for a kit item. Contains the
components for the kit item ordered.
COLINE - Used to store customer order line information.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store detail transaction history for stock on hand
quantity updates of inventory tracked items. Detail includes
bins, lots, serial numbers, and multiple units of measure.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details.
When copying an invoice to create a return, details are copied
from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines. When
copying an invoice to create a return, lines are copied from
this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
When copying an invoice to create a return, information is
copied from this file to the return header.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple unit of measure quantities are kept on this file.
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD -
OE30.4 - Return Bins
**Form Purpose
Use Return Bins (OE30.4) to indicate which bin the items will be stored in.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the order line is for a kit item. Contains the
components for the kit item ordered.
COLINE - Used to store customer order line information.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store detail transaction history for stock on hand
quantity updates of inventory tracked items. Detail includes
bins, lots, serial numbers, and multiple units of measure.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details. When copying an invoice to create a return, details
are copied from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines. When
copying an invoice to create a return, lines are copied from
this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
When copying an invoice to create a return, information is
copied from this file to the return header.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple unit of measure quantities are kept on this file.
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD -
WHSHLDTL -
OE30.5 - Return Lots
**Form Purpose
Use Return Lots (OE30.5) to indicate which lots and sublots are being
returned. If the item is also bin tracked, specify which bin each lot is being
stored in.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the order line is for a kit item. Contains the
components for the kit item ordered.
COLINE - Used to store customer order line information.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store detail transaction history for stock on hand
quantity updates of inventory tracked items. Detail includes
bins, lots, serial numbers, and multiple units of measure.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details. When copying an invoice to create a return, details
are copied from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines. When
copying an invoice to create a return, lines are copied from
this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
When copying an invoice to create a return, information is
copied from this file to the return header.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple units of measure quantities are kept on this file.
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD -
WHSHLDTL - Used to store shipment line detail quantities for bin, lot,
serial number, and multiple unit of measure detail tracked
items.
OE30.6 - Return Serials
**Form Purpose
Use Return Serials (OE30.6) to tell the application which serial numbers are
being returned. If the item is also bin tracked, specify the bin in which the
item will be stored.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the order line is for a kit item. Contains the
components for the kit item ordered.
COLINE - Used to store customer order line information.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store detail transaction history for stock on hand
quantity updates of inventory tracked items. Detail includes
bins, lots, serial numbers, and multiple units of measure.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details. When copying an invoice to create a return, details
are copied from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines. When
copying an invoice to create a return, lines are copied from
this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple units of measure quantities are kept on this file.
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD -
WHSHLDTL - Used to store shipment line detail quantities for bin, lot,
serial number, and multiple unit of measure detail tracked
items.
OE30.7 - Return by Unit of Measure
**Form Purpose
Use Return by UOM (OE30.7) to indicate the quantities of each unit of measure
being returned.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the order line is for a kit item. Contains the
components for the kit item ordered.
COLINE - Used to store customer order line information.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store detail transaction history for stock on hand
quantity updates of inventory tracked items. Detail includes
bins, lots, serial numbers, and multiple units of measure.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details.
When copying an invoice to create a return, details are copied
from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines. When
copying an invoice to create a return, lines are copied from
this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
When copying an invoice to create a return, information is
copied from this file to the return header.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple units of measure quantities are kept on this file.
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
WHSHLAUD -
OE30.9 - Return Copy
**Form Purpose
Use Return Copy (OE30.9) to return all items for an invoice or order.
**Processing Effect
The application creates a return for all the line items in a single invoice
or order.
Updated Files
ACCOMMIT - Used in the Activity Management edit routines.
ACCOMMITX - Used in the Activity Management edit routines.
ADDRDATA -
ARCODE - Used to validate the Accounts Receivable code.
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.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
COCOMP - Created if the order line is for a kit item. Contains the
components for the kit item ordered.
COLINE - Used to store customer order line information.
COLINEUOM - Used to store item pricing for an order line if the item is
priced via multiple units of measure.
COMISC - Used to store order and order line add-on charges.
COSGBLK -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
HCPATCHRG - Not used in this program.
HCPATVISIT - Not used in this program.
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 item sales history for inventory tracked
items.
ICLOCATION - Used to validate Inventory Control locations.
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 of inventory tracked items.
ICTRANSDTL - Used to store detail transaction history for stock on hand
quantity updates of inventory tracked items. Detail includes
bins, lots, serial numbers, and multiple units of measure.
INSTDETAIL -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
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 -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store invoice line bin, lot, serial number, and
multiple units of measure. When creating credit memos, invoice
details for lots and serial numbers are created from return
details. When copying an invoice to create a return, details
are copied from this file to the return detail file.
OEINVCLINE - Used to store invoice line information. When creating credit
memos, invoice lines are created from return lines. When
copying an invoice to create a return, lines are copied from
this file to the return line file.
OEINVCMISC - Used to store invoice add-on charges. When creating a credit
memo, invoice add-on charges are created from the return add-on
charges.
OEINVCTAX - Used to store invoice taxes when the invoice is released.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type is referenced, the used flag is set.
OEINVCUOM - Used to store invoice pricing information when multiple units
of measure are used to price.
OEINVHDR - Invoice Batch Header file. Created when a return is released
that creates a credit memo.
OEINVOICE - Used to store invoice information. When creating a credit
memo, the invoice is created from the return information.
When copying an invoice to create a return, information is
copied from this file to the return header.
OEINVSGBLK -
OEMETHOD -
OEMISC - Used to validate add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
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 -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
POINTERFAC - Used to pass purchase order items that are to be ordered from
a vendor rather than filled from stock.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNDTL - Used to store return details. Lot, bin, serial number, and
multiple units of measure quantities are kept on this file.
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
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, serial number,
and multiple unit of measure quantities are kept on these
records.
TERITORY - Used to validate the sales territory. If this is the first
time the territory is referenced, the used flag is set.
TERMS - Used to validate the Accounts Receivable terms
code.
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.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 -
APINVOICE -
APPAYMENT -
APPROCLEV -
APUAVAL -
APVENADDR -
APVENGROUP -
ARADJUST - Used in the Customer Edit routine.
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 - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
AROIHDR - Used in the Customer Edit routine.
AROITEMS - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
BILLTO - Used to validate the customer bill to entered on the
order.
BUYCLASS -
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 -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
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 -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
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 any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to edit the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OEROUTE - Used to validate routes.
OESLSACCT - Used to validate sales class accounts.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
WHSHIPMENT - Used to store shipment header information.
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
|