ShipmentLineTransactionRequestsshipmentLinesnotes
ShipmentLineTransactionRequestsshipmentLinesnotes
Columns
| Name | Type | Description |
| ShipmentLineTransactionRequestsTransactionId [KEY] | Long | ShipmentLineTransactionRequestsTransactionId of ShipmentLineTransactionRequestsshipmentLinesnotes |
| ShipmentlinesDeliveryDetailInterfaceId [KEY] | Long | ShipmentlinesDeliveryDetailInterfaceId of ShipmentLineTransactionRequestsshipmentLinesnotes |
| NoteId [KEY] | Long | The unique identifier of the note. This is the primary key of the notes table. |
| SourceObjectCode | String | This is the source object code for the source object as defined in OBJECTS Metadata. |
| SourceObjectId | String | The unique identifier of the parent source object associated to the note. |
| PartyName | String | The name of the party. |
| NoteTxt | String | The column which stores the actual note text. |
| NoteTypeCode | String | The note type code for categorization of note. |
| VisibilityCode | String | The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private. |
| CreatorPartyId | Long | The unique identifier of the party. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| PartyId | Long | The unique identifier of the party. |
| CorpCurrencyCode | String | The corporate currency code for extensibility. |
| CurcyConvRateType | String | The currency conversion rate type for extensibility. |
| CurrencyCode | String | The currency code for extensibility. |
| ContactRelationshipId | Long | The relationship ID populated when the note is associated with a contact. |
| ParentNoteId | Long | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdatedBy | String | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdateLogin | String | The login of the user who last updated the record. |
| EmailAddress | String | The email address of the user who created the note. |
| FormattedAddress | String | The address of the user who created the note. |
| FormattedPhoneNumber | String | The phone number of the user who created the note. |
| UpdateFlag | Bool | Indicates whether the user can update the note. |
| DeleteFlag | Bool | Indicates whether the user has access to delete the note. |
| NoteNumber | String | The alternate unique identifier of the note. A user key that's system generated or from an external system. |
| NoteTitle | String | The title of the note entered by the user. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BaseItem | String | BaseItem |
| BaseItemId | Long | BaseItemId |
| Carrier | String | Carrier |
| CarrierId | Long | CarrierId |
| CarrierNumber | String | CarrierNumber |
| EndAssemblyItem | String | EndAssemblyItem |
| FromRequestedDate | Datetime | FromRequestedDate |
| FromScheduledShipDate | Datetime | FromScheduledShipDate |
| InitialDestinationId | Long | InitialDestinationId |
| Item | String | Item |
| ItemId | Long | ItemId |
| ModeOfTransportCode | String | ModeOfTransportCode |
| OrderTypeCode | String | OrderTypeCode |
| OrganizationCode | String | OrganizationCode |
| OrganizationId | Long | OrganizationId |
| OrganizationName | String | OrganizationName |
| ServiceLevelCode | String | ServiceLevelCode |
| ToRequestedDate | Datetime | ToRequestedDate |
| ToScheduledShipDate | Datetime | ToScheduledShipDate |
| TransactionId | Long | TransactionId |
| TransportationShipment | String | TransportationShipment |
| Finder | String | finder |