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

Before You Start

Workflow

  1. Open Form Sales / Point of Sale / Table List.
  2. Create a new record, or select an existing record when the data needs to be corrected.
  3. Fill in the required fields and complete supporting information that helps search, reporting, or transaction processing.
  4. Review the code, name, status, accounts, grouping, and other references before saving.
  5. Click Save. If the application shows a validation message, follow the message until the data is saved successfully.

Key Fields

FieldUser ExplanationStatus
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

After Saving

Common Issues

Available Fields

The list below summarizes the fields available in this form. Field labels follow the English UI language file used by the application.

FieldUser ExplanationStatus
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