Lawson Insight Technical Documentation |
|
ARUOIHDR
ARUOIHDR FILE
This file contains the User Analysis value associated with open item header
records.
UPDATED BY
AR129 AR130 AR131 AR135 AR30.1 AR30.6
AR30.8 AR300 AR32.1 AR32.3 AR33.1 AR33.3
AR33.6 AR34.1 AR34.2 AR35.1 AR35.2 AR39.1
AR39.2 AR42.2 AR48.3 AR560 ARLL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UIH-COMPANY Numeric 4 AR129 AR130
Element: Company The number representing an AR company. AR131 AR135
AR30.1 AR30.6
AR30.8 AR300
AR32.1 AR32.3
AR33.1 AR33.3
AR33.6 AR34.1
AR34.2 AR35.1
AR35.2 AR39.1
AR39.2 AR42.2
AR48.3 AR560
ARLL.1
UIH-TRANS-TYPE Alpha 1 AR129 AR130
Element: Trans Type The transaction type. Valid values are: AR131 AR135
AR30.1 AR30.6
C = Cedit Memo AR30.8 AR300
D = Debit Memo AR32.1 AR32.3
I = Invoice AR33.1 AR33.3
M - Mixed AR33.6 AR34.1
AR34.2 AR35.1
AR35.2 AR39.1
AR39.2 AR42.2
AR48.3 AR560
ARLL.1
UIH-INVOICE Alpha 22 AR129 AR130
Element: Invoice Used to identify the invoice, credit AR131 AR135
memo, or debit memo. AR30.1 AR30.6
AR30.8 AR300
AR32.1 AR32.3
AR33.1 AR33.3
AR33.6 AR34.1
AR34.2 AR35.1
AR35.2 AR39.1
AR39.2 AR42.2
AR48.3 AR560
ARLL.1
UIH-SEGMENT-BLOCK Alpha 103 AR129 AR130
Element: Segment Block This field contains the user analysis AR131 AR135
values for the associated open item AR30.1 AR30.6
header record. Commas separate user AR30.8 AR300
analysis values. AR32.1 AR32.3
AR33.1 AR33.3
AR33.6 AR34.1
AR34.2 AR35.1
AR35.2 AR39.1
AR39.2 AR42.2
AR48.3 AR560
ARLL.1
ARUOIHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UIHSET1 COMPANY AR129 AR130
TRANS-TYPE AR131 AR135
INVOICE AR30.1 AR30.6
AR30.8 AR300
AR32.1 AR32.3
AR33.1 AR33.3
AR33.6 AR34.1
AR34.2 AR35.1
AR35.2 AR39.1
AR39.2 AR42.2
AR48.3 AR560
ARLL.1
ARUOIHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aroihdr AROIHDR Not Required
UIH-COMPANY -> ARH-COMPANY
UIH-TRANS-TYPE -> ARH-TRANS-TYPE
UIH-INVOICE -> ARH-INVOICE
|