Lawson Insight Technical Documentation |
|
ARUADJUST
ARUADJUST FILE
This file contains the User Analysis value associated with cash application
adjustment records.
UPDATED BY
AR129 AR130 AR131 AR135 AR230 AR232
AR233 AR235 AR237 AR239 AR30.1 AR30.8
AR300 AR32.1 AR33.1 AR33.3 AR33.5 AR33.6
AR34.1 AR35.1 AR35.2 AR39.1 AR39.2 AR48.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGM-COMPANY Numeric 4 AR129 AR130
Element: Company The number representing an AR company. AR131 AR135
AR230 AR232
AR233 AR235
AR237 AR239
AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
AGM-TRANS-TYPE Alpha 1 AR129 AR130
Element: Trans Type The transaction type. Valid values are: AR131 AR135
AR230 AR232
C = Credit Memo AR233 AR235
D = Debit Memo AR237 AR239
I = Invoice AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
AGM-INVOICE Alpha 22 AR129 AR130
Element: Invoice Used to identify the invoice, debit AR131 AR135
memo, or credit memo. AR230 AR232
AR233 AR235
AR237 AR239
AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
AGM-PAYMENT-SEQ Numeric 6 AR129 AR130
Element: Seq Number Payment Sequence. This is the generated AR131 AR135
sequence number to separate individual AR230 AR232
invoice, debit memo, or creit memo AR233 AR235
payment requirements. AR237 AR239
AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
AGM-BATCH-NBR Numeric 6 AR129 AR130
Element: Batch Nbr This identifies the batch the entered AR131 AR135
invoices, debit memos, and credit memos AR230 AR232
are a part of. AR233 AR235
AR237 AR239
AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
AGM-APP-SEQ Numeric 7 AR129 AR130
Element: App Seq The application sequence number of the AR131 AR135
invoice, debit memo, or credit memo. AR230 AR232
AR233 AR235
AR237 AR239
AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
AGM-ADJ-SEQ Numeric 3 AR129 AR130
Element: Adj Seq The adjustment sequence number of the AR131 AR135
invoice, credit memo, or debit memo AR230 AR232
application. AR233 AR235
AR237 AR239
AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
AGM-SEGMENT-BLOCK Alpha 103 AR129 AR130
Element: Segment Block This field contains the user analysis AR131 AR135
values for the associated adjustment. AR230 AR232
Commas separate user analysis values. AR233 AR235
AR237 AR239
AR30.1 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
ARUADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGMSET1 COMPANY AR129 AR130
TRANS-TYPE AR131 AR135
INVOICE AR230 AR232
PAYMENT-SEQ AR233 AR235
BATCH-NBR AR237 AR239
APP-SEQ AR30.1 AR30.8
ADJ-SEQ AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR39.1
AR39.2 AR48.3
ARUADJUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aradjust ARADJUST Not Required
AGM-COMPANY -> ADJ-COMPANY
AGM-TRANS-TYPE -> ADJ-TRANS-TYPE
AGM-INVOICE -> ADJ-INVOICE
AGM-PAYMENT-SEQ -> ADJ-PAYMENT-SEQ
AGM-BATCH-NBR -> ADJ-BATCH-NBR
AGM-APP-SEQ -> ADJ-APP-SEQ
AGM-ADJ-SEQ -> ADJ-ADJ-SEQ
|