ARUDISTRIB – No description in the Lawson data dictionary

System: Accounts Receivable (AR)
Prefix: DGM
Primary key: COMPANY, BATCH-NBR, TRANS-TYPE, INVOICE, CUSTOMER, DIST-SEQ
Fields: 8
Updated by: 2 programs
Referenced by: 0 programs

ARUDISTRIB is a Lawson Accounts Receivable table (prefix DGM); no description in the lawson data dictionary. It is indexed by COMPANY, BATCH-NBR, TRANS-TYPE, INVOICE, CUSTOMER, DIST-SEQ (DGMSET1); alternate indexes: DGMSET2. It is related 1:1 to ARDISTRIB. It is updated by ARLL.1 and CB191. The table has 8 fields, 2 indexes and 1 documented relation.

About ARUDISTRIB

No description in the Lawson data dictionary.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`DGM-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	ARLL.1, CB191
`DGM-BATCH-NBR` PK BATCH_NBR	Numeric 6	This identifies the batch the entered invoices, debit memos, and credit memos are a part of.	ARLL.1, CB191
`DGM-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	The transaction type. Valid values are: `C` Credit Memo `D` Debit Memo `I` Invoice	ARLL.1, CB191
`DGM-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice, credit memo, or debit memo.	ARLL.1, CB191
`DGM-CUSTOMER` PK CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	ARLL.1, CB191
`DGM-DIST-SEQ` PK DIST_SEQ	Numeric 4	The distribution sequence number for uniqueness purposes.	ARLL.1, CB191
`DGM-DST-TYPE` DST_TYPE	Alpha 2	Identifies where the transaction originated in the Lawson Accounts Receivable system.	ARLL.1, CB191
`DGM-SEGMENT-BLOCK` SEGMENT_BLOCK	Alpha 103	This field contains the user analysis values for the associated adjustment. Commas separate user analysis values.	ARLL.1, CB191

Indexes (2)

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
`DGMSET1`	`COMPANY`, `BATCH-NBR`, `TRANS-TYPE`, `INVOICE`, `CUSTOMER`, `DIST-SEQ`	Primary		ARLL.1, CB191
`DGMSET2`	`COMPANY`, `BATCH-NBR`, `TRANS-TYPE`, `INVOICE`, `CUSTOMER`, `DIST-SEQ`	Subset	Where DST-TYPE = "RI" Or DST-TYPE = "RP" Or DST-TYPE = "RM"	ARLL.1, CB191

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Ardistrib	ARDISTRIB	Not Required		`DGM-COMPANY` → `AMD-COMPANY`, `DGM-BATCH-NBR` → `AMD-BATCH-NBR`, `DGM-TRANS-TYPE` → `AMD-TRANS-TYPE`, `DGM-INVOICE` → `AMD-INVOICE`, `DGM-CUSTOMER` → `AMD-CUSTOMER`, `DGM-DIST-SEQ` → `AMD-DIST-SEQ`

Programs

Updated by (2)

ARLL.1 AR Transaction Interface
CB191 Bank Statement Close