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