Name | Description | Type | Additional information |
---|---|---|---|
CustomerEquipmentId |
Sedona internal autonumber from ARCustomerEquipment |
integer |
None. |
CustomerId |
Foreign key from AR_Customer table |
integer |
Required |
CustomerNumber |
Customer_Number field from the AR_Customer table |
string |
None. |
CustomerSiteId |
Foreign key from AR_Customer_Site table |
integer |
Required |
CustomerSystemId |
Foreign key from AR_Customer_System table |
integer |
Required |
TypeJSO |
The type: Job (J), Service (S), Other (O); defaults to "O" if not supplied |
string |
String length: inclusive between 0 and 1 |
JobId |
Value from OE_Job table; set automatically on POST based on value supplied for JobCode |
integer |
None. |
JobCode |
Value from OE_Job table; defaults to 000 on POST if not supplied |
string |
None. |
ServiceId |
set to N/A on POST |
integer |
None. |
OtherDescription |
defaults to Part Description on POST if not supplied |
string |
None. |
PartCode |
Part_Code, from IN_Part table; required for Post |
string |
Required String length: inclusive between 0 and 25 |
Quantity |
The quantity of equipment; defaults to 1 on POST if not supplied |
decimal number |
None. |
Cost |
The cost of the equipment; defaults to IN_Part.Sales_Price on POST if not supplied |
decimal number |
None. |
Date |
Date equipment added; defaults to today's date on POST if not supplied |
string |
None. |
Location |
Location of equipment installation |
string |
None. |
ManufactWarrantyExp |
Date the manufacturer's warranty expires |
string |
None. |
SerialNumber |
Serial number of the equipment |
string |
None. |
InvoiceItem |
Is this an invoice item? (Y/N); defaults to Y on POST if not supplied |
string |
String length: inclusive between 0 and 1 |
WarrantyId |
Value from SV_Warranty table; set automatically on POST based on value supplied for JobCode |
integer |
None. |
WarrantyCode |
Abbreviated Warranty from SV_Warranty table; defaults to N/A on POST if not supplied |
string |
String length: inclusive between 0 and 25 |
WarrantyStartDate |
The date the warranty starts |
string |
None. |
CoveredByContract |
set automatically on POST |
string |
None. |
RemovalTypeJSO |
set automatically on POST |
string |
None. |
RemovalOtherDescription |
Description upon removal |
string |
None. |
LocalZone |
set automatically on POST |
string |
None. |
RemovalServiceId |
set automatically on POST |
integer |
None. |
RemovalJobId |
Job ID where the equipment was removed; set automatically on POST |
integer |
None. |
RemovalDate |
Date the equipment was removed; set automatically on POST |
string |
None. |
MasterEquipmentId |
set automatically on POST |
integer |
None. |
Latitude |
set automatically on POST |
decimal number |
None. |
Longitude |
set automatically on POST |
decimal number |
None. |
LotNumber |
set automatically on POST |
string |
None. |
ManufacturerWarrantyId |
set automatically on POST |
integer |
None. |
UsePartCost |
Set to true if NOT specifying a Cost to use IN_Part.Purchase_Cost instead of Sales_Price |
boolean |
None. |