Lawson Insight Technical Documentation |
|
AROPIVOT
AROPIVOT FILE
REFERENCED BY
AR72.1
UPDATED BY
AR112 AR115 AR12.1 AR12.2 AR129 AR130
AR131 AR135 AR137 AR180 AR190 AR20.1
AR21.1 AR21.2 AR21.3 AR29.3 AR30.1 AR30.2
AR30.3 AR30.4 AR30.8 AR31.5 AR31.6 AR35.1
AR35.2 AR37.1 AR37.2 AR37.3 AR37.4 AR37.5
AR37.6 AR37.7 AR42.1 AR42.2 AR42.6 AR42.7
AR43.1 AR44.3 AR48.3 AR502 AR504 AR560
AR82.1 CB06.2 DT150 DT170 DT180 DT181
DT45.1 DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVT-NAT-COMPANY Numeric 4 AR112 AR115
Element: Company AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-NAT-CUSTOMER Alpha 9 (Right Justified) AR112 AR115
Element: Customer Number AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-COMPANY Numeric 4 AR112 AR115
Element: Company The company number represents an AR12.1 AR12.2
established company and is entered on AR129 AR130
all function codes. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-CUSTOMER Alpha 9 (Right Justified) AR112 AR115
Element: Customer NumbeThis field contains the number that AR12.1 AR12.2
represents a customer. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-CUST-PO-NBR Alpha 22 AR112 AR115
Element: Customer P.O. Number AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-TRANS-TYPE Alpha 1 AR112 AR115
Element: Transaction TyDetermines if amounts or units are AR12.1 AR12.2
processed in each transaction. AR129 AR130
C = Credit Memo AR131 AR135
D = Debit Memo AR137 AR180
I = Invoice AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-INVOICE Alpha 22 AR112 AR115
Element: Invoice NumberUsed to identify the invoice. AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-TRANS-DATE Numeric 8 (yyyymmdd) AR112 AR115
Element: Date AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-DUE-DATE Numeric 8 (yyyymmdd) AR112 AR115
Element: Date The transaction due date. AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-DISC-DATE Numeric 8 (yyyymmdd) Occurs 3 Times AR112 AR115
Element: Date AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-DISC-PCT Percent 7.5 (Percent) Occurs 3 Times AR112 AR115
Element: Discount Percent AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-PROCESS-LEVEL Alpha 5 AR112 AR115
Element: Process Level This field contains the process level, AR12.1 AR12.2
which is the reporting hierarchy below AR129 AR130
company. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-ACTIVITY Alpha 15 AR112 AR115
Element: Activity Activities are the processes or AR12.1 AR12.2
procedures that produce work. Cost AR129 AR130
objects (products, services, customers, AR131 AR135
and so on) are the reasons for AR137 AR180
performing the activity. AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-BASE-AMT Signed 15.2 AR112 AR115
Element: Base Amount This is the amount of the transaction in AR12.1 AR12.2
the company base amount. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-TRAN-AMT Signed 15.2 AR112 AR115
Element: Adj Amt AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-OPEN-BASE Signed 15.2 AR12.1 AR12.2
Element: Open Base AR20.1 AR21.1
AR21.2 AR21.3
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
CB06.2 DT45.1
DT92.1
PVT-OPEN-TRAN Signed 15.2 AR12.1 AR12.2
Element: Open Tran AR20.1 AR21.1
AR21.2 AR21.3
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.5 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
CB06.2 DT45.1
DT92.1
PVT-SORT-AMOUNT Numeric 17 AR112 AR115
Element: Sort Amount AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-TRANS-USER1 Alpha 10 AR112 AR115
Element: Cust User1 AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-XREF-TYPE Alpha 1 AR112 AR115
Element: Xref Type AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-XREF-NBR Alpha 22 AR112 AR115
Element: Xref Nbr AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-PAYMENT-SEQ Numeric 6 AR112 AR115
Record Sequence AR12.1 AR12.2
Number AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-ORIG-CURRENCY Alpha 5 AR112 AR115
To Company Base AR12.1 AR12.2
Currency AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-ORIG-ND Numeric 1 AR112 AR115
Account Currency AR12.1 AR12.2
Code AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-ORIG-RATE Signed 12.6 AR112 AR115
Element: Account Rate AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-CURR-MUDV Alpha 1 AR112 AR115
Currency AR12.1 AR12.2
Multiply/Divide AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-SUM-LINE Alpha 1 AR112 AR115
Element: All Flag N = No line summarization AR12.1 AR12.2
Y = Summarize lines AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-NAT-FLAG Alpha 1 AR112 AR115
Element: Nat Flag N = Invoiced customer flag AR12.1 AR12.2
I = National account customer flag AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-APPLIED-SEQ Numeric 5 AR112 AR115
Element: App Seq AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-BANK-INST-CODE Alpha 3 AR112 AR115
Element: Transaction CoA transaction code represents a type of AR12.1 AR12.2
cash payment, bill of exchange payment, AR129 AR130
or bank service transaction. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-BANK-INST-TYPE Alpha 1 AR112 AR115
Transaction Code This categorizes the type of bank AR12.1 AR12.2
Type instrument. AR129 AR130
C = Cash payment AR131 AR135
D = Bill of Exchange AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
PVT-ALT-TYPE Alpha 1 AR112 AR115
Element: Alt Type I = Invoice AR12.1 AR12.2
C = Credit Memo AR129 AR130
D = Debit Memo AR131 AR135
M = Mixed signed lime items AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR560
AR82.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
AROPIVOT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVTSET1 NAT-COMPANY AR112 AR115
NAT-CUSTOMER AR12.1 AR12.2
TRANS-TYPE AR129 AR130
INVOICE AR131 AR135
PAYMENT-SEQ AR137 AR180
COMPANY AR190 AR20.1
CUSTOMER AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
...
PVTSET10 NAT-COMPANY KeyChange, Subset AR30.1 AR30.2
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.3 AR72.1
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET11 NAT-COMPANY Subset AR30.1 AR30.2
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.3 AR72.1
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET12 NAT-COMPANY Subset AR30.1 AR30.2
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.3 AR72.1
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET13 NAT-COMPANY Subset AR12.2 AR30.1
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.2 AR30.3
ACTIVITY AR72.1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET14 NAT-COMPANY Subset AR30.1 AR30.2
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.3 AR72.1
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET2 NAT-COMPANY AR131 AR30.1
NAT-CUSTOMER AR30.2 AR30.3
DUE-DATE AR72.1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET3 NAT-COMPANY KeyChange AR30.1 AR30.2
NAT-CUSTOMER AR30.3 AR72.1
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET4 NAT-COMPANY AR30.1 AR30.2
NAT-CUSTOMER AR30.3 AR72.1
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET5 NAT-COMPANY AR30.1 AR30.2
NAT-CUSTOMER AR30.3 AR72.1
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET6 NAT-COMPANY AR30.1 AR30.2
NAT-CUSTOMER AR30.3 AR72.1
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET7 NAT-COMPANY AR30.1 AR30.2
NAT-CUSTOMER AR30.3 AR72.1
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET8 NAT-COMPANY Subset AR12.1 AR12.2
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.1 AR30.2
TRANS-TYPE AR30.3 AR72.1
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET9 NAT-COMPANY Subset AR30.1 AR30.2
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.3 AR72.1
DUE-DATE
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
AROPIVOT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aroihdr AROIHDR Required
PVT-COMPANY -> ARH-COMPANY
PVT-ALT-TYPE -> ARH-TRANS-TYPE
PVT-INVOICE -> ARH-INVOICE
Aroitems AROITEMS Required
PVT-COMPANY -> ARO-COMPANY
PVT-TRANS-TYPE -> ARO-TRANS-TYPE
PVT-INVOICE -> ARO-INVOICE
PVT-PAYMENT-SEQ -> ARO-PAYMENT-SEQ
Arsapplied ARSAPPLIED Not Required
PVT-COMPANY -> ASG-COMPANY
PVT-TRANS-TYPE -> ASG-TRANS-TYPE
PVT-INVOICE -> ASG-INVOICE
PVT-PAYMENT-SEQ -> ASG-PAYMENT-SEQ
Cbbankinst CBBANKINST Required
PVT-BANK-INST-CODE -> CBI-BANK-INST-CODE
AROPIVOT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED
PVT-COMPANY -> ARA-COMPANY
PVT-TRANS-TYPE -> ARA-TRANS-TYPE
PVT-INVOICE -> ARA-INVOICE
PVT-PAYMENT-SEQ -> ARA-PAYMENT-SEQ
ARA-BATCH-NBR
ARA-APP-SEQ
|