OEPROCLEV – Order Entry Process Level
- System
- Billing (BL)
- Prefix
OEP- Primary key
COMPANY,PROCESS-LEVEL- Fields
- 73
- Updated by
- 3 programs
- Referenced by
- 3 programs
OEPROCLEV is the Order Entry Process Level table in Lawson Billing (prefix OEP). It is indexed by COMPANY, PROCESS-LEVEL (OEPSET1). It is related 1:1 to ARCOMP, ARPROCLEVL, HOLDCODES, GLMASTER, OECOMPANY, OEREASON and ORDERTYPE and 1:M to OECOMPREF. It is updated by TX140, WH20.2 and WH20.7 and referenced by TX00.1, TX40.1 and WH120. The table has 73 fields, 1 index and 13 documented relations.
About OEPROCLEV
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.
Fields (73)
Column = COBOL field name without the OEP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OEP-COMPANY PKCOMPANY | 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 PKPROCESS_LEVEL | Alpha 5 | This field contains the process level, which is the reporting hierarchy below company. | — |
OEP-NAMENAME | Alpha 30 (Lower Case) | The name of the process level. This is the remit-to name that will print on the invoice. | — |
OEP-POA-NAMEPOA_NAME | Alpha 30 (Lower Case) | Displays the company description. | — |
OEP-POA-ADDR1POA_ADDR1 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
OEP-POA-ADDR2POA_ADDR2 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
OEP-POA-ADDR3POA_ADDR3 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
OEP-POA-ADDR4POA_ADDR4 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
OEP-POA-CITYPOA_CITY | Alpha 18 | — | — |
OEP-POA-STATEPOA_STATE | Alpha 2 | — | — |
OEP-POA-ZIPPOA_ZIP | Alpha 10 | This field contains the postal code of the address. | — |
OEP-POA-COUNTRYPOA_COUNTRY | Alpha 30 (Lower Case) | — | — |
OEP-POA-COUNTYPOA_COUNTY | Alpha 25 (Lower Case) | The county for the company address. | TX140 |
OEP-RMT-NAMERMT_NAME | Alpha 30 (Lower Case) | The first line of the remit-to address is entered in this field. | — |
OEP-RMT-ADDR1RMT_ADDR1 | Alpha 30 (Lower Case) | The remit-to address that will print on documents created using this process level. | — |
OEP-RMT-ADDR2RMT_ADDR2 | Alpha 30 (Lower Case) | The remit-to address that will print on documents created for this process level. | — |
OEP-RMT-ADDR3RMT_ADDR3 | Alpha 30 (Lower Case) | The remit-to address that will print on documents created for this process level. | — |
OEP-RMT-ADDR4RMT_ADDR4 | Alpha 30 (Lower Case) | The remit-to address that will print on documents created for this process level. | — |
OEP-RMT-CITYRMT_CITY | Alpha 18 | The remit-to city that will print on documents created for this process level. | — |
OEP-RMT-STATERMT_STATE | Alpha 2 | The remit-to state that will print on documents created for this process level. | — |
OEP-RMT-ZIPRMT_ZIP | Alpha 10 | The remit-to postal code that will print on documents created for this process level. | — |
OEP-RMT-COUNTRYRMT_COUNTRY | Alpha 30 (Lower Case) | The remit-to country that will print on documents created for this process level. | — |
OEP-RMT-COUNTYRMT_COUNTY | Alpha 25 (Lower Case) | The county for the company address. | — |
OEP-DEF-LOCATIONDEF_LOCATION | Alpha 5 | The default location that will be used when placing an order for this process level. | — |
OEP-DEF-ORDER-TYPDEF_ORDER_TYP | 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-REASONDEF_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-HOLDDEF_COD_HOLD | 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-HOLDDEF_CIA_HOLD | 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-UNITSLS_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-ACCOUNTSLS_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-ACCTSLS_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-UNITMI_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-ACCOUNTMI_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-ACCTMI_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-UNITMCG_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-ACCOUNTMCG_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-ACCTMCG_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-UNITEXP_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-ACCOUNTEXP_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-ACCTEXP_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-UNITDSC_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-ACCOUNTDSC_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-ACCTDSC_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-OPTINVC_EDIT_OPT | 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).
| — |
OEP-INTF-COST-FLINTF_COST_FL | Alpha 1 | This field indicates whether or not to post cost for interfaced invoice.
| — |
OEP-INTF-INV-FLINTF_INV_FL | Alpha 1 | This field indicates whether or not to post cost for interfaced invoices.
| — |
OEP-TAX-PRINT-CDTAX_PRINT_CD | Alpha 1 | Code indicating whether the tax lines should print in summary or detail on the invoice.
| — |
OEP-TAX-PRICE-FLTAX_PRICE_FL | Alpha 1 | Flag to indicate that prices printed on the customer's invoice include taxes.
| — |
OEP-DISC-AOC-FLDISC_AOC_FL | Alpha 1 | Flag to indicate whether add-on charges are included in order-level discount calculations.
| — |
OEP-TERMS-AOC-FLTERMS_AOC_FL | Alpha 1 | " "
| — |
OEP-INVC-CR-FLINVC_CR_FL | 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.
| — |
OEP-INVC-EDIT-FLINVC_EDIT_FL | 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.
| — |
OEP-INVC-PRT-FLINVC_PRT_FL | 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.
| — |
OEP-INVC-UPD-FLINVC_UPD_FL | 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.
| — |
OEP-INVC-DTL-FLINVC_DTL_FL | Alpha 1 | This flag indicates whether lots/sublots and serial numbers of items ordered should print on the invoice.
| — |
OEP-COD-INVC-OPTCOD_INVC_OPT | 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).
| — |
OEP-SHIP-DAYSSHIP_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-NUMBEREDI_NUMBER | Alpha 15 | Electronic Data Interface (EDI) number. | — |
OEP-USED-FLUSED_FL | Alpha 1 | Flag indicating whether the process level has been used or not.
| WH20.2, WH20.7 |
OEP-TAX-EXEMPT-CDTAX_EXEMPT_CD | Alpha 1 | Code indicating the taxing status. E - Exempt, T - Taxable. | — |
OEP-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | TX140 |
OEP-POA-CTRY-CDPOA_CTRY_CD | Alpha 2 | — | — |
OEP-POA-REGIONPOA_REGION | Alpha 2 | — | — |
OEP-POA-EC-CTRYPOA_EC_CTRY | Numeric 3 | — | — |
OEP-POA-ISO-CTRYPOA_ISO_CTRY | Numeric 3 | — | — |
OEP-RMT-CTRY-CDRMT_CTRY_CD | Alpha 2 | — | — |
OEP-RMT-REGIONRMT_REGION | Alpha 2 | — | — |
OEP-RMT-EC-CTRYRMT_EC_CTRY | Numeric 3 | — | — |
OEP-RMT-ISO-CTRYRMT_ISO_CTRY | Numeric 3 | — | — |
OEP-TERMS-FRT-FLTERMS_FRT_FL | Alpha 1 | — | — |
OEP-RND-ACCT-UNITRND_ACCT_UNIT | Alpha 15 | — | — |
OEP-RND-ACCOUNTRND_ACCOUNT | Numeric 6 | — | — |
OEP-RND-SUB-ACCTRND_SUB_ACCT | Numeric 4 | — | — |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OEPSET1 | COMPANY, PROCESS-LEVEL | Primary | TX00.1, TX140, TX40.1, WH120, WH20.2, WH20.7 |
Relations
One to one (12) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Oecompref | OECOMPREF | OEP-COMPANY → OEL-COMPANY, OEP-PROCESS-LEVEL → OEL-PROCESS-LEVEL, OEL-TYPE |