 |
Lawson Insight Technical Documentation |
|
ARUDISTRIB FILE
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
AR48.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
AR48.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
AR48.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
AR48.3 AR560
AR570 AR575
AR580 AR82.1
CB191
DGM-INVOICE Alpha 22 AR115 AR124
Invoice Number Used to identify the invoice. 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
AR48.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
AR48.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
AR48.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
AR48.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 AR48.3 AR560
separate them. For example: AR570 AR575
value1,value2,value3,value4 AR580 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
INVOICE AR21.3 AR220
CUSTOMER AR24.1 AR242
DIST-SEQ AR295 AR30.1
AR30.2 AR30.4
AR300 AR42.2
AR42.7 AR44.3
AR48.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
INVOICE 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
AR48.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-INVOICE -> AMD-INVOICE
DGM-CUSTOMER -> AMD-CUSTOMER
DGM-DIST-SEQ -> AMD-DIST-SEQ
|