National Account Trans

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

AROPIVOT FILE RELATIONS

ONE TO ONE RELATIONS

AROPIVOT FILE RELATIONS

ONE TO MANY RELATIONS

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