AROPIVOT FILE UPDATED BY AR115 AR12.1 AR12.2 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PVT-NAT-COMPANY Numeric 4 AR115 AR12.1 Nat Company AR12.2 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-NAT-CUSTOMER Alpha 9 (Right Justified) AR115 AR12.1 Nat Customer AR12.2 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-COMPANY Numeric 4 AR115 AR130 Company The company number represents an AR131 AR135 established company and is entered on AR137 AR180 all function codes. 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-CUSTOMER Alpha 9 (Right Justified) AR115 AR130 Customer Number This field contains the number that AR131 AR135 represents a customer. 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-CUST-PO-NBR Alpha 20 AR115 AR130 Customer P.O. Number 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-TRANS-TYPE Alpha 1 AR115 AR130 Transaction Type Determines if amounts or units are AR131 AR135 processed in each 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-TRANS-NBR Alpha 10 (Right Justified) AR115 AR130 Trans Nbr A unique, user-defined value used to AR131 AR135 identify the 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-TRANS-DATE Numeric 8 (yyyymmdd) AR115 AR130 Transaction Date The date of the 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-DUE-DATE Numeric 8 (yyyymmdd) AR115 AR130 Due Date The transaction due date. 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-DISC-DATE Numeric 8 (yyyymmdd) Occurs 3 Times AR115 AR130 Discount Date 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-DISC-PCT Percent 5.3 (Percent) Occurs 3 Times AR115 AR130 Discount Percent 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-PROCESS-LEVEL Alpha 5 AR115 AR130 Process Level This field contains the process level, AR131 AR135 which is the reporting hierarchy below AR137 AR180 company. 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-ACTIVITY Alpha 15 AR115 AR130 Activity Activities are the processes or AR131 AR135 procedures that produce work. Cost AR137 AR180 objects (products, services, customers, AR190 AR20.1 and so on) are the reasons for AR21.1 AR21.2 performing the activity. Activities and AR21.3 AR29.3 cost object activities are used AR30.1 AR30.2 synonymously in the Activity Management AR30.3 AR30.4 system. Direct costs are posted to AR30.8 AR31.5 activities, and indirect costs are AR31.6 AR35.1 allocated to activities based on AR35.2 AR37.1 activity drivers. AR37.2 AR37.3 AR37.4 AR37.5 Activities are grouped or organized by AR37.6 AR37.7 activity levels. There are two kinds of AR42.1 AR42.2 activities: "posting allowed" and AR42.6 AR42.7 "summary only." Use posting level AR43.1 AR44.3 activities to budget and maintain all AR502 AR504 posted transactions. Summary activities AR560 AR82.1 or macro activities combine information CB06.2 DT150 and balances from lower level activities DT170 DT180 for reporting and inquiries. DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-BASE-AMT Signed 15.2 AR115 AR130 Base Amount The transaction's 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-TRAN-AMT Signed 15.2 AR115 AR130 Transaction 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 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 AR44.3 CB06.2 DT40.1 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 AR44.3 CB06.2 DT40.1 DT45.1 DT92.1 PVT-SORT-AMOUNT Numeric 17 AR115 AR130 Sort 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-TRANS-USER1 Alpha 10 AR115 AR130 Trans User 1 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-XREF-TYPE Alpha 1 AR115 AR130 Xref Type 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-XREF-NBR Alpha 10 AR115 AR130 Xref Nbr 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-PAYMENT-SEQ Numeric 6 AR115 AR130 Payment Seq Payment Sequence. This is the generated AR131 AR135 sequence number to separate individual AR137 AR180 invoice payment requirements. 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-ORIG-CURRENCY Alpha 5 AR115 AR130 Original Currency 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-ORIG-ND Numeric 1 AR115 AR130 Orig Nd Currency decimal indicator. 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-ORIG-RATE Signed 12.6 AR115 AR130 Orig Rate 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-CURR-MUDV Alpha 1 AR115 AR130 Currency AR131 AR135 Multiply/Divide 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-SUM-LINE Alpha 1 AR115 AR130 Sum Line 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-NAT-FLAG Alpha 1 AR115 AR130 Nat Flag 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 PVT-APPLIED-SEQ Numeric 5 AR115 AR130 Application Sequence 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 AR502 AR504 AR560 AR82.1 CB06.2 DT150 DT170 DT180 DT181 DT40.1 DT45.1 DT520 DT92.1 AROPIVOT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PVTSET1 NAT-COMPANY AR115 AR130 NAT-CUSTOMER AR131 AR135 TRANS-TYPE AR137 AR180 TRANS-NBR AR190 AR20.1 PAYMENT-SEQ AR21.1 AR21.2 COMPANY AR21.3 AR29.3 CUSTOMER 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 ... PVTSET10 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 NAT-FLAG PROCESS-LEVEL TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET11 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 COMPANY CUSTOMER SORT-AMOUNT* TRANS-TYPE TRANS-NBR PAYMENT-SEQ PVTSET12 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 COMPANY CUSTOMER DUE-DATE TRANS-TYPE TRANS-NBR PAYMENT-SEQ PVTSET13 NAT-COMPANY AR12.1 AR12.2 NAT-CUSTOMER AR30.1 AR30.2 COMPANY AR30.3 CUSTOMER TRANS-TYPE TRANS-NBR PAYMENT-SEQ PVTSET14 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 COMPANY CUSTOMER TRANS-DATE TRANS-TYPE TRANS-NBR PAYMENT-SEQ PVTSET2 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 TRANS-DATE TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET3 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 DUE-DATE TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET4 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 SORT-AMOUNT* TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET5 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 PROCESS-LEVEL TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET6 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 NAT-FLAG TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET7 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 NAT-FLAG TRANS-DATE TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET8 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 NAT-FLAG DUE-DATE TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER PVTSET9 NAT-COMPANY AR30.1 AR30.2 NAT-CUSTOMER AR30.3 NAT-FLAG SORT-AMOUNT* TRANS-TYPE TRANS-NBR PAYMENT-SEQ COMPANY CUSTOMER |