OESLSACCT – Sales Accounts

System: Billing (BL)
Prefix: OSA
Primary key: COMPANY, PROCESS-LEVEL, SALES-MAJCL, SALES-MINCL
Fields: 18
Updated by: 0 programs
Referenced by: 0 programs

OESLSACCT is the Sales Accounts table in Lawson Billing (prefix OSA). It is indexed by COMPANY, PROCESS-LEVEL, SALES-MAJCL, SALES-MINCL (OSASET1). It is related 1:1 to ARCOMP, GLMASTER, HOLDCODES, ICCOMPANY, MAJORCL, MINORCL, OECOMPANY and OEPROCLEV. The table has 18 fields, 1 index and 12 documented relations.

About OESLSACCT

This file stores the accounts needed to post to sales and Cost of Goods Sold for both stock and nonstock items. In addition, a target profit margin can be entered along with a hold code to apply if an order line fails to meet that target.

Fields (18)

Column = COBOL field name without the OSA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`OSA-COMPANY` PK 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.	—
`OSA-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	The process level is the reporting hierarchy below company.	—
`OSA-SALES-MAJCL` PK SALES_MAJCL	Alpha 4	Sales major class code. Sales major/minor classes are first set up in the Inventory Control system. Every inventoried and nonstock item ordered in the Order Entry and Billing systems must belong to a sales class as that is how the system knows which general ledger accounts to debit and credit.	—
`OSA-SALES-MINCL` PK SALES_MINCL	Alpha 4	Sales minor class code within the major class. Sales major/minor classes are set up in the Inventory Control system. Every inventoried and nonstock item ordered in the Order Entry and Billing systems must belong to a sales class as that is how the system knows which general ledger accounts to debit and credit.	—
`OSA-SLS-ACCT-UNIT` SLS_ACCT_UNIT	Alpha 15	Default general ledger account unit to be credited for inventoried and nonstock type items ordered that belong to this sales major/minor class.	—
`OSA-SLS-ACCOUNT` SLS_ACCOUNT	Numeric 6	Default general ledger account number to be credited for inventoried and nonstock type items ordered that belong to this sales major/minor class.	—
`OSA-SLS-SUB-ACCT` SLS_SUB_ACCT	Numeric 4	Default general ledger subaccount to be credited for inventoried and nonstock type items ordered that belong to this sales major/minor class.	—
`OSA-EXP-ACCT-UNIT` EXP_ACCT_UNIT	Alpha 15	This is the general ledger account unit to be credited as an offset to COGS when placing an order for nonstock items within the sales major/minor class.	—
`OSA-EXP-ACCOUNT` EXP_ACCOUNT	Numeric 6	This is the general ledger account number to be credited as an offset to COGS when placing an order for nonstock items within the sales class.	—
`OSA-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	This is the general ledger subaccount number to be credited as an offset to COGS when placing an order for nonstock items within the sales class.	—
`OSA-CGS-ACCT-UNIT` CGS_ACCT_UNIT	Alpha 15	This is the general ledger account unit that is debited for cost of goods sold when an order is placed for inventoried or nonstock items belonging to this sales major/minor class.	—
`OSA-CGS-ACCOUNT` CGS_ACCOUNT	Numeric 6	This is the general ledger account number that is debited for cost of goods sold when an order is placed for inventoried or nonstock items belonging to this sales major/minor class.	—
`OSA-CGS-SUB-ACCT` CGS_SUB_ACCT	Numeric 4	This is the general ledger subaccount number that is debited for cost of goods sold when an order is placed for inventoried or nonstock items belonging to this sales major/minor class.	—
`OSA-VAR-ACCT-UNIT` VAR_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	—
`OSA-VAR-ACCOUNT` VAR_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	—
`OSA-VAR-SUB-ACCT` VAR_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	—
`OSA-PROF-MARGIN` PROF_MARGIN	Percent 4.2 (Percent)	Entering a profit margin percentage for a sales class will place the Profit Hold Code on order lines for items from this class when the order line's projected profit margin does not exceed this margin. Profit margin is calculated as: (unit net price * SPR UOM (sell unit of measure to price unit of measure conversion factor) - unit cost) / unit net price. This is the target profit margin that should be reached or exceeded by all orders placed using items belonging to this sales class.	—
`OSA-PROF-HOLD-CD` PROF_HOLD_CD	Alpha 4	This is the default hold code that the system will place on the order line that does not reach the profit margin criteria. These hold codes are set up in the Accounts Receivable system.	—

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
`OSASET1`	`COMPANY`, `PROCESS-LEVEL`, `SALES-MAJCL`, `SALES-MINCL`	Primary		WH20.2, WH20.7

