ReceivablesCreditMemosnotes
ReceivablesCreditMemosnotes
Columns
Name | Type | Description |
ReceivablesCreditMemosCustomerTransactionId [KEY] | Long | The unique identifier of the credit memo. |
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 |
BindAccountingDate | Date | BindAccountingDate |
BindAllowCompletion | String | BindAllowCompletion |
BindBillToCustomer | String | BindBillToCustomer |
BindBillToCustomerNumber | String | BindBillToCustomerNumber |
BindBillToSite | String | BindBillToSite |
BindBusinessUnit | String | BindBusinessUnit |
BindCreditMemoCurrency | String | BindCreditMemoCurrency |
BindCreditMemoStatus | String | BindCreditMemoStatus |
BindCrossReference | String | BindCrossReference |
BindDeliveryMethod | String | BindDeliveryMethod |
BindDocumentNumber | Long | BindDocumentNumber |
BindIntercompany | String | BindIntercompany |
BindPrimarySalesperson | String | BindPrimarySalesperson |
BindPrintStatus | String | BindPrintStatus |
BindPurchaseOrder | String | BindPurchaseOrder |
BindShipToCustomerName | String | BindShipToCustomerName |
BindShipToSite | String | BindShipToSite |
BindTransactionDate | Date | BindTransactionDate |
BindTransactionNumber | String | BindTransactionNumber |
BindTransactionSource | String | BindTransactionSource |
BindTransactionType | String | BindTransactionType |
CustomerTransactionId | Long | CustomerTransactionId |
Finder | String | finder |