Lawson Insight Technical Documentation |
|
AROPIVOT
AROPIVOT FILE
This file contains national account transaction records that reference open
iten records. National account transaction records are used for cash
application and credit management sorting purposes.
REFERENCED BY
AR570 AR575 AR580 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
AR32.1 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 AR38.1 AR38.2 AR38.3
AR39.1 AR39.2 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 The national account number AR12.1 AR12.2
representing an AR company. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The national account 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The number representing an AR 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 This 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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: Cust Po Nbr The purchase order number of the related AR12.1 AR12.2
transaction. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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: Trans Type The transaction type of the related AR12.1 AR12.2
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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 Used 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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: Trans Date The date of the related 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 related 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related transaction discount 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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: Disc Pct The related transaction discount AR12.1 AR12.2
percent. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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
or the related transaction. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The Activity value of the related AR12.1 AR12.2
transaction. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 related AR12.1 AR12.2
transaction in 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The amount of the related transaction in AR12.1 AR12.2
transaction currency. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The unapplied amount of the related AR20.1 AR21.1
transaction in company base currency. AR21.2 AR21.3
AR29.3 AR30.1
AR30.8 AR32.1
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
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 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 The unapplied amount of the related AR20.1 AR21.1
transaction in transaction currency. AR21.2 AR21.3
AR29.3 AR30.1
AR30.8 AR32.1
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
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 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 The unapplied amount of the related AR12.1 AR12.2
transaction used for sorting purposes. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related transaction's User 1 field. 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related transaction's cross AR12.1 AR12.2
reference type field. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related transaction's cross AR12.1 AR12.2
reference number field. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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
Element: Seq Number This is the related transaction's AR12.1 AR12.2
generated sequence number to separate AR129 AR130
individual invoice payment requirements. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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: Orig Currency The related transaction's 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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
Element: Acct Nd The related transaction's currency AR12.1 AR12.2
decimal indicator. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related transaction's currency AR12.1 AR12.2
exchange rate. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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
Element: Curr Mudv The related transaction's currency AR12.1 AR12.2
multiply or divide indicator. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related transaction's sum line AR12.1 AR12.2
indicator. Valid values are: AR129 AR130
N = No line summarization AR131 AR135
Y = Summarize lines AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related customer's national account AR12.1 AR12.2
orientation. Valid values are: AR129 AR130
N = Invoiced customer flag AR131 AR135
I = National account customer flag AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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: Applied Seq The related transction's applied AR12.1 AR12.2
sequence number. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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: Bank Inst CodeThe related transaction's payment code AR12.1 AR12.2
representing a type of cash payment AR129 AR130
(with atributes for either receiving AR131 AR135
AP payments, or AR137 AR180
creating EFT payments), bill of AR190 AR20.1
exchange payment, or bank service AR21.1 AR21.2
transaction. AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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
Element: Bank Inst TypeThis categorizes the type of bank AR12.1 AR12.2
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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 The related transaction's alternate AR12.1 AR12.2
transaction type used to access the AR129 AR130
transaction header record. AR131 AR135
I = Invoice AR137 AR180
C = Credit Memo AR190 AR20.1
D = Debit Memo AR21.1 AR21.2
M = Mixed signed lime items AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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-DISC-AMT Signed 18.2 Occurs 3 Times 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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-MAJ-CLASS Alpha 4 AR112 AR115
Element: Major Class 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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-MIN-CLASS Alpha 4
Element: Minor Class
PVT-RISK-CD Alpha 1 AR112 AR115
Element: Risk Cd 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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-SALESMAN Numeric 4 AR112 AR115
Element: Salesman This field contains the code that AR12.1 AR12.2
represents the primary salesrep of this AR129 AR130
line. If left blank, this defaults AR131 AR135
from the order header. AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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-TERMS-CD Alpha 5 AR112 AR115
Element: Term Code A user-defined code representing a AR12.1 AR12.2
method of determining invoice due and AR129 AR130
discount dates. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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-AC-CUSTOMER-ID Alpha 5 AR112 AR115
Element: Ac Customer Id 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
AR32.1 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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
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 AR21.4
AR29.3 AR30.1
AR30.8 AR32.1
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 AR130 AR131
NAT-CUSTOMER AR30.1 AR30.8
DUE-DATE AR33.1 AR39.1
TRANS-TYPE AR72.1
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET3 NAT-COMPANY KeyChange AR30.1 AR33.1
NAT-CUSTOMER AR39.1 AR72.1
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET4 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR39.1 AR72.1
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET5 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR39.1 AR72.1
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET6 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR39.1 AR72.1
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET7 NAT-COMPANY AR30.1 AR33.1
NAT-CUSTOMER AR39.1 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
|