Skip to main content

Window: Test

[Created: 21/06/1999 - Updated: 02/01/2000 ]
Description: Test Screen
Help:

Tab: Test

[Created: 21/06/1999 - Updated: 02/01/2000 ]
Description:
Help:
Tab Level: 0

Table 10: Test - 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.test.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.test.AD_Org_ID numeric(10)
Table Direct
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.test.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.test.Description character varying(255)
String
Comment/HelpComment or HintThe Help field contains a hint, comment or help about the use of this item.test.Help character varying(2000)
Text
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.test.IsActive character(1)
Yes-No
CurrencyThe Currency for this recordIndicates the Currency to be used when processing or reporting on this recordtest.C_Currency_ID numeric(10)
Table Direct
Amounttest.T_Amount numeric
Amount
Integertest.T_Integer numeric(10)
Integer
Numbertest.T_Number numeric
Number
UOMUnit of MeasureThe UOM defines a unique non monetary Unit of Measuretest.C_UOM_ID numeric(10)
Table Direct
Qtytest.T_Qty numeric
Quantity
Datetest.T_Date timestamp without time zone
Date
DateTimetest.T_DateTime timestamp without time zone
Date+Time
TimestampTimestamp with time zonetest.T_Timestamp timestamp with time zone
Timestamp With Time Zone
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersontest.C_BPartner_ID numeric(10)
Search
PaymentPayment identifierThe Payment is a unique identifier of this payment.test.C_Payment_ID numeric(10)
Search
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.test.M_Product_ID numeric(10)
Search
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.test.M_Locator_ID numeric(10)
Locator (WH)
AddressLocation or AddressThe Location / Address field defines the location of an entity.test.C_Location_ID numeric(10)
Location (Address)
Account_Accttest.Account_Acct numeric(10)
Account
TableDatabase Table informationThe Database Table provides the information of the table definitiontest.AD_Table_ID numeric(10)
Table Direct
Record IDDirect internal record IDThe Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known.test.Record_ID numeric(10)
Record ID
Record UUIDtest.Record_UU character varying(36)
Record UUID
Colortest.Color character varying(7)
Color
Binary DataBinary DataThe Binary field stores binary data.test.BinaryData bytea
Binary
Character DataLong Character Fieldtest.CharacterData text
Text Long
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.test.Processed character(1)
Yes-No
Process Nowtest.Processing character(1)
Button
JSON DataThe json field stores json data.test.JsonData jsonb
JSON