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 Form Sales / 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 |
|---|---|---|
Codeid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Namename |
Name shown in selections, transactions, and reports. Use wording that is clear for daily users. | Required |
Customer Codecustomerid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Table Grouptablegroup |
Table Group stores information needed by Table List. Fill it in according to the company data standard. | Required |
Activeisactive |
Status that controls whether the data can be used in new transactions or selections. | Optional |
Product Codeproductid |
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 |
|---|---|---|
Codeid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Namename |
Name shown in selections, transactions, and reports. Use wording that is clear for daily users. | Required |
Customer Codecustomerid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Required |
Table Grouptablegroup |
Table Group stores information needed by Table List. Fill it in according to the company data standard. | Required |
Activeisactive |
Status that controls whether the data can be used in new transactions or selections. | Optional |
Product Codeproductid |
Unique code used to identify Table List. Use a consistent pattern so users can search and sort the data easily. | Optional |
Last Updatedupdatetimestamp |
Audit timestamp filled in automatically by the application. | Optional |
Number of Guestsguestcount |
Number of Guests stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Visitor Namevisitorname |
Name shown in selections, transactions, and reports. Use wording that is clear for daily users. | Optional |
Leasedisrent |
Leased stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Time Unittimeunit |
Time used to distinguish entries that happen on the same date. | Optional |
Secondary Time Unitsecondtimeunit |
Time used to distinguish entries that happen on the same date. | Optional |
The variable below is calculated using the secondary time unithrsecondunit |
Time used to distinguish entries that happen on the same date. | Optional |
Rental Expiration Warning Timenotiftimebeforefinish |
Time used to distinguish entries that happen on the same date. | Optional |
Start Deadlinelimittimestart |
Time used to distinguish entries that happen on the same date. | Optional |
Completion Deadlinelimittimefinish |
Time used to distinguish entries that happen on the same date. | Optional |
Minimum Rental Periodminrentperiod |
Minimum Rental Period stores information needed by Table List. Fill it in according to the company data standard. | Optional |
External Commandhrexternalcommand |
External Command stores information needed by Table List. Fill it in according to the company data standard. | Optional |
External Command on Startcommandstart |
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 Warningcommandwarning |
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 Finishcommandfinish |
External Command on Finish stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Sales Invoicesalesid |
Sales Invoice stores information needed by Table List. Fill it in according to the company data standard. | Optional |
Created Byusercreate |
Audit information filled in automatically when the record is created. | Optional |
Updated Byuseredit |
Audit information filled in automatically when the record is updated. | Optional |
Menu Location
- Form Sales / Point of Sale / Table List
/form/postable