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 |