AROPIVOT

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.
UPDATED BY
AR12.1 AR12.2 ARLL.1 CB06.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVT-NAT-COMPANY
Element: Company
Numeric 4
The national account number representing an AR company.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-NAT-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
The national account customer number.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-CUST-PO-NBR
Element: Cust Po Nbr
Alpha 22
The purchase order number of the related transaction.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-TRANS-TYPE
Element: Trans Type
Alpha 1
The transaction type of the related transaction.
C = Credit Memo
D = Debit Memo
I = Invoice
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
The date of the related transaction.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
The related transaction due date.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-DISC-DATE
Element: Date
Numeric 8 (yyyymmdd) Occurs 3 Times
The related transaction discount date.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-DISC-PCT
Element: Disc Pct
Percent 7.5 (Percent) Occurs 3 Times
The related transaction discount percent.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, or the related transaction.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-ACTIVITY
Element: Activity
Alpha 15
The Activity value of the related transaction.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-BASE-AMT
Element: Intl Amt
Signed 18.2
This is the amount of the related transaction in the company base amount.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-TRAN-AMT
Element: Intl Amt
Signed 18.2
The amount of the related transaction in transaction currency.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-OPEN-BASE
Element: Intl Amt
Signed 18.2
The unapplied amount of the related transaction in company base currency.
AR12.1 AR12.2
CB06.2
PVT-OPEN-TRAN
Element: Intl Amt
Signed 18.2
The unapplied amount of the related transaction in transaction currency.
AR12.1 AR12.2
CB06.2
PVT-SORT-AMOUNT
Element: Sort Amount
Numeric 17
The unapplied amount of the related transaction used for sorting purposes.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-TRANS-USER1
Element: Trans User1
Alpha 10
The related transaction's User 1 field.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-XREF-TYPE
Element: Xref Type
Alpha 1
The related transaction's cross reference type field.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-XREF-NBR
Element: Xref Nbr
Alpha 22
The related transaction's cross reference number field.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-PAYMENT-SEQ
Element: Seq Number
Numeric 6
This is the related transaction's generated sequence number to separate individual invoice payment requirements.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-ORIG-CURRENCY
Element: Orig Currency
Alpha 5
The related transaction's currency.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-ORIG-ND
Element: Acct Nd
Numeric 1
The related transaction's currency decimal indicator.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-ORIG-RATE
Element: Orig Rate
Signed 14.7
The related transaction's currency exchange rate.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-CURR-MUDV
Element: Curr Mudv
Alpha 1
The related transaction's currency multiply or divide indicator.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-SUM-LINE
Element: Sum Line
Alpha 1
The related transaction's sum line indicator. Valid values are:
N = No line summarization
Y = Summarize lines
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-NAT-FLAG
Element: Nat Flag
Alpha 1
The related customer's national account orientation. Valid values are:
N = Invoiced customer flag
I = National account customer flag
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-APPLIED-SEQ
Element: Applied Seq
Numeric 7
The related transction's applied sequence number.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-BANK-INST-CODE
Element: Bank Inst Code
Alpha 3
The related transaction's payment code representing a type of cash payment (with atributes for either receiving AP payments, or creating EFT payments), bill of exchange payment, or bank service transaction.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-BANK-INST-TYPE
Element: Bank Inst Type
Alpha 1
This categorizes the type of bank instrument.
C = Cash payment
D = Bill of Exchange
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-ALT-TYPE
Element: Alt Type
Alpha 1
The related transaction's alternate transaction type used to access the transaction header record.
I = Invoice
C = Credit Memo
D = Debit Memo
M = Mixed signed lime items
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-ORIG-DISC-AMT
Element: Intl Amt
Signed 18.2 Occurs 3 Times
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-MAJ-CLASS
Element: Major Class
Alpha 4
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-MIN-CLASS
Element: Minor Class
Alpha 4
PVT-RISK-CD
Element: Risk Cd
Alpha 1
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-SALESMAN
Element: Salesman
Numeric 4
This field contains the code that represents the primary salesrep of this line. If left blank, this defaults from the order header.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-TERMS-CD
Element: Term Code
Alpha 5
A user-defined code representing a method of determining invoice due and discount dates.
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-AC-CUSTOMER-ID
Element: Ac Customer Id
Alpha 5
AR12.1 AR12.2
ARLL.1 CB06.2
PVT-BATCH-NBR
Element: Batch Nbr
Numeric 6
AR12.1 AR12.2
ARLL.1 CB06.2


AROPIVOT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVTSET1 NAT-COMPANY
NAT-CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
AR12.1 AR12.2
ARLL.1 CB06.2
PVTSET10 NAT-COMPANY
NAT-CUSTOMER
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
KeyChange, Subset
WhereNAT-FLAG ="I"
PVTSET11 NAT-COMPANY
NAT-CUSTOMER
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
Subset
WhereNAT-FLAG ="I"
PVTSET12 NAT-COMPANY
NAT-CUSTOMER
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
Subset
WhereNAT-FLAG ="I"
PVTSET13 NAT-COMPANY
NAT-CUSTOMER
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
Subset
WhereNAT-FLAG ="I"
AR12.2
PVTSET14 NAT-COMPANY
NAT-CUSTOMER
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
Subset
WhereNAT-FLAG ="I"
PVTSET2 NAT-COMPANY
NAT-CUSTOMER
DUE-DATE
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET3 NAT-COMPANY
NAT-CUSTOMER
SORT-AMOUNT*
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
KeyChange
PVTSET4 NAT-COMPANY
NAT-CUSTOMER
PROCESS-LEVEL
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET5 NAT-COMPANY
NAT-CUSTOMER
TRANS-USER1
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET6 NAT-COMPANY
NAT-CUSTOMER
ACTIVITY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET7 NAT-COMPANY
NAT-CUSTOMER
CUST-PO-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
PVTSET8 NAT-COMPANY
NAT-CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
Subset
WhereNAT-FLAG ="I"
AR12.1 AR12.2
PVTSET9 NAT-COMPANY
NAT-CUSTOMER
DUE-DATE
TRANS-TYPE
INVOICE
PAYMENT-SEQ
COMPANY
CUSTOMER
Subset
WhereNAT-FLAG ="I"


AROPIVOT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Aroihdr AROIHDR Required
PVT-COMPANY->ARH-COMPANY (ARHSET1)
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
NAME
RELATED 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


File created: Thu Jun 09 11:09:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.