ARUDISTRIB FILE The AR Distributions (User Analysis) file connects the user analysis values to distribution records for every transaction that will be posted to the General Ledger system through the Lawson Accounts Receivable system. UPDATED BY AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY DGM-COMPANY Numeric 4 AR115 AR124 Company The company number represents an AR190 AR20.1 established company and is entered on AR21.1 AR21.2 all function codes. AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGM-BATCH-NBR Numeric 6 AR115 AR124 Batch Number This identifies the batch the entered AR190 AR20.1 invoices, debit memos, and credit memos AR21.1 AR21.2 are a part of. AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGM-TRANS-TYPE Alpha 1 AR115 AR124 Transaction Type Determines if amounts or units are AR190 AR20.1 processed in each transaction. AR21.1 AR21.2 AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGM-TRANS-NBR Alpha 10 (Right Justified) AR115 AR124 Trans Nbr A unique, user-defined value used to AR190 AR20.1 identify the transaction. AR21.1 AR21.2 AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGM-CUSTOMER Alpha 9 (Right Justified) AR115 AR124 Customer Number This field contains the number that AR190 AR20.1 represents a customer. AR21.1 AR21.2 AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGM-DIST-SEQ Numeric 4 AR115 AR124 Distribution The distribution sequence number. AR190 AR20.1 Sequence Number AR21.1 AR21.2 AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGM-DST-TYPE Alpha 2 AR115 AR124 Distribution Type The distribution type. AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR220 AR24.1 AR242 AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGM-SEGMENT-BLOCK Alpha 103 AR115 AR124 User Analysis This field identifies the user analysis AR190 AR20.1 values included in the transaction. AR21.1 AR21.2 AR21.3 AR220 You can either type up to four values AR24.1 AR242 or use Define (F6) to open the User AR295 AR30.1 Analysis Entry subform. Use this subform AR30.2 AR30.4 to select the user analysis values you AR300 AR42.2 want to include in the transaction. If AR42.7 AR44.3 you choose to type values, use commas to AR560 AR570 separate them. For example: AR575 AR580 value1,value2,value3,value4 AR82.1 CB191 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information. ARUDISTRIB FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN DGMSET1 COMPANY AR115 AR124 BATCH-NBR AR190 AR20.1 TRANS-TYPE AR21.1 AR21.2 TRANS-NBR AR21.3 AR220 CUSTOMER AR24.1 AR242 DIST-SEQ AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 DGMSET2 COMPANY Subset AR115 AR124 BATCH-NBR Where DST-TYPE = "RI" AR190 AR20.1 TRANS-TYPE Or DST-TYPE = "RP" AR21.1 AR21.2 TRANS-NBR Or DST-TYPE = "RM" AR21.3 AR220 CUSTOMER AR24.1 AR242 DIST-SEQ AR295 AR30.1 AR30.2 AR30.4 AR300 AR42.2 AR42.7 AR44.3 AR560 AR570 AR575 AR580 AR82.1 CB191 ARUDISTRIB FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Ardistrib ARDISTRIB Not Required DGM-COMPANY -> AMD-COMPANY DGM-BATCH-NBR -> AMD-BATCH-NBR DGM-TRANS-TYPE -> AMD-TRANS-TYPE DGM-TRANS-NBR -> AMD-TRANS-NBR DGM-CUSTOMER -> AMD-CUSTOMER DGM-DIST-SEQ -> AMD-DIST-SEQ |