Entering the 'Find Transfers' Formula Directly
The inserted Excel formula for the 'Find Transfers' command is shown below.
= SFGetTrans (System, Database, Model, ModelAnalysis, StartingCase, EndingCase, TransferType, TransportMode, Source, Destination, Material, Transfer Template, Outcode, TimeContext)
The following table lists the formula arguments.
Get Transfer Values Formula Arguments
| Argument | Description |
|---|---|
| System (string) | Sigmafine Server name. |
| Database (string) | Database name. |
| Model (string) | Model name. |
| Model Analysis (string) | Model analysis name. |
| StartingCase (string) | Date/time of the starting case |
| EndingCase (string) | Date/time of the ending case. |
| TransferType (string) | Transaction type (receipt, shipment, or movement) or a cell reference to a transaction type. |
| Transfer Mode (String) | Mode of transportation (e.g., barge) or cell reference to a transport name. |
| Source (string)1 | Source Element name or cell reference to a source Element name. |
| Destination (string)1 | Destination Element name or cell reference to a destination Element name. |
| Material (string) | Material name or a cell reference to a material name. |
| Attribute (string) | Attribute name of the specified element. |
| UOM (string) | This is a specified unit of measure that the value will have. The UOM must be one of the units listed in the attribute's unit-of-measure class. |
| Transfer Template (string) | This is the name of the transfer template. |
| Outcode (number) | For Outcode values, see "Output Code (Outcode) Table". |
| TimeContext (string) | The time context for the retrieval of the value. Valid values are By Case, By Time, and By Time Range. |
| 1Wildcard searches are supported. For more information, see Using Wildcards to Search for Source and Destination. |