3 * Table Definition for saleshistory
5 require_once 'DB/DataObject.php';
7 class Pman_Xtuple_DataObjects_Saleshistory extends DB_DataObject
10 /* the code below is auto generated do not remove the above tag */
12 public $__table = 'saleshistory'; // table name
13 public $cohist_id; // int4(4)
14 public $cohist_cust_id; // int4(4)
15 public $cohist_itemsite_id; // int4(4)
16 public $cohist_shipdate; // date(4)
17 public $cohist_shipvia; // text(-1)
18 public $cohist_ordernumber; // text(-1)
19 public $cohist_orderdate; // date(4)
20 public $cohist_invcnumber; // text(-1)
21 public $cohist_invcdate; // date(4)
22 public $cohist_qtyshipped; // numeric(-1)
23 public $cohist_unitprice; // numeric(-1)
24 public $cohist_shipto_id; // int4(4)
25 public $cohist_salesrep_id; // int4(4)
26 public $cohist_duedate; // date(4)
27 public $cohist_imported; // bool(1)
28 public $cohist_billtoname; // text(-1)
29 public $cohist_billtoaddress1; // text(-1)
30 public $cohist_billtoaddress2; // text(-1)
31 public $cohist_billtoaddress3; // text(-1)
32 public $cohist_billtocity; // text(-1)
33 public $cohist_billtostate; // text(-1)
34 public $cohist_billtozip; // text(-1)
35 public $cohist_shiptoname; // text(-1)
36 public $cohist_shiptoaddress1; // text(-1)
37 public $cohist_shiptoaddress2; // text(-1)
38 public $cohist_shiptoaddress3; // text(-1)
39 public $cohist_shiptocity; // text(-1)
40 public $cohist_shiptostate; // text(-1)
41 public $cohist_shiptozip; // text(-1)
42 public $cohist_commission; // numeric(-1)
43 public $cohist_commissionpaid; // bool(1)
44 public $cohist_unitcost; // numeric(-1)
45 public $cohist_misc_type; // bpchar(-1)
46 public $cohist_misc_descrip; // text(-1)
47 public $cohist_misc_id; // int4(4)
48 public $cohist_doctype; // text(-1)
49 public $cohist_promisedate; // date(4)
50 public $cohist_ponumber; // text(-1)
51 public $cohist_curr_id; // int4(4)
52 public $cohist_sequence; // int4(4)
53 public $cohist_taxtype_id; // int4(4)
54 public $cohist_taxzone_id; // int4(4)
55 public $invoicenumber; // text(-1)
56 public $cust_id; // int4(4)
57 public $cust_number; // text(-1)
58 public $cust_name; // text(-1)
59 public $cust_curr_id; // int4(4)
60 public $cust_custtype_id; // int4(4)
61 public $custtype_code; // text(-1)
62 public $custtype_descrip; // text(-1)
63 public $salesrep_number; // text(-1)
64 public $salesrep_name; // text(-1)
65 public $shipzone_id; // int4(4)
66 public $shipzone_name; // text(-1)
67 public $shipzone_descrip; // text(-1)
68 public $itemsite_warehous_id; // int4(4)
69 public $itemsite_item_id; // int4(4)
70 public $item_id; // int4(4)
71 public $item_number; // text(-1)
72 public $item_descrip1; // text(-1)
73 public $itemdescription; // text(-1)
74 public $item_prodcat_id; // int4(4)
75 public $warehous_code; // text(-1)
76 public $warehous_descrip; // text(-1)
77 public $prodcat_code; // text(-1)
78 public $basecommission; // numeric(-1)
79 public $baseunitprice; // numeric(-1)
80 public $custunitprice; // numeric(-1)
81 public $extprice; // numeric(-1)
82 public $baseextprice; // numeric(-1)
83 public $custextprice; // numeric(-1)
84 public $extcost; // numeric(-1)
85 public $currabbr; // varchar(-1)
86 public $cohist_invcdate_xtnullrole; // text(-1)
87 public $cohist_qtyshipped_xtnumericrole; // text(-1)
88 public $cohist_unitprice_xtnumericrole; // text(-1)
89 public $baseunitprice_xtnumericrole; // text(-1)
90 public $custunitprice_xtnumericrole; // text(-1)
91 public $custextprice_xtnumericrole; // text(-1)
92 public $extprice_xtnumericrole; // text(-1)
93 public $baseextprice_xtnumericrole; // text(-1)
94 public $cohist_unitcost_xtnumericrole; // text(-1)
95 public $extcost_xtnumericrole; // text(-1)
96 public $cohist_commission_xtnumericrole; // text(-1)
97 public $basecommission_xtnumericrole; // text(-1)
98 public $cohist_qtyshipped_xttotalrole; // int4(4)
99 public $custextprice_xttotalrole; // int4(4)
100 public $baseextprice_xttotalrole; // int4(4)
101 public $extcost_xttotalrole; // int4(4)
102 public $basecommission_xttotalrole; // int4(4)
105 /* the code above is auto generated do not remove the tag below */