ReceivingReceiptTransactionRequests
ReceivingReceiptTransactionRequests
Columns
| Name | Type | Description |
| InterfaceTransactionId [KEY] | Long | Value that uniquely identifies the interfaced receipt transaction line request. |
| HeaderInterfaceId | Long | Value that uniquely identifies the header interfaced receipt transaction line request. |
| CreatedBy | String | CreatedBy of ReceivingReceiptTransactionRequests |
| CreationDate | Datetime | CreationDate of ReceivingReceiptTransactionRequests |
| LastUpdateDate | Datetime | LastUpdateDate of ReceivingReceiptTransactionRequests |
| LastUpdatedBy | String | LastUpdatedBy of ReceivingReceiptTransactionRequests |
| TransactionType | String | Type of transaction for the receipt transaction line request. Valid values include ACCEPT, REJECT, TRANSFER, DELIVER, CORRECT, RETURN TO VENDOR, RETURN TO RECEIVING, RETURN TO CUSTOMER, and RETURN TO ORGANIZATION. |
| AutoTransactCode | String | This attribute is not applicable and should be left blank. |
| TransactionDate | Datetime | Date when the transaction for the current line is created. This attribute is used for receipt accounting, invoicing, and other related processes. The default value is the current date and time. If the time zone is not provided, the value stored is the time zone of the database. This value cannot be a future date. |
| OrganizationCode | String | Abbreviation that identifies the receiving organization. This attribute is used to derive OrganizationId. For every receipt transaction request, you must provide one of the following attributes: OrganizationCode or OrganizationId, otherwise the request will fail. |
| OrganizationId | Long | Value that uniquely identifies the receiving organization. For every receipt transaction request, you must provide one of the following attributes: OrganizationCode or OrganizationId, otherwise the request will fail. |
| ItemDescription | String | Description of the item corresponding to the receipt transaction request. When you create a receipt transaction for a purchase order, it should match the item description of the corresponding purchase order line. For receipt transactions against In-transit shipment, transfer order, and return material authorization (RMA), this attribute should match the description of the inventory item. When creating a receipt transaction, one of the following must be provided: ItemId, ItemNumber, or ItemDescription. If left blank, the value from the source document is used. |
| ItemId | Long | Value that uniquely identifies the inventory item. If left blank, the value from the source document is used. When creating a receipt transaction, one of the following must be provided: ItemId, ItemNumber, or ItemDescription. |
| ItemNumber | String | Number that identifies the item. This attribute is used to derive ItemId. If blank, the value from the source document is used. When creating a receipt transaction, one of the following must be provided: ItemId, ItemNumber, or ItemDescription. |
| ItemRevision | String | Revision number of the item. This attribute is mandatory when delivering receipt lines whose item is revision controlled. |
| ReceiptSourceCode | String | Value that identifies the source of the advanced shipment notice (ASN) or the receipt. Valid values include VENDOR when creating an ASN, receiving a purchase order, or receiving an ASN, INVENTORY when receiving an in-transit shipment, TRANSFER ORDER when receiving a transfer order, CUSTOMER when receiving a return material authorization (RMA). This attribute is mandatory. |
| SourceDocumentCode | String | Abbreviation that identifies the type of source document. Valid values include PO to create an advanced shipment notice (ASN), receive a purchase order, or an ASN, INVENTORY to receive an in-transit shipment, TRANSFER ORDER to receive a transfer order, RMA to receive a transfer order. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. This attribute is mandatory. |
| DocumentNumber | String | Number that identifies the document for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order or an ASN), this attribute is the purchase order number. When the source document code is INVENTORY, this attribute is the in-transit shipment number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment number. When the source document code is RMA, this attribute is the return material authorization (RMA) number. This attribute is mandatory. |
| DocumentLineNumber | Long | Number that identifies the document line number for the receipt line request or advanced shipment notice (ASN) line request. When the source document code is PO (create an ASN, receive a purchase order, or receive an ASN), this attribute is the purchase order line number. When the source document code is INVENTORY, this attribute is the in-transit shipment line number. When the source document code is TRANSFER ORDER, this attribute is the transfer order shipment line number. When the source document code is RMA, this attribute is the return material authorization (RMA) line number. This attribute is mandatory. |
| DocumentShipmentLineNumber | Long | Number that identifies the document schedule for the receiving transaction. When the source document code is PO (create an advanced shipment notice (ASN), receive a purchase order, or receive an ASN), this attribute is the purchase order schedule number. When receiving a purchase order or creating an ASN line, this attribute is mandatory. |
| DocumentDistributionNumber | Long | Number that identifies the document distribution for the receiving transaction. When receiving a purchase order that has multiple distributions, this attribute is the respective purchase order distribution number. When receiving a purchase order with multiple distributions, this attribute is mandatory. |
| PODistributionId | Long | Value that uniquely identifies the purchase order distribution. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| POHeaderId | Long | Value that uniquely identifies the purchase order header. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| POLineId | Long | Value that uniquely identifies the purchase order line. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| POLineLocationId | Long | Value that uniquely identifies the purchase order schedule. This attribute is applicable when creating an advanced shipment notice (ASN), receiving a purchase order or an ASN. |
| ShipmentHeaderId | Long | Value that uniquely identifies the receiving shipment or receipt header. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order. |
| ShipmentLineId | Long | Value that uniquely identifies the shipment line. This attribute is applicable when receiving an advanced shipment notice (ASN), a in-transit shipment, or a transfer order. |
| ShipmentNumber | String | Number that identifies the shipment that the shipment source assigns. This number corresponds to the number that identifies one of the following objects: advance shipment notice, in-transit shipment, or transfer-order shipment. |
| ASNLineNumber | Long | Number that identifies the line on the advance shipment notice. Either this attribute or ShipmentLineId must be provided when receiving an advanced shipment notice (ASN). |
| TransferOrderHeaderId | Long | Value that uniquely identifies the transfer order header. This attribute is applicable when receiving a transfer order. |
| TransferOrderLineId | Long | Value that uniquely identifies the transfer order line. This attribute is applicable receiving a transfer order. |
| TransferOrderDistributionId | Long | Value that uniquely identifies the transfer order distribution. This attribute is applicable when receiving a transfer order with multiple distributions and direct routing. |
| SoldtoLegalEntity | String | Name of the sold-to legal entity. Populate this attribute with the sold-to legal entity associated to the purchase order. This is used to derive SoldtoLegalEntityId. |
| SoldtoLegalEntityId | Long | Value that uniquely identifies the sold-to legal entity. The combination of DocumentNumber and SoldtoLegalEntityId is needed to derive POHeaderId, which identifies the purchase order header for a purchase order-based transaction. |
| DestinationTypeCode | String | Abbreviation that identifies the destination type for the receiving transaction. This attribute should be left blank. It will be derived from the source document. |
| Subinventory | String | Name of the destination subinventory for the receiving transaction. This attribute is mandatory when: the transaction type is DELIVER, destination type of the document schedule or document line is Inventory, subinventory is not specified on the document distribution or line (if provided in the document line, the default value is used), or no item transaction default exists (if item transaction default exists, it will be derived). |
| Locator | String | Name of the destination locator for the receiving transaction. This is used to derive LocatorId. This attribute or LocatorId is mandatory when: the transaction type is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived). |
| LocatorId | Long | Value that uniquely identifies the destination locator for the receiving transaction. This attribute or Locator is mandatory when: the transaction type is DELIVER, destination type of the document schedule or document line is Inventory, locator control is predefined or dynamic and item transaction defaults or not entered (if item transaction default exists, it will be derived). |
| Quantity | Double | Transaction quantity in the unit of measure that the receipt transaction request uses. |
| UnitOfMeasure | String | Unit of measure for the receipt transaction request. This attribute is used to derive UOMCode. |
| UOMCode | String | Abbreviation that identifies the unit of measure that the receipt transaction uses. |
| PrimaryQuantity | Double | Transaction quantity in the primary unit of measure that the item uses. |
| PrimaryUOMCode | String | Abbreviation that identifies the primary unit of measure that the item in the receiving organization uses. |
| PrimaryUnitOfMeasure | String | Primary unit of measure that the item in the receiving organization uses. This attribute is used to derive PrimaryUOMCode. |
| ProcessingStatusCode | String | Value that indicates the processing status for the line request. Valid values include PENDING, RUNNING, COMPLETED. The default value is PENDING. Only the interface records with value PENDING will be picked for processing. If there is an error in the derive, default, and validate cycle, the status moves to ERROR. This attribute should be left blank during POST operation so that the default value of PENDING is picked. |
| SecondaryUOMCode | String | Abbreviation that identifies the secondary unit of measure that the item in the receiving organization uses. |
| SecondaryUnitOfMeasure | String | Secondary unit of measure that the item in the receiving organization uses. |
| SecondaryQuantity | Double | Transaction quantity in the secondary unit of measure that the item uses. |
| EmployeeId | Long | Value that uniquely identifies the employee who performed the receiving transaction. If this attribute is blank, the value from the parent transaction is used. |
| EmployeeName | String | Name of the employee who performed the receiving transaction. This attribute is used to derive EmployeeId. If this attribute is blank, the value from the parent transaction is used. |
| ParentTransactionId | Long | Value that uniquely identifies the parent receiving transaction. This attribute is mandatory. Without this attribute, inspections, put away, corrections, and returns will not be processed. |
| SourceTransactionNumber | String | Number that identifies the unique transaction identifier in the source application. There can be only one record in receiving transactions for a source transaction number. |
| ParentSourceTransactionNumber | String | Number that identifies the source transaction number of the parent receiving transaction. |
| InterfaceSourceCode | String | Abbreviation that identifies the source that interfaced the receiving transaction. It can be populated with the source application name. |
| InterfaceSourceLineId | Long | Value that uniquely identifies the interfaced source line. This can be populated with the identifier of the line in the source application that initiated the receipt. |
| ShipToLocationCode | String | Abbreviation that identifies the receiving location. This is used to derive ShipTolocationId. This attribute is applicable only when transaction type is ACCEPT, REJECT, and TRANSFER. If this attribute is blank, the value from the parent transaction is used. |
| ShipToLocationId | Long | Value that uniquely identifies the receiving location. If this attribute is blank during a POST operation, the value is derived from ShipToLocationId of the source document. This attribute is applicable only when transaction type is ACCEPT, REJECT, and TRANSFER. If this attribute is blank, the value from the parent transaction is used. |
| DeliverToLocationCode | String | Abbreviation that identifies the deliver-to location. This attribute is used to derive DeliverTolocationId. If this attribute is blank, the default value from the purchase order distribution or transfer order distribution is used. |
| DeliverToLocationId | Long | Value that uniquely identifies the deliver-to location. If this attribute is blank, the default value from the purchase order distribution or transfer order distribution is used. DeliverToLocationId is mandatory when transaction type is DELIVER and source document code is PO or TRANSFER ORDER and the destination type code of the distribution is EXPENSE. |
| DeliverToPersonId | Long | Value that uniquely identifies the deliver-to person or requester. If this attribute is blank, the default value of the requester specified on the purchase order distribution or transfer order distribution is used. |
| DeliverToPersonName | String | Name of the deliver-to person or requester. This attribute is used to derive DeliverToPersonId. |
| RoutingCode | String | Value that indicates the receiving routing. This attribute need not be populated for this resource. It is derived from the parent transaction. |
| RoutingHeaderId | Long | Value that uniquely identifies the receiving routing. This attribute need not be populated for this resource. It is derived from the parent transaction. |
| InspectionQualityCode | String | Abbreviation that identifies the inspection quality. This attribute is applicable only when the transaction type is ACCEPT or REJECT. A list of accepted values is defined in the lookup type RCV_QUALITY_CODE. |
| Exception | String | Value that indicates whether or not the receive transaction being created has an exception. If you want to flag the receiving transaction as an exception, populate this attribute with Y. Else, leave it blank. |
| RMAReference | String | Number that identifies the return material authorization that the supplier provides when returning goods to the supplier. This attribute is applicable only when the transaction type is RETURN TO VENDOR. |
| RMANumber | String | Number of the return material authorization (RMA) against which receipt is being done. This attribute along with RMASourceSystemName of the header is used to derive ReceiptAdviceHeaderId. This attribute is applicable when creating receipt transactions for RMA. |
| RMALineNumber | String | Line number of the return material authorization (RMA) against which receipt is being created. This attribute is used to derive ReceiptAdviceLineId. This attribute is mandatory when creating receipt for RMA. |
| RMAScheduleNumber | String | Schedule number of the return material authorization against which receipt is being done. |
| ReceiptAdviceHeaderId | Long | Value that uniquely identifies the receipt advice header. |
| ReceiptAdviceLineId | Long | Value that uniquely identifies the receipt advice line. |
| CustomerId | Long | Value that uniquely identifies the customer. This attribute can be blank and the value is derived from the parent transaction. |
| CustomerPartyName | String | Name of the customer. This attribute can be blank and the value is derived from the parent transaction. |
| CustomerPartyNumber | String | Number that uniquely identifies the customer. This attribute can be blank and the value is derived from the parent transaction. |
| CustomerItemNumber | String | Number that the customer uses to identify the item. This attribute can be blank and the value is derived from the parent transaction. |
| CustomerItemId | Long | Value that the customer uses to uniquely identify the item. This attribute can be blank and the value is derived from the parent transaction. |
| Amount | Double | Receipt amount in the purchase order currency. This attribute is mandatory when creating receipt for a fixed price service purchase order line. |
| CountryOfOriginCode | String | Abbreviation that identifies the country of manufacture for this item. This attribute can be blank for this resource. |
| CurrencyCode | String | Receipt amount in the purchase order currency. This attribute is mandatory when creating receipt for a fixed price service purchase order line. |
| CurrencyConversionDate | Date | Date when the currency conversion occurred for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt and the order currency is different from the ledger currency of the receiving organization. |
| CurrencyConversionRate | Double | Currency conversion rate for the receipt. Use this attribute only for a purchase order receipt where the option on the purchase order schedule is Receipt, the order currency is different from the ledger currency of the receiving organization, and the rate type on the purchase order is User. |
| FromOrganizationCode | String | Abbreviation that identifies the source organization for an interorganization transfer. This is applicable for receipts against in-transit shipment or transfer order shipment. |
| FromOrganizationId | Long | Value that uniquely identifies the source organization for an in-transit shipment. |
| ContainerNumber | String | Container number. This attribute is not currently used. |
| SubstituteItemNumber | String | Substitute item number for the item on the receipt line. This attribute is not currently used. |
| SubstituteItemId | Long | Value that uniquely identifies the substitute item. This attribute is not currently used. |
| SubstituteUnorderedCode | String | Value that indicates whether the transaction is for a substitute item. This attribute is not currently used. |
| VendorName | String | Name of the supplier. This attribute can be blank for this resource and is derived from the parent transaction. |
| VendorId | Long | Value that uniquely identifies the supplier. This attribute can be blank for this resource and is derived from the parent transaction. |
| VendorNumber | String | Number that identifies the supplier. This attribute can be blank for this resource and is derived from the parent transaction. |
| VendorSiteCode | String | Abbreviation that identifies the supplier site for a business unit. This attribute can be blank for this resource and is derived from the parent transaction. |
| VendorSiteId | Long | Value that uniquely identifies the supplier site. This attribute can be blank for this resource and is derived from the parent transaction. |
| VendorItemNumber | String | Number that the supplier uses to identify the item. This attribute can be blank for this resource and is derived from the parent transaction. |
| BusinessUnit | String | Name of the business unit. This attribute can be blank for this resource and is derived from the parent transaction. |
| BusinessUnitId | Long | Value that uniquely identifies the business unit. This attribute can be blank for this resource and is derived from the parent transaction. |
| ConsignedLine | String | Value that indicates whether or not the receiving transaction is for consigned material. If this attribute is blank, the value is derived from the parent transaction. Enter N if returning an owned (once consigned) material. Else, leave this attribute blank. |
| ReasonId | Long | Value that uniquely identifies the inventory transaction reason for the receiving transaction. |
| ReasonName | String | Name of the inventory transaction reason for the receiving transaction. This attribute is used to derive ReasonId. |
| PackingSlip | String | Packing slip number for the container that contains this item. This attribute can be blank for this resource. |
| Comments | String | Text that the used entered when receiving the item. |
| FromSubinventory | String | Name of the source subinventory for the receiving transaction. This attribute is applicable for negative corrections or returns and the value is derived from the parent DELIVER transaction. Enter this value if you want to return from a different location than where the material was put away. |
| FromLocator | String | Name of the source locator for the receiving transaction. This attribute is used to derive FromLocatorId. This attribute is applicable for negative corrections or returns and the value is derived from the parent DELIVER transaction. Enter this value if you want to return from a different location than where the material was put away. |
| FromLocatorId | Long | Value that uniquely identifies the source locator for the receiving transaction. This attribute is applicable for negative corrections or returns and the value is derived from the parent DELIVER transaction. Enter this value if you want to return from a different location than where the material was put away. |
| TransactionStatusCode | String | Value that indicates the status of the advanced shipment notice (ASN) line request or receipt transaction request. Valid values include PENDING, RUNNING or ERROR. The default value is PENDING. Only the interface records with value PENDING are picked for processing. If there is an error in running the transaction, the status changes to ERROR. This attribute should be blank during POST operations so that the default value of PENDING is used. |
| GroupId | Long | Value that uniquely identifies the group of interface records submitted together for processing. |
| ExternalSystemPackingUnit | String | License plate number of the external warehouse management application. |
| DefaultTaxationCountry | String | Value that indicates the default taxation country. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| DocumentFiscalClassification | String | Fiscal classification for the document. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| FirstPartyRegistrationId | Long | Value that uniquely identifies the first party registration. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| ThirdPartyRegistrationId | Long | Value that uniquely identifies the third party registration. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| TransactionBusinessCategory | String | Business category of the transaction. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| TaxInvoiceNumber | String | Number of the tax invoice. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| TaxInvoiceDate | Date | Date when the tax invoice is created. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| EwayBillNumber | Long | Number that identifies the electronic waybill provided by supplier for shipment of goods. This attribute is not applicable and should be left blank. |
| EwayBillDate | Date | Date when the electronic waybill was generated. This attribute is not applicable and should be left blank. |
| UserDefinedFiscalClassification | String | Value that indicates the fiscal classification defined by the user. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| ProductFiscalClassificationId | Long | Value that uniquely identifies the product fiscal classification. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| TaxClassificationCode | String | Value that indicates the tax classification. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| IntendedUseClassificationId | Long | Value that uniquely identifies the intended use classification. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| IntendedUse | String | Value that indicates the intended use. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| ProductCategory | String | Value that indicates the product category. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| AssessableValue | Double | Assessable value of the transaction for taxation purposes. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| FinalDischargeLocationId | Long | Value that uniquely identifies the final discharge location. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| ProductType | String | Value that indicates the product type for taxation purposes. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| FirstPartyRegistrationNumber | String | Number that is used for the first party registration. This attribute is used to derive FirstPartyRegistrationId. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| ThirdPartyRegistrationNumber | String | Number that is used for the third party registration. This attribute is used to derive ThirdPartyRegistrationId. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| ProductFiscalClassName | String | Name used to indicate the product fiscal classification. This attribute is used to derive ProductFiscalClassificationId. This attribute is applicable only for return transactions. Even for returns, if blank, the default value from the parent transaction is used. |
| FinalDischargeLocationCode | String | Value that indicates the final discharge location. This attribute is used to derive FinalDischargeLocationId. Applicable only for return transactions. Even for returns, if left blank, defaulted from the parent transaction. |
| BarcodeLabel | String | Label of the barcode on the product. This attribute is not currently used. |
| TruckNumber | String | Number of the truck. This attribute is not currently used. |
| InsertAndProcessFlag | Bool | Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API processes the posted interface data automatically and immediately returns the response. If false, then the records are created in interface tables but no processing is done. These interface records can subsequently processed by the Manage Receiving Transactions scheduled process. The default value is true. |
| ReturnStatus | String | Value that indicates the status of the application call that is sent to the client. Values include SUCCESS or ERROR. |
| LPNId | Long | Value that uniquely identifies the source license plate number. This attribute can be blank for this resource. |
| LicensePlateNumber | String | Source license plate number. This attribute can be blank for this resource. |
| SaveAndSubmitFlag | Bool | Contains one of the following values: true or false. If true, then the Manage Receiving Transactions API resubmits the patched interface data automatically and immediately returns the response. If false, then the records are updated in interface tables but not resubmitted. The default value is false. |
| CreateDebitMemoFlag | Bool | Contains one of the following values: true or false. If true, then the supplier site of the purchase order is setup to create a debit memo and the receipt (for which return is performed) has a corresponding evaluated receipt settlement (ERS) invoice. If false, then the supplier site of the purchase order is not setup for creating debit memo. The default value is false. This attribute determines whether to create the debit memo. This attribute is applicable only when transaction type is RETURN TO VENDOR. |
| PhysicalMaterialReturnRequiredFlag | Bool | Contains one of the following values: true or false. If true, then a new return transfer order is created that needs to be shipped to the source organization. If false, then the material is issued to scrap. The default value is false. This attribute determines whether the return against a transfer order requires a physical return of the item. This attribute is applicable only when the transaction type is RETURN TO ORGANIZATION. |
| RecallHeaderId | Long | Value that uniquely identifies the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| RecallLineId | Long | Value that uniquely identifies the line corresponding to the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| RecallLineNumber | Long | Number that identifies the recall notice line. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| RecallNoticeNumber | String | Number that identifies the recall notice. This attribute should only be used for the RETURN TO VENDOR transaction type. |
| ExternalSystemTransactionReference | String | Value that contains reference information for the corresponding transaction in external applications. |
| DefaultLotsAndSerialNumbersFromASNFlag | Bool | Contains one of the following values: true or false. If true, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will be are defaulted when executing a receipt or a put away transaction. If false, then the lots and serial numbers from an advance shipment notice (ASN) or an advance shipment billing notice (ASBN) will not be defaulted when executing a receipt or a put away transaction. The default value is false. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| FromDate | Datetime | FromDate |
| ToDate | Datetime | ToDate |
| Finder | String | finder |