Lawson Insight Technical Documentation |
|
ARUSADJUST
ARUSADJUST FILE
UPDATED BY
AR130 AR30.1 AR30.3 AR30.6 AR30.7 AR30.8
AR31.1 AR33.3 AR34.1 AR34.2 AR34.3 AR34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SGM-COMPANY Numeric 4 AR130 AR30.1
Element: Company Identifies the AP company if the AR30.3 AR30.6
resource type = V. Identifies the HR AR30.7 AR30.8
company if the resource type = E. It is AR31.1 AR33.3
blank for type A, P or Q resources. AR34.1 AR34.2
AR34.3 AR34.4
SGM-TRANS-TYPE Alpha 1 AR130 AR30.1
Element: Transaction TyDetermines if amounts or units are AR30.3 AR30.6
processed in each transaction. AR30.7 AR30.8
AR31.1 AR33.3
AR34.1 AR34.2
AR34.3 AR34.4
SGM-INVOICE Alpha 22 AR130 AR30.1
Element: Invoice NumberUsed to identify the invoice. AR30.3 AR30.6
AR30.7 AR30.8
AR31.1 AR33.3
AR34.1 AR34.2
AR34.3 AR34.4
SGM-PAYMENT-SEQ Numeric 6 AR130 AR30.1
Record Sequence Payment Sequence. This is the generated AR30.3 AR30.6
Number sequence number to separate individual AR30.7 AR30.8
invoice payment requirements. AR31.1 AR33.3
AR34.1 AR34.2
AR34.3 AR34.4
SGM-ADJ-SEQ Numeric 3 AR130 AR30.1
Element: Adj Seq AR30.3 AR30.6
AR30.7 AR30.8
AR31.1 AR33.3
AR34.1 AR34.2
AR34.3 AR34.4
SGM-SEGMENT-BLOCK Alpha 103 AR130 AR30.1
Element: User Analysis This field identifies the user analysis AR30.3 AR30.6
values included in the transaction. AR30.7 AR30.8
AR31.1 AR33.3
You can either type up to four values AR34.1 AR34.2
or use Define (F6) to open the User AR34.3 AR34.4
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
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.
ARUSADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SGMSET1 COMPANY AR130 AR30.1
TRANS-TYPE AR30.3 AR30.6
INVOICE AR30.7 AR30.8
PAYMENT-SEQ AR31.1 AR33.3
ADJ-SEQ AR34.1 AR34.2
AR34.3 AR34.4
ARUSADJUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arsadjust ARSADJUST Not Required
SGM-COMPANY -> ASJ-COMPANY
SGM-TRANS-TYPE -> ASJ-TRANS-TYPE
SGM-INVOICE -> ASJ-INVOICE
SGM-PAYMENT-SEQ -> ASJ-PAYMENT-SEQ
SGM-ADJ-SEQ -> ASJ-ADJ-SEQ
|