Entity | Document |
Key property | ID |
Property starting with A | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
AccountContactEmail | Account Contact Email | Account Contact Email | String | AccountContactEmail | |||||
AccountContactID | AccContactID | AccContactID | GUID | AccountContactID | |||||
AccountContactName | AccContactName | AccContactName | String | AccountContactName | |||||
AllowPublish | Allow publish | Allow publish | Boolean | AllowPublish | |||||
AllowReplies | Allow replies | Allow replies | Boolean | AllowReplies | |||||
AssociateCode | AssociateCode | AssociateCode | String | AssociateCode | |||||
AssociateEmail | Associate Email | Associate Email | String | AssociateEmail | |||||
AssociateID | Associate | Associate | GUID | AssociateID | |||||
AssociateName | Associate name | Associate name | String | AssociateName | |||||
Assortment | Product line | Product line | Number | Assortment | |||||
AttachmentCount | Number | AttachmentCount | 252 | MWS | RD.SYN.252.MWS | ||||
Property starting with B | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
BinaryUpdate | BinaryUpdate | BinaryUpdate | Boolean | BinaryUpdate | |||||
Body | 0 | 0 | Binary | Body | |||||
Property starting with C | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Category | Category | Category | String | Category | |||||
CategoryID | GUID | CategoryID | |||||||
CheckedOut | Checked Out | Checked Out | Date | CheckedOut | |||||
CheckedOutBy | Checked Out By | Checked Out By | Number | CheckedOutBy | |||||
CheckedOutByName | Checked Out By | Checked Out By | String | CheckedOutByName | |||||
CompanyCode | Company | Company | String | CompanyCode | |||||
CompanyName | Company name | Company name | String | CompanyName | |||||
CreatedDate | Created date | Created date | Date |
![]() |
CreatedDate | ||||
Creator | Created by | Created by | String | Creator | |||||
CreatorName | Created by fullname | Created by fullname | String | CreatorName | |||||
CreditorNumber | String | CreditorNumber | |||||||
Property starting with D | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
DebtorNumber | String | DebtorNumber | |||||||
Description | Product line name | Product line name | String | Description | |||||
Property starting with E | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
EntryKey | Transaction | Transaction | GUID | EntryKey | |||||
ExpiryDate | Date | ExpiryDate | |||||||
Property starting with F | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
FileName | File name | File name | String | FileName | |||||
FPIntroText | String | FPIntroText | |||||||
Property starting with G | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
GroupID | Group id | Group id | Number | GroupID | |||||
GroupName | Group name | Group name | String | GroupName | |||||
GroupTemplate | GroupTemplate | GroupTemplate | GUID | GroupTemplate | |||||
Property starting with H | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
HID | HID | HID | Number | HID | |||||
Property starting with I | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
ID | ID | ID | GUID |
![]() |
ID | ||||
IsEmail | Boolean | IsEmail | 252 | MWS | RD.SYN.252.MWS | ||||
IsMailMerge | IsMailMerge | IsMailMerge | Boolean | IsMailMerge | |||||
IsTemplate | Template | Template | Boolean | IsTemplate | |||||
ItemCode | Item code | Item code | String | ItemCode | |||||
ItemName | Item name | Item name | String | ItemName | |||||
ItemSerialNumber | ItemSerialNumber | ItemSerialNumber | GUID | ItemSerialNumber | |||||
ItemSerialNumberCode | ItemSerialNumberCode | ItemSerialNumberCode | String | ItemSerialNumberCode | |||||
ItemSerialNumberName | ItemSerialNumberDesc | ItemSerialNumberDesc | String | ItemSerialNumberName | |||||
Property starting with L | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
LanguageID | Language | Language | String | LanguageID | |||||
LanguageName | Language name | Language name | String | LanguageName | |||||
Property starting with M | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
MessageID | MessageID | MessageID | GUID | MessageID | |||||
MessageIDBody | GUID | MessageIDBody | |||||||
ModifiedDate | Modified date | Modified date | Date | ModifiedDate | |||||
Modifier | Modified by | Modified by | String | Modifier | |||||
ModifierName | Modified by fullname | Modified by fullname | String | ModifierName | |||||
Property starting with N | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
NeedsApproval | Needs approval | Needs approval | Boolean | NeedsApproval | |||||
NewsType | Publish as | Publish as | Number |
![]() |
NewsType | ||||
Note | String | Note | |||||||
Property starting with O | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
OpportunityDescription | String | OpportunityDescription | |||||||
OpportunityID | Number | OpportunityID | |||||||
OrderNumber | Order number | Order number | String | OrderNumber | |||||
OurRef | Our ref. | Our ref. | String | OurRef | |||||
Owner | Owner | Owner | Number | Owner | |||||
OwnerName | OwnerFullname | OwnerFullname | String | OwnerName | |||||
OwnerType | Owner Type | Owner Type | Number | OwnerType | |||||
OwnerTypeValue | Owner Type Value | Owner Type Value | String | OwnerTypeValue | |||||
Property starting with P | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
ParentID | Parent ID | Parent ID | GUID | ParentID | |||||
PaymentReference | String | PaymentReference | |||||||
PersonEmail | Person Email | Person Email | String | PersonEmail | |||||
PersonID | Person | Person | Number | PersonID | |||||
PersonName | Person name | Person name | String | PersonName | |||||
PrepareDownload | PrepareDownload | PrepareDownload | Boolean | PrepareDownload | |||||
PrepareDownloadBody | Boolean | PrepareDownloadBody | |||||||
ProductReleaseOn | Release from | Release from | String | ProductReleaseOn | |||||
ProductReleaseTil | Release until | Release until | String | ProductReleaseTil | |||||
ProjectCompanyCode | Division | Division | String | ProjectCompanyCode | |||||
ProjectDescription | Description | Description | String | ProjectDescription | |||||
ProjectNumber | ProjectNr | ProjectNr | String | ProjectNumber | |||||
Property starting with S | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Security | Security | Security | Boolean | Security | |||||
SecurityLevel | Security level | Security level | Number |
![]() |
SecurityLevel | ||||
ShipmentMethod | String | ShipmentMethod | |||||||
SMSConfigurationCode | String | SMSConfigurationCode | |||||||
SMSConfigurationID | GUID | SMSConfigurationID | |||||||
SMSContractID | GUID | SMSContractID | |||||||
SMSContractNumber | String | SMSContractNumber | |||||||
Source | String | Source | |||||||
Status | Status | Status | Number |
![]() |
Status | ||||
StatusText | Status text | Status text | String | StatusText | |||||
SubCategory | sub-category | sub-category | String | SubCategory | |||||
Subject | Subject | Subject | String |
![]() |
Subject | ||||
Property starting with T | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Type | Type | Type | Number | Type | |||||
TypeAccountLabel | Account Label | Account Label | String | TypeAccountLabel | |||||
TypeAccountSelection | Account Selection | Account Selection | String | TypeAccountSelection | |||||
TypeAccountType | Account Type | Account Type | String | TypeAccountType | |||||
TypeAllowAttachment | Attachment | Attachment | Number | TypeAllowAttachment | |||||
TypeDaysToExpiry | Number | TypeDaysToExpiry | |||||||
TypeDefSecurity | default security | default security | Number | TypeDefSecurity | |||||
TypeDefSecurityTo | default security to | default security to | Number | TypeDefSecurityTo | |||||
TypeDeleteRights | String | TypeDeleteRights | |||||||
TypeEditRights | String | TypeEditRights | |||||||
TypeEditSecurity | Edit Security | Edit Security | Number | TypeEditSecurity | |||||
TypeFinanceSelection | Finance Selection | Finance Selection | String | TypeFinanceSelection | |||||
TypeItemLabel | Item Label | Item Label | String | TypeItemLabel | |||||
TypeItemSelection | Item Selection | Item Selection | String | TypeItemSelection | |||||
TypeItemStatus | Item Status | Item Status | String | TypeItemStatus | |||||
TypeName | Description | Description | String | TypeName | |||||
TypeOpportunitySelection | Opportunity | Opportunity | String | TypeOpportunitySelection | |||||
TypeProjectSelection | Project Selection | Project Selection | String | TypeProjectSelection | |||||
TypeResourceLabel | Resource Label | Resource Label | String | TypeResourceLabel | |||||
TypeResourceSelection | Resource Selection | Resource Selection | String | TypeResourceSelection | |||||
TypeResourceStatus | Resource Status | Resource Status | String | TypeResourceStatus | |||||
TypeResourceType | Resource Type | Resource Type | String | TypeResourceType | |||||
TypeSMSConfigurationSelection | Configuration Selection | Configuration Selection | String | TypeSMSConfigurationSelection | |||||
TypeSMSContractSelection | Contract Selection | Contract Selection | String | TypeSMSContractSelection | |||||
TypeTemplate | TypeTemplate | TypeTemplate | GUID | TypeTemplate | |||||
TypeUseAccount | Use Account | Use Account | Number | TypeUseAccount | |||||
TypeUseApprove | Approve | Approve | Number | TypeUseApprove | |||||
TypeUseAssortment | Use Assortment | Use Assortment | Number | TypeUseAssortment | |||||
TypeUseFinance | Use Finance | Use Finance | Number | TypeUseFinance | |||||
TypeUseItem | Use Item | Use Item | Number | TypeUseItem | |||||
TypeUseItemSerialNumber | TypeUseItemSerialNumber | TypeUseItemSerialNumber | Number | TypeUseItemSerialNumber | |||||
TypeUseLanguage | Use language | Use language | Number | TypeUseLanguage | |||||
TypeUseOpportunity | Opportunity | Opportunity | Number | TypeUseOpportunity | |||||
TypeUseOrderNumber | Number | TypeUseOrderNumber | |||||||
TypeUseOurRef | Number | TypeUseOurRef | |||||||
TypeUseOwner | Use Owner | Use Owner | Number | TypeUseOwner | |||||
TypeUsePaymentReference | Number | TypeUsePaymentReference | |||||||
TypeUseProject | Use Project | Use Project | Number | TypeUseProject | |||||
TypeUsePublish | Use Project | Use Project | Number | TypeUsePublish | |||||
TypeUseRating | Use Rating | Use Rating | Number | TypeUseRating | |||||
TypeUseResource | Use Resource | Use Resource | Number | TypeUseResource | |||||
TypeUseShipmentMethod | Number | TypeUseShipmentMethod | |||||||
TypeUseSMSConfiguration | Configuration | Configuration | Number | TypeUseSMSConfiguration | |||||
TypeUseSMSContract | Contract | Contract | Number | TypeUseSMSContract | |||||
TypeUseWarehouse | Number | TypeUseWarehouse | |||||||
TypeUseYourRef | Number | TypeUseYourRef | |||||||
TypeVersionType | String | TypeVersionType | |||||||
Property starting with U | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
UseAssociate | Use associate | Use associate | Number | UseAssociate | |||||
UseClass | Use class 01 | Use class 01 | Number | UseClass | |||||
UseCompany | Use company | Use company | Number | UseCompany | |||||
UseEntryKey | UseEntryKey | UseEntryKey | Number | UseEntryKey | |||||
UseItem | Use item | Use item | Number | UseItem | |||||
UseItemSerialNumber | UseItemSerialNumber | UseItemSerialNumber | Number | UseItemSerialNumber | |||||
UseLanguage | Use language | Use language | Number | UseLanguage | |||||
UseOpportunity | Opportunity | Opportunity | Number | UseOpportunity | |||||
UsePerson | Use person | Use person | Number | UsePerson | |||||
UseProjectNr | UseProjectNr | UseProjectNr | Number | UseProjectNr | |||||
Property starting with V | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Version | Version | Version | String | Version | |||||
VersionActivate | Boolean | VersionActivate | |||||||
VersionCheckedOut | Checked Out | Checked Out | Date | VersionCheckedOut | |||||
VersionCheckedOutBy | Checked Out By | Checked Out By | Number | VersionCheckedOutBy | |||||
VersionCheckedOutByName | Checked Out By | Checked Out By | String | VersionCheckedOutByName | |||||
VersionCreatedBy | String |
![]() |
VersionCreatedBy | ||||||
VersionCreatedDate | Date | VersionCreatedDate | |||||||
VersionFilename | String | VersionFilename | |||||||
VersionFPIntroText | String | VersionFPIntroText | |||||||
VersionHID | Number | VersionHID | |||||||
VersionID | GUID | VersionID | |||||||
VersionModifiedBy | String |
![]() |
VersionModifiedBy | ||||||
VersionModifiedDate | Date | VersionModifiedDate | |||||||
VersionNote | String | VersionNote | |||||||
VersionStartDate | Date | VersionStartDate | |||||||
VersionStatus | Number | VersionStatus | |||||||
VersionStatusText | String | VersionStatusText | |||||||
VersionSubject | String | VersionSubject | |||||||
VersionToDealWith | String | VersionToDealWith | |||||||
ViewDate | View Date | View Date | Date | ViewDate | |||||
Property starting with W | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Warehouse | Warehouse | Warehouse | String | Warehouse | |||||
Property starting with Y | |||||||||
Name | Caption | Description | Type | Mandatory | Name (known in REST) | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
YourRef | Your ref. | Your ref. | String | YourRef |
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 | |
AccountContactEmail | AccContactEmail | String | 128 | 0 | ||||||||||||||
AccountContactID | AccContactID | GUID | 16 | 0 | ||||||||||||||
AccountContactName | AccContactName | String | 128 | 0 | ||||||||||||||
AllowPublish | AllowPublish | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
AllowReplies | AllowReplies | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
AssociateCode | AssociatCode | String | 20 | 0 |
![]() |
![]() |
||||||||||||
AssociateEmail | AssociateEmail | String | 128 | 0 | ||||||||||||||
AssociateID | Associate | GUID | 16 | 0 | ||||||||||||||
AssociateName | AssociateName | String | 50 | 0 | ||||||||||||||
Assortment | Class_01 | Number | 10 | 0 | ||||||||||||||
AttachmentCount | AttachmentCount | Number | 10 | 0 | ||||||||||||||
Property starting with B | ||||||||||||||||||
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 | |
BinaryUpdate | BinaryUpdate | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
Body | Body | Binary | 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 | ||||||||||||||
FPIntroText | 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 | |||||||||||||
IsEmail | IsEmail | 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 | |
MessageID | MessageID | GUID | 16 | 0 | ||||||||||||||
MessageIDBody | MessageIDBody | 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 | |
OpportunityDescription | OpportunityDescription | String | 255 | 0 | ||||||||||||||
OpportunityID | OpportunityID | Number | 4 | 0 | ||||||||||||||
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 | ||||||||||||||
PrepareDownload | PrepareDownload | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
PrepareDownloadBody | PrepareDownloadBody | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
ProductReleaseOn | Class_02_1 | String | 30 | 0 | ||||||||||||||
ProductReleaseTil | Class_02_2 | String | 30 | 0 | ||||||||||||||
ProjectCompanyCode | ProjectNrDiv | String | 3 | 0 | ||||||||||||||
ProjectDescription | ProjectDescription | String | 30 | 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 |
![]() |
|||||||||||||
SMSConfigurationCode | SMSConfigurationCode | String | 30 | 0 | ||||||||||||||
SMSConfigurationID | SMSConfigurationID | GUID | 16 | 0 | ||||||||||||||
SMSContractID | SMSContractID | GUID | 16 | 0 | ||||||||||||||
SMSContractNumber | SMSContractNumber | String | 30 | 0 | ||||||||||||||
Source | Source | String | 1 | 0 | S |
|
||||||||||||
Status | Status | Number |
![]() |
10 | 0 | |||||||||||||
StatusText | StatusText | String | 100 | 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 | ||||||||||||||
TypeDefSecurityTo | TypeDefSecurityTo | 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 | ||||||||||||||
TypeOpportunitySelection | TypeOpportunitySelection | String | 255 | 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 | ||||||||||||||
TypeSMSConfigurationSelection | TypeSMSConfigurationSelection | String | 255 | 0 | ||||||||||||||
TypeSMSContractSelection | TypeSMSContractSelection | String | 255 | 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 | ||||||||||||||
TypeUseLanguage | TypeUseLanguage | Number | 10 | 0 | ||||||||||||||
TypeUseOpportunity | TypeUseOpportunity | Number | 1 | 0 | ||||||||||||||
TypeUseOrderNumber | TypeUseOrderNumber | Number | 1 | 0 | ||||||||||||||
TypeUseOurRef | 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 | ||||||||||||||
TypeUseSMSConfiguration | TypeUseSMSConfiguration | Number | 1 | 0 | ||||||||||||||
TypeUseSMSContract | TypeUseSMSContract | Number | 1 | 0 | ||||||||||||||
TypeUseWarehouse | TypeUseWarehouse | Number | 1 | 0 | ||||||||||||||
TypeUseYourRef | 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 | ||||||||||||||
UseOpportunity | UseOpportunity | Number | 1 | 0 | ||||||||||||||
UsePerson | UsePerson | Number | 10 | 0 | ||||||||||||||
UseProjectNr | 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 |