|
|
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 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 SADM.2 TX226 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
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 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE810 OE830 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 OE30.1
Element: Name The name of the process level. This is OE53.1
the remit-to name that will print on the
invoice.
OEP-POA-NAME Alpha 30 (Lower Case) BL01.1
Element: Name
OEP-POA-ADDR1 Alpha 30 (Lower Case) BL01.1
Element: Address 1
OEP-POA-ADDR2 Alpha 30 (Lower Case) BL01.1
Element: Address 1
OEP-POA-ADDR3 Alpha 30 (Lower Case) BL01.1
Element: Address 1
OEP-POA-ADDR4 Alpha 30 (Lower Case) BL01.1
Element: Address 1
OEP-POA-CITY Alpha 18 BL01.1
Element: Billing City
OEP-POA-STATE Alpha 2 BL01.1
Element: Poa State
OEP-POA-ZIP Alpha 10 BL01.1
Element: Postal Code
OEP-POA-COUNTRY Alpha 30 (Lower Case) BL01.1
Element: Poa Country
OEP-POA-COUNTY Alpha 25 (Lower Case) BL01.1 TX140
Element: County
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: Address 1 The remit-to address that will print on
documents created using this process
level.
OEP-RMT-ADDR2 Alpha 30 (Lower Case) BL01.1
Element: Address 1 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-ADDR3 Alpha 30 (Lower Case) BL01.1
Element: Address 1 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-ADDR4 Alpha 30 (Lower Case) BL01.1
Element: Address 1 The remit-to address that will print on
documents created for this process
level.
OEP-RMT-CITY Alpha 18 BL01.1
Element: Billing City The remit-to city that will print on
documents created for this process
level.
OEP-RMT-STATE Alpha 2 BL01.1
Element: State or ProviThe remit-to state that will print on
documents created for this process
level.
OEP-RMT-ZIP Alpha 10 BL01.1
Element: Postal Code 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 or OthThe remit-to country that will print on
documents created for this process
level.
OEP-RMT-COUNTY Alpha 25 (Lower Case) BL01.1
Element: County
OEP-DEF-LOCATION Alpha 5 BL01.1
Element: Location Code 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 CodThe 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: Accounting UniSafety 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: 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
Element: Accounting UniThis 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: Subaccount 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: Accounting UniThis 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: Subaccount 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: Accounting UniThis 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: Subaccount 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: Accounting UniDefault 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: Subaccount 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 Indicates whether terms are applied to
add-on costs.
Y = Yes
N = No
" "
OEP-INVC-CR-FL Alpha 1 OE129
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 OE114
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
Normal Days to Ship Number of days to be added to the order
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 Number Electronic Data Interface (EDI) number.
OEP-USED-FL Alpha 1 BL00.1 BL01.1
Element: Used 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
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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
OEP-TAX-EXEMPT-CD Alpha 1 BL01.1
Element: Tax Exempt CodCode 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
|
