DocumentRecords
DocumentRecords
Columns
| Name | Type | Description |
| DocumentsOfRecordId [KEY] | Long | Surrogate identifier for the record. Applicable to existing records only. |
| DocumentTypeId | Long | Unique identifier for the document type. |
| SystemDocumentType | String | System-generated name that uniquely identifies the document type. |
| DocumentType | String | Document type for the document record. |
| Country | String | Name of the country, if the document type is country specific. |
| CategoryCode | String | Category for the document type. |
| SubCategoryCode | String | Subcategory code for the document type. |
| PersonId | Long | Unique identifier for the person. |
| PersonNumber | String | Person number of the person the document record is for. |
| ListName | String | Name of the person the document record is for. |
| DisplayName | String | Display name of the person the document record is for. |
| FullName | String | Full name of the person the document record is for. |
| DocumentCode | String | Unique code that identifies the document record for the person and document type. |
| DocumentName | String | Name for the document record. Used to differentiate records when multiple documents are added for the same document type. |
| DocumentNumber | String | Number that legally identifies the document. |
| DateFrom | Date | Date from which the document is valid. |
| DateTo | Date | Last date up to which the document is valid. |
| IssuingAuthority | String | Name of the issuing authority. |
| IssuingCountryName | String | Name of the country that issued the document. |
| IssuedDate | Date | Date on which the document was issued. |
| IssuingLocation | String | Location at which the document was issued. |
| Comments | String | Comments pertaining to the document record. |
| Publish | String | Option to determine whether or not to publish the document record on a specific date. |
| PublishDate | Date | Date on which the document was published. |
| RelatedObjectId | Long | Unique identifier of the related object. |
| RelatedObjectIdColumn | String | Column details of the related object identifier. |
| RelatedObjectName | String | Name of the related object. |
| CreatedBy | String | Name of the user who created the document. |
| CreationDate | Datetime | Date on which the document record was created. |
| LastUpdatedBy | String | Name of the user who last updated the document. |
| LastUpdateDate | Datetime | Date on which the document record was last updated. |
| AssignmentId | Long | Assignment Identifier of the person assignment. |
| AssignmentNumber | String | Assignment Number of the person assignment. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |