inc_num Incidents
Incident Number
string unit_comp_id Incidents
Unit Component ID
string inc_date Incidents
Incident Date
datetime close_date Incidents
Close Date
datetime due_date Incidents
Due Date
datetime followup_date Incidents
Follow-up Date
datetime create_date Incidents
Create Date
datetime cust_num Incidents
Customer Number
string description Incidents
Description
string der_description Incidents
Derived Description
string stat_code Incidents
Status Code
string stat_code_desc Incidents
Status Code Description
string prior_code Incidents
Priority Code
string prior_code_desc Incidents
Priority Code Description
string ssr_name Incidents
SSR Name
string owner_name Incidents
Owner Name
string salesperson Incidents
Salesperson
string region_desc Incidents
Region Description
string work_site Incidents
Work Site
string item_desc Incidents
Item Description
string ser_num Incidents
Serial Number
string unit_desc Incidents
Unit Description
string bill_to_name Incidents
Bill To Name
string der_bill_address Incidents
Derived Bill Address
string der_ship_address Incidents
Derived Ship Address
string ref_num Incidents
Reference Number
string ref_type Incidents
Reference Type
string know_num Incidents
Knowledge Base Number
string contact Incidents empfindlich
Contact
string email Incidents empfindlich
Email
string phone Incidents empfindlich
Phone
string fax_num Incidents empfindlich
Fax Number
string pager_addr Incidents empfindlich
Pager Address
string txt_msg_addr Incidents empfindlich
Text Message Address
string der_reason_gen Incidents
General Reason
string der_reason_spec Incidents
Specific Reason
string cust_seq Incidents
Customer Sequence
integer der_priority Incidents
Derived Priority
integer der_days_old Incidents
Days Old
integer der_days_late Incidents
Days Late
integer der_days_until_late Incidents
Days Until Late
integer stat_code_closed Incidents
Status Closed
boolean der_past_due Incidents
Past Due
boolean der_closed Incidents
Closed
boolean awaiting_parts Incidents
Awaiting Parts
boolean to_schedule Incidents
To Schedule
boolean followup_complete Incidents
Follow-up Complete
boolean in_workflow Incidents
In Workflow
boolean contract Service Contracts
Contract
string start_date Service Contracts
Start Date
datetime end_date Service Contracts
End Date
datetime create_date Service Contracts
Create Date
datetime cont_stat Service Contracts
Contract Status
string cust_num Service Contracts
Customer Number
string slsman Service Contracts
Salesman
string terms_code Service Contracts
Terms Code
string tax_code_1 Service Contracts
Tax Code 1
string tax_code_2 Service Contracts
Tax Code 2
string cust_seq Service Contracts
Customer Sequence
integer in_workflow Service Contracts
In Workflow
boolean cust_num Service Customers
Customer Number
string cust_seq Service Customers
Customer Sequence
integer partner_id Service Customers
Partner ID
string create_date Service Customers
Create Date
datetime der_last_service_date Service Customers
Last Service Date
datetime der_last_incident_date Service Customers
Last Incident Date
datetime waiver_expiration Service Customers
Waiver Expiration
datetime cstbil_name Service Customers
Customer Name
string bill_to_name Service Customers
Bill To Name
string ship_to_name Service Customers
Ship To Name
string def_ship_to_name Service Customers
Default Ship To Name
string bill_mgr Service Customers
Bill Manager
string pricecode Service Customers
Price Code
string prior_code Service Customers
Priority Code
string terms_code Service Customers
Terms Code
string ship_code Service Customers
Ship Code
string serv_type Service Customers
Service Type
string reimb_method Service Customers
Reimbursement Method
string region Service Customers
Region
string region_desc Service Customers
Region Description
string def_region Service Customers
Default Region
string def_region_desc Service Customers
Default Region Description
string cont_num Service Customers
Contract Number
string cont_contact Service Customers empfindlich
Contract Contact
string cont_email Service Customers empfindlich
Contract Email
string cont_phone Service Customers empfindlich
Contract Phone
string cont_phone2 Service Customers empfindlich
Contract Phone 2
string cont_fax_num Service Customers empfindlich
Contract Fax Number
string def_cont_num Service Customers
Default Contact Number
string def_cont_contact Service Customers empfindlich
Default Contact
string def_cont_email Service Customers empfindlich
Default Contact Email
string def_cont_phone Service Customers empfindlich
Default Contact Phone
string def_cont_phone2 Service Customers empfindlich
Default Contact Phone 2
string def_cont_fax_num Service Customers empfindlich
Default Contact Fax Number
string vend_num Service Customers
Vendor Number
string cstbil_curr_code Service Customers
Currency Code
string cstbil_external_email_addr Service Customers empfindlich
External Email Address
string der_bill_address Service Customers
Derived Bill Address
string der_ship_address Service Customers
Derived Ship Address
string def_der_ship_address Service Customers
Default Derived Ship Address
string directions Service Customers
Directions
string sta_description Service Customers
Status Description
string custstat_description Service Customers
Customer Status Description
string fspar_name Service Customers
Partner Name
string cstbil_credit_limit Service Customers
Credit Limit
float cust_bal_der_posted_bal Service Customers
Posted Balance
float der_available_credit_amount Service Customers
Available Credit Amount
float der_open_payment_amount Service Customers
Open Payment Amount
float der_service_contracts_amount Service Customers
Service Contracts Amount
float der_service_orders_amount Service Customers
Service Orders Amount
float deposit_applied Service Customers
Deposit Applied
float deposit_received Service Customers
Deposit Received
float deposit_sro_rec Service Customers
Deposit SRO Received
float deposit_sro_total Service Customers
Deposit SRO Total
float der_count_of_closed_incidents Service Customers
Closed Incidents Count
integer der_sros_ytd Service Customers
SROs Year to Date
integer in_workflow Service Customers
In Workflow
boolean cstbil_credit_hold Service Customers
Credit Hold
boolean apply_open_deposits Service Customers
Apply Open Deposits
boolean deposit_req Service Customers
Deposit Required
boolean excl_waiver_charge Service Customers
Exclude Waiver Charge
boolean default_ship_to Service Customers
Default Ship To
boolean show_in_drop_down_list Service Customers
Show In Drop Down List
boolean show_in_ship_to_drop_down_list Service Customers
Show In Ship To Drop Down List
boolean sro_num Service Order Labor Transactions
SRO Number
string sro_line Service Order Labor Transactions
SRO Line
integer sro_oper Service Order Labor Transactions
SRO Operation
string trans_num Service Order Labor Transactions
Transaction Number
integer partner_id Service Order Labor Transactions
Partner ID
string trans_date Service Order Labor Transactions
Transaction Date
datetime post_date Service Order Labor Transactions
Post Date
datetime create_date Service Order Labor Transactions
Create Date
datetime start_date Service Order Labor Transactions
Start Date
datetime end_date Service Order Labor Transactions
End Date
datetime approved_date Service Order Labor Transactions
Approved Date
datetime sign_off_date Service Order Labor Transactions
Sign Off Date
datetime type Service Order Labor Transactions
Type
string bill_code Service Order Labor Transactions
Bill Code
string bill_stat Service Order Labor Transactions
Bill Status
string reimb_stat Service Order Labor Transactions
Reimbursement Status
string description Service Order Labor Transactions
Description
string ln_description Service Order Labor Transactions
Line Description
string oper_code Service Order Labor Transactions
Operation Code
string oper_description Service Order Labor Transactions
Operation Description
string work_code Service Order Labor Transactions
Work Code
string work_code_description Service Order Labor Transactions
Work Code Description
string dept Service Order Labor Transactions
Department
string whse Service Order Labor Transactions
Warehouse
string partner_name Service Order Labor Transactions
Partner Name
string sro_cust_num Service Order Labor Transactions
SRO Customer Number
string sro_description Service Order Labor Transactions
SRO Description
string sro_sro_stat Service Order Labor Transactions
SRO Status
string sro_sro_type Service Order Labor Transactions
SRO Type
string sro_region Service Order Labor Transactions
SRO Region
string sro_stat Service Order Labor Transactions
SRO Stat
string sro_bill_mgr Service Order Labor Transactions
SRO Bill Manager
string inv_num Service Order Labor Transactions
Invoice Number
string tax_code_1 Service Order Labor Transactions
Tax Code 1
string tax_code_2 Service Order Labor Transactions
Tax Code 2
string reimb_tax_code_1 Service Order Labor Transactions
Reimb Tax Code 1
string reimb_tax_code_2 Service Order Labor Transactions
Reimb Tax Code 2
string curr_code Service Order Labor Transactions
Currency Code
string der_cost_curr_code Service Order Labor Transactions
Cost Currency Code
string der_cust_curr_code Service Order Labor Transactions
Customer Currency Code
string approved_by Service Order Labor Transactions
Approved By
string sign_off Service Order Labor Transactions
Sign Off
string ref_num Service Order Labor Transactions
Reference Number
string ref_type Service Order Labor Transactions
Reference Type
string ln_item Service Order Labor Transactions
Line Item
string ln_ser_num Service Order Labor Transactions
Line Serial Number
string hrs_to_bill Service Order Labor Transactions
Hours to Bill
float hrs_worked Service Order Labor Transactions
Hours Worked
float rate Service Order Labor Transactions
Rate
float cost Service Order Labor Transactions
Cost
float ext_cost Service Order Labor Transactions
Extended Cost
float ext_price Service Order Labor Transactions
Extended Price
float lbr_cost Service Order Labor Transactions
Labor Cost
float fovhd_cost Service Order Labor Transactions
Fixed Overhead Cost
float vovhd_cost Service Order Labor Transactions
Variable Overhead Cost
float disc Service Order Labor Transactions
Discount
float reimburse_due Service Order Labor Transactions
Reimburse Due
float reimburse_paid Service Order Labor Transactions
Reimburse Paid
float reimburse_amt Service Order Labor Transactions
Reimburse Amount
float reimb_sales_tax Service Order Labor Transactions
Reimb Sales Tax
float sro_cust_seq Service Order Labor Transactions
SRO Customer Sequence
integer ref_line_suf Service Order Labor Transactions
Reference Line Suffix
integer inv_line Service Order Labor Transactions
Invoice Line
integer posted Service Order Labor Transactions
Posted
boolean bill_hold Service Order Labor Transactions
Bill Hold
boolean plan_trans Service Order Labor Transactions
Plan Transaction
boolean reimb_partner Service Order Labor Transactions
Reimburse Partner
boolean partner_reimb_labor Service Order Labor Transactions
Partner Reimb Labor
boolean to_schedule Service Order Labor Transactions
To Schedule
boolean in_workflow Service Order Labor Transactions
In Workflow
boolean payroll Service Order Labor Transactions
Payroll
boolean sro_num Service Order Lines
SRO Number
string sro_line Service Order Lines
SRO Line
integer partner_id Service Order Lines
Partner ID
string create_date Service Order Lines
Create Date
datetime due_date Service Order Lines
Due Date
datetime sro_open_date Service Order Lines
SRO Open Date
datetime sro_projected_date Service Order Lines
SRO Projected Date
datetime sro_start_date Service Order Lines
SRO Start Date
datetime line_type Service Order Lines
Line Type
string stat Service Order Lines
Status
string bill_code Service Order Lines
Bill Code
string bill_stat Service Order Lines
Bill Status
string bill_type Service Order Lines
Bill Type
string product_code Service Order Lines
Product Code
string dept Service Order Lines
Department
string dept_description Service Order Lines
Department Description
string description Service Order Lines
Description
string der_description Service Order Lines
Derived Description
string sro_desc Service Order Lines
SRO Description
string sro_sro_stat Service Order Lines
SRO Status
string sro_type Service Order Lines
SRO Type
string srotype_description Service Order Lines
SRO Type Description
string sro_cust_num Service Order Lines
SRO Customer Number
string sro_whse Service Order Lines
SRO Warehouse
string sro_region Service Order Lines
SRO Region
string item Service Order Lines
Item
string um Service Order Lines
Unit of Measure
string ser_num Service Order Lines
Serial Number
string pricecode Service Order Lines
Price Code
string bill_to_name Service Order Lines
Bill To Name
string der_cust_name Service Order Lines
Derived Customer Name
string ref_num Service Order Lines
Reference Number
string ref_type Service Order Lines
Reference Type
string ref_release Service Order Lines
Reference Release
string inc_num Service Order Lines
Incident Number
string contract Service Order Lines
Contract
string serv_type Service Order Lines
Service Type
string inspect_type Service Order Lines
Inspection Type
string cgs_rev_loc_labor Service Order Lines
CGS Rev Loc Labor
string cgs_rev_loc_matl Service Order Lines
CGS Rev Loc Material
string cgs_rev_loc_misc Service Order Lines
CGS Rev Loc Misc
string der_next_sro_oper Service Order Lines
Next SRO Operation
string qty Service Order Lines
Quantity
float qty_issued Service Order Lines
Quantity Issued
float qty_shipped Service Order Lines
Quantity Shipped
float qty_returned Service Order Lines
Quantity Returned
float qty_packed Service Order Lines
Quantity Packed
float der_qty_outstanding Service Order Lines
Quantity Outstanding
float extend_lbr_trans Service Order Lines
Extended Labor Transactions
float extend_matl_trans Service Order Lines
Extended Material Transactions
float extend_misc_trans Service Order Lines
Extended Misc Transactions
float accum_wip Service Order Lines
Accumulated WIP
float total_cost_lbr Service Order Lines
Total Cost Labor
float total_cost_matl Service Order Lines
Total Cost Material
float total_cost_misc Service Order Lines
Total Cost Misc
float der_total_cost Service Order Lines
Derived Total Cost
float total_price Service Order Lines
Total Price
float total_billed Service Order Lines
Total Billed
float total_sales_tax_1 Service Order Lines
Total Sales Tax 1
float total_sales_tax_2 Service Order Lines
Total Sales Tax 2
float ref_line_suf Service Order Lines
Reference Line Suffix
integer der_operation_count Service Order Lines
Operation Count
integer sro_cust_seq Service Order Lines
SRO Customer Sequence
integer maint_seq Service Order Lines
Maintenance Sequence
integer sro_allow_partial Service Order Lines
SRO Allow Partial
boolean awaiting_parts Service Order Lines
Awaiting Parts
boolean to_schedule Service Order Lines
To Schedule
boolean use_est Service Order Lines
Use Estimate
boolean in_workflow Service Order Lines
In Workflow
boolean der_has_labor Service Order Lines
Has Labor
boolean der_has_matl Service Order Lines
Has Material
boolean der_has_misc Service Order Lines
Has Misc
boolean der_has_tran Service Order Lines
Has Transactions
boolean sro_num Service Order Material Transactions
SRO Number
string sro_line Service Order Material Transactions
SRO Line
integer sro_oper Service Order Material Transactions
SRO Operation
string trans_num Service Order Material Transactions
Transaction Number
integer partner_id Service Order Material Transactions
Partner ID
string trans_date Service Order Material Transactions
Transaction Date
datetime post_date Service Order Material Transactions
Post Date
datetime create_date Service Order Material Transactions
Create Date
datetime approved_date Service Order Material Transactions
Approved Date
datetime sign_off_date Service Order Material Transactions
Sign Off Date
datetime projected_date Service Order Material Transactions
Projected Date
datetime type Service Order Material Transactions
Type
string trans_type Service Order Material Transactions
Transaction Type
string bill_code Service Order Material Transactions
Bill Code
string bill_stat Service Order Material Transactions
Bill Status
string reimb_stat Service Order Material Transactions
Reimbursement Status
string description Service Order Material Transactions
Description
string ln_description Service Order Material Transactions
Line Description
string oper_code Service Order Material Transactions
Operation Code
string oper_description Service Order Material Transactions
Operation Description
string item Service Order Material Transactions
Item
string ln_item Service Order Material Transactions
Line Item
string ln_ser_num Service Order Material Transactions
Line Serial Number
string lot Service Order Material Transactions
Lot
string loc Service Order Material Transactions
Location
string whse Service Order Material Transactions
Warehouse
string um Service Order Material Transactions
Unit of Measure
string revision Service Order Material Transactions
Revision
string dept Service Order Material Transactions
Department
string partner_name Service Order Material Transactions
Partner Name
string sro_cust_num Service Order Material Transactions
SRO Customer Number
string sro_description Service Order Material Transactions
SRO Description
string sro_stat Service Order Material Transactions
SRO Status
string sro_region Service Order Material Transactions
SRO Region
string sro_bill_mgr Service Order Material Transactions
SRO Bill Manager
string inv_num Service Order Material Transactions
Invoice Number
string tax_code_1 Service Order Material Transactions
Tax Code 1
string tax_code_2 Service Order Material Transactions
Tax Code 2
string reimb_tax_code_1 Service Order Material Transactions
Reimb Tax Code 1
string reimb_tax_code_2 Service Order Material Transactions
Reimb Tax Code 2
string curr_code Service Order Material Transactions
Currency Code
string der_cost_curr_code Service Order Material Transactions
Cost Currency Code
string der_cust_curr_code Service Order Material Transactions
Customer Currency Code
string der_cost_type Service Order Material Transactions
Cost Type
string approved_by Service Order Material Transactions
Approved By
string sign_off Service Order Material Transactions
Sign Off
string ref_num Service Order Material Transactions
Reference Number
string ref_type Service Order Material Transactions
Reference Type
string ref_release Service Order Material Transactions
Reference Release
string trans_nat Service Order Material Transactions
Transaction Nature
string reason_code Service Order Material Transactions
Reason Code
string process_ind Service Order Material Transactions
Process Indicator
string usage_type Service Order Material Transactions
Usage Type
string origin Service Order Material Transactions
Origin
string comm_code Service Order Material Transactions
Commodity Code
string drop_type Service Order Material Transactions
Drop Type
string drop_cust_num Service Order Material Transactions
Drop Customer Number
string drop_usr_num Service Order Material Transactions
Drop User Number
string drop_ship_no Service Order Material Transactions
Drop Ship Number
string exp_matl_acct Service Order Material Transactions
Material Expense Account
string exp_lbr_acct Service Order Material Transactions
Labor Expense Account
string exp_fov_acct Service Order Material Transactions
Fixed Overhead Expense Account
string exp_vov_acct Service Order Material Transactions
Variable Overhead Expense Account
string exp_out_acct Service Order Material Transactions
Outside Processing Expense Account
string rev_acct Service Order Material Transactions
Revenue Account
string sale_ds_acct Service Order Material Transactions
Sales Discount Account
string matl_qty Service Order Material Transactions
Material Quantity
float qty_back_order Service Order Material Transactions
Quantity Back Order
float cost Service Order Material Transactions
Cost
float ext_cost Service Order Material Transactions
Extended Cost
float price Service Order Material Transactions
Price
float ext_price Service Order Material Transactions
Extended Price
float disc Service Order Material Transactions
Discount
float matl_cost Service Order Material Transactions
Material Cost
float lbr_cost Service Order Material Transactions
Labor Cost
float fovhd_cost Service Order Material Transactions
Fixed Overhead Cost
float vovhd_cost Service Order Material Transactions
Variable Overhead Cost
float out_cost Service Order Material Transactions
Outside Processing Cost
float wip_matl Service Order Material Transactions
WIP Material
float wip_rel_matl Service Order Material Transactions
WIP Released Material
float wip_lbr Service Order Material Transactions
WIP Labor
float wip_rel_lbr Service Order Material Transactions
WIP Released Labor
float wip_fov Service Order Material Transactions
WIP Fixed Overhead
float wip_rel_fov Service Order Material Transactions
WIP Released Fixed Overhead
float wip_vov Service Order Material Transactions
WIP Variable Overhead
float wip_rel_vov Service Order Material Transactions
WIP Released Variable Overhead
float wip_out Service Order Material Transactions
WIP Outside Processing
float wip_rel_out Service Order Material Transactions
WIP Released Outside Processing
float reimburse_due Service Order Material Transactions
Reimburse Due
float reimburse_paid Service Order Material Transactions
Reimburse Paid
float reimburse_amt Service Order Material Transactions
Reimburse Amount
float reimb_sales_tax Service Order Material Transactions
Reimb Sales Tax
float export_value Service Order Material Transactions
Export Value
float unit_weight Service Order Material Transactions
Unit Weight
float sro_cust_seq Service Order Material Transactions
SRO Customer Sequence
integer ref_line_suf Service Order Material Transactions
Reference Line Suffix
integer inv_line Service Order Material Transactions
Invoice Line
integer posted Service Order Material Transactions
Posted
boolean bill_hold Service Order Material Transactions
Bill Hold
boolean reimb_partner Service Order Material Transactions
Reimburse Partner
boolean partner_reimb_matl Service Order Material Transactions
Partner Reimb Material
boolean in_workflow Service Order Material Transactions
In Workflow
boolean rtn_to_stock Service Order Material Transactions
Return to Stock
boolean sro_incl_demand Service Order Material Transactions
SRO Include Demand
boolean der_item_exists Service Order Material Transactions
Item Exists
boolean der_lot_tracked Service Order Material Transactions
Lot Tracked
boolean der_serial_tracked Service Order Material Transactions
Serial Tracked
boolean track_ecn Service Order Material Transactions
Track ECN
boolean include_in_config Service Order Material Transactions
Include in Config
boolean sro_num Service Order Operations
SRO Number
string sro_line Service Order Operations
SRO Line
integer sro_oper Service Order Operations
SRO Operation
string partner_id Service Order Operations
Partner ID
string open_date Service Order Operations
Open Date
datetime close_date Service Order Operations
Close Date
datetime start_date Service Order Operations
Start Date
datetime end_date Service Order Operations
End Date
datetime create_date Service Order Operations
Create Date
datetime stat Service Order Operations
Status
string oper_code Service Order Operations
Operation Code
string description Service Order Operations
Description
string dept Service Order Operations
Department
string whse Service Order Operations
Warehouse
string bill_code Service Order Operations
Bill Code
string bill_stat Service Order Operations
Bill Status
string tax_code_1 Service Order Operations
Tax Code 1
string tax_code_2 Service Order Operations
Tax Code 2
string inspector Service Order Operations
Inspector
string to_schedule Service Order Operations
To Schedule
boolean in_workflow Service Order Operations
In Workflow
boolean sro_num Service Order Transactions
SRO Number
string sro_line Service Order Transactions
SRO Line
integer sro_operation Service Order Transactions
SRO Operation
string trans_num Service Order Transactions
Transaction Number
integer object_id Service Order Transactions
Object ID
string trans_date Service Order Transactions
Transaction Date
datetime create_date Service Order Transactions
Create Date
datetime event_time Service Order Transactions
Event Time
datetime trans_type Service Order Transactions
Transaction Type
string billing_code Service Order Transactions
Billing Code
string event Service Order Transactions
Event
string partner Service Order Transactions
Partner
string work_code Service Order Transactions
Work Code
string misc_code Service Order Transactions
Misc Code
string item Service Order Transactions
Item
string item_description Service Order Transactions
Item Description
string uom Service Order Transactions
Unit of Measure
string pay_type Service Order Transactions
Pay Type
string site_ref Service Order Transactions
Site Reference
string ref_service_order_operations Service Order Transactions
Ref Service Order Operations
string qty Service Order Transactions
Quantity
float unit_cost Service Order Transactions
Unit Cost
float ext_cost Service Order Transactions
Extended Cost
float unit_price Service Order Transactions
Unit Price
float ext_price Service Order Transactions
Extended Price
float labor_cost Service Order Transactions
Labor Cost
float labor_rate Service Order Transactions
Labor Rate
float hrs_worked Service Order Transactions
Hours Worked
float matl_cost Service Order Transactions
Material Cost
float in_workflow Service Order Transactions
In Workflow
boolean sro_num Service Orders
SRO Number
string partner_id Service Orders
Partner ID
string drop_partner_id Service Orders
Drop Partner ID
string shift_id Service Orders
Shift ID
string description Service Orders
Description
string inc_num Service Orders
Incident Number
string sro_stat Service Orders
SRO Status
string bill_stat Service Orders
Bill Status
string cust_num Service Orders
Customer Number
string der_bill_address Service Orders
Derived Bill Address
string der_ship_address Service Orders
Derived Ship Address
string sro_type Service Orders
SRO Type
string whse Service Orders
Warehouse
string dept Service Orders
Department
string product_code Service Orders
Product Code
string region Service Orders
Region
string region_desc Service Orders
Region Description
string slsman Service Orders
Salesman
string der_slsman_name Service Orders
Derived Salesman Name
string partner_name Service Orders
Partner Name
string terms_code Service Orders
Terms Code
string terms_code_desc Service Orders
Terms Code Description
string pricecode Service Orders
Price Code
string ship_code Service Orders
Ship Code
string end_user_type Service Orders
End User Type
string whse_name Service Orders
Warehouse Name
string cust_po Service Orders
Customer PO
string dept_description Service Orders
Department Description
string ref_type Service Orders
Reference Type
string ref_num Service Orders
Reference Number
string product_code_desc Service Orders
Product Code Description
string ref_release Service Orders
Reference Release
string open_date Service Orders
Open Date
datetime close_date Service Orders
Close Date
datetime maint_date Service Orders
Maintenance Date
datetime start_date Service Orders
Start Date
datetime end_date Service Orders
End Date
datetime usr_num Service Orders
User Number
string der_cons_bill_address Service Orders
Derived Consumer Bill Address
string der_cons_ship_address Service Orders
Derived Consumer Ship Address
string bill_type Service Orders
Bill Type
string cgs_rev_loc_matl Service Orders
CGS Rev Loc Material
string cgs_rev_loc_labor Service Orders
CGS Rev Loc Labor
string cgs_rev_loc_misc Service Orders
CGS Rev Loc Misc
string bill_code Service Orders
Bill Code
string bill_mgr Service Orders
Bill Manager
string bill_mgr_name Service Orders
Bill Manager Name
string tax_code_1 Service Orders
Tax Code 1
string tax_code_1_desc Service Orders
Tax Code 1 Description
string tax_code_2 Service Orders
Tax Code 2
string tax_code_2_desc Service Orders
Tax Code 2 Description
string frt_tax_code_1 Service Orders
Freight Tax Code 1
string frt_tax_code_1_desc Service Orders
Freight Tax Code 1 Description
string frt_tax_code_2 Service Orders
Freight Tax Code 2
string frt_tax_code_2_desc Service Orders
Freight Tax Code 2 Description
string msc_tax_code_1 Service Orders
Misc Tax Code 1
string msc_tax_code_1_desc Service Orders
Misc Tax Code 1 Description
string msc_tax_code_2 Service Orders
Misc Tax Code 2
string msc_tax_code_2_desc Service Orders
Misc Tax Code 2 Description
string trans_nat Service Orders
Transaction Nature
string trans_nat_desc Service Orders
Transaction Nature Description
string credit_hold_user Service Orders empfindlich
Credit Hold User
string delterm Service Orders
Delivery Terms
string delterm_desc Service Orders
Delivery Terms Description
string process_ind Service Orders
Process Indicator
string credit_hold_reason Service Orders
Credit Hold Reason
string credit_hold_reason_description Service Orders
Credit Hold Reason Description
string credit_hold_date Service Orders
Credit Hold Date
datetime projected_date Service Orders
Projected Date
datetime prior_code Service Orders
Prior Code
string stat_code Service Orders
Status Code
string contact Service Orders empfindlich
Contact
string email Service Orders empfindlich
Email
string phone Service Orders empfindlich
Phone
string fax_num Service Orders empfindlich
Fax Number
string pager_addr Service Orders empfindlich
Pager Address
string txt_msg_addr Service Orders empfindlich
Text Message Address
string drop_type Service Orders
Drop Type
string drop_cust_num Service Orders
Drop Customer Number
string drop_usr_num Service Orders
Drop User Number
string drop_ship_no Service Orders
Drop Ship Number
string der_drop_name Service Orders
Derived Drop Name
string der_drop_ship_address Service Orders
Derived Drop Ship Address
string cust_seq Service Orders
Customer Sequence
integer ref_line_suf Service Orders
Reference Line Suffix
integer maint_duration Service Orders
Maintenance Duration
float usr_seq Service Orders
User Sequence
integer freight Service Orders
Freight
float misc_charges Service Orders
Misc Charges
float disc Service Orders
Discount
float disc_matl Service Orders
Discount Material
float disc_labor Service Orders
Discount Labor
float disc_misc Service Orders
Discount Misc
float accum_wip Service Orders
Accumulated WIP
float extend_matl_trans Service Orders
Extended Material Transactions
float extend_lbr_trans Service Orders
Extended Labor Transactions
float extend_misc_trans Service Orders
Extended Misc Transactions
float total_cost_matl Service Orders
Total Cost Material
float total_cost_lbr Service Orders
Total Cost Labor
float total_cost_misc Service Orders
Total Cost Misc
float inv_close Service Orders
Invoice Close
integer total_cost Service Orders
Total Cost
float fixed_rate Service Orders
Fixed Rate
float exch_rate Service Orders
Exchange Rate
float total_price Service Orders
Total Price
float total_billed Service Orders
Total Billed
float freight_t Service Orders
Freight Tax
float misc_charges_t Service Orders
Misc Charges Tax
float disc_t Service Orders
Discount Tax
float total_sales_tax_1 Service Orders
Total Sales Tax 1
float total_sales_tax_2 Service Orders
Total Sales Tax 2
float der_net_sales_amount Service Orders
Derived Net Sales Amount
float drop_cust_seq Service Orders
Drop Customer Sequence
integer drop_usr_seq Service Orders
Drop User Sequence
integer allow_partial Service Orders
Allow Partial
boolean awaiting_parts Service Orders
Awaiting Parts
boolean incl_demand Service Orders
Include Demand
boolean to_schedule Service Orders
To Schedule
boolean plan_req Service Orders
Plan Required
boolean use_est Service Orders
Use Estimate
boolean credit_hold Service Orders
Credit Hold
boolean insp_finalized Service Orders
Inspection Finalized
boolean partner_id Service Partners
Partner ID
string sup_id Service Partners
Supervisor ID
string gps_last_timestamp Service Partners
GPS Last Timestamp
datetime ref_type Service Partners
Reference Type
string ref_emp_num Service Partners
Reference Employee Number
string ref_cust_num Service Partners
Reference Customer Number
string ref_vend_num Service Partners
Reference Vendor Number
string ref_num Service Partners
Reference Number
string dept Service Partners
Department
string dept_desc Service Partners
Department Description
string curr_code Service Partners
Currency Code
string curr_code_description Service Partners
Currency Code Description
string email Service Partners empfindlich
Email
string pager_addr Service Partners empfindlich
Pager Address
string txt_msg_addr Service Partners empfindlich
Text Message Address
string work_code Service Partners
Work Code
string work_code_description Service Partners
Work Code Description
string misc_code Service Partners
Misc Code
string misc_code_description Service Partners
Misc Code Description
string whse Service Partners
Warehouse
string reimb_method Service Partners
Reimbursement Method
string user_name Service Partners
User Name
string vend_num Service Partners
Vendor Number
string cust_num Service Partners
Customer Number
string der_partner_address Service Partners
Derived Partner Address
string der_phone Service Partners empfindlich
Derived Phone
string der_region Service Partners
Derived Region
string fs_pay_type Service Partners
Pay Type
string pay_type_pay_desc Service Partners
Pay Type Description
string emp_phone Service Partners empfindlich
Employee Phone
string cust_phone Service Partners empfindlich
Customer Phone
string ven_phone Service Partners empfindlich
Vendor Phone
string der_total_billed_mtd Service Partners
Total Billed MTD
float hrs_1 Service Partners
Hours Day 1
float hrs_2 Service Partners
Hours Day 2
float hrs_3 Service Partners
Hours Day 3
float hrs_4 Service Partners
Hours Day 4
float hrs_5 Service Partners
Hours Day 5
float hrs_6 Service Partners
Hours Day 6
float hrs_7 Service Partners
Hours Day 7
float gps_last_latitude Service Partners
GPS Last Latitude
float gps_last_longitude Service Partners
GPS Last Longitude
float gps_polling_interval Service Partners
GPS Polling Interval
integer der_closed_sros_mtd Service Partners
Closed SROs MTD
integer ref_cust_seq Service Partners
Reference Customer Sequence
integer active Service Partners
Active
boolean in_workflow Service Partners
In Workflow
boolean der_on_task Service Partners
On Task
boolean der_resource Service Partners
Is Resource
boolean display_on_schedule_board Service Partners
Display On Schedule Board
boolean reimb_labor Service Partners
Reimburse Labor
boolean reimb_matl Service Partners
Reimburse Material
boolean seq Service Schedules
Sequence
integer partner_id Service Schedules
Partner ID
string sched_date Service Schedules
Schedule Date
datetime create_date Service Schedules
Create Date
datetime ser_num Service Units
Serial Number
string comp_id Service Units
Component ID
string create_date Service Units
Create Date
datetime install_date Service Units
Install Date
datetime ship_date Service Units
Ship Date
datetime last_meter_date Service Units
Last Meter Date
datetime last_calib_date Service Units
Last Calibration Date
datetime last_ins_date Service Units
Last Inspection Date
datetime last_pm_date Service Units
Last PM Date
datetime next_calib_date Service Units
Next Calibration Date
datetime next_ins_date Service Units
Next Inspection Date
datetime next_pm_date Service Units
Next PM Date
datetime description Service Units
Description
string cust_num Service Units
Customer Number
string cust_item Service Units
Customer Item
string contract Service Units
Contract
string location Service Units
Location
string unit_stat Service Units
Unit Status
string unit_stat_code Service Units
Unit Status Code
string prior_code Service Units
Priority Code
string hold_reason Service Units
Hold Reason
string mfg Service Units
Manufacturer
string mfg_num Service Units
Manufacturer Number
string whse Service Units
Warehouse
string wc Service Units
Work Center
string srv_dealer Service Units
Service Dealer
string fa_num Service Units
Fixed Asset Number
string usr_num Service Units
User Number
string region Service Units
Region
string item_meter_label Service Units
Item Meter Label
string item_pmt_code Service Units
Item PM Type Code
string bill_to_name Service Units
Bill To Name
string ship_to_name Service Units
Ship To Name
string cust_addr Service Units
Customer Address
string usr_addr Service Units
User Address
string resid Service Units
Resource ID
string co_num Service Units
Customer Order Number
string co_line Service Units
Customer Order Line
string co_release Service Units
Customer Order Release
string list_price Service Units
List Price
float sale_amount Service Units
Sale Amount
float last_meter_amt Service Units
Last Meter Amount
float cust_seq Service Units
Customer Sequence
integer usr_seq Service Units
User Sequence
integer date_seq Service Units
Date Sequence
integer item_ins_days Service Units
Inspection Interval Days
integer avail_for_service Service Units
Available for Service
boolean avail_for_rent Service Units
Available for Rent
boolean hold_flag Service Units
Hold Flag
boolean in_workflow Service Units
In Workflow
boolean valid_warr Service Units
Valid Warranty
boolean der_under_contract Service Units
Under Contract
boolean der_fs_conts_exists Service Units
Has Service Contracts
boolean der_fs_incident_exists Service Units
Has Incidents
boolean der_fs_sro_line_exists Service Units
Has SRO Lines
boolean