SalesOrders
Usage information for the operation SalesOrders.rsd.
Columns
| Name | Type | ReadOnly | References | Description |
| OrderHeaderId [KEY] | Long | False |
Unique identifier for the quote or Order | |
| ActiveVersionFlag | Bool | False |
active version flag | |
| CreatedBy | String | False | ||
| CreationDate | Datetime | False | ||
| CrmConversionRate | Double | False | ||
| CurrencyCode | String | False |
Currency code | |
| DeleteFlag | Bool | False |
This flag controls if the user has access to delete the record | |
| Description | String | False |
Quote Description | |
| ExpirationDate | Datetime | False |
Expiration Date of the Quote or Order | |
| ExternalQuoteNumber | String | False |
Identifier from source system that created this Quote | |
| ExternalReferenceNumber | String | False |
Identifier for the External Quote/Order | |
| ExternalSystemReferenceCode | String | False |
External reference(Third party) type for the Quote or Order. Big machines will pass BMQUOTE | |
| LastOptySyncDate | Datetime | False |
Last Opportunity Sync date for the quote to identify the Active version of the quote for the opportunity. | |
| LastUpdateDate | Datetime | False |
last update date when record was updated | |
| LastUpdateLogin | String | False | ||
| LastUpdatedBy | String | False | ||
| Name | String | False |
Store the Quote/Order Name | |
| OptyId | Long | False |
Opportunity Id for the Quote is created | |
| OptyNumber | String | False | ||
| OrderHeaderNumber | String | False | ||
| OrderTotal | Double | False |
Total Amount | |
| Owner | String | False |
Quote Owner | |
| PlacedOnDate | Datetime | False |
Date on which Order was placed | |
| ProposalExistFlag | Bool | False |
Flag to identify the associated proposal for the Quote. Valid values are Y or N | |
| ProposalUrl | String | False |
URL to fetch quote proposal document | |
| SalesAccountId | Long | False | ||
| SalesAccountUniqueName | String | False |
Name of the customer account | |
| SoldContactPartyId | Long | False |
Customer Contact Party Identifier | |
| SoldContactPartyNumber | String | False | ||
| SoldCustPartyNumber | String | False | ||
| SoldCustomerPartyId | Long | False |
Customer Party Identifier | |
| SoldPartySiteId | Long | False |
Customer Address Identifier | |
| Status | String | False |
The exact quote status sent by BM | |
| UpdateFlag | Bool | False |
This flag controls if the user has access to update the record | |
| VersionNumber | Long | False |
Version Number of the Quote/Order | |
| WinStatusCode | String | False |
Lookup code for lookup type=ORA_ZCA_WIN_STATUS |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |