AROPIVOT – National Account Trans

System
Accounts Receivable (AR)
Prefix
PVT
Primary key
NAT-COMPANY, NAT-CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, COMPANY, CUSTOMER
Fields
40
Updated by
4 programs
Referenced by
0 programs

AROPIVOT is the National Account Trans table in Lawson Accounts Receivable (prefix PVT). It is indexed by NAT-COMPANY, NAT-CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, COMPANY, CUSTOMER (PVTSET1); alternate indexes: PVTSET10, PVTSET11, PVTSET12, PVTSET13, PVTSET14, PVTSET2, PVTSET3, PVTSET4 and 5 more. It is related 1:1 to AROIHDR, AROITEMS, ARSAPPLIED and CBBANKINST and 1:M to ARAPPLIED. It is updated by AR12.1, AR12.2, ARLL.1 and CB06.2. The table has 40 fields, 14 indexes and 5 documented relations.

About AROPIVOT

No description in the Lawson data dictionary.

Fields (40)

Column = COBOL field name without the PVT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PVT-NAT-COMPANY PK
NAT_COMPANY		Numeric 4The national account number representing an AR company.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-NAT-CUSTOMER PK
NAT_CUSTOMER		Alpha 9 (Right Justified)The national account customer number.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-CUSTOMER PK
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 SET14 SET7
CUST_PO_NBR		Alpha 22The purchase order number of the related transaction.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-TRANS-TYPE PK
TRANS_TYPE		Alpha 1The transaction type of the related transaction.
  • C Credit Memo
  • D Debit Memo
  • I Invoice
AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the related transaction.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-DUE-DATE SET2 SET9
DUE_DATE		Numeric 8 (yyyymmdd)The related transaction due date.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-DISC-DATE
DISC_DATE		Numeric 8 (yyyymmdd) Occurs 3 Times ×3The related transaction discount date.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-DISC-PCT
DISC_PCT		Percent 7.5 (Percent) Occurs 3 Times ×3The related transaction discount percent.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-PROCESS-LEVEL SET11 SET4
PROCESS_LEVEL		Alpha 5This field contains the process level, or the related transaction.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-ACTIVITY SET13 SET6
ACTIVITY		Alpha 15The Activity value of the related transaction.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-BASE-AMT
BASE_AMT		Signed 18.2This is the amount of the related transaction in the company base amount.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-TRAN-AMT
TRAN_AMT		Signed 18.2The amount of the related transaction in transaction currency.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-OPEN-BASE
OPEN_BASE		Signed 18.2The unapplied amount of the related transaction in company base currency.AR12.1, AR12.2, CB06.2
#PVT-OPEN-TRAN
OPEN_TRAN		Signed 18.2The unapplied amount of the related transaction in transaction currency.AR12.1, AR12.2, CB06.2
#PVT-SORT-AMOUNT SET10 SET3
SORT_AMOUNT		Numeric 17The unapplied amount of the related transaction used for sorting purposes.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-TRANS-USER1 SET12 SET5
TRANS_USER1		Alpha 10The related transaction's User 1 field.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-XREF-TYPE
XREF_TYPE		Alpha 1The related transaction's cross reference type field.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-XREF-NBR
XREF_NBR		Alpha 22The related transaction's cross reference number field.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6This 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
ORIG_CURRENCY		Alpha 5The related transaction's currency.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-ORIG-ND
ORIG_ND		Numeric 1The related transaction's currency decimal indicator.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-ORIG-RATE
ORIG_RATE		Signed 14.7The related transaction's currency exchange rate.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-CURR-MUDV
CURR_MUDV		Alpha 1The related transaction's currency multiply or divide indicator.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-SUM-LINE
SUM_LINE		Alpha 1The 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
NAT_FLAG		Alpha 1The 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
APPLIED_SEQ		Numeric 7The related transction's applied sequence number.AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-BANK-INST-CODE
BANK_INST_CODE		Alpha 3The 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
BANK_INST_TYPE		Alpha 1This categorizes the type of bank instrument.
  • C Cash payment
  • D Bill of Exchange
AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-ALT-TYPE
ALT_TYPE		Alpha 1The 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
ORIG_DISC_AMT		Signed 18.2 Occurs 3 Times ×3—AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-MAJ-CLASS
MAJ_CLASS		Alpha 4—AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-MIN-CLASS
MIN_CLASS		Alpha 4——
#PVT-RISK-CD
RISK_CD		Alpha 1—AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-SALESMAN
SALESMAN		Numeric 4This 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
TERMS_CD		Alpha 5A 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
AC_CUSTOMER_ID		Alpha 5—AR12.1, AR12.2, ARLL.1, CB06.2
#PVT-BATCH-NBR
BATCH_NBR		Numeric 6—AR12.1, AR12.2, ARLL.1, CB06.2

Indexes (14)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PVTSET1
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
  6. COMPANY
  7. CUSTOMER
PrimaryAR12.1, AR12.2, ARLL.1, CB06.2
PVTSET10
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. SORT-AMOUNT ↓
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
KeyChange, SubsetWhere NAT-FLAG = "I"—
PVTSET11
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. PROCESS-LEVEL
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
SubsetWhere NAT-FLAG = "I"—
PVTSET12
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. TRANS-USER1
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
SubsetWhere NAT-FLAG = "I"—
PVTSET13
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. ACTIVITY
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
SubsetWhere NAT-FLAG = "I"AR12.2
PVTSET14
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. CUST-PO-NBR
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
SubsetWhere NAT-FLAG = "I"—
PVTSET2
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. DUE-DATE
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
—
PVTSET3
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. SORT-AMOUNT ↓
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
KeyChange—
PVTSET4
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. PROCESS-LEVEL
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
—
PVTSET5
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. TRANS-USER1
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
—
PVTSET6
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. ACTIVITY
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
—
PVTSET7
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. CUST-PO-NBR
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
—
PVTSET8
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
  6. COMPANY
  7. CUSTOMER
SubsetWhere NAT-FLAG = "I"AR12.1, AR12.2
PVTSET9
  1. NAT-COMPANY
  2. NAT-CUSTOMER
  3. DUE-DATE
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. COMPANY
  8. CUSTOMER
SubsetWhere NAT-FLAG = "I"—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AROIHDRAROITEMSARSAPPLIEDCBBANKINSTARAPPLIEDAROPIVOT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AroihdrAROIHDRRequired
PVT-COMPANY→ARH-COMPANY (ARHSET1)
PVT-ALT-TYPE→ARH-TRANS-TYPE
PVT-INVOICE→ARH-INVOICE
AroitemsAROITEMSRequired
PVT-COMPANY→ARO-COMPANY
PVT-TRANS-TYPE→ARO-TRANS-TYPE
PVT-INVOICE→ARO-INVOICE
PVT-PAYMENT-SEQ→ARO-PAYMENT-SEQ
ArsappliedARSAPPLIEDNot Required
PVT-COMPANY→ASG-COMPANY
PVT-TRANS-TYPE→ASG-TRANS-TYPE
PVT-INVOICE→ASG-INVOICE
PVT-PAYMENT-SEQ→ASG-PAYMENT-SEQ
CbbankinstCBBANKINSTRequired
PVT-BANK-INST-CODE→CBI-BANK-INST-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
ArappliedARAPPLIED
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

Programs

Updated by (4)