Skip to main content
Skip table of contents

Clusters and Attributes Used in ARUPEESC

The following are a few popular clusters available for the AR subsystem. Each section title is a cluster followed by the many attributes for that cluster. For a complete listing, visit the NU Cluster/Attribute Definition (NUUPCA) page.

What is a cluster or attribute?

Cluster: A table within the specific subsystem's database
Attribute: A column within the Cluster.

The Definition field of AR Selection Class (ARUPEESC) page uses Cluster.Attributes to define conditions. These conditions will form calculations, selections, or limit a selection to specific AR records. The records found during this selection or "query" will perform specific functions the user has designed. For instance, a Selection Class code can target specific records that use ACH for AR transactions, interface per a particular finance code, and more.

Within a condition statement, use mathematical symbols to manipulate and filter for the desired records. Use > , < , / , + , - , or = as desired to target information that will be used to make decisions.

Join the condition statements with "and" or "or."

Isolate conditions statements with the use of parentheses "(" and ")" when using "and" or "or" to connect ideas or limit the selection. "And" implies that both conditions must be met to be included, and "Or" implies that there is a choice where the first or second condition may be true.

ARUPEESC's Definition fields requires the following syntax to form condition statements:

Cluster.Attribute[command][condition]

Example#1: (ACCT.ABAL>"1000")  

  • ACCT is the cluster and ABAL is the attribute
  • Condition is to filter and return records where the Adjusted Account balance is greater than $1,000

Example#2: (ACCT.ABAL>10) and (TRNS.DUEDT<[xx/xx/xx]) 

  • Condition 1 is using cluster "ACCT" and attribute "ABAL"
  • Condition 2 is using cluster "TRNS" and attribute "DUEDT"
  • Condition is to filter and return records where the Adjusted Account balance is greater than $10.00, and the due date is as stated by xx/xx/xx.

Example#3: (ACCT.ABAL>10) or (TRNS.DUEDT<[xx/xx/xx])

  • Condition is to filter and return records where either the Adjusted Account balance is greater than $10.00 -OR- the due date is as stated by xx/xx/xx.

  • So "or" expanded the search for by asking for records where either condition A or condition B were true, or both true.

List of AR Clusters and Attributes

ACCT

 

 

 

 

Attribute

Description

 

Attribute

Description

ABAL

Adjusted Balance

 

DQSTAT

Delinquent Status

ACCTCC

Account #

 

FLAG

Misc Flags

ARADDR

Account Address Code

 

FLAG2

Misc Flags

ARAPE

Account PE Code

 

FULL

Full Time Flag

ATYPEV

Account Type Codes

 

GRAD

Grad Flag

BAL

Account Balance

 

ID

Account ID

BILL

Bill Flag

 

IDGR

Account GR

BKACCT

Bank Account

 

NAME

Account Name

BKRTE

Bank Route

 

NOTEDT

Delinquent Note Date

CRDAMT

Credit Amount

 

NOTETY

Delinquent Note Type

DFNUM

Account User Def. Number

 

STATUS

Status

DFNUMV

Account User Defined Numeric

 

TYPE

Account Type

PE

 

 

 

 

Attribute

Description

 

Attribute

Description

ADDRCD

Override Address Code

 

ID

Responsible PE ID

BG

Billing Group

 

NAME

Responsible Name

FLAG

Misc. Flags

 

PECD

PEDB Location Code

FLAG2

Misc. Flags

 

 

 

TERM

 

 

 

 

Attribute

Description

 

Attribute

Description

ARACID

Account ID

 

STATUS

TERM Status

ARIDTR

Account ID + Term

 

TERM

Category Term

ARITR2

Account GR

 

TYPE

Account Term Type

DFNUM

User Defined Term Number

 

TYPEV

Key Type

DFNUMV

User Defined Term Number

 

 

 

TRNS

 

 

 

 

Attribute

Description

 

Attribute

Description

ACGR

Account GR

 

BILLFL

Bill Flag

ACID

Account ID

 

BILLRF

Bill Ref

ADDRCD

Address Code

 

BTCH

Batch ID

AMT

Distribution Amount

 

CCAUTH

Credit Card Authorization

ARDIV

A/R Division Code

 

CCEXP

Credit Card EXP Date

ARIDTR

Acct ID & Term

 

CHARGE

Charge Amount

ARREF

Ref/Invoice

 

CHCD

Charge Code

BANKDT

Deposit Date

 

CRREF

Cash Receipt Number

BANKID

Deposit Bank

 

CURRCD

Currency Code

BANKSL

Deposit Slip

 

DEFID

Deferred Payment Plan ID

BF

Bill Flag

 

DESC

Description

BILLDT

Statement Date

 

DISC

Discount Amount

DISPF

Dispute Flag

 

PREP

Prep ID

DISPFL

Dispute Flag

 

PRIN

Principal Amount

DUEDT

Due Date

 

PRODID

Product ID

DUTY

Duty Amount

 

PYREF

Payment Reference

DUTYCD

Duty Code

 

PYTYPE

Payment Method

FCAMT

Native Amount

 

QTY

Quantity

FINCD

Finance Code

 

REFAMT

Reference Amount

GLKEY

Account Key

 

REFDT

Reference Date

GLKEY1

first char of Account Key

 

REL1

Relate To 1

GLOBJ

Object

 

REL2

Relate To 2

GR

Ledger Code

 

RETAIL

Retail Amount

HITAR

Hit A/R

 

SEPFLA

Separate Invoice/Billing Flag

ID

transactions id

 

SRCID

Source ID

INT

Interest

 

TAPETL

Tape Total

JLGR

Job Ledger GR Code

 

TAX1

Tax Amount

JLKEY

Job

 

TAX2

Tax Amount 2

JLOBJ

Functional Area

 

TAXCD1

Tax Code

JOBNO

IFAS Job Number

 

TAXCD2

Tax Code 2

MISC

Misc Code

 

TERM

Transaction Term

MSUR

Units of Measure

 

TERMS

Discount Terms

NAMECR

PAYEE NAME

 

TEXTID

Text Pointer

PLAN

Plan No

 

TF

Transaction Format

POREF

PO Reference

 

TID

Account ID

POSTCD

Posting Code

 

TID2

Account ID

POSTDT

GL Posting Date

 

TRTYPE

Transaction Type

PPNDX

Payment Plan Index

 

TYPE

Transaction Term Type

PRDL

LONG KEY DESC

 

WO

Work Order


 
 
 
 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.