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.8
AR31.5 AR31.6 AR33.1 AR33.3 AR33.5 AR33.6
AR34.1 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 AR80.1 AR80.2 AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-COMPANY Numeric 4 AR112 AR115
Element: Company Identifies the AP company if the AR12.1 AR12.2
resource type = V. Identifies the HR AR129 AR130
company if the resource type = E. It is AR131 AR135
blank for type A, P or Q resources. AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-TRANS-DATE Numeric 8 (yyyymmdd) AR112 AR115
Element: Transaction DaThe date of the transaction. AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-DUE-DATE Numeric 8 (yyyymmdd) AR112 AR115
Element: Due 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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-BASE-AMT Signed 18.2 AR112 AR115
Element: Intl Amt 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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-TRAN-AMT Signed 18.2 AR112 AR115
Element: Intl 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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-OPEN-BASE Signed 18.2 AR12.1 AR12.2
Element: Intl Amt AR20.1 AR21.1
AR21.2 AR21.3
AR29.3 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
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
AR80.1 AR80.2
CB06.2 DT45.1
DT92.1
PVT-OPEN-TRAN Signed 18.2 AR12.1 AR12.2
Element: Intl Amt AR20.1 AR21.1
AR21.2 AR21.3
AR29.3 AR30.1
AR30.8 AR31.5
AR31.6 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
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
AR80.1 AR80.2
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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-TRANS-USER1 Alpha 10 AR112 AR115
Element: Trans 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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-PAYMENT-SEQ Numeric 6 AR112 AR115
Record Sequence Payment Sequence. This is the generated AR12.1 AR12.2
Number sequence number to separate individual AR129 AR130
invoice payment requirements. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-ORIG-CURRENCY Alpha 5 AR112 AR115
Element: Original Currency AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-ORIG-ND Numeric 1 AR112 AR115
Account Currency Currency decimal indicator. 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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-ORIG-RATE Signed 14.7 AR112 AR115
Element: Orig 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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-SUM-LINE Alpha 1 AR112 AR115
Element: Sum Line 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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.1
CB06.2 DT150
DT170 DT180
DT181 DT45.1
DT92.1
PVT-APPLIED-SEQ Numeric 7 AR112 AR115
Element: Application Sequence AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 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
AR80.1 AR80.2
AR82.1 ARLL.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.8
AR31.5 AR31.6
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
...
PVTSET10 NAT-COMPANY KeyChange, Subset AR30.1 AR33.1
NAT-CUSTOMER Where NAT-FLAG = "I" AR72.1
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET11 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where NAT-FLAG = "I" AR72.1
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET12 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where NAT-FLAG = "I" 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" AR33.1 AR72.1
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET14 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where NAT-FLAG = "I" AR72.1
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET2 NAT-COMPANY AR131 AR30.1
NAT-CUSTOMER AR33.1 AR72.1
DUE-DATE
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET3 NAT-COMPANY KeyChange AR30.1 AR33.1
NAT-CUSTOMER AR72.1
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET4 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR72.1
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET5 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR72.1
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET6 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR72.1
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET7 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR72.1
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET8 NAT-COMPANY Subset AR112 AR12.1
NAT-CUSTOMER Where NAT-FLAG = "I" AR12.2 AR30.1
TRANS-TYPE AR33.1 AR72.1
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET9 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where NAT-FLAG = "I" 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
|