Lawson Insight Technical Documentation |
|
ARUDISTRIB
ARUDISTRIB FILE
This field contains the user analysis values for the associated distribution.
UPDATED BY
AR115 AR124 AR195 AR20.1 AR21.1 AR21.2
AR21.3 AR220 AR24.1 AR242 AR295 AR30.1
AR300 AR32.1 AR34.1 AR42.2 AR42.7 AR44.3
AR48.3 AR560 AR570 AR575 AR580 AR82.1
ARLL.1 CB191
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DGM-COMPANY Numeric 4 AR115 AR124
Element: Company The number representing an AR company. AR195 AR20.1
AR21.1 AR21.2
AR21.3 AR220
AR24.1 AR242
AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGM-BATCH-NBR Numeric 6 AR115 AR124
Element: Batch Nbr This identifies the batch the entered AR195 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
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGM-TRANS-TYPE Alpha 1 AR115 AR124
Element: Trans Type The transaction type. Valid values are: AR195 AR20.1
AR21.1 AR21.2
C = Credit Memo AR21.3 AR220
D = Debit Memo AR24.1 AR242
I = Invoice AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGM-INVOICE Alpha 22 AR115 AR124
Element: Invoice Used to identify the invoice, credit AR195 AR20.1
memo, or debit memo. AR21.1 AR21.2
AR21.3 AR220
AR24.1 AR242
AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGM-CUSTOMER Alpha 9 (Right Justified) AR115 AR124
Element: Customer This field contains the number that AR195 AR20.1
represents a customer. AR21.1 AR21.2
AR21.3 AR220
AR24.1 AR242
AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGM-DIST-SEQ Numeric 4 AR115 AR124
Element: Dist Seq The distribution sequence number for AR195 AR20.1
uniqueness purposes. AR21.1 AR21.2
AR21.3 AR220
AR24.1 AR242
AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGM-DST-TYPE Alpha 2 AR115 AR124
Element: Dst Type Identifies where the transaction AR195 AR20.1
originated in the Lawson Accounts AR21.1 AR21.2
Receivable system. AR21.3 AR220
AR24.1 AR242
AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGM-SEGMENT-BLOCK Alpha 103 AR115 AR124
Element: Segment Block This field contains the user analysis AR195 AR20.1
values for the associated adjustment. AR21.1 AR21.2
Commas separate user analysis values. AR21.3 AR220
AR24.1 AR242
AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
ARUDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DGMSET1 COMPANY AR115 AR124
BATCH-NBR AR195 AR20.1
TRANS-TYPE AR21.1 AR21.2
INVOICE AR21.3 AR220
CUSTOMER AR24.1 AR242
DIST-SEQ AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DGMSET2 COMPANY Subset AR115 AR124
BATCH-NBR Where DST-TYPE = "RI" AR195 AR20.1
TRANS-TYPE Or DST-TYPE = "RP" AR21.1 AR21.2
INVOICE Or DST-TYPE = "RM" AR21.3 AR220
CUSTOMER AR24.1 AR242
DIST-SEQ AR295 AR30.1
AR300 AR32.1
AR34.1 AR42.2
AR42.7 AR44.3
AR48.3 AR560
AR570 AR575
AR580 AR82.1
ARLL.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-INVOICE -> AMD-INVOICE
DGM-CUSTOMER -> AMD-CUSTOMER
DGM-DIST-SEQ -> AMD-DIST-SEQ
|