Table List
Table List is used to maintain master data that becomes a reference for transactions, reports, filters, or other settings.
Used By
Administrator or module owner
Data Type
master data
Search Keys
Code, Name
When to Use This Form
- When users need to create, review, or update Table List.
- When this data needs to be available as a choice in transactions, reports, filters, or settings.
- When existing data needs correction because policies, accounts, prices, contacts, or operating rules have changed.
Before You Start
- Make sure the user has access to this menu and the related reference data has already been prepared.
- Check required fields first, especially codes, names, dates, accounts, customers, suppliers, products, divisions, or departments.
- If the form uses active status, confirm the status before saving so the data appears in the correct selections.
Workflow
- Open Sales & POS / Point of Sale / Table List.
- Create a new record, or select an existing record when the data needs to be corrected.
- Fill in the required fields and complete supporting information that helps search, reporting, or transaction processing.
- Review the code, name, status, accounts, grouping, and other references before saving.
- Click Save. If the application shows a validation message, follow the message until the data is saved successfully.
Key Fields
| Field | User Explanation | Status |
|---|---|---|
Code
id |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Name
name |
Name shown in selections, transactions, and reports. Use wording that is clear for daily users. | Required |
Customer Code
customerid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Table Group
tablegroup |
Table Group stores information needed by Table List. Fill it in according to the company data standard. | Required |
Active
isactive |
Status that controls whether the data can be used in new transactions or selections. | Optional |
Product Code
productid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Optional |
Details and Relationships
- Most master-data forms are used as references by other forms. Changes may affect future transactions and reports.
- Audit fields are filled in automatically by the application and help support teams trace changes.
After Saving
- Active data can appear as a choice in transactions, reports, filters, or settings that use this reference.
- Changes are normally used for new activity. Historical documents remain available for review.
- If required data is incomplete or inconsistent, the application rejects the save and shows a validation message.
Common Issues
- Data cannot be saved: complete required fields and read the validation message shown by the application.
- Data does not appear in selection or search: check active status, access rights, filters, and the search keyword.
- Duplicate code or name: use the existing record when it should be corrected, or use a different code for a new record.
- Report values do not match: recheck reference data, accounts, dates, transaction status, and related filters.
Available Fields
The list below summarizes the fields available in this form. Field labels follow the English UI language file used by the application.
| Field | User Explanation | Status |
|---|---|---|
Code
id |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Name
name |
Name shown in selections, transactions, and reports. Use wording that is clear for daily users. | Required |
Customer Code
customerid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Table Group
tablegroup |
Table Group stores information needed by Table List. Fill it in according to the company data standard. | Required |
Active
isactive |
Status that controls whether the data can be used in new transactions or selections. | Optional |
Product Code
productid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Optional |
Last Updated
updatetimestamp |
Audit timestamp filled in automatically by the application. | Optional |
Number of Guests
guestcount |
Number of Guests stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Visitor Name
visitorname |
Name shown in selections, transactions, and reports. Use wording that is clear for daily users. | Optional |
Leased
isrent |
Leased stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Time Unit
timeunit |
Time used to distinguish entries that happen on the same date. | Optional |
Secondary Time Unit
secondtimeunit |
Time used to distinguish entries that happen on the same date. | Optional |
The variable below is calculated using the secondary time unit
hrsecondunit |
Time used to distinguish entries that happen on the same date. | Optional |
Rental Expiration Warning Time
notiftimebeforefinish |
Time used to distinguish entries that happen on the same date. | Optional |
Start Deadline
limittimestart |
Time used to distinguish entries that happen on the same date. | Optional |
Completion Deadline
limittimefinish |
Time used to distinguish entries that happen on the same date. | Optional |
Minimum Rental Period
minrentperiod |
Minimum Rental Period stores information needed by Table List. Fill it in according to the company data standard. | Optional |
External Command
hrexternalcommand |
External Command stores information needed by Table List. Fill it in according to the company data standard. | Optional |
External Command on Start
commandstart |
External Command on Start stores information needed by Table List. Fill it in according to the company data standard. | Optional |
External Command on Near Finish Warning
commandwarning |
External Command on Near Finish Warning stores information needed by Table List. Fill it in according to the company data standard. | Optional |
External Command on Finish
commandfinish |
External Command on Finish stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Sales Invoice
salesid |
Sales Invoice stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Created By
usercreate |
Audit information filled in automatically when the record is created. | Optional |
Updated By
useredit |
Audit information filled in automatically when the record is updated. | Optional |
Menu Location
- Sales & POS / Point of Sale / Table List
/form/postable