Lawson Insight Technical Documentation |
|
ARUDISTRIB
ARUDISTRIB FILE
UPDATED BY
AR115 AR124 AR20.1 AR21.1 AR21.2 AR21.3
AR220 AR24.1 AR242 AR295 AR30.1 AR300
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 Identifies the AP company if the AR20.1 AR21.1
resource type = V. Identifies the HR AR21.2 AR21.3
company if the resource type = E. It is AR220 AR24.1
blank for type A, P or Q resources. AR242 AR295
AR30.1 AR300
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 Number This identifies the batch the entered AR20.1 AR21.1
invoices, debit memos, and credit memos AR21.2 AR21.3
are a part of. AR220 AR24.1
AR242 AR295
AR30.1 AR300
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: Transaction TyDetermines if amounts or units are AR20.1 AR21.1
processed in each transaction. AR21.2 AR21.3
AR220 AR24.1
AR242 AR295
AR30.1 AR300
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 NumberUsed to identify the invoice. AR20.1 AR21.1
AR21.2 AR21.3
AR220 AR24.1
AR242 AR295
AR30.1 AR300
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 NumbeThis field contains the number that AR20.1 AR21.1
represents a customer. AR21.2 AR21.3
AR220 AR24.1
AR242 AR295
AR30.1 AR300
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
Distribution The distribution sequence number. AR20.1 AR21.1
Sequence Number AR21.2 AR21.3
AR220 AR24.1
AR242 AR295
AR30.1 AR300
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: Distribution TThe distribution type. AR20.1 AR21.1
AR21.2 AR21.3
AR220 AR24.1
AR242 AR295
AR30.1 AR300
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: User Analysis This field identifies the user analysis AR20.1 AR21.1
values included in the transaction. AR21.2 AR21.3
AR220 AR24.1
You can either type up to four values AR242 AR295
or use Define (F6) to open the User AR30.1 AR300
Analysis Entry subform. Use this subform AR34.1 AR42.2
to select the user analysis values you AR42.7 AR44.3
want to include in the transaction. If AR48.3 AR560
you choose to type values, use commas to AR570 AR575
separate them. For example: AR580 AR82.1
value1,value2,value3,value4 ARLL.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 AR20.1 AR21.1
TRANS-TYPE AR21.2 AR21.3
INVOICE AR220 AR24.1
CUSTOMER AR242 AR295
DIST-SEQ AR30.1 AR300
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" AR20.1 AR21.1
TRANS-TYPE Or DST-TYPE = "RP" AR21.2 AR21.3
INVOICE Or DST-TYPE = "RM" AR220 AR24.1
CUSTOMER AR242 AR295
DIST-SEQ AR30.1 AR300
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
|