POST api/ordOrderFreight
Insert a new record into the OrdersFreight table.
Request Information
URI Parameters
None.
Body Parameters
ordOrderFreightDb| Name | Description | Type | Additional information |
|---|---|---|---|
| OrderID | integer |
Required |
|
| QuoteID | integer |
None. |
|
| WONumber | integer |
None. |
|
| BillToAddressID | integer |
None. |
|
| ForwarderUserID | integer |
None. |
|
| SupporterUserID | integer |
None. |
|
| TrackerUserID | integer |
None. |
|
| BillingUserID | integer |
None. |
|
| OriginCity | string |
Max length: 100 |
|
| OriginStateProvinceCode | string |
Max length: 2 |
|
| OriginPostalCode | string |
Max length: 10 |
|
| OriginCountryCode | string |
Max length: 3 |
|
| DestinationCity | string |
Max length: 100 |
|
| DestinationStateProvinceCode | string |
Max length: 2 |
|
| DestinationPostalCode | string |
Max length: 10 |
|
| DestinationCountryCode | string |
Max length: 3 |
|
| InboundCarrierEntityID | integer |
None. |
|
| OutboundCarrierEntityID | integer |
None. |
|
| AirportCode | string |
Max length: 3 |
|
| PODName | string |
Max length: 100 |
|
| SupportBilling | boolean |
None. |
|
| PaymentTermsID | byte |
None. |
|
| PaymentTypeID | byte |
None. |
|
| WaybillNumber | string |
Max length: 100 |
|
| PARSNumber | string |
Max length: 100 |
|
| PONumber | string |
Max length: 60 |
|
| QuoteStatusStep | integer |
None. |
|
| ForwardingStatusStep | integer |
None. |
|
| BilledStatusStep | integer |
None. |
|
| InvoiceStatusStep | integer |
None. |
|
| QuotedDate | date |
None. |
|
| SetupDate | date |
None. |
|
| ReleasedDate | date |
None. |
|
| ArchivedDate | date |
None. |
|
| CompletedDate | date |
None. |
|
| SubmittedDate | date |
None. |
|
| ApprovedDate | date |
None. |
|
| ShipmentTypeID | byte |
None. |
|
| DescriptionOfShipment | string |
Max length: 2048 |
|
| Priority | string |
Max length: 100 |
|
| InternationalTypeID | byte |
None. |
|
| BillOfLading | string |
Max length: 100 |
|
| DimFactor | integer |
None. |
|
| SetupComplete | boolean |
None. |
|
| CreatedBy | integer |
None. |
|
| CreatedDate | date |
None. |
|
| UpdatedBy | integer |
None. |
|
| UpdatedDate | date |
None. |
|
| OriginCSC | string |
None. |
|
| DestinationCSC | string |
None. |
|
| results | Collection of ValidationResult |
None. |
Request Formats
application/json, text/json
Sample:
{
"results": null,
"OrderID": 1,
"QuoteID": 1,
"WONumber": 1,
"BillToAddressID": 1,
"ForwarderUserID": 1,
"SupporterUserID": 1,
"TrackerUserID": 1,
"BillingUserID": 1,
"OriginCity": "sample string 2",
"OriginStateProvinceCode": "sample string 3",
"OriginPostalCode": "sample string 4",
"OriginCountryCode": "sample string 5",
"DestinationCity": "sample string 6",
"DestinationStateProvinceCode": "sample string 7",
"DestinationPostalCode": "sample string 8",
"DestinationCountryCode": "sample string 9",
"InboundCarrierEntityID": 1,
"OutboundCarrierEntityID": 1,
"AirportCode": "sample string 10",
"PODName": "sample string 11",
"SupportBilling": true,
"PaymentTermsID": 64,
"PaymentTypeID": 64,
"WaybillNumber": "sample string 13",
"PARSNumber": "sample string 14",
"PONumber": "sample string 15",
"QuoteStatusStep": 1,
"ForwardingStatusStep": 1,
"BilledStatusStep": 1,
"InvoiceStatusStep": 1,
"QuotedDate": "2025-12-06T23:42:52.8190962+00:00",
"SetupDate": "2025-12-06T23:42:52.8190962+00:00",
"ReleasedDate": "2025-12-06T23:42:52.8190962+00:00",
"ArchivedDate": "2025-12-06T23:42:52.8190962+00:00",
"CompletedDate": "2025-12-06T23:42:52.8190962+00:00",
"SubmittedDate": "2025-12-06T23:42:52.8190962+00:00",
"ApprovedDate": "2025-12-06T23:42:52.8190962+00:00",
"ShipmentTypeID": 64,
"DescriptionOfShipment": "sample string 16",
"Priority": "sample string 17",
"InternationalTypeID": 64,
"BillOfLading": "sample string 18",
"DimFactor": 19,
"SetupComplete": true,
"CreatedBy": 21,
"CreatedDate": "2025-12-06T23:42:52.8190962+00:00",
"UpdatedBy": 23,
"UpdatedDate": "2025-12-06T23:42:52.8190962+00:00",
"OriginCSC": "sample string 25",
"DestinationCSC": "sample string 26"
}
application/xml, text/xml
Sample:
<ordOrderFreightDb xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Tables">
<results xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility" />
<AirportCode>sample string 10</AirportCode>
<ApprovedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</ApprovedDate>
<ArchivedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</ArchivedDate>
<BillOfLading>sample string 18</BillOfLading>
<BillToAddressID>1</BillToAddressID>
<BilledStatusStep>1</BilledStatusStep>
<BillingUserID>1</BillingUserID>
<CompletedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</CompletedDate>
<CreatedBy>21</CreatedBy>
<CreatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</CreatedDate>
<DescriptionOfShipment>sample string 16</DescriptionOfShipment>
<DestinationCSC>sample string 26</DestinationCSC>
<DestinationCity>sample string 6</DestinationCity>
<DestinationCountryCode>sample string 9</DestinationCountryCode>
<DestinationPostalCode>sample string 8</DestinationPostalCode>
<DestinationStateProvinceCode>sample string 7</DestinationStateProvinceCode>
<DimFactor>19</DimFactor>
<ForwarderUserID>1</ForwarderUserID>
<ForwardingStatusStep>1</ForwardingStatusStep>
<InboundCarrierEntityID>1</InboundCarrierEntityID>
<InternationalTypeID>64</InternationalTypeID>
<InvoiceStatusStep>1</InvoiceStatusStep>
<OrderID>1</OrderID>
<OriginCSC>sample string 25</OriginCSC>
<OriginCity>sample string 2</OriginCity>
<OriginCountryCode>sample string 5</OriginCountryCode>
<OriginPostalCode>sample string 4</OriginPostalCode>
<OriginStateProvinceCode>sample string 3</OriginStateProvinceCode>
<OutboundCarrierEntityID>1</OutboundCarrierEntityID>
<PARSNumber>sample string 14</PARSNumber>
<PODName>sample string 11</PODName>
<PONumber>sample string 15</PONumber>
<PaymentTermsID>64</PaymentTermsID>
<PaymentTypeID>64</PaymentTypeID>
<Priority>sample string 17</Priority>
<QuoteID>1</QuoteID>
<QuoteStatusStep>1</QuoteStatusStep>
<QuotedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</QuotedDate>
<ReleasedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</ReleasedDate>
<SetupComplete>true</SetupComplete>
<SetupDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</SetupDate>
<ShipmentTypeID>64</ShipmentTypeID>
<SubmittedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</SubmittedDate>
<SupportBilling>true</SupportBilling>
<SupporterUserID>1</SupporterUserID>
<TrackerUserID>1</TrackerUserID>
<UpdatedBy>23</UpdatedBy>
<UpdatedDate xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
<d2p1:DateTime>2025-12-06T23:42:52.8190962Z</d2p1:DateTime>
<d2p1:OffsetMinutes>0</d2p1:OffsetMinutes>
</UpdatedDate>
<WONumber>1</WONumber>
<WaybillNumber>sample string 13</WaybillNumber>
</ordOrderFreightDb>
application/x-www-form-urlencoded
Sample:
Response Information
Resource Description
UpsertRetOfordOrderFreightDb| Name | Description | Type | Additional information |
|---|---|---|---|
| returnID | integer |
None. |
|
| results | Collection of ValidationResult |
None. |
|
| returnItem | ordOrderFreightDb |
None. |
|
| displayMessage | string |
None. |
Response Formats
application/json, text/json
Sample:
{
"returnID": 1,
"results": null,
"returnItem": {
"results": null,
"OrderID": 1,
"QuoteID": 1,
"WONumber": 1,
"BillToAddressID": 1,
"ForwarderUserID": 1,
"SupporterUserID": 1,
"TrackerUserID": 1,
"BillingUserID": 1,
"OriginCity": "sample string 2",
"OriginStateProvinceCode": "sample string 3",
"OriginPostalCode": "sample string 4",
"OriginCountryCode": "sample string 5",
"DestinationCity": "sample string 6",
"DestinationStateProvinceCode": "sample string 7",
"DestinationPostalCode": "sample string 8",
"DestinationCountryCode": "sample string 9",
"InboundCarrierEntityID": 1,
"OutboundCarrierEntityID": 1,
"AirportCode": "sample string 10",
"PODName": "sample string 11",
"SupportBilling": true,
"PaymentTermsID": 64,
"PaymentTypeID": 64,
"WaybillNumber": "sample string 13",
"PARSNumber": "sample string 14",
"PONumber": "sample string 15",
"QuoteStatusStep": 1,
"ForwardingStatusStep": 1,
"BilledStatusStep": 1,
"InvoiceStatusStep": 1,
"QuotedDate": "2025-12-06T23:42:52.8190962+00:00",
"SetupDate": "2025-12-06T23:42:52.8190962+00:00",
"ReleasedDate": "2025-12-06T23:42:52.8190962+00:00",
"ArchivedDate": "2025-12-06T23:42:52.8190962+00:00",
"CompletedDate": "2025-12-06T23:42:52.8190962+00:00",
"SubmittedDate": "2025-12-06T23:42:52.8190962+00:00",
"ApprovedDate": "2025-12-06T23:42:52.8190962+00:00",
"ShipmentTypeID": 64,
"DescriptionOfShipment": "sample string 16",
"Priority": "sample string 17",
"InternationalTypeID": 64,
"BillOfLading": "sample string 18",
"DimFactor": 19,
"SetupComplete": true,
"CreatedBy": 21,
"CreatedDate": "2025-12-06T23:42:52.8190962+00:00",
"UpdatedBy": 23,
"UpdatedDate": "2025-12-06T23:42:52.8190962+00:00",
"OriginCSC": "sample string 25",
"DestinationCSC": "sample string 26"
},
"displayMessage": "sample string 1"
}
application/xml, text/xml
Sample:
<UpsertRetOfordOrderFreightDb66KPc_SrH xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebAPI.Data.Utility">
<displayMessage>sample string 1</displayMessage>
<results xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" />
<returnID>1</returnID>
<returnItem xmlns:d2p1="http://schemas.datacontract.org/2004/07/WebAPI.Data.Tables">
<results xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.ComponentModel.DataAnnotations" i:nil="true" />
<d2p1:AirportCode>sample string 10</d2p1:AirportCode>
<d2p1:ApprovedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:ApprovedDate>
<d2p1:ArchivedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:ArchivedDate>
<d2p1:BillOfLading>sample string 18</d2p1:BillOfLading>
<d2p1:BillToAddressID>1</d2p1:BillToAddressID>
<d2p1:BilledStatusStep>1</d2p1:BilledStatusStep>
<d2p1:BillingUserID>1</d2p1:BillingUserID>
<d2p1:CompletedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:CompletedDate>
<d2p1:CreatedBy>21</d2p1:CreatedBy>
<d2p1:CreatedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:CreatedDate>
<d2p1:DescriptionOfShipment>sample string 16</d2p1:DescriptionOfShipment>
<d2p1:DestinationCSC>sample string 26</d2p1:DestinationCSC>
<d2p1:DestinationCity>sample string 6</d2p1:DestinationCity>
<d2p1:DestinationCountryCode>sample string 9</d2p1:DestinationCountryCode>
<d2p1:DestinationPostalCode>sample string 8</d2p1:DestinationPostalCode>
<d2p1:DestinationStateProvinceCode>sample string 7</d2p1:DestinationStateProvinceCode>
<d2p1:DimFactor>19</d2p1:DimFactor>
<d2p1:ForwarderUserID>1</d2p1:ForwarderUserID>
<d2p1:ForwardingStatusStep>1</d2p1:ForwardingStatusStep>
<d2p1:InboundCarrierEntityID>1</d2p1:InboundCarrierEntityID>
<d2p1:InternationalTypeID>64</d2p1:InternationalTypeID>
<d2p1:InvoiceStatusStep>1</d2p1:InvoiceStatusStep>
<d2p1:OrderID>1</d2p1:OrderID>
<d2p1:OriginCSC>sample string 25</d2p1:OriginCSC>
<d2p1:OriginCity>sample string 2</d2p1:OriginCity>
<d2p1:OriginCountryCode>sample string 5</d2p1:OriginCountryCode>
<d2p1:OriginPostalCode>sample string 4</d2p1:OriginPostalCode>
<d2p1:OriginStateProvinceCode>sample string 3</d2p1:OriginStateProvinceCode>
<d2p1:OutboundCarrierEntityID>1</d2p1:OutboundCarrierEntityID>
<d2p1:PARSNumber>sample string 14</d2p1:PARSNumber>
<d2p1:PODName>sample string 11</d2p1:PODName>
<d2p1:PONumber>sample string 15</d2p1:PONumber>
<d2p1:PaymentTermsID>64</d2p1:PaymentTermsID>
<d2p1:PaymentTypeID>64</d2p1:PaymentTypeID>
<d2p1:Priority>sample string 17</d2p1:Priority>
<d2p1:QuoteID>1</d2p1:QuoteID>
<d2p1:QuoteStatusStep>1</d2p1:QuoteStatusStep>
<d2p1:QuotedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:QuotedDate>
<d2p1:ReleasedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:ReleasedDate>
<d2p1:SetupComplete>true</d2p1:SetupComplete>
<d2p1:SetupDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:SetupDate>
<d2p1:ShipmentTypeID>64</d2p1:ShipmentTypeID>
<d2p1:SubmittedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:SubmittedDate>
<d2p1:SupportBilling>true</d2p1:SupportBilling>
<d2p1:SupporterUserID>1</d2p1:SupporterUserID>
<d2p1:TrackerUserID>1</d2p1:TrackerUserID>
<d2p1:UpdatedBy>23</d2p1:UpdatedBy>
<d2p1:UpdatedDate xmlns:d3p1="http://schemas.datacontract.org/2004/07/System">
<d3p1:DateTime>2025-12-06T23:42:52.8190962Z</d3p1:DateTime>
<d3p1:OffsetMinutes>0</d3p1:OffsetMinutes>
</d2p1:UpdatedDate>
<d2p1:WONumber>1</d2p1:WONumber>
<d2p1:WaybillNumber>sample string 13</d2p1:WaybillNumber>
</returnItem>
</UpsertRetOfordOrderFreightDb66KPc_SrH>