Standardized List of Table Name Abbreviations
This list is an effort to standardize our naming convention for
database table and column names. Please use these abbreviations when
names are too long (longer than 28 characters).
| Full Word |
Abbreviation |
| Account |
ACCT |
| Accounts Receivable |
AR |
| Adjustment |
ADJ |
| Applicable |
APPL |
| Automatic |
AUTO |
| Back Office |
BO |
| Button |
BTN |
| Charge |
CHG |
| Charge Account |
CA |
| Community |
COM |
| Community Plan |
CP |
| Completion |
COMP |
| Configuration |
CONFIG |
| Credit Card |
CC |
| Customer |
CUST |
| Customer Type |
CT |
| Defined |
DEF |
| Department |
DEPT |
| Description |
DESC |
| Employee |
EMP |
| Extension/External |
EXT |
| Field |
FLD |
| Generation/Generate |
GEN |
| Internal |
INT |
| Inventory |
INV |
| Item Type |
IT |
| Knowledge Base |
KB |
| Magnetic |
MAG |
| Maximum |
MAX |
| Merchant ID |
MID |
| Message |
MSG |
| Minimum |
MIN |
| Move Order |
MO |
| Multiple |
MULT |
| Number |
NUM |
| Online Ordering |
OO |
| Password |
PW |
| Percentage |
PCT |
| Point of Sale |
POS |
| Purchase Order |
PO |
| Quantity |
QTY |
| Requisition/Requested |
REQ |
| Resident |
RES |
| Residents |
RDTS |
| Resident Portal |
RP |
| Revisions |
REV |
| Scope |
SCP |
| Separate |
SEP |
| Single Sign On |
SSO |
| Temporary |
TEMP |
| Terminal ID |
TID |
| Touch Screen |
TS |
| Transaction |
TRANS |
| Username |
UN |
| Yes/No |
YN |
Related Articles
Change Community Name/Abbreviation
Usage: Search and replace COMMUNITY_ID Search and replace COMMUNITY_NAME Search and replace billing abbrev Adjust descriptions as needed and follow instructions --*** DEVELOPMENT 1. Select from FC_OBJ_OWNER.COMMUNITIES table to identify community for ...
Reading List / Training for Customer Portal
Front-end Electron Electron Documentation - Starting page for official electron documentation. Sample apps for Electron - Example applications to illustrate the usage of Electron APIs. electron-builder - Tool for packaging and creating installers for ...
Colors/Themes
Community colors provide additional customization for communities to style their touchscreen point of sale systems. Each community has a list of configurable colors that can be accessed within the Backoffice application. In order to configure ...
Back Office and Engage SSO
Back Office SSO Engage SSO Back Office SSO FullCount utilizes the OpenId Connect (ODIC) protocol to authenticate users from external identity providers (IDP) into the Back Office. Documentation we can provide to the customer about the process can be ...
Remote Deployment Process - Java
Deployment Process Determine if a valid argument has been passed in Only continue if downloadOnly, postDownload, fullDeployment, handleSuccess, checkHash, verifyApplications passed through. Lock file to stop deployment from running more than once ...