|
|
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
BL05.1 BL125 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 TX00.1 TX40.1
WH120
UPDATED BY
BL00.1 BL01.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL200 BL201 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
BL98.1 TX140 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEP-COMPANY Numeric 4 BL01.1
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OEP-PROCESS-LEVEL Alpha 5 BL01.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
OEP-NAME Alpha 30 (Lower Case) BL01.1
Element: Name The name of the process level. This is
the remit-to name that will print on the
invoice.
OEP-POA-NAME Alpha 30 (Lower Case) BL01.1
Element: Name Displays the company description.
OEP-POA-ADDR1 Alpha 30 (Lower Case) BL01.1
Element: Addr1 This field contains the first line of
address information.
OEP-POA-ADDR2 Alpha 30 (Lower Case) BL01.1
Element: Addr1 This field contains the first line of
address information.
OEP-POA-ADDR3 Alpha 30 (Lower Case) BL01.1
Element: Addr1 This field contains the first line of
address information.
OEP-POA-ADDR4 Alpha 30 (Lower Case) BL01.1
Element: Addr1 This field contains the first line of
address information.
OEP-POA-CITY Alpha 18 BL01.1
Element: Bill City
OEP-POA-STATE Alpha 2 BL01.1
Element: Poa State
OEP-POA-ZIP Alpha 10 BL01.1
Element: Zip This field contains the postal code of
the address.
OEP-POA-COUNTRY Alpha 30 (Lower Case) BL01.1
Element: Poa Country
OEP-POA-COUNTY Alpha 25 (Lower Case) BL01.1 TX140
Element: County The county for the company address.
OEP-RMT-NAME Alpha 30 (Lower Case) BL01.1
Element: Name The first line of the remit-to address
is entered in this field.
OEP-RMT-ADDR1 Alpha 30 (Lower Case) BL01.1
Element: Addr1 The remit-to address that will print on
documents created using this process
level.
OEP-RMT-ADDR2 Alpha 30 (Lower Case) BL01.1
Element: Addr1 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-ADDR3 Alpha 30 (Lower Case) BL01.1
Element: Addr1 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-ADDR4 Alpha 30 (Lower Case) BL01.1
Element: Addr1 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-CITY Alpha 18 BL01.1
Element: Bill City The remit-to city that will print on
documents created for this process
level.
OEP-RMT-STATE Alpha 2 BL01.1
Element: State Prov The remit-to state that will print on
documents created for this process
level.
OEP-RMT-ZIP Alpha 10 BL01.1
Element: 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
Element: Country The remit-to country that will print on
documents created for this process
level.
OEP-RMT-COUNTY Alpha 25 (Lower Case) BL01.1
Element: County The county for the company address.
OEP-DEF-LOCATION Alpha 5 BL01.1
Element: Location The default location that will be used
when placing an order for this process
level.
OEP-DEF-ORDER-TYP Alpha 2 BL01.1
Element: Order Type The default order type that will be
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
Element: Cb Reason The default cancellation reason code to
be used by the system when canceling an
order for this process level. These
codes are defined on BL07.1 (Reason
Codes).
OEP-DEF-COD-HOLD Alpha 4 BL01.1
Element: Hold Code 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
Element: Hold Code 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
Element: Acct Unit Safety default general ledger account
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
Element: 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
Element: Sub Acct 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
Element: Acct Unit This is the sales general ledger
account unit to be credited for special
orders placed using this process level.
OEP-MI-ACCOUNT Numeric 6 BL01.1
Element: Account This is the sales general ledger
account number to be credited for
special orders placed using this process
level.
OEP-MI-SUB-ACCT Numeric 4 BL01.1
Element: Sub Acct This is the sales general ledger
subaccount number to be credited for
special orders placed using this process
level.
OEP-MCG-ACCT-UNIT Alpha 15 BL01.1
Element: Acct Unit This is the general ledger account 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
Element: Account This is the general ledger 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
Element: Sub Acct This is the general ledger subaccount
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
Element: Acct Unit This is the general ledger account 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
Element: 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
Element: Sub Acct This is the general ledger 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
Element: Acct Unit Default general ledger accounting 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
Element: 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
Element: Sub Acct Default general ledger subaccount
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-EDIT-OPT Alpha 1 BL01.1
Element: All Flag 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
Element: All Flag This field indicates whether or not to
post cost for interfaced invoice.
Y = Yes
N = No
OEP-INTF-INV-FL Alpha 1
Element: All Flag This field indicates whether or not to
post cost for interfaced invoices.
Y = Yes
N = No
OEP-TAX-PRINT-CD Alpha 1 BL01.1
Element: 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
P = Price incl tax - print summary
OEP-TAX-PRICE-FL Alpha 1
Element: All Flag 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
Element: All Flag 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
Element: All Flag Y = Yes
N = No
" "
OEP-INVC-CR-FL Alpha 1
Element: All 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
Element: All Flag If invoicing is done at the process
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
Element: All Flag If invoicing is done at the process
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
Element: All Flag 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
Element: All Flag 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
Element: All Flag 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
Element: Ship Days Number of days to be added to the order
date when an order is added to the
system to calculate the default expected
ship date for the orders. Orders are
printed on the pick list based upon
their expected ship date.
OEP-EDI-NUMBER Alpha 15 BL01.1
Element: Edi Nbr Electronic Data Interface (EDI) number.
OEP-USED-FL Alpha 1 BL00.1 BL01.1
Element: Used Fl Flag indicating whether the process BL120 BL121
level has been used or not. BL122 BL123
Y = Yes BL130 BL20.1
N = No BL20.3 BL200
BL201 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BL98.1 WH20.7
OEP-TAX-EXEMPT-CD Alpha 1 BL01.1
Element: Tax Exempt Cd Code indicating the taxing status. E -
Exempt, T - Taxable.
OEP-TAX-CODE Alpha 10 BL01.1 TX140
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
OEP-POA-CTRY-CD Alpha 2 BL01.1
Element: Poa Ctry Cd
OEP-POA-REGION Alpha 2 BL01.1
Element: Poa Region
OEP-POA-EC-CTRY Numeric 3 BL01.1
Element: Poa Ec Ctry
OEP-POA-ISO-CTRY Numeric 3 BL01.1
Element: Poa Iso Ctry
OEP-RMT-CTRY-CD Alpha 2 BL01.1
Element: Rmt Ctry Cd
OEP-RMT-REGION Alpha 2 BL01.1
Element: Rmt Region
OEP-RMT-EC-CTRY Numeric 3 BL01.1
Element: Rmt Ec Ctry
OEP-RMT-ISO-CTRY Numeric 3 BL01.1
Element: Rmt Iso Ctry
OEPROCLEV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEPSET1 COMPANY BL00.1 BL01.1
PROCESS-LEVEL BL05.1 BL120
BL121 BL122
BL123 BL125
BL130 BL20.1
BL20.3 BL20.5
BL20.6 BL200
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
...
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
OEPROCLEV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompref OECOMPREF
OEP-COMPANY -> OEL-COMPANY
OEP-PROCESS-LEVEL -> OEL-PROCESS-LEVEL
OEL-TYPE
|