Relations

One to one (12) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcomp	ARCOMP	Required		`OSA-COMPANY` → `ACO-COMPANY`
Cogs	GLMASTER	Required	When OSA-CGS-ACCT-UNIT != Spaces Or OSA-CGS-ACCOUNT != Zeroes Or OSA-CGS-SUB-ACCT != Zeroes	`OSA-COMPANY` → `GLM-COMPANY`, `OSA-CGS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OSA-CGS-ACCOUNT` → `GLM-ACCOUNT`, `OSA-CGS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Expenses	GLMASTER	Required	When ((OSA-EXP-ACCT-UNIT != Spaces) Or (OSA-EXP-ACCOUNT != Zeroes) Or (OSA-EXP-SUB-ACCT != Zeroes))	`OSA-COMPANY` → `GLM-COMPANY`, `OSA-EXP-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OSA-EXP-ACCOUNT` → `GLM-ACCOUNT`, `OSA-EXP-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Holdcode	HOLDCODES	Required	When OSA-PROF-HOLD-CD != Spaces	`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `OSA-PROF-HOLD-CD` → `HDD-HOLD-CODE`
Holdcodes	HOLDCODES	Required	When OSA-PROF-HOLD-CD != Spaces	`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `OSA-PROF-HOLD-CD` → `HDD-HOLD-CODE`
Iccompany	ICCOMPANY	Required		`OSA-COMPANY` → `ICC-COMPANY`
Majorcl	MAJORCL	Required		`ICC-ITEM-GROUP` → `MAJ-ITEM-GROUP`, `"S"` → `MAJ-CLASS-TYPE`, `OSA-SALES-MAJCL` → `MAJ-MAJOR-CLASS`
Minorcl	MINORCL	Required	When OSA-SALES-MINCL != Spaces	`ICC-ITEM-GROUP` → `MIN-ITEM-GROUP`, `"S"` → `MIN-CLASS-TYPE`, `OSA-SALES-MAJCL` → `MIN-MAJOR-CLASS`, `OSA-SALES-MINCL` → `MIN-MINOR-CLASS`
Oecompany	OECOMPANY	Required		`OSA-COMPANY` → `OEC-COMPANY`
Oeproclev	OEPROCLEV	Required		`OSA-COMPANY` → `OEP-COMPANY`, `OSA-PROCESS-LEVEL` → `OEP-PROCESS-LEVEL`
Sales	GLMASTER	Required	When OSA-SLS-ACCT-UNIT != Spaces Or OSA-SLS-ACCOUNT != Zeroes Or OSA-SLS-SUB-ACCT != Zeroes	`OSA-COMPANY` → `GLM-COMPANY`, `OSA-SLS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OSA-SLS-ACCOUNT` → `GLM-ACCOUNT`, `OSA-SLS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Variance	GLMASTER	Not Required	Valid When OSA-VAR-ACCT-UNIT != Spaces Or OSA-VAR-ACCOUNT != Zeroes Or OSA-VAR-SUB-ACCT != Zeroes	`OSA-COMPANY` → `GLM-COMPANY`, `OSA-VAR-ACCT-UNIT` → `GLM-ACCT-UNIT`, `OSA-VAR-ACCOUNT` → `GLM-ACCOUNT`, `OSA-VAR-SUB-ACCT` → `GLM-SUB-ACCOUNT`

Programs

No Lawson programs are documented as updating or referencing this table.