Skip to main content

Window: Test UU Based Table

[Created: 17/03/2023 - Updated: 17/03/2023 ]
Description:
Help:

Tab: Test UU Based Table

[Created: 17/03/2023 - Updated: 10/06/2023 ]
Description:
Help:
Tab Level: 0

Table 10: Test UU Based Table - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.testuu.AD_Client_ID numeric(10)
Search
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.testuu.AD_Org_ID numeric(10)
Table Direct
Search KeySearch key for the record in the format required - must be uniqueA search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).testuu.Value character varying(40)
String
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.testuu.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.testuu.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.testuu.Help character varying(2000)
String
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.testuu.IsActive character(1)
Yes-No

Tab: Test UU Based Table Trl

[Created: 26/11/2023 - Updated: 27/10/2024 ]
Description:
Help:
Tab Level: 1

Table 20: Test UU Based Table Trl - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.testuu_trl.AD_Client_ID numeric(10)
Search
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.testuu_trl.AD_Org_ID numeric(10)
Table Direct
Test UUtestuu_trl.TestUU_UU character varying(36)
Search (UU)
LanguageLanguage for this entityThe Language identifies the language to use for display and formattingtestuu_trl.AD_Language character varying(6)
Table
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.testuu_trl.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.testuu_trl.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.testuu_trl.Help character varying(2000)
String
TranslatedThis column is translatedThe Translated checkbox indicates if this column is translated.testuu_trl.IsTranslated character(1)
Yes-No
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.testuu_trl.IsActive character(1)
Yes-No

Tab: Test UU Detail

[Created: 24/03/2023 - Updated: 26/11/2023 ]
Description:
Help:
Tab Level: 1

Table 30: Test UU Detail - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.testuudet.AD_Client_ID numeric(10)
Search
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.testuudet.AD_Org_ID numeric(10)
Table Direct
Test UUtestuudet.TestUU_UU character varying(36)
Table Direct (UU)
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.testuudet.Name character varying(60)
String
Alternate Test UUtestuudet.AltTestUU_UU character varying(36)
Search (UU)
Multi Test UUtestuudet.TestUU_UUs character varying(2000)
Chosen Multiple Selection Table
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.testuudet.IsActive character(1)
Yes-No