OEPROCLEV

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
TX00.1 TX40.1 WH120


UPDATED BY
TX140 WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEP-COMPANY
Element: Company
Numeric 4
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
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
OEP-NAME
Element: Name
Alpha 30 (Lower Case)
The name of the process level. This is the remit-to name that will print on the invoice.
OEP-POA-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
OEP-POA-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
OEP-POA-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
OEP-POA-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
OEP-POA-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
OEP-POA-CITY
Element: Bill City
Alpha 18
OEP-POA-STATE
Element: Poa State
Alpha 2
OEP-POA-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the address.
OEP-POA-COUNTRY
Element: Poa Country
Alpha 30 (Lower Case)
OEP-POA-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
TX140
OEP-RMT-NAME
Element: Name
Alpha 30 (Lower Case)
The first line of the remit-to address is entered in this field.
OEP-RMT-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
The remit-to address that will print on documents created using this process level.
OEP-RMT-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
The remit-to address that will print on documents created for this process level.
OEP-RMT-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
The remit-to address that will print on documents created for this process level.
OEP-RMT-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
The remit-to address that will print on documents created for this process level.
OEP-RMT-CITY
Element: Bill City
Alpha 18
The remit-to city that will print on documents created for this process level.
OEP-RMT-STATE
Element: State Prov
Alpha 2
The remit-to state that will print on documents created for this process level.
OEP-RMT-ZIP
Element: Zip
Alpha 10
The remit-to postal code that will print on documents created for this process level.
OEP-RMT-COUNTRY
Element: Country
Alpha 30 (Lower Case)
The remit-to country that will print on documents created for this process level.
OEP-RMT-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
OEP-DEF-LOCATION
Element: Location
Alpha 5
The default location that will be used when placing an order for this process level.
OEP-DEF-ORDER-TYP
Element: Order Type
Alpha 2
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
Element: Cb Reason
Alpha 4
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
Element: Hold Code
Alpha 4
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
Element: Hold Code
Alpha 4
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
Element: Acct Unit
Alpha 15
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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Acct Unit
Alpha 15
This is the sales general ledger account unit to be credited for special orders placed using this process level.
OEP-MI-ACCOUNT
Element: Account
Numeric 6
This is the sales general ledger account number to be credited for special orders placed using this process level.
OEP-MI-SUB-ACCT
Element: Sub Acct
Numeric 4
This is the sales general ledger subaccount number to be credited for special orders placed using this process level.
OEP-MCG-ACCT-UNIT
Element: Acct Unit
Alpha 15
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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Acct Unit
Alpha 15
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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Acct Unit
Alpha 15
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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
This field indicates whether or not to post cost for interfaced invoice.
Y = Yes
N = No
OEP-INTF-INV-FL
Element: All Flag
Alpha 1
This field indicates whether or not to post cost for interfaced invoices.
Y = Yes
N = No
OEP-TAX-PRINT-CD
Element: Tax Print Cd
Alpha 1
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
B = Calc Line - Print Dtl & Summ
X = Calc Summ - Print Dtl & Summ
OEP-TAX-PRICE-FL
Element: All Flag
Alpha 1
Flag to indicate that prices printed on the customer's invoice include taxes.
Y = Yes
N = No
OEP-DISC-AOC-FL
Element: All Flag
Alpha 1
Flag to indicate whether add-on charges are included in order-level discount calculations.
Y = Yes
N = No
OEP-TERMS-AOC-FL
Element: All Flag
Alpha 1

Y = Yes
N = No
" "
OEP-INVC-CR-FL
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: Ship Days
Numeric 3
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
Element: Edi Nbr
Alpha 15
Electronic Data Interface (EDI) number.
OEP-USED-FL
Element: Used Fl
Alpha 1
Flag indicating whether the process level has been used or not.
Y = Yes
N = No
WH20.2 WH20.7
OEP-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
Code indicating the taxing status. E - Exempt, T - Taxable.
OEP-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
TX140
OEP-POA-CTRY-CD
Element: Poa Ctry Cd
Alpha 2
OEP-POA-REGION
Element: Poa Region
Alpha 2
OEP-POA-EC-CTRY
Element: Poa Ec Ctry
Numeric 3
OEP-POA-ISO-CTRY
Element: Poa Iso Ctry
Numeric 3
OEP-RMT-CTRY-CD
Element: Rmt Ctry Cd
Alpha 2
OEP-RMT-REGION
Element: Rmt Region
Alpha 2
OEP-RMT-EC-CTRY
Element: Rmt Ec Ctry
Numeric 3
OEP-RMT-ISO-CTRY
Element: Rmt Iso Ctry
Numeric 3
OEP-TERMS-FRT-FL
Element: All Flag
Alpha 1
OEP-RND-ACCT-UNIT
Element: Acct Unit
Alpha 15
OEP-RND-ACCOUNT
Element: Account
Numeric 6
OEP-RND-SUB-ACCT
Element: Sub Acct
Numeric 4


OEPROCLEV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OEPSET1 COMPANY
PROCESS-LEVEL
TX00.1 TX140
TX40.1 WH120
WH20.2 WH20.7


OEPROCLEV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
OrOEP-EXP-ACCOUNT !=Zeroes
OrOEP-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
OrOEP-MCG-ACCOUNT !=Zeroes
OrOEP-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
OrOEP-DSC-ACCOUNT !=Zeroes
OrOEP-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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oecompref OECOMPREF
OEP-COMPANY->OEL-COMPANY
OEP-PROCESS-LEVEL->OEL-PROCESS-LEVEL
  OEL-TYPE


File created: Thu Jun 09 02:09:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.