 |
Lawson Insight Technical Documentation |
|
AROPIVOT FILE
REFERENCED BY
AR72.1
UPDATED BY
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 AR115 AR12.1
Nat Company 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) AR115 AR12.1
Nat Customer 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 AR115 AR12.1
Company The company number represents an AR129 AR130
established company and is entered on AR131 AR135
all function codes. 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) AR115 AR12.1
Customer Number This field contains the number that AR129 AR130
represents a customer. 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 AR115 AR12.1
Customer P.O. 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-TRANS-TYPE Alpha 1 AR115 AR12.1
Transaction Type Determines if amounts or units are AR129 AR130
processed in each transaction. AR131 AR135
C = Credit Memo AR137 AR180
D = Debit Memo AR190 AR20.1
I = Invoice 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 AR115 AR12.1
Invoice Number Used to identify the invoice. 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) AR115 AR12.1
Transaction Date The date of the transaction. 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) AR115 AR12.1
Due Date The transaction due date. 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 AR115 AR12.1
Discount Date 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 AR115 AR12.1
Discount Percent 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 AR115 AR12.1
Process Level This field contains the process level, AR129 AR130
which is the reporting hierarchy below AR131 AR135
company. 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 AR115 AR12.1
Activity Activities are the processes or AR129 AR130
procedures that produce work. Cost AR131 AR135
objects (products, services, customers, AR137 AR180
and so on) are the reasons for AR190 AR20.1
performing the activity. 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 AR115 AR12.1
Base Amount This is the amount of the transaction in AR129 AR130
the company base amount. 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 AR115 AR12.1
Transaction 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-OPEN-BASE Signed 15.2 AR12.1 AR20.1
Open Base 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 AR20.1
Open Tran 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 AR115 AR12.1
Sort 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-TRANS-USER1 Alpha 10 AR115 AR12.1
Trans User1 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 AR115 AR12.1
Xref Type 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 AR115 AR12.1
Xref Nbr 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 AR115 AR12.1
Payment Seq Payment Sequence. This is the generated AR129 AR130
sequence number to separate individual AR131 AR135
invoice payment requirements. 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 AR115 AR12.1
Original 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 AR115 AR12.1
Orig Nd Currency decimal indicator. 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 AR115 AR12.1
Orig Rate 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 AR115 AR12.1
Currency AR129 AR130
Multiply/Divide 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 AR115 AR12.1
Sum Line N = No line summarization AR129 AR130
Y = Summarize lines 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 AR115 AR12.1
Nat Flag N = Invoiced customer flag AR12.2 AR129
I = National account customer flag 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 AR115 AR12.1
Application Sequence 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 AR115 AR12.1
Transaction Code A transaction code represents a type of AR129 AR130
cash payment, bill of exchange payment, AR131 AR135
or bank service transaction. 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 AR115 AR12.1
Transaction Code This categorizes the type of bank AR129 AR130
Type instrument. AR131 AR135
C = Cash payment AR137 AR180
D = Bill of Exchange 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 AR115 AR12.1
Alt Type I = Invoice AR129 AR130
C = Credit Memo AR131 AR135
D = Debit Memo AR137 AR180
M = Mixed signed lime items 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 AR115 AR12.1
NAT-CUSTOMER AR129 AR130
TRANS-TYPE AR131 AR135
INVOICE AR137 AR180
PAYMENT-SEQ AR190 AR20.1
COMPANY AR21.1 AR21.2
CUSTOMER 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
...
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 AR30.1 AR30.2
NAT-CUSTOMER AR30.3 AR72.1
DUE-DATE
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 AR30.1
NAT-CUSTOMER Where NAT-FLAG = "I" AR30.2 AR30.3
TRANS-TYPE 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
|