|
ARUADJUST FILE
UPDATED BY
AR129 AR130 AR131 AR135 AR230 AR232
AR233 AR235 AR30.1 AR30.8 AR300 AR31.5
AR31.6 AR33.1 AR33.3 AR33.5 AR33.6 AR34.1
AR35.1 AR35.2 AR48.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGM-COMPANY Numeric 4 AR129 AR130
Element: Company Identifies the AP company if the AR131 AR135
resource type = V. Identifies the HR AR230 AR232
company if the resource type = E. It is AR233 AR235
blank for type A, P or Q resources. AR30.1 AR30.8
AR300 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3
AGM-TRANS-TYPE Alpha 1 AR129 AR130
Element: Transaction TyDetermines if amounts or units are AR131 AR135
processed in each transaction. AR230 AR232
AR233 AR235
AR30.1 AR30.8
AR300 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3
AGM-INVOICE Alpha 22 AR129 AR130
Element: Invoice NumberUsed to identify the invoice. AR131 AR135
AR230 AR232
AR233 AR235
AR30.1 AR30.8
AR300 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3
AGM-PAYMENT-SEQ Numeric 6 AR129 AR130
Record Sequence Payment Sequence. This is the generated AR131 AR135
Number sequence number to separate individual AR230 AR232
invoice payment requirements. AR233 AR235
AR30.1 AR30.8
AR300 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3
AGM-BATCH-NBR Numeric 6 AR129 AR130
Element: Batch Number This identifies the batch the entered AR131 AR135
invoices, debit memos, and credit memos AR230 AR232
are a part of. AR233 AR235
AR30.1 AR30.8
AR300 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3
AGM-APP-SEQ Numeric 7 AR129 AR130
Element: App Seq AR131 AR135
AR230 AR232
AR233 AR235
AR30.1 AR30.8
AR300 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3
AGM-ADJ-SEQ Numeric 3 AR129 AR130
Element: Adj Seq AR131 AR135
AR230 AR232
AR233 AR235
AR30.1 AR30.8
AR300 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR48.3
AGM-SEGMENT-BLOCK Alpha 103 AR129 AR130
Element: User Analysis This field identifies the user analysis AR131 AR135
values included in the transaction. AR230 AR232
AR233 AR235
You can either type up to four values AR30.1 AR30.8
or use Define (F6) to open the User AR300 AR31.5
Analysis Entry subform. Use this subform AR31.6 AR33.1
to select the user analysis values you AR33.3 AR33.5
want to include in the transaction. If AR33.6 AR34.1
you choose to type values, use commas to AR35.1 AR35.2
separate them. For example: AR48.3
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.
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 AR30.1 AR30.8
APP-SEQ AR300 AR31.5
ADJ-SEQ AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.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
|