|
|
OE14.1 - Order Tax Inquiry
Use this subform to display the order's projected tax and discount
information.
Updated Files
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.
Referenced Files
APACCRCODE - Used in the Vendor Edit routine.
COLINE - Used to store customer order line information.
COMISC - Used to store customer order/customer order line add-on
charges.
CUCONV - Used to access general ledger and currency information.
CURELAT - Used to validate currency relationships.
CUSTORDER - Stores a record for every order entered in the Order Entry
system.
GLSYSTEM - Used to validate the General Ledger company.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
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.
OEPROCLEV - Used to validate the Billing process level.
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.
TXTAXRATE - Used in the Sales Tax Calculation routine.
OE14.2 - Line Tax Inquiry
With this subform, you can inquire on projected tax and discount information
for a specific order line.
Updated Files
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.
Referenced Files
APACCRCODE - Used in the Vendor Edit routine.
COLINE - Used to store customer order line information.
COMISC - Used to store customer order/customer order line add-on
charges.
CUCONV - Used to access general ledger and currency information.
CURELAT - Used to validate currency relationships.
CUSTORDER - Stores a record for every order entered in the Order Entry
system.
GLSYSTEM - Used to validate the General Ledger company.
ICCOMPANY - Used to validate the Inventory Control company.
ICLOCATION - Used to validate the Inventory Control location.
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.
OEPROCLEV - Used to validate the Billing process level.
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.
TXTAXRATE - Used in the Sales Tax Calculation routine.
OE14.3 - Customer Credit Status
Use this subform to display a customer's credit situation. For example, if a
customer who is on hold places an order, this subform displays, notifying you
that the customer is on hold (assuming the company is performing online
allocation).
Updated Files
HOLDCODES - Used to validate the hold code. If this is the first time the
hold code is
referenced, the used flag is set.
Referenced Files
AGINGCODE - 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.
ARCUSTOMER - Used to validate the Accounts Receivable customer. The open
order amount is updated with the released order's total amount.
ARCUSTTOTS - Used in the Customer Edit routine.
ARLOCKBOX - Used in the Customer Edit routine.
ARPAYMENT - Used in the Customer Edit routine.
CUSTDESC - Used in the Customer Edit routine.
CUSTORDER - Stores a record for every order entered in the Order Entry
system.
INSTCTRYCD - Validates the Intrastat country code.
NATACCT - Used in the Customer Edit routine.
NATBALANCE - Used in the Customer Edit routine.
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.
OECUST - Used in the Customer Edit routine.
STATICCUST - Used in the Customer Edit routine.
OE14.4 - Order Copy
With this subform, you can create an order by copying from either a standard
order or a previous order for this customer.
Updated Files
ACCOMMIT - Used to maintain commitment balance information for activity
transactions that have not been posted to the general ledger.
ACCOMMITX - Used to maintain commitment detail information for activity
transactions that have not been posted to the general ledger.
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.
COLINEDTL - Used to store allocated details (lot, serial number, bin, unit
of measure quantity)
for a 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 - Used to store user analysis values for order header, line, and
add-on charge records. User analysis values represent
information your organization can use to measure profitability.
To utilize this measure of organizational profitability, you
must be set up to use the Strategic Ledger system.
CUSTDESC - Used in the Customer Edit routine.
CUSTORDER - Stores a record for every order entered in the Order Entry
system.
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.
ICLOT - Used to obtain the lot expiration date.
ICRECEIPTS - Used to record receipts of stock.
INSTDETAIL - Used to maintain Intrastat detail records.
INSTHEADER - Used to maintain Intrastat header records.
INSTNBR - Used to assign the next available Intrastat number to an
Intrastat transaction.
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.
MMDIST - Contains general ledger account postings for inventory
transaction.
MMUAVAL - Used to store user analysis values defined for transactions.
User analysis values represent information your organization
can use to measure profitability. To utilize this measure of
organizational profitability, you must be set up to use the
Strategic Ledger system.
NATBALANCE - Used in the Customer Edit routine.
OEAUDIT - Used to store audits of changes to released customer orders
and order lines.
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.
OECREDCARD - Used to validate the credit card type. If this is the first
time the credit
card type is referenced, the used flag is set.
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.
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.
POAOCDTL - Used in Purchase Order revision logic.
POAUDIT - Used in Purchase Order revision logic.
POCOMMENTS - Used in Purchase Order revision logic.
POCOMOUT -
POHDROUT -
POINTAOC - Used in Purchase Order revision logic.
POINTCMTS - Used to pass comments for purchase order items that are to be
ordered from a vendor rather than
fulfilled from stock.
POINTERFAC - Used in Purchase Order revision logic.
POLINE - Used in Purchase Order revision logic.
POLINEOUT -
PORETURNHD - Used to store and validate vendor return header information.
POVENDOR - Used in Purchase Order revision logic.
PURCHORDER - 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.
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.
STPOLINE - Used in Purchase Order revision logic.
STPURCHORD - Used in Purchase Order revision logic.
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.
WHDEMNDCMT - Contains comments for the demand records. Created from order
comments or requisition comments.
WHDEMNDHDR - Used to validate the Warehouse demand header.
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.
ACCAL - Used in the Activity Management edit routines.
ACCALX - Used in the Activity Management edit routines.
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.
APCOMPANY - Used to validate the Accounts Payable company.
APCPYVND - Used in the Vendor Edit routine.
APDISTCODE - Used in the Vendor Edit routine.
APHLDINV - Used in the Vendor Edit routine.
APPROCLEV - Used to validate the Accounts Payable company.
APVENCLASS - Used in the Vendor Edit routine.
APVENGROUP - Used in the Vendor Edit routine.
APVENLOC - Used in the Vendor Edit routine.
APVENMAST - Used to validate the Accounts Payable vendor.
ARCOMMENT - Used to obtain customer comments for customer orders.
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.
ARLOCKBOX - 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 - Used in Purchase Order revision logic.
BUYER - Used in Purchase Order revision logic.
COMPONENT - Used to obtain Inventory Control definition of components for
a kit item.
CUCONV - Used to access general ledger and currency information.
CURELAT - Used to validate currency relationships.
FOBCODE - Used in Purchase Order revision logic.
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.
GLSYSTEM - Used to validate the General Ledger company.
ICBIN - Used to validate Inventory Control bins.
ICCATEGORY - Used to validate Inventory Control general ledger categories.
ICCOUT -
ICLOCATION - Used to validate the Inventory Control location.
INSTATPROC - Used to validate Intrastat statistical procedure codes.
INSTCMDTY - Used to validate Intrastat commodity codes.
INSTCTRYCD - Validates the Intrastat country code.
INSTNOTC - Used to validate Intrastat nature of transaction codes.
INSTPORTS - Used to validate Intrastat port codes.
INSTREGN - Used to validate Intrastat region codes.
INSTUOM - Used to validate Intrastat secondary units of measure.
ITEMADDON - Used to create add-on charges automatically when specified
items are sold to
specific states (or optionally to any state).
ITEMMAST - Used to validate the Inventory Control item.
ITEMSUB - Used to find item substitutes.
KITITEM - Used to identify kit items.
MAJORCL - Used to validate the major sales class.
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.
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.
OEINVCTYPE - Used to validate the invoice type. If this is the first time
the invoice type
is referenced, the used flag is set.
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.
OESTDCOMM - Used to validate the standard comment code. If valid,
comments are then copied to the order comment file for the line
referenced.
OESTDLINE - Used to store standard order line information.
OESTDORDER - Contains standard order header information.
OPERATOR - Used to validate the user ID.
POAOCMAST - Used in Purchase Order revision logic.
POAOCSPRD - Used in Purchase Order revision logic.
POAPPROVE - Used in Purchase Order revision logic.
POCOMPANY - Used to validate the Purchase Order company.
POFRTTERM - Used in Purchase Order revision logic.
POINVOICE - Used in Purchase Order revision logic.
POITEMVEN - Used in Purchase Order revision logic.
POLOCCON - Used to maintain and validate ties between requesting
locations and contracts.
POQUOTES - Used in Purchase Order revision logic.
PORECLINE - Used in Purchase Order revision logic.
POVENDLOC - Used in Purchase Order revision logic.
REQHEADER -
REQLINE - Used in Purchase Order revision logic.
RQLOC - Used in the Warehouse edit routines.
SHIPTOCMNT - Used to obtain ship-to order comments.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE - Used to validate standard comment codes.
SYSTEMCODE - Used to validate system code information.
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate the Warehouse process type.
INVOKED Programs
IFAC
ACAC
IFCR
IFSG
IFCU
IFAU
SLSE
SLSU
IFCC
IFOB
IFRS
SLSS
|