Entity | Document |
Key property | ID |
Property starting with A | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
AccountCode | AssociateCode | AssociateCode | String | |||||
AccountContactEmail | Account Contact Email | Account Contact Email | String | |||||
AccountContactID | AccContactID | AccContactID | GUID | |||||
AccountContactName | AccContactName | AccContactName | String | |||||
AccountEmail | Associate Email | Associate Email | String | |||||
AccountID | Associate | Associate | GUID | |||||
AccountName | Associate name | Associate name | String | |||||
AllowPublish | Allow publish | Allow publish | Boolean | |||||
AllowReplies | Allow replies | Allow replies | Boolean | |||||
Assortment | Product line | Product line | Number | |||||
Property starting with C | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Category | Category | Category | String | |||||
CategoryID | GUID | |||||||
CheckedOut | Checked Out | Checked Out | Date | |||||
CheckedOutBy | Checked Out By | Checked Out By | Number | |||||
CheckedOutByName | Checked Out By | Checked Out By | String | |||||
CompanyCode | Company | Company | String | |||||
CompanyName | Company name | Company name | String | |||||
CreatedDate | Created date | Created date | Date |
![]() |
||||
Creator | Created by | Created by | String | |||||
CreatorName | Created by fullname | Created by fullname | String | |||||
CreditorNumber | String | |||||||
Property starting with D | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
DebtorNumber | String | |||||||
Description | Product line name | Product line name | String | |||||
Property starting with E | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
EntryKey | Transaction | Transaction | GUID | |||||
ExpiryDate | Date | |||||||
Property starting with F | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
FileName | File name | File name | String | |||||
FrontPageIntroText | String | |||||||
Property starting with G | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
GroupID | Group id | Group id | Number | |||||
GroupName | Group name | Group name | String | |||||
GroupTemplate | GroupTemplate | GroupTemplate | GUID | |||||
Property starting with H | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
HID | HID | HID | Number | |||||
Property starting with I | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
ID | ID | ID | GUID |
![]() |
||||
IsBinaryServiceEnabled | Boolean | |||||||
IsMailMerge | IsMailMerge | IsMailMerge | Boolean | |||||
IsTemplate | Template | Template | Boolean | |||||
ItemCode | Item code | Item code | String | |||||
ItemName | Item name | Item name | String | |||||
ItemSerialNumber | ItemSerialNumber | ItemSerialNumber | GUID | |||||
ItemSerialNumberCode | ItemSerialNumberCode | ItemSerialNumberCode | String | |||||
ItemSerialNumberName | ItemSerialNumberDesc | ItemSerialNumberDesc | String | |||||
Property starting with L | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
LanguageID | Language | Language | String | |||||
LanguageName | Language name | Language name | String | |||||
Property starting with M | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
MessageIDBody | GUID | |||||||
MessageIDDocument | GUID | |||||||
ModifiedDate | Modified date | Modified date | Date | |||||
Modifier | Modified by | Modified by | String | |||||
ModifierName | Modified by fullname | Modified by fullname | String | |||||
Property starting with N | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
NeedsApproval | Needs approval | Needs approval | Boolean | |||||
NewsType | Publish as | Publish as | Number |
![]() |
||||
Note | String | |||||||
Property starting with O | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
OrderNumber | Order number | Order number | String | |||||
OurRef | Our ref. | Our ref. | String | |||||
Owner | Owner | Owner | Number | |||||
OwnerName | OwnerFullname | OwnerFullname | String | |||||
OwnerType | Owner Type | Owner Type | Number | |||||
OwnerTypeValue | Owner Type Value | Owner Type Value | String | |||||
Property starting with P | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
ParentID | Parent ID | Parent ID | GUID | |||||
PaymentReference | String | |||||||
PersonEmail | Person Email | Person Email | String | |||||
PersonID | Person | Person | Number | |||||
PersonName | Person name | Person name | String | |||||
ProductReleaseOn | Release from | Release from | String | |||||
ProjectCompanyCode | Division | Division | String | |||||
ProjectDescription | Description | Description | String | |||||
ProjectNumber | ProjectNr | ProjectNr | String | |||||
Property starting with S | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Security | Security | Security | Boolean | |||||
SecurityLevel | Security level | Security level | Number |
![]() |
||||
ShipmentMethod | String | |||||||
Source | String | |||||||
Status | Status | Status | Number |
![]() |
||||
StatusText | Status text | Status text | String | |||||
SubCategory | sub-category | sub-category | String | |||||
Subject | Subject | Subject | String |
![]() |
||||
Property starting with T | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Type | Type | Type | Number | |||||
TypeAccountLabel | Account Label | Account Label | String | |||||
TypeAccountSelection | Account Selection | Account Selection | String | |||||
TypeAccountType | Account Type | Account Type | String | |||||
TypeAllowAttachment | Attachment | Attachment | Number | |||||
TypeDaysToExpiry | Number | |||||||
TypeDefSecurity | default security | default security | Number | |||||
TypeDeleteRights | String | |||||||
TypeEditRights | String | |||||||
TypeEditSecurity | Edit Security | Edit Security | Number | |||||
TypeFinanceSelection | Finance Selection | Finance Selection | String | |||||
TypeItemLabel | Item Label | Item Label | String | |||||
TypeItemSelection | Item Selection | Item Selection | String | |||||
TypeItemStatus | Item Status | Item Status | String | |||||
TypeName | Description | Description | String | |||||
TypeProjectSelection | Project Selection | Project Selection | String | |||||
TypeResourceLabel | Resource Label | Resource Label | String | |||||
TypeResourceSelection | Resource Selection | Resource Selection | String | |||||
TypeResourceStatus | Resource Status | Resource Status | String | |||||
TypeResourceType | Resource Type | Resource Type | String | |||||
TypeTemplate | TypeTemplate | TypeTemplate | GUID | |||||
TypeUseAccount | Use Account | Use Account | Number | |||||
TypeUseApprove | Approve | Approve | Number | |||||
TypeUseAssortment | Use Assortment | Use Assortment | Number | |||||
TypeUseFinance | Use Finance | Use Finance | Number | |||||
TypeUseItem | Use Item | Use Item | Number | |||||
TypeUseItemSerialNumber | TypeUseItemSerialNumber | TypeUseItemSerialNumber | Number | |||||
TypeUseOrderNumber | Number | |||||||
TypeUseOurReference | Number | |||||||
TypeUseOwner | Use Owner | Use Owner | Number | |||||
TypeUsePaymentReference | Number | |||||||
TypeUseProject | Use Project | Use Project | Number | |||||
TypeUsePublish | Use Project | Use Project | Number | |||||
TypeUseRating | Use Rating | Use Rating | Number | |||||
TypeUseResource | Use Resource | Use Resource | Number | |||||
TypeUseShipmentMethod | Number | |||||||
TypeUseWarehouse | Number | |||||||
TypeUseYourReference | Number | |||||||
TypeVersionType | String | |||||||
Property starting with U | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
UseAssociate | Use associate | Use associate | Number | |||||
UseClass | Use class 01 | Use class 01 | Number | |||||
UseCompany | Use company | Use company | Number | |||||
UseEntryKey | UseEntryKey | UseEntryKey | Number | |||||
UseItem | Use item | Use item | Number | |||||
UseItemSerialNumber | UseItemSerialNumber | UseItemSerialNumber | Number | |||||
UseLanguage | Use language | Use language | Number | |||||
UsePerson | Use person | Use person | Number | |||||
UseProjectNumber | UseProjectNr | UseProjectNr | Number | |||||
Property starting with V | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Version | Version | Version | String | |||||
VersionActivate | Boolean | |||||||
VersionCheckedOut | Checked Out | Checked Out | Date | |||||
VersionCheckedOutBy | Checked Out By | Checked Out By | Number | |||||
VersionCheckedOutByName | Checked Out By | Checked Out By | String | |||||
VersionCreatedBy | String |
![]() |
||||||
VersionCreatedDate | Date | |||||||
VersionFilename | String | |||||||
VersionFPIntroText | String | |||||||
VersionHID | Number | |||||||
VersionID | GUID | |||||||
VersionModifiedBy | String |
![]() |
||||||
VersionModifiedDate | Date | |||||||
VersionNote | String | |||||||
VersionStartDate | Date | |||||||
VersionStatus | Number | |||||||
VersionStatusText | String | |||||||
VersionSubject | String | |||||||
VersionToDealWith | String | |||||||
ViewDate | View Date | View Date | Date | |||||
Property starting with W | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Warehouse | Warehouse | Warehouse | String | |||||
Property starting with Y | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
YourRef | Your ref. | Your ref. | String |
Property starting with A | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
AccountCode | AssociatCode | String | 20 | 0 |
![]() |
![]() |
||||||||||||||
AccountContactEmail | AccContactEmail | String | 128 | 0 | ||||||||||||||||
AccountContactID | AccContactID | GUID | 16 | 0 | ||||||||||||||||
AccountContactName | AccContactName | String | 128 | 0 | ||||||||||||||||
AccountEmail | AssociateEmail | String | 128 | 0 | ||||||||||||||||
AccountID | Associate | GUID | 16 | 0 | ||||||||||||||||
AccountName | AssociateName | String | 50 | 0 | ||||||||||||||||
AllowPublish | AllowPublish | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
AllowReplies | AllowReplies | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
Assortment | Class_01 | Number | 10 | 0 | ||||||||||||||||
Property starting with C | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
Category | Category | String | 30 | 0 | ||||||||||||||||
CategoryID | CategoryID | GUID | 16 | 0 | ||||||||||||||||
CheckedOut | CheckedOut | Date | 0 | 0 | ||||||||||||||||
CheckedOutBy | CheckedOutBy | Number | 10 | 0 | ||||||||||||||||
CheckedOutByName | CheckedOutByName | String | 64 | 0 | ||||||||||||||||
CompanyCode | Company | String | 3 | 0 | ||||||||||||||||
CompanyName | CompanyName | String | 60 | 0 | ||||||||||||||||
CreatedDate | CreatedDate | Date |
![]() |
0 | 0 | NOW | ||||||||||||||
Creator | CreatedBy | String | 30 | 0 | ||||||||||||||||
CreatorName | CreatedByFullname | String | 64 | 0 | ||||||||||||||||
CreditorNumber | CreditorNumber | String | 6 | 0 |
![]() |
![]() |
||||||||||||||
Property starting with D | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
DebtorNumber | DebtorNumber | String | 6 | 0 |
![]() |
![]() |
||||||||||||||
Description | Class_01Name | String | 60 | 0 | ||||||||||||||||
Property starting with E | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
EntryKey | EntryKey | GUID | 16 | 0 | ||||||||||||||||
ExpiryDate | ExpiryDate | Date | 0 | 0 | ||||||||||||||||
Property starting with F | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
FileName | FileName | String | 128 | 0 | ||||||||||||||||
FrontPageIntroText | FPIntroText | String | 200 | 0 | ||||||||||||||||
Property starting with G | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
GroupID | Group | Number | 10 | 0 | ||||||||||||||||
GroupName | GroupName | String | 60 | 0 | ||||||||||||||||
GroupTemplate | GroupTemplate | GUID | 16 | 0 | ||||||||||||||||
Property starting with H | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
HID | HID | Number | 10 | 0 | ||||||||||||||||
Property starting with I | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
ID | ID | GUID |
![]() |
16 | 0 | |||||||||||||||
IsBinaryServiceEnabled | IsBinaryServiceEnabled | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
IsMailMerge | IsMailMerge | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
IsTemplate | IsTemplate | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
ItemCode | Item | String | 30 | 0 | ||||||||||||||||
ItemName | ItemName | String | 60 | 0 | ||||||||||||||||
ItemSerialNumber | ItemSerialNumber | GUID | 16 | 0 | ||||||||||||||||
ItemSerialNumberCode | ItemSerialNumbeCode | String | 30 | 0 | ||||||||||||||||
ItemSerialNumberName | ItemSerialNumberName | String | 60 | 0 | ||||||||||||||||
Property starting with L | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
LanguageID | Language | String | 3 | 0 |
![]() |
|||||||||||||||
LanguageName | LanguageName | String | 30 | 0 | ||||||||||||||||
Property starting with M | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
MessageIDBody | MessageID_body | GUID | 16 | 0 | ||||||||||||||||
MessageIDDocument | MessageID_document | GUID | 16 | 0 | ||||||||||||||||
ModifiedDate | ModifiedDate | Date | 0 | 0 | Select GetDate() as ModifiedDate | |||||||||||||||
Modifier | ModifiedBy | String | 30 | 0 | ||||||||||||||||
ModifierName | ModifiedByFullName | String | 64 | 0 | ||||||||||||||||
Property starting with N | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
NeedsApproval | NeedsApproval | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
NewsType | NewsType | Number |
![]() |
10 | 0 | 0 |
|
|||||||||||||
Note | Note | String | 8191 | 0 | ||||||||||||||||
Property starting with O | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
OrderNumber | OrderNumber | String | 8 | 0 |
![]() |
|||||||||||||||
OurRef | OurRef | String | 8 | 0 |
![]() |
|||||||||||||||
Owner | Owner | Number | 10 | 0 |
![]() |
|||||||||||||||
OwnerName | OwnerFullname | String | 64 | 0 | ||||||||||||||||
OwnerType | OwnerType | Number | 1 | 0 | 0 | |||||||||||||||
OwnerTypeValue | OwnerTypeValue | String | 50 | 0 | ||||||||||||||||
Property starting with P | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
ParentID | ParentID | GUID | 16 | 0 | ||||||||||||||||
PaymentReference | PaymentReference | String | 8191 | 0 | ||||||||||||||||
PersonEmail | PersonEmail | String | 128 | 0 | ||||||||||||||||
PersonID | Person | Number | 10 | 0 |
![]() |
|||||||||||||||
PersonName | PersonName | String | 64 | 0 | ||||||||||||||||
ProductReleaseOn | Class_02_1 | String | 30 | 0 | ||||||||||||||||
ProjectCompanyCode | ProjectNrDiv | String | 3 | 0 | ||||||||||||||||
ProjectDescription | ProjectDescription | String | 60 | 0 | ||||||||||||||||
ProjectNumber | ProjectNr | String | 20 | 0 |
![]() |
|||||||||||||||
Property starting with S | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
Security | Security | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
SecurityLevel | SecurityLevel | Number |
![]() |
10 | 0 | 0 | ||||||||||||||
ShipmentMethod | ShipmentMethod | String | 3 | 0 |
![]() |
|||||||||||||||
Source | Source | String | 1 | 0 | S |
|
||||||||||||||
Status | Status | Number |
![]() |
10 | 0 | |||||||||||||||
StatusText | StatusText | String | 1 | 0 | ||||||||||||||||
SubCategory | SubCategory | String | 30 | 0 | ||||||||||||||||
Subject | Subject | String |
![]() |
255 | 0 | |||||||||||||||
Property starting with T | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
Type | Type | Number | 10 | 0 | 0 |
![]() |
||||||||||||||
TypeAccountLabel | TypeAccountLabel | String | 255 | 0 | ||||||||||||||||
TypeAccountSelection | TypeAccountSelection | String | 255 | 0 | ||||||||||||||||
TypeAccountType | TypeAccountType | String | 1 | 0 | ||||||||||||||||
TypeAllowAttachment | TypeAllowAttachment | Number | 1 | 0 | ||||||||||||||||
TypeDaysToExpiry | TypeDaysToExpiry | Number | 1 | 0 | ||||||||||||||||
TypeDefSecurity | TypeDefSecurity | Number | 2 | 0 | ||||||||||||||||
TypeDeleteRights | TypeDeleteRights | String | 1 | 0 | ||||||||||||||||
TypeEditRights | TypeEditRights | String | 1 | 0 | ||||||||||||||||
TypeEditSecurity | TypeEditSecurity | Number | 1 | 0 | ||||||||||||||||
TypeFinanceSelection | TypeFinanceSelection | String | 255 | 0 | ||||||||||||||||
TypeItemLabel | TypeItemLabel | String | 255 | 0 | ||||||||||||||||
TypeItemSelection | TypeItemSelection | String | 255 | 0 | ||||||||||||||||
TypeItemStatus | TypeItemStatus | String | 1 | 0 | ||||||||||||||||
TypeName | TypeName | String | 30 | 0 | ||||||||||||||||
TypeProjectSelection | TypeProjectSelection | String | 255 | 0 | ||||||||||||||||
TypeResourceLabel | TypeResourceLabel | String | 255 | 0 | ||||||||||||||||
TypeResourceSelection | TypeResourceSelection | String | 255 | 0 | ||||||||||||||||
TypeResourceStatus | TypeResourceStatus | String | 1 | 0 | ||||||||||||||||
TypeResourceType | TypeResourceType | String | 1 | 0 | ||||||||||||||||
TypeTemplate | TypeTemplate | GUID | 16 | 0 | ||||||||||||||||
TypeUseAccount | TypeUseAccount | Number | 1 | 0 | ||||||||||||||||
TypeUseApprove | TypeUseApprove | Number | 1 | 0 | ||||||||||||||||
TypeUseAssortment | TypeUseAssortment | Number | 1 | 0 | ||||||||||||||||
TypeUseFinance | TypeUseFinance | Number | 1 | 0 | ||||||||||||||||
TypeUseItem | TypeUseItem | Number | 1 | 0 | ||||||||||||||||
TypeUseItemSerialNumber | TypeUseItemSerialNumber | Number | 1 | 0 | ||||||||||||||||
TypeUseOrderNumber | TypeUseOrderNumber | Number | 1 | 0 | ||||||||||||||||
TypeUseOurReference | TypeUseOurRef | Number | 1 | 0 | ||||||||||||||||
TypeUseOwner | TypeUseOwner | Number | 1 | 0 | ||||||||||||||||
TypeUsePaymentReference | TypeUsePaymentReference | Number | 1 | 0 | ||||||||||||||||
TypeUseProject | TypeUseProject | Number | 1 | 0 | ||||||||||||||||
TypeUsePublish | TypeUsePublish | Number | 1 | 0 | ||||||||||||||||
TypeUseRating | TypeUseRating | Number | 1 | 0 | ||||||||||||||||
TypeUseResource | TypeUseResource | Number | 1 | 0 | ||||||||||||||||
TypeUseShipmentMethod | TypeUseShipmentMethod | Number | 1 | 0 | ||||||||||||||||
TypeUseWarehouse | TypeUseWarehouse | Number | 1 | 0 | ||||||||||||||||
TypeUseYourReference | TypeUseYourRef | Number | 1 | 0 | ||||||||||||||||
TypeVersionType | TypeVersionType | String | 1 | 0 | ||||||||||||||||
Property starting with U | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
UseAssociate | UseAssociate | Number | 10 | 0 | ||||||||||||||||
UseClass | UseClass_01 | Number | 10 | 0 | ||||||||||||||||
UseCompany | UseCompany | Number | 10 | 0 | ||||||||||||||||
UseEntryKey | UseEntryKey | Number | 1 | 0 | ||||||||||||||||
UseItem | UseItem | Number | 10 | 0 | ||||||||||||||||
UseItemSerialNumber | UseItemSerialNumber | Number | 10 | 0 | ||||||||||||||||
UseLanguage | UseLanguage | Number | 10 | 0 | ||||||||||||||||
UsePerson | UsePerson | Number | 10 | 0 | ||||||||||||||||
UseProjectNumber | UseProjectNr | Number | 1 | 0 | ||||||||||||||||
Property starting with V | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
Version | Version | String | 20 | 0 | ||||||||||||||||
VersionActivate | VersionActivate | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||||
VersionCheckedOut | VersionCheckedOut | Date | 0 | 0 | ||||||||||||||||
VersionCheckedOutBy | VersionCheckedOutBy | Number | 10 | 0 | ||||||||||||||||
VersionCheckedOutByName | VersionCheckedOutByName | String | 64 | 0 | ||||||||||||||||
VersionCreatedBy | VersionCreatedBy | String |
![]() |
30 | 0 | HumresID | ||||||||||||||
VersionCreatedDate | VersionCreatedDate | Date | 0 | 0 | ||||||||||||||||
VersionFilename | VersionFilename | String | 128 | 0 | ||||||||||||||||
VersionFPIntroText | VersionFPIntroText | String | 200 | 0 | ||||||||||||||||
VersionHID | VersionHID | Number | 10 | 0 | ||||||||||||||||
VersionID | VersionID | GUID | 16 | 0 | ||||||||||||||||
VersionModifiedBy | VersionModifiedBy | String |
![]() |
30 | 0 | HumresID | ||||||||||||||
VersionModifiedDate | VersionModifiedDate | Date | 0 | 0 | ||||||||||||||||
VersionNote | VersionNote | String | 8191 | 0 | ||||||||||||||||
VersionStartDate | VersionStartDate | Date | 0 | 0 | NOW | |||||||||||||||
VersionStatus | VersionStatus | Number | 10 | 0 | ||||||||||||||||
VersionStatusText | VersionStatusText | String | 1 | 0 | ||||||||||||||||
VersionSubject | VersionSubject | String | 255 | 0 | ||||||||||||||||
VersionToDealWith | VersionToDealWith | String | 20 | 0 | ||||||||||||||||
ViewDate | ViewDate | Date | 0 | 0 | Select GetDate() as ViewDate | |||||||||||||||
Property starting with W | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
Warehouse | Warehouse | String | 4 | 0 | ||||||||||||||||
Property starting with Y | ||||||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values | |||
YourRef | YourRef | String | 40 | 0 |