ARUSERSORT – This table contains user sort data entered from AR42 Transaction Entry.

System: Accounts Receivable (AR)
Prefix: USS
Primary key: COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ
Fields: 8
Updated by: 0 programs
Referenced by: 0 programs

ARUSERSORT is the This table contains user sort data entered from AR42 Transaction Entry. table in Lawson Accounts Receivable (prefix USS). It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ (USSSET1). The table has 8 fields, 1 index and 0 documented relations.

About ARUSERSORT

This table contains user sort data entered from AR42 Transaction Entry. This table is deleted when a transaction (invoice, debit memo, or credit memo) is released.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`USS-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	—
`USS-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	The transaction type. Valid valus are: emo `C` Credit Memo `D` Debit Memo `I` Invoice `M` Mixed	—
`USS-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice, credit memo, or debit memo.	—
`USS-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	Payment Sequence. This is the generated sequence number to separate individual invoice, credit memo, or debit memo payment requirements.	—
`USS-SORT-1` SORT_1	Alpha 32 (Lower Case)	User Sort 1 value.	—
`USS-SORT-2` SORT_2	Alpha 32 (Lower Case)	User Sort 2 value.	—
`USS-SORT-3` SORT_3	Alpha 32 (Lower Case)	User Sort 3 value.	—
`USS-SORT-4` SORT_4	Alpha 32 (Lower Case)	User Sort 4 value.	—

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
`USSSET1`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	Primary		ARLL.1

Programs

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