ARUSADJUST FILE
UPDATED BY
AR130 AR30.1 AR30.2 AR30.4 AR30.6 AR30.7
AR30.8 AR31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SGM-COMPANY Numeric 4 AR130 AR30.1
Company The company number represents an AR30.2 AR30.4
established company and is entered on AR30.6 AR30.7
all function codes. AR30.8 AR31.1
SGM-TRANS-TYPE Alpha 1 AR130 AR30.1
Transaction Type Determines if amounts or units are AR30.2 AR30.4
processed in each transaction. AR30.6 AR30.7
AR30.8 AR31.1
SGM-INVOICE Alpha 22 AR130 AR30.1
Invoice Number Used to identify the invoice. AR30.2 AR30.4
AR30.6 AR30.7
AR30.8 AR31.1
SGM-PAYMENT-SEQ Numeric 6 AR130 AR30.1
Payment Seq Payment Sequence. This is the generated AR30.2 AR30.4
sequence number to separate individual AR30.6 AR30.7
invoice payment requirements. AR30.8 AR31.1
SGM-ADJ-SEQ Numeric 3 AR130 AR30.1
Adj Seq AR30.2 AR30.4
AR30.6 AR30.7
AR30.8 AR31.1
SGM-SEGMENT-BLOCK Alpha 103 AR130 AR30.1
User Analysis This field identifies the user analysis AR30.2 AR30.4
values included in the transaction. AR30.6 AR30.7
AR30.8 AR31.1
You can either type up to four values
or use Define (F6) to open the User
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.2 AR30.4
INVOICE AR30.6 AR30.7
PAYMENT-SEQ AR30.8 AR31.1
ADJ-SEQ
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
|
