|
|
OEPROCLEV FILE
Order Entry Process Level
The Order Entry Process Level file contains the valid process levels for the
entire system. Each is attached to a company and can only be used in that
company. A process level can be a division, a department, a group of
departments, and so on. An entity that will enter, process, and track
customer orders separately should be defined as a process level.
REFERENCED BY
AC15.1 BL00.1 BL05.1 BL121 BL201 BL205
BL220 BL290 BL291 BL293 BL30.1 BL30.2
BL30.3 BL30.5 BL31.1 BL31.2 BL31.3 BL31.5
BL31.7 BL32.1 BL32.2 BL32.3 BL32.4 BL80.1
BL91.1 OE112 OE210 OE272 OE280 OE281
OE283 OE284 OE286 OE287 OE288 OE289
OE290 OE291 OE292 OE293 OE53.1 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 OE81.1 OE85.1
OE90.1 OE90.2 SA02.1 SA80.1 SA90.1 SAA2.1
WH120
UPDATED BY
AC115 BL01.1 BL120 BL122 BL123 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 BL940 BL965 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE810 OE830 OE920 OE950 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEP-COMPANY Numeric 4 BL01.1 BL965
Company The company number represents an
established company and is entered on
all function codes.
OEP-PROCESS-LEVEL Alpha 5 BL01.1 BL965
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
OEP-NAME Alpha 30 (Lower Case) BL01.1 BL965
Name The name of the process level. This is OE30.1 OE53.1
the remit-to name that will print on the
invoice.
OEP-RMT-NAME Alpha 30 (Lower Case) BL01.1 BL965
Rmt Name The first line of the remit-to address
is entered in this field.
OEP-RMT-ADDR1 Alpha 30 (Lower Case) BL01.1 BL965
Rmt Addr1 The remit-to address that will print on
documents created using this process
level.
OEP-RMT-ADDR2 Alpha 30 (Lower Case) BL01.1 BL965
Rmt Addr2 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-ADDR3 Alpha 30 (Lower Case) BL01.1 BL965
Rmt Addr3 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-ADDR4 Alpha 30 (Lower Case) BL01.1 BL965
Rmt Addr4 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-CITY Alpha 18 BL01.1 BL965
Rmt City The remit-to city that will print on
documents created for this process
level.
OEP-RMT-STATE Alpha 2 BL01.1 BL965
Rmt State The remit-to state that will print on
documents created for this process
level.
OEP-RMT-ZIP Alpha 10 BL01.1 BL965
Rmt Zip The remit-to postal code that will
print on documents created for this
process level.
OEP-RMT-COUNTRY Alpha 30 (Lower Case) BL01.1 BL965
Rmt Country The remit-to country that will print on
documents created for this process
level.
OEP-DEF-LOCATION Alpha 5 BL01.1 BL965
Default Location The default location that will be used
for Operator when placing an order for this process
level.
OEP-DEF-ORDER-TYP Alpha 2 BL01.1 BL965
Default Order Type The default order type that will be
for Opr used when placing an order for this
process level when the operator's
default order type is blank. Order types
are set up on OE51.1 (Order Type).
OEP-DEF-REASON Alpha 4 BL01.1 BL965
Default The default cancellation reason code to OE10.1 OE10.2
Cancellation Reason be used by the system when canceling an OE10.3 OE10.4
order for this process level. These OE10.5 OE10.6
codes are defined on BL07.1 (Reason OE10.7 OE10.8
Codes). OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.2
WH20.7
OEP-DEF-COD-HOLD Alpha 4 BL01.1 BL965
Def Cod Hold The default hold code that the system
will use for Cash on Delivery invoices
placed on hold that belong to this
process level. Hold codes are
established in the Accounts Receivable
system.
Cash on delivery invoices are placed on
hold after the shipment record has been
created and the invoice sent. To process
the invoice it must be taken off hold.
OEP-DEF-CIA-HOLD Alpha 4 BL01.1 BL965
Def Cia-Hold The default hold code that the system
will use for orders placed on hold if
cash in advance has not been paid yet
for all invoices that belong to this
process level. Hold codes are
established in the Accounts Receivable
system.
OEP-SLS-ACCT-UNIT Alpha 15 BL01.1 BL965
Sales Accounting Safety default general ledger account
Unit unit to be credited for items ordered
using this process level. This account
unit will be disregarded and the sales
account unit on the sales major/minor
classes will be used instead. The sales
major/minor class accounts are
established on BL05.1 (Sales Class
Accounts). This sales account found on
the process level serves as somewhat of
a safety net - if something goes wrong
and for some reason the sales class
record is not found, the system will use
this account. Therefore, it should never
really be used.
OEP-SLS-ACCOUNT Numeric 6 BL01.1 BL965
Sales Account Default general ledger account number
to be credited for items ordered using
this process level. This account number
will be disregarded and the sales
account number on the sales major/minor
classes will be used instead. The sales
major/minor class accounts are
established on BL05.1 (Sales Class
Accounts). This sales account found on
the process level serves as somewhat of
a safety net - if something goes wrong
and for some reason the sales class
record is not found, the system will use
this account. Therefore, it should never
really be used.
OEP-SLS-SUB-ACCT Numeric 4 BL01.1 BL965
Sales Subaccount Default general ledger subaccount
number to be credited for items ordered
using this process level. This account
unit will be disregarded and the sales
account unit on the sales major/minor
classes will be used instead. The sales
major/minor class accounts are
established on BL05.1 (Sales Class
Accounts). This sales account found on
the process level serves as somewhat of
a safety net - if something goes wrong
and for some reason the sales class
record is not found, the system will use
this account. Therefore, it should never
really be used.
OEP-MI-ACCT-UNIT Alpha 15 BL01.1 BL965
Default Misc This is the sales general ledger
Accounting Unit account unit to be credited for special
orders placed using this process level.
OEP-MI-ACCOUNT Numeric 6 BL01.1 BL965
Default Misc This is the sales general ledger
Account Number account number to be credited for
special orders placed using this process
level.
OEP-MI-SUB-ACCT Numeric 4 BL01.1 BL965
Default Misc This is the sales general ledger
Subaccount Number subaccount number to be credited for
special orders placed using this process
level.
OEP-MCG-ACCT-UNIT Alpha 15 BL01.1 BL965
Miscellaneous COGS This is the general ledger account unit
Acct Unit that is debited for cost of goods sold
when a special order is placed for this
process level.
OEP-MCG-ACCOUNT Numeric 6 BL01.1 BL965
Miscellaneous COGS This is the general ledger account
Account number that is debited for cost of goods
sold when a special order is placed for
this process level.
OEP-MCG-SUB-ACCT Numeric 4 BL01.1 BL965
Miscellaneous COGS This is the general ledger subaccount
Subacct number that is debited for cost of goods
sold when a special order is placed for
this process level.
OEP-EXP-ACCT-UNIT Alpha 15 BL01.1 BL965
Expense Accounting This is the general ledger account unit
Unit to be credited as an offset to COGS when
placing a special order for this process
level.
OEP-EXP-ACCOUNT Numeric 6 BL01.1 BL965
Expense Account This is the general ledger account
number to be credited as the offset to
COGS when placing a special order using
this process level.
OEP-EXP-SUB-ACCT Numeric 4 BL01.1 BL965
Depr Expense This is the general ledger subaccount
Subaccount number to be credited as the offset to
COGS for special orders placed using
this process level.
OEP-DSC-ACCT-UNIT Alpha 15 BL01.1 BL965
Discount Accounting Default general ledger accounting unit
Unit that will be debited when add-on
discounts are used. An add-on discount
can be either entered for an order line
or an order header by using some of the
options available at order entry time.
OEP-DSC-ACCOUNT Numeric 6 BL01.1 BL965
Discount Account Default general ledger accounting
number that will be debited when add-on
discounts are used. An add-on discount
can be either entered for an order line
or an order header by using some of the
options available at order entry time.
OEP-DSC-SUB-ACCT Numeric 4 BL01.1 BL965
Discount Subaccount Default general ledger subaccount
Number number that will be debited when add-on
discounts are used. An add-on discount
can be either entered for an order line
or an order header by using some of the
options available at order entry time.
OEP-INVC-PREFIX Alpha 2 BL01.1 BL965
Invoice Prefix Invoice prefix is assigned from either
the company or process level depending
on the invoice level option chosen. This
is a unique two-character prefix that
will precede invoices created by the
system.
OEP-LST-INVC-NBR Numeric 8 AC115 BL01.1
Last Invoice Number Last invoice number used by the system BL120 BL130
within the company. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL965 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEP-CM-PREFIX Alpha 2 BL01.1 BL965
Cm Prefix Credit memo prefix is assigned from
either the process level or the company
depending upon an option chosen when
setting up the company in the Billing
system. This is a unique two-character
prefix that will precede the credit memo
number for all credit memos created
using the system.
OEP-LST-CM-NBR Numeric 8 AC115 BL01.1
Lst Cm Nbr Last credit memo number used by the BL120 BL130
system within a company. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL965 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEP-RECUR-PREFIX Alpha 2 BL01.1 BL965
Recur Prefix The recurring invoice prefix is
assigned from either the process level
or the company level, based on a
company-level option.
OEP-LST-RECUR-INVC Numeric 8 BL01.1 BL120
Lst Recur Invc The last recurring invoice number used BL130 BL20.1
by the system within a company. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BL940 BL965
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEP-INVC-EDIT-OPT Alpha 1 BL01.1 BL965
Invoice Edit Option Option that determines whether or not
users are required to run an invoice
edit report before the invoice is
printed out. If the invoice edit is
required, users will need to run BL121
(Invoice Print Edit Report).
N = No
Y = Yes
OEP-INTF-COST-FL Alpha 1 BL01.1 BL965
Intf Cost Fl This field indicates whether or not to
post cost for interfaced invoice.
Y = Yes
N = No
OEP-INTF-INV-FL Alpha 1 BL965
Intf Inv Fl This field indicates whether or not to
post cost for interfaced invoices.
Y = Yes
N = No
OEP-TAX-PRINT-CD Alpha 1 BL01.1 BL965
Tax Print Cd Code indicating whether the tax lines
should print in summary or detail on the
invoice.
D = Calc by line - print Detail
S = Calc by line - print summary
T = Calc and print in summary
OEP-TAX-PRICE-FL Alpha 1 BL965
Tax Price Fl Flag to indicate that prices printed on
the customer's invoice include taxes.
Y = Yes
N = No
OEP-DISC-AOC-FL Alpha 1 BL01.1 BL965
Disc AOC Fl Flag to indicate whether add-on charges
are included in order-level discount
calculations.
Y = Yes
N = No
OEP-TERMS-AOC-FL Alpha 1 BL01.1 BL965
Terms AOC Fl Indicates whether terms are applied to
add-on costs.
Y = Yes
N = No
" "
OEP-INVC-CR-FL Alpha 1 BL965 OE129
Credit Memo Flag If invoicing is done at the process
level and OE129 (Daily Shipment Journal)
is running (this program creates
invoices), this flag will be set to Yes
to indicate that other invoice update
programs cannot be run.
N = No
Y = Yes
OEP-INVC-EDIT-FL Alpha 1 BL965
Invoice Edit If invoicing is done at the process
Running Flag level and BL121 (Invoice Print Edit
Report) is running, this flag will be
set to Yes to indicate that other
invoice update programs cannot be run.
N = No
Y = Yes
OEP-INVC-PRT-FL Alpha 1 BL122 BL965
Invoice Printed Flag If invoicing is done at the process OE114
level and BL122 (Invoice and Register
Print) is running, this flag will be set
to Yes to indicate that other invoice
update programs cannot be run.
N = No
Y = Yes
OEP-INVC-UPD-FL Alpha 1 BL123 BL965
Invc Upd Fl If invoicing is done at the company
level and BL123 (Sub-System Update) is
running, this flag will be set to Yes to
indicate that other invoice update
programs cannot be run.
N = No
Y = Yes
OEP-INVC-DTL-FL Alpha 1 BL01.1 BL965
Invc Dtl Fl This flag indicates whether
lots/sublots and serial numbers of items
ordered should print on the invoice.
N = No
Y = Yes
OEP-COD-INVC-OPT Alpha 1 BL01.1 BL965
Cod Invc Opt This option determines whether invoices
should be created and printed twice for
Cash on Delivery orders. If Yes is
selected, an invoice will be printed to
be sent with the goods (invoice at this
time is placed on hold until the driver
returns with the payment) and when the
driver returns with the payment, that
invoice will be printed again to send to
the customer for their records. This
final invoice will reflect any
corrections made after the driver
returns.
The invoice for the COD order is
printed right after the packing step by
the COD invoice print program to
accompany the shipping. This option
determines whether an additional invoice
is to be printed by BL122 (Invoice and
Register Print).
Y = Yes
N = No
OEP-SHIP-DAYS Numeric 3 BL01.1 BL965
Normal Days to Ship Number of days to be added to the order OE10.1 OE10.2
Order date when an order is added to the OE10.3 OE10.4
system to calculate the default expected OE10.5 OE10.6
ship date for the orders. Orders are OE10.7 OE10.8
printed on the pick list based upon OE11.1 OE11.4
their expected ship date. OE11.8 OE11.9
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 WH20.2
WH20.7
OEP-EDI-NUMBER Alpha 15 BL01.1 BL965
EDI Number Electronic Data Interface (EDI) number.
OEP-USED-FL Alpha 1 BL120 BL130
Used Flag indicating whether the process BL20.1 BL20.3
level has been used or not. BL21.2 BL21.5
Y = Yes BL29.1 BL29.2
N = No BL520 BL820
BL92.1 BL940
BL965 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 WH20.7
OEPROCLEV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEPSET1 COMPANY AC115 AC15.1
PROCESS-LEVEL BL00.1 BL01.1
BL05.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL201 BL205
BL21.2 BL21.5
BL220 BL29.1
BL29.2 BL290
BL291 BL293
BL30.1 BL30.2
BL30.3 BL30.5
BL31.1 BL31.2
BL31.3 BL31.5
...
OEPROCLEV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OEP-COMPANY -> ACO-COMPANY
Arproclevl ARPROCLEVL Required
OEP-COMPANY -> APV-COMPANY
OEP-PROCESS-LEVEL -> APV-PROCESS-LEVEL
Def Cia Hold HOLDCODES Required
When OEP-DEF-CIA-HOLD != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
OEP-DEF-CIA-HOLD -> HDD-HOLD-CODE
Def Cod Hold HOLDCODES Required
When OEP-DEF-COD-HOLD != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
OEP-DEF-COD-HOLD -> HDD-HOLD-CODE
Exp Acct GLMASTER Required
When OEP-EXP-ACCT-UNIT != Spaces
Or OEP-EXP-ACCOUNT != Zeroes
Or OEP-EXP-SUB-ACCT != Zeroes
OEP-COMPANY -> GLM-COMPANY
OEP-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
OEP-EXP-ACCOUNT -> GLM-ACCOUNT
OEP-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Misc Csgs GLMASTER Required
When OEP-MCG-ACCT-UNIT != Spaces
Or OEP-MCG-ACCOUNT != Zeroes
Or OEP-MCG-SUB-ACCT != Zeroes
OEP-COMPANY -> GLM-COMPANY
OEP-MCG-ACCT-UNIT -> GLM-ACCT-UNIT
OEP-MCG-ACCOUNT -> GLM-ACCOUNT
OEP-MCG-SUB-ACCT -> GLM-SUB-ACCOUNT
Misc Sls Acct GLMASTER Required
OEP-COMPANY -> GLM-COMPANY
OEP-MI-ACCT-UNIT -> GLM-ACCT-UNIT
OEP-MI-ACCOUNT -> GLM-ACCOUNT
OEP-MI-SUB-ACCT -> GLM-SUB-ACCOUNT
Oecompany OECOMPANY Required
OEP-COMPANY -> OEC-COMPANY
Oereason OEREASON Required
When OEP-DEF-REASON != Spaces
OEP-COMPANY -> OER-COMPANY
OEP-DEF-REASON -> OER-REASON-CODE
Ord Discount GLMASTER Required
When OEP-DSC-ACCT-UNIT != Spaces
Or OEP-DSC-ACCOUNT != Zeroes
Or OEP-DSC-SUB-ACCT != Zeroes
OEP-COMPANY -> GLM-COMPANY
OEP-DSC-ACCT-UNIT -> GLM-ACCT-UNIT
OEP-DSC-ACCOUNT -> GLM-ACCOUNT
OEP-DSC-SUB-ACCT -> GLM-SUB-ACCOUNT
Ordertype ORDERTYPE Required
OEP-COMPANY -> OTP-COMPANY
OEP-DEF-ORDER-TYP -> OTP-ORDER-TYPE
Sales Account GLMASTER Required
OEP-COMPANY -> GLM-COMPANY
OEP-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
OEP-SLS-ACCOUNT -> GLM-ACCOUNT
OEP-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
|