RETURNMISC – OE Returns

System: OE (OE)
Prefix: RMC
Primary key: COMPANY, AUTH-NO, LINE-NBR, SEQ
Fields: 31
Updated by: 0 programs
Referenced by: 0 programs

RETURNMISC is the OE Returns table in Lawson OE (prefix RMC). It is indexed by COMPANY, AUTH-NO, LINE-NBR, SEQ (RMCSET1); alternate indexes: RMCSET2 and RMCSET3. It is related 1:1 to OECOMPANY, OEMISC, RETURNHDR and RETURNLINE. The table has 31 fields, 3 indexes and 4 documented relations.

About RETURNMISC

No description in the Lawson data dictionary.

Fields (31)

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

Field / column	Type	Description & values	Updated by
`RMC-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.	—
`RMC-AUTH-NO` PK AUTH_NO	Numeric 10	—	—
`RMC-LINE-NBR` PK LINE_NBR	Numeric 6	This field contains the line number.	—
`RMC-SEQ` PK SEQ	Numeric 3	This field contains the record sequence number.	—
`RMC-MISC` MISC	Alpha 16	—	—
`RMC-CHARGE-TYPE` CHARGE_TYPE	Numeric 1	Indicates whether the charge is Lump Sum, Unit Price or Percentage.	—
`RMC-ENT-UNIT-PRC` ENT_UNIT_PRC	Signed 18.5	—	—
`RMC-PRICE-PCT` PRICE_PCT	Percent 5.3 (Percent)	Cost Percent. Percent to applied to unit cost of the item to arrive at the Add on charge cost.	—
`RMC-ENT-PRICE` ENT_PRICE	Signed 18.2	—	—
`RMC-UNIT-COST` UNIT_COST	Signed 18.5	—	—
`RMC-COST-PCT` COST_PCT	Percent 5.3 (Percent)	Cost Percent. Percent to applied to unit cost of the item to arrive at the Add on charge cost.	—
`RMC-COST` COST	Signed 18.5	—	—
`RMC-ALLOC-DISC` ALLOC_DISC	Signed 18.2	—	—
`RMC-ORD-DISC-FL` ORD_DISC_FL	Alpha 1	—	—
`RMC-SLS-ACCT-UNIT` SLS_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.	—
`RMC-SLS-ACCOUNT` SLS_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.	—
`RMC-SLS-SUB-ACCT` SLS_SUB_ACCT	Numeric 4	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	—
`RMC-OFF-ACCT-UNIT` OFF_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.	—
`RMC-OFF-ACCOUNT` OFF_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.	—
`RMC-OFF-SUB-ACCT` OFF_SUB_ACCT	Numeric 4	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	—
`RMC-CGS-ACCT-UNIT` CGS_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.	—
`RMC-CGS-ACCOUNT` CGS_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.	—
`RMC-CGS-SUB-ACCT` CGS_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.	—
`RMC-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	—
`RMC-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	—
`RMC-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	—
`RMC-ACTIVITY-C` ACTIVITY_C	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	—
`RMC-ACCT-CATEG-C` ACCT_CATEG_C	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	—
`RMC-ATN-OBJ-ID-C` ATN_OBJ_ID_C	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	—
`RMC-CHARGE-CURR` CHARGE_CURR	Signed 18.2	—	—
`RMC-TRACK-TYPE` TRACK_TYPE	Alpha 1	" " = Other AOC `I` Insurance `F` Freight `C` Customs Charges	—

Indexes (3)

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
`RMCSET1`	`COMPANY`, `AUTH-NO`, `LINE-NBR`, `SEQ`	Primary		WH20.7
`RMCSET2`	`ATN-OBJ-ID`	Subset	Where ATN-OBJ-ID != Zeroes	—
`RMCSET3`	`ATN-OBJ-ID-C`	Subset	Where ATN-OBJ-ID-C != Zeroes	—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Condition	Field map
Oecompany	OECOMPANY	Required		`RMC-COMPANY` → `OEC-COMPANY (OECSET1)`
Oemisc	OEMISC	Required		`RMC-COMPANY` → `OEM-COMPANY`, `RMC-MISC` → `OEM-MISC`, `RTN-CURRENCY-CODE` → `OEM-CURRENCY-CODE`
Returnhdr	RETURNHDR	Required		`RMC-COMPANY` → `RTN-COMPANY`, `RMC-AUTH-NO` → `RTN-AUTH-NO`
Returnline	RETURNLINE	Required	When RMC-LINE-NBR != Zeroes	`RMC-COMPANY` → `RTL-COMPANY`, `RMC-AUTH-NO` → `RTL-AUTH-NO`, `RMC-LINE-NBR` → `RTL-LINE-NBR`

Programs

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