git.roojs.org Git - Pman.Xtuple/blob - Pman.Tab.XtuplePurchaseRecv.js

   1 //<script type="text/javascript">
   2
   3 // Auto generated file - created by app.Builder.js- do not edit directly (at present!)
   4
   5 Pman.Tab.XtuplePurchaseRecv = new Roo.XComponent({
   6     part     :  ["Xtuple","PurchaseRecv"],
   7     order    : '001-Pman.Tab.XtuplePurchaseRecv',
   8     region   : 'center',
   9     parent   : 'Pman.Tab.XtuplePurchases',
  10     name     : "Pman.Tab.XtuplePurchaseRecv",
  11     disabled : false,
  12     permname : '',
  13     _tree : function()
  14     {
  15         var _this = this;
  16         var MODULE = this;
  17         return {
  18             xtype: 'NestedLayoutPanel',
  19             xns: Roo,
  20             background : true,
  21             region : 'center',
  22             title : "PO / Recieve Stock",
  23             layout : {
  24                 xtype: 'BorderLayout',
  25                 xns: Roo,
  26                 items : [
  27                     {
  28                         xtype: 'GridPanel',
  29                         xns: Roo,
  30                         listeners : {
  31                             activate : function() {
  32                                 _this.ppanel = this;
  33                                 if (_this.grid) {
  34                                     _this.grid.footer.onClick('first');
  35                                 }
  36                             }
  37                         },
  38                         background : true,
  39                         fitContainer : true,
  40                         fitToframe : true,
  41                         region : 'center',
  42                         tableName : 'pohead',
  43                         title : "PO Receive Stock",
  44                         grid : {
  45                             xtype: 'Grid',
  46                             xns: Roo.grid,
  47                             listeners : {
  48                                 render : function()
  49                                 {
  50                                     _this.grid = this;
  51                                     //_this.dialog = Pman.Dialog.FILL_IN
  52                                     if (_this.ppanel.active) {
  53                                        this.footer.onClick('first');
  54                                     }
  55                                 },
  56                                 cellclick : function (_self, rowIndex, columnIndex, e)
  57                                 {
  58
  59                                     var applyVoucher = function(){
  60                                         Roo.MessageBox.confirm("Confirm", "Are you sure to apply voucher for the selected PO completely?",
  61                                             function(v) {
  62                                                 if (v != 'yes') {
  63                                                     return;
  64                                                 }
  65
  66                                                 Pman.request({
  67                                                     url: baseURL+'/Roo/Pohead.php',
  68                                                     method :'POST',
  69                                                     mask : 'Processing',
  70                                                     params : {
  71                                                         'pohead_id' : s.data.pohead_id,
  72                                                         '_applyVoucher' : 1
  73                                                     },
  74                                                     success : function  () {
  75                                                         _this.grid.footer.onClick('refresh');
  76                                                         return;
  77                                                     }
  78                                                 });
  79                                             });
  80                                             return;
  81                                     }
  82
  83                                     var di = _this.grid.getColumnModel().getDataIndex(columnIndex);
  84                                     var s = _this.grid.ds.getAt(rowIndex);
  85
  86                                     if(di == 'pohead_vouchered'){
  87                                         if(s.data.pohead_status != 'O'){
  88                                             Roo.MessageBox.alert('Error', 'Please Open this PO first');
  89                                             return;
  90                                         }
  91                                         if(Math.round(s.data.pohead_vouchered*100) > Math.round(s.data.pohead_val*100)){
  92                                             //Roo.MessageBox.alert('Error', 'This PO has been apply completely!');
  93                                             return;
  94                                         }
  95                                         applyVoucher();
  96
  97                                         return;
  98                                     }
  99
 100                                     if(di == 'pohead_paid'){ // comming soon...
 101                                         return;
 102                                     }
 103
 104
 105
 106                                     _this.rggrid.ds.load({});
 107                                 },
 108                                 rowdblclick : function (_self, rowIndex, e)
 109                                 {
 110
 111
 112                                     var r = _this.grid.ds.getAt(rowIndex);
 113
 114                                     Pman.Dialog.XtuplePurchaseOrder.show( { pohead_id : r.data.pohead_id }, function() {
 115                                         _this.grid.footer.onClick('refresh');
 116                                     });
 117                                 }
 118                             },
 119                             autoExpandColumn : 'pohead_vend_id_vend_name',
 120                             loadMask : true,
 121                             trackMouseOver : true,
 122                             sm : {
 123                                 xtype: 'RowSelectionModel',
 124                                 xns: Roo.grid,
 125                                 singleSelect : true
 126                             },
 127                             dataSource : {
 128                                 xtype: 'Store',
 129                                 xns: Roo.data,
 130                                 listeners : {
 131                                     beforeload : function (_self, o)
 132                                     {
 133                                         o.params._with_recv = 1;
 134
 135
 136                                         o.params['query[number]'] = _this.searchBox.getValue();
 137
 138                                         // only filter by type if the number is empty..
 139                                         if (!o.params['query[number]'].length) {
 140                                             if (_this.status.getValue() != 'E') {
 141                                                 o.params._status = _this.status.getValue();
 142                                             }
 143                                         }
 144                                         if (_this.status.getValue() == 'E') {
 145                                             o.params['!pohead_has_error'] = 0;
 146                                         }
 147
 148
 149                                     },
 150                                     load : function (_self, records, options)
 151                                     {
 152
 153                                         (function() { _this.rggrid.ds.load({}); }).defer(100);
 154                                     }
 155                                 },
 156                                 remoteSort : true,
 157                                 sortInfo : { field : 'pohead_orderdate', direction: 'DESC' },
 158                                 proxy : {
 159                                     xtype: 'HttpProxy',
 160                                     xns: Roo.data,
 161                                     method : 'GET',
 162                                     url : baseURL + '/Roo/pohead.php'
 163                                 },
 164                                 reader : {
 165                                     xtype: 'JsonReader',
 166                                     xns: Roo.data,
 167                                     totalProperty : 'total',
 168                                     root : 'data',
 169                                     id : 'id',
 170                                     fields : [
 171                                         {
 172                                             'name': 'pohead_id',
 173                                             'type': 'int'
 174                                         },
 175                                         {
 176                                             'name': 'pohead_status',
 177                                             'type': 'string'
 178                                         },
 179                                         {
 180                                             'name': 'pohead_number',
 181                                             'type': 'string'
 182                                         },
 183                                         {
 184                                             'name': 'pohead_orderdate',
 185                                             'type': 'date',
 186                                             'dateFormat': 'Y-m-d'
 187                                         },
 188                                         {
 189                                             'name': 'pohead_vend_id',
 190                                             'type': 'int'
 191                                         },
 192                                         {
 193                                             'name': 'pohead_fob',
 194                                             'type': 'string'
 195                                         },
 196                                         {
 197                                             'name': 'pohead_shipvia',
 198                                             'type': 'string'
 199                                         },
 200                                         {
 201                                             'name': 'pohead_comments',
 202                                             'type': 'string'
 203                                         },
 204                                         {
 205                                             'name': 'pohead_freight',
 206                                             'type': 'float'
 207                                         },
 208                                         {
 209                                             'name': 'pohead_printed',
 210                                             'type': 'int'
 211                                         },
 212                                         {
 213                                             'name': 'pohead_terms_id',
 214                                             'type': 'int'
 215                                         },
 216                                         {
 217                                             'name': 'pohead_warehous_id',
 218                                             'type': 'int'
 219                                         },
 220                                         {
 221                                             'name': 'pohead_vendaddr_id',
 222                                             'type': 'int'
 223                                         },
 224                                         {
 225                                             'name': 'pohead_agent_username',
 226                                             'type': 'string'
 227                                         },
 228                                         {
 229                                             'name': 'pohead_curr_id',
 230                                             'type': 'int'
 231                                         },
 232                                         {
 233                                             'name': 'pohead_saved',
 234                                             'type': 'int'
 235                                         },
 236                                         {
 237                                             'name': 'pohead_taxzone_id',
 238                                             'type': 'int'
 239                                         },
 240                                         {
 241                                             'name': 'pohead_taxtype_id',
 242                                             'type': 'int'
 243                                         },
 244                                         {
 245                                             'name': 'pohead_dropship',
 246                                             'type': 'int'
 247                                         },
 248                                         {
 249                                             'name': 'pohead_vend_cntct_id',
 250                                             'type': 'int'
 251                                         },
 252                                         {
 253                                             'name': 'pohead_vend_cntct_honorific',
 254                                             'type': 'string'
 255                                         },
 256                                         {
 257                                             'name': 'pohead_vend_cntct_first_name',
 258                                             'type': 'string'
 259                                         },
 260                                         {
 261                                             'name': 'pohead_vend_cntct_middle',
 262                                             'type': 'string'
 263                                         },
 264                                         {
 265                                             'name': 'pohead_vend_cntct_last_name',
 266                                             'type': 'string'
 267                                         },
 268                                         {
 269                                             'name': 'pohead_vend_cntct_suffix',
 270                                             'type': 'string'
 271                                         },
 272                                         {
 273                                             'name': 'pohead_vend_cntct_phone',
 274                                             'type': 'string'
 275                                         },
 276                                         {
 277                                             'name': 'pohead_vend_cntct_title',
 278                                             'type': 'string'
 279                                         },
 280                                         {
 281                                             'name': 'pohead_vend_cntct_fax',
 282                                             'type': 'string'
 283                                         },
 284                                         {
 285                                             'name': 'pohead_vend_cntct_email',
 286                                             'type': 'string'
 287                                         },
 288                                         {
 289                                             'name': 'pohead_vendaddress1',
 290                                             'type': 'string'
 291                                         },
 292                                         {
 293                                             'name': 'pohead_vendaddress2',
 294                                             'type': 'string'
 295                                         },
 296                                         {
 297                                             'name': 'pohead_vendaddress3',
 298                                             'type': 'string'
 299                                         },
 300                                         {
 301                                             'name': 'pohead_vendcity',
 302                                             'type': 'string'
 303                                         },
 304                                         {
 305                                             'name': 'pohead_vendstate',
 306                                             'type': 'string'
 307                                         },
 308                                         {
 309                                             'name': 'pohead_vendzipcode',
 310                                             'type': 'string'
 311                                         },
 312                                         {
 313                                             'name': 'pohead_vendcountry',
 314                                             'type': 'string'
 315                                         },
 316                                         {
 317                                             'name': 'pohead_shipto_cntct_id',
 318                                             'type': 'int'
 319                                         },
 320                                         {
 321                                             'name': 'pohead_shipto_cntct_honorific',
 322                                             'type': 'string'
 323                                         },
 324                                         {
 325                                             'name': 'pohead_shipto_cntct_first_name',
 326                                             'type': 'string'
 327                                         },
 328                                         {
 329                                             'name': 'pohead_shipto_cntct_middle',
 330                                             'type': 'string'
 331                                         },
 332                                         {
 333                                             'name': 'pohead_shipto_cntct_last_name',
 334                                             'type': 'string'
 335                                         },
 336                                         {
 337                                             'name': 'pohead_shipto_cntct_suffix',
 338                                             'type': 'string'
 339                                         },
 340                                         {
 341                                             'name': 'pohead_shipto_cntct_phone',
 342                                             'type': 'string'
 343                                         },
 344                                         {
 345                                             'name': 'pohead_shipto_cntct_title',
 346                                             'type': 'string'
 347                                         },
 348                                         {
 349                                             'name': 'pohead_shipto_cntct_fax',
 350                                             'type': 'string'
 351                                         },
 352                                         {
 353                                             'name': 'pohead_shipto_cntct_email',
 354                                             'type': 'string'
 355                                         },
 356                                         {
 357                                             'name': 'pohead_shiptoddress_id',
 358                                             'type': 'int'
 359                                         },
 360                                         {
 361                                             'name': 'pohead_shiptoaddress1',
 362                                             'type': 'string'
 363                                         },
 364                                         {
 365                                             'name': 'pohead_shiptoaddress2',
 366                                             'type': 'string'
 367                                         },
 368                                         {
 369                                             'name': 'pohead_shiptoaddress3',
 370                                             'type': 'string'
 371                                         },
 372                                         {
 373                                             'name': 'pohead_shiptocity',
 374                                             'type': 'string'
 375                                         },
 376                                         {
 377                                             'name': 'pohead_shiptostate',
 378                                             'type': 'string'
 379                                         },
 380                                         {
 381                                             'name': 'pohead_shiptozipcode',
 382                                             'type': 'string'
 383                                         },
 384                                         {
 385                                             'name': 'pohead_shiptocountry',
 386                                             'type': 'string'
 387                                         },
 388                                         {
 389                                             'name': 'pohead_cohead_id',
 390                                             'type': 'int'
 391                                         },
 392                                         {
 393                                             'name': 'pohead_released',
 394                                             'type': 'date',
 395                                             'dateFormat': 'Y-m-d'
 396                                         },
 397                                         {
 398                                             'name': 'pohead_curr_id_curr_id',
 399                                             'type': 'int'
 400                                         },
 401                                         {
 402                                             'name': 'pohead_curr_id_curr_base',
 403                                             'type': 'int'
 404                                         },
 405                                         {
 406                                             'name': 'pohead_curr_id_curr_name',
 407                                             'type': 'string'
 408                                         },
 409                                         {
 410                                             'name': 'pohead_curr_id_curr_symbol',
 411                                             'type': 'string'
 412                                         },
 413                                         {
 414                                             'name': 'pohead_curr_id_curr_abbr',
 415                                             'type': 'string'
 416                                         },
 417                                         {
 418                                             'name': 'pohead_warehous_id_warehous_id',
 419                                             'type': 'int'
 420                                         },
 421                                         {
 422                                             'name': 'pohead_warehous_id_warehous_code',
 423                                             'type': 'string'
 424                                         },
 425                                         {
 426                                             'name': 'pohead_warehous_id_warehous_descrip',
 427                                             'type': 'string'
 428                                         },
 429                                         {
 430                                             'name': 'pohead_warehous_id_warehous_fob',
 431                                             'type': 'string'
 432                                         },
 433                                         {
 434                                             'name': 'pohead_warehous_id_warehous_active',
 435                                             'type': 'int'
 436                                         },
 437                                         {
 438                                             'name': 'pohead_warehous_id_warehous_counttag_prefix',
 439                                             'type': 'string'
 440                                         },
 441                                         {
 442                                             'name': 'pohead_warehous_id_warehous_counttag_number',
 443                                             'type': 'int'
 444                                         },
 445                                         {
 446                                             'name': 'pohead_warehous_id_warehous_bol_prefix',
 447                                             'type': 'string'
 448                                         },
 449                                         {
 450                                             'name': 'pohead_warehous_id_warehous_bol_number',
 451                                             'type': 'int'
 452                                         },
 453                                         {
 454                                             'name': 'pohead_warehous_id_warehous_shipping',
 455                                             'type': 'int'
 456                                         },
 457                                         {
 458                                             'name': 'pohead_warehous_id_warehous_useslips',
 459                                             'type': 'int'
 460                                         },
 461                                         {
 462                                             'name': 'pohead_warehous_id_warehous_usezones',
 463                                             'type': 'int'
 464                                         },
 465                                         {
 466                                             'name': 'pohead_warehous_id_warehous_aislesize',
 467                                             'type': 'int'
 468                                         },
 469                                         {
 470                                             'name': 'pohead_warehous_id_warehous_aislealpha',
 471                                             'type': 'int'
 472                                         },
 473                                         {
 474                                             'name': 'pohead_warehous_id_warehous_racksize',
 475                                             'type': 'int'
 476                                         },
 477                                         {
 478                                             'name': 'pohead_warehous_id_warehous_rackalpha',
 479                                             'type': 'int'
 480                                         },
 481                                         {
 482                                             'name': 'pohead_warehous_id_warehous_binsize',
 483                                             'type': 'int'
 484                                         },
 485                                         {
 486                                             'name': 'pohead_warehous_id_warehous_binalpha',
 487                                             'type': 'int'
 488                                         },
 489                                         {
 490                                             'name': 'pohead_warehous_id_warehous_locationsize',
 491                                             'type': 'int'
 492                                         },
 493                                         {
 494                                             'name': 'pohead_warehous_id_warehous_locationalpha',
 495                                             'type': 'int'
 496                                         },
 497                                         {
 498                                             'name': 'pohead_warehous_id_warehous_enforcearbl',
 499                                             'type': 'int'
 500                                         },
 501                                         {
 502                                             'name': 'pohead_warehous_id_warehous_default_accnt_id',
 503                                             'type': 'int'
 504                                         },
 505                                         {
 506                                             'name': 'pohead_warehous_id_warehous_shipping_commission',
 507                                             'type': 'float'
 508                                         },
 509                                         {
 510                                             'name': 'pohead_warehous_id_warehous_cntct_id',
 511                                             'type': 'int'
 512                                         },
 513                                         {
 514                                             'name': 'pohead_warehous_id_warehous_addr_id',
 515                                             'type': 'int'
 516                                         },
 517                                         {
 518                                             'name': 'pohead_warehous_id_warehous_transit',
 519                                             'type': 'int'
 520                                         },
 521                                         {
 522                                             'name': 'pohead_warehous_id_warehous_shipform_id',
 523                                             'type': 'int'
 524                                         },
 525                                         {
 526                                             'name': 'pohead_warehous_id_warehous_shipvia_id',
 527                                             'type': 'int'
 528                                         },
 529                                         {
 530                                             'name': 'pohead_warehous_id_warehous_shipcomments',
 531                                             'type': 'string'
 532                                         },
 533                                         {
 534                                             'name': 'pohead_warehous_id_warehous_costcat_id',
 535                                             'type': 'int'
 536                                         },
 537                                         {
 538                                             'name': 'pohead_warehous_id_warehous_costcat_id',
 539                                             'type': 'int'
 540                                         },
 541                                         {
 542                                             'name': 'pohead_warehous_id_warehous_sitetype_id',
 543                                             'type': 'int'
 544                                         },
 545                                         {
 546                                             'name': 'pohead_warehous_id_warehous_taxzone_id',
 547                                             'type': 'int'
 548                                         },
 549                                         {
 550                                             'name': 'pohead_warehous_id_warehous_sequence',
 551                                             'type': 'int'
 552                                         },
 553                                         {
 554                                             'name': 'pohead_vendaddr_id_vendaddr_id',
 555                                             'type': 'int'
 556                                         },
 557                                         {
 558                                             'name': 'pohead_vendaddr_id_vendaddr_vend_id',
 559                                             'type': 'int'
 560                                         },
 561                                         {
 562                                             'name': 'pohead_vendaddr_id_vendaddr_code',
 563                                             'type': 'string'
 564                                         },
 565                                         {
 566                                             'name': 'pohead_vendaddr_id_vendaddr_name',
 567                                             'type': 'string'
 568                                         },
 569                                         {
 570                                             'name': 'pohead_vendaddr_id_vendaddr_comments',
 571                                             'type': 'string'
 572                                         },
 573                                         {
 574                                             'name': 'pohead_vendaddr_id_vendaddr_cntct_id',
 575                                             'type': 'int'
 576                                         },
 577                                         {
 578                                             'name': 'pohead_vendaddr_id_vendaddr_addr_id',
 579                                             'type': 'int'
 580                                         },
 581                                         {
 582                                             'name': 'pohead_vendaddr_id_vendaddr_taxzone_id',
 583                                             'type': 'int'
 584                                         },
 585                                         {
 586                                             'name': 'pohead_vend_id_vend_id',
 587                                             'type': 'int'
 588                                         },
 589                                         {
 590                                             'name': 'pohead_vend_id_vend_name',
 591                                             'type': 'string'
 592                                         },
 593                                         {
 594                                             'name': 'pohead_vend_id_vend_lastpurchdate',
 595                                             'type': 'date'
 596                                         },
 597                                         {
 598                                             'name': 'pohead_vend_id_vend_active',
 599                                             'type': 'int'
 600                                         },
 601                                         {
 602                                             'name': 'pohead_vend_id_vend_po',
 603                                             'type': 'int'
 604                                         },
 605                                         {
 606                                             'name': 'pohead_vend_id_vend_comments',
 607                                             'type': 'string'
 608                                         },
 609                                         {
 610                                             'name': 'pohead_vend_id_vend_pocomments',
 611                                             'type': 'string'
 612                                         },
 613                                         {
 614                                             'name': 'pohead_vend_id_vend_number',
 615                                             'type': 'string'
 616                                         },
 617                                         {
 618                                             'name': 'pohead_vend_id_vend_1099',
 619                                             'type': 'int'
 620                                         },
 621                                         {
 622                                             'name': 'pohead_vend_id_vend_exported',
 623                                             'type': 'int'
 624                                         },
 625                                         {
 626                                             'name': 'pohead_vend_id_vend_fobsource',
 627                                             'type': 'string'
 628                                         },
 629                                         {
 630                                             'name': 'pohead_vend_id_vend_fob',
 631                                             'type': 'string'
 632                                         },
 633                                         {
 634                                             'name': 'pohead_vend_id_vend_terms_id',
 635                                             'type': 'int'
 636                                         },
 637                                         {
 638                                             'name': 'pohead_vend_id_vend_shipvia',
 639                                             'type': 'string'
 640                                         },
 641                                         {
 642                                             'name': 'pohead_vend_id_vend_vendtype_id',
 643                                             'type': 'int'
 644                                         },
 645                                         {
 646                                             'name': 'pohead_vend_id_vend_qualified',
 647                                             'type': 'int'
 648                                         },
 649                                         {
 650                                             'name': 'pohead_vend_id_vend_ediemail',
 651                                             'type': 'string'
 652                                         },
 653                                         {
 654                                             'name': 'pohead_vend_id_vend_ediemailbody',
 655                                             'type': 'string'
 656                                         },
 657                                         {
 658                                             'name': 'pohead_vend_id_vend_edisubject',
 659                                             'type': 'string'
 660                                         },
 661                                         {
 662                                             'name': 'pohead_vend_id_vend_edifilename',
 663                                             'type': 'string'
 664                                         },
 665                                         {
 666                                             'name': 'pohead_vend_id_vend_accntnum',
 667                                             'type': 'string'
 668                                         },
 669                                         {
 670                                             'name': 'pohead_vend_id_vend_emailpodelivery',
 671                                             'type': 'int'
 672                                         },
 673                                         {
 674                                             'name': 'pohead_vend_id_vend_restrictpurch',
 675                                             'type': 'int'
 676                                         },
 677                                         {
 678                                             'name': 'pohead_vend_id_vend_edicc',
 679                                             'type': 'string'
 680                                         },
 681                                         {
 682                                             'name': 'pohead_vend_id_vend_curr_id',
 683                                             'type': 'int'
 684                                         },
 685                                         {
 686                                             'name': 'pohead_vend_id_vend_cntct1_id',
 687                                             'type': 'int'
 688                                         },
 689                                         {
 690                                             'name': 'pohead_vend_id_vend_cntct2_id',
 691                                             'type': 'int'
 692                                         },
 693                                         {
 694                                             'name': 'pohead_vend_id_vend_addr_id',
 695                                             'type': 'int'
 696                                         },
 697                                         {
 698                                             'name': 'pohead_vend_id_vend_match',
 699                                             'type': 'int'
 700                                         },
 701                                         {
 702                                             'name': 'pohead_vend_id_vend_ach_enabled',
 703                                             'type': 'int'
 704                                         },
 705                                         {
 706                                             'name': 'pohead_vend_id_vend_ach_accnttype',
 707                                             'type': 'string'
 708                                         },
 709                                         {
 710                                             'name': 'pohead_vend_id_vend_ach_use_vendinfo',
 711                                             'type': 'int'
 712                                         },
 713                                         {
 714                                             'name': 'pohead_vend_id_vend_ach_indiv_number',
 715                                             'type': 'string'
 716                                         },
 717                                         {
 718                                             'name': 'pohead_vend_id_vend_ach_indiv_name',
 719                                             'type': 'string'
 720                                         },
 721                                         {
 722                                             'name': 'pohead_vend_id_vend_ediemailhtml',
 723                                             'type': 'int'
 724                                         },
 725                                         {
 726                                             'name': 'pohead_vend_id_vend_ach_routingnumber',
 727                                             'type': 'text'
 728                                         },
 729                                         {
 730                                             'name': 'pohead_vend_id_vend_ach_accntnumber',
 731                                             'type': 'text'
 732                                         },
 733                                         {
 734                                             'name': 'pohead_vend_id_vend_taxzone_id',
 735                                             'type': 'int'
 736                                         },
 737                                         {
 738                                             'name': 'pohead_vend_cntct_id_cntct_id',
 739                                             'type': 'int'
 740                                         },
 741                                         {
 742                                             'name': 'pohead_vend_cntct_id_cntct_crmacct_id',
 743                                             'type': 'int'
 744                                         },
 745                                         {
 746                                             'name': 'pohead_vend_cntct_id_cntct_addr_id',
 747                                             'type': 'int'
 748                                         },
 749                                         {
 750                                             'name': 'pohead_vend_cntct_id_cntct_first_name',
 751                                             'type': 'string'
 752                                         },
 753                                         {
 754                                             'name': 'pohead_vend_cntct_id_cntct_last_name',
 755                                             'type': 'string'
 756                                         },
 757                                         {
 758                                             'name': 'pohead_vend_cntct_id_cntct_honorific',
 759                                             'type': 'string'
 760                                         },
 761                                         {
 762                                             'name': 'pohead_vend_cntct_id_cntct_initials',
 763                                             'type': 'string'
 764                                         },
 765                                         {
 766                                             'name': 'pohead_vend_cntct_id_cntct_active',
 767                                             'type': 'int'
 768                                         },
 769                                         {
 770                                             'name': 'pohead_vend_cntct_id_cntct_phone',
 771                                             'type': 'string'
 772                                         },
 773                                         {
 774                                             'name': 'pohead_vend_cntct_id_cntct_phone2',
 775                                             'type': 'string'
 776                                         },
 777                                         {
 778                                             'name': 'pohead_vend_cntct_id_cntct_fax',
 779                                             'type': 'string'
 780                                         },
 781                                         {
 782                                             'name': 'pohead_vend_cntct_id_cntct_email',
 783                                             'type': 'string'
 784                                         },
 785                                         {
 786                                             'name': 'pohead_vend_cntct_id_cntct_webaddr',
 787                                             'type': 'string'
 788                                         },
 789                                         {
 790                                             'name': 'pohead_vend_cntct_id_cntct_notes',
 791                                             'type': 'string'
 792                                         },
 793                                         {
 794                                             'name': 'pohead_vend_cntct_id_cntct_title',
 795                                             'type': 'string'
 796                                         },
 797                                         {
 798                                             'name': 'pohead_vend_cntct_id_cntct_number',
 799                                             'type': 'string'
 800                                         },
 801                                         {
 802                                             'name': 'pohead_vend_cntct_id_cntct_middle',
 803                                             'type': 'string'
 804                                         },
 805                                         {
 806                                             'name': 'pohead_vend_cntct_id_cntct_suffix',
 807                                             'type': 'string'
 808                                         },
 809                                         {
 810                                             'name': 'pohead_vend_cntct_id_cntct_owner_username',
 811                                             'type': 'string'
 812                                         },
 813                                         {
 814                                             'name': 'pohead_vend_cntct_id_cntct_name',
 815                                             'type': 'string'
 816                                         },
 817                                         {
 818                                             'name': 'pohead_terms_id_terms_id',
 819                                             'type': 'int'
 820                                         },
 821                                         {
 822                                             'name': 'pohead_terms_id_terms_code',
 823                                             'type': 'string'
 824                                         },
 825                                         {
 826                                             'name': 'pohead_terms_id_terms_descrip',
 827                                             'type': 'string'
 828                                         },
 829                                         {
 830                                             'name': 'pohead_terms_id_terms_type',
 831                                             'type': 'string'
 832                                         },
 833                                         {
 834                                             'name': 'pohead_terms_id_terms_duedays',
 835                                             'type': 'int'
 836                                         },
 837                                         {
 838                                             'name': 'pohead_terms_id_terms_discdays',
 839                                             'type': 'int'
 840                                         },
 841                                         {
 842                                             'name': 'pohead_terms_id_terms_discprcnt',
 843                                             'type': 'float'
 844                                         },
 845                                         {
 846                                             'name': 'pohead_terms_id_terms_cutoffday',
 847                                             'type': 'int'
 848                                         },
 849                                         {
 850                                             'name': 'pohead_terms_id_terms_ap',
 851                                             'type': 'int'
 852                                         },
 853                                         {
 854                                             'name': 'pohead_terms_id_terms_ar',
 855                                             'type': 'int'
 856                                         },
 857                                         {
 858                                             'name': 'pohead_taxzone_id_taxzone_id',
 859                                             'type': 'int'
 860                                         },
 861                                         {
 862                                             'name': 'pohead_taxzone_id_taxzone_code',
 863                                             'type': 'string'
 864                                         },
 865                                         {
 866                                             'name': 'pohead_taxzone_id_taxzone_descrip',
 867                                             'type': 'string'
 868                                         },
 869                                         {
 870                                             'name': 'pohead_taxtype_id_taxtype_id',
 871                                             'type': 'int'
 872                                         },
 873                                         {
 874                                             'name': 'pohead_taxtype_id_taxtype_name',
 875                                             'type': 'string'
 876                                         },
 877                                         {
 878                                             'name': 'pohead_taxtype_id_taxtype_descrip',
 879                                             'type': 'string'
 880                                         },
 881                                         {
 882                                             'name': 'pohead_taxtype_id_taxtype_sys',
 883                                             'type': 'int'
 884                                         },
 885                                         {
 886                                             'name': 'pohead_shiptoddress_id_addr_id',
 887                                             'type': 'int'
 888                                         },
 889                                         {
 890                                             'name': 'pohead_shiptoddress_id_addr_active',
 891                                             'type': 'int'
 892                                         },
 893                                         {
 894                                             'name': 'pohead_shiptoddress_id_addr_line1',
 895                                             'type': 'string'
 896                                         },
 897                                         {
 898                                             'name': 'pohead_shiptoddress_id_addr_line2',
 899                                             'type': 'string'
 900                                         },
 901                                         {
 902                                             'name': 'pohead_shiptoddress_id_addr_line3',
 903                                             'type': 'string'
 904                                         },
 905                                         {
 906                                             'name': 'pohead_shiptoddress_id_addr_city',
 907                                             'type': 'string'
 908                                         },
 909                                         {
 910                                             'name': 'pohead_shiptoddress_id_addr_state',
 911                                             'type': 'string'
 912                                         },
 913                                         {
 914                                             'name': 'pohead_shiptoddress_id_addr_postalcode',
 915                                             'type': 'string'
 916                                         },
 917                                         {
 918                                             'name': 'pohead_shiptoddress_id_addr_country',
 919                                             'type': 'string'
 920                                         },
 921                                         {
 922                                             'name': 'pohead_shiptoddress_id_addr_notes',
 923                                             'type': 'string'
 924                                         },
 925                                         {
 926                                             'name': 'pohead_shiptoddress_id_addr_number',
 927                                             'type': 'string'
 928                                         },
 929                                         {
 930                                             'name': 'pohead_shipto_cntct_id_cntct_id',
 931                                             'type': 'int'
 932                                         },
 933                                         {
 934                                             'name': 'pohead_shipto_cntct_id_cntct_crmacct_id',
 935                                             'type': 'int'
 936                                         },
 937                                         {
 938                                             'name': 'pohead_shipto_cntct_id_cntct_addr_id',
 939                                             'type': 'int'
 940                                         },
 941                                         {
 942                                             'name': 'pohead_shipto_cntct_id_cntct_first_name',
 943                                             'type': 'string'
 944                                         },
 945                                         {
 946                                             'name': 'pohead_shipto_cntct_id_cntct_last_name',
 947                                             'type': 'string'
 948                                         },
 949                                         {
 950                                             'name': 'pohead_shipto_cntct_id_cntct_honorific',
 951                                             'type': 'string'
 952                                         },
 953                                         {
 954                                             'name': 'pohead_shipto_cntct_id_cntct_initials',
 955                                             'type': 'string'
 956                                         },
 957                                         {
 958                                             'name': 'pohead_shipto_cntct_id_cntct_active',
 959                                             'type': 'int'
 960                                         },
 961                                         {
 962                                             'name': 'pohead_shipto_cntct_id_cntct_phone',
 963                                             'type': 'string'
 964                                         },
 965                                         {
 966                                             'name': 'pohead_shipto_cntct_id_cntct_phone2',
 967                                             'type': 'string'
 968                                         },
 969                                         {
 970                                             'name': 'pohead_shipto_cntct_id_cntct_fax',
 971                                             'type': 'string'
 972                                         },
 973                                         {
 974                                             'name': 'pohead_shipto_cntct_id_cntct_email',
 975                                             'type': 'string'
 976                                         },
 977                                         {
 978                                             'name': 'pohead_shipto_cntct_id_cntct_webaddr',
 979                                             'type': 'string'
 980                                         },
 981                                         {
 982                                             'name': 'pohead_shipto_cntct_id_cntct_notes',
 983                                             'type': 'string'
 984                                         },
 985                                         {
 986                                             'name': 'pohead_shipto_cntct_id_cntct_title',
 987                                             'type': 'string'
 988                                         },
 989                                         {
 990                                             'name': 'pohead_shipto_cntct_id_cntct_number',
 991                                             'type': 'string'
 992                                         },
 993                                         {
 994                                             'name': 'pohead_shipto_cntct_id_cntct_middle',
 995                                             'type': 'string'
 996                                         },
 997                                         {
 998                                             'name': 'pohead_shipto_cntct_id_cntct_suffix',
 999                                             'type': 'string'
1000                                         },
1001                                         {
1002                                             'name': 'pohead_shipto_cntct_id_cntct_owner_username',
1003                                             'type': 'string'
1004                                         },
1005                                         {
1006                                             'name': 'pohead_shipto_cntct_id_cntct_name',
1007                                             'type': 'string'
1008                                         },
1009                                         {
1010                                             'name': 'pohead_cohead_id_cohead_id',
1011                                             'type': 'int'
1012                                         },
1013                                         {
1014                                             'name': 'pohead_cohead_id_cohead_number',
1015                                             'type': 'string'
1016                                         },
1017                                         {
1018                                             'name': 'pohead_cohead_id_cohead_cust_id',
1019                                             'type': 'int'
1020                                         },
1021                                         {
1022                                             'name': 'pohead_cohead_id_cohead_custponumber',
1023                                             'type': 'string'
1024                                         },
1025                                         {
1026                                             'name': 'pohead_cohead_id_cohead_type',
1027                                             'type': 'string'
1028                                         },
1029                                         {
1030                                             'name': 'pohead_cohead_id_cohead_orderdate',
1031                                             'type': 'date'
1032                                         },
1033                                         {
1034                                             'name': 'pohead_cohead_id_cohead_warehous_id',
1035                                             'type': 'int'
1036                                         },
1037                                         {
1038                                             'name': 'pohead_cohead_id_cohead_shipto_id',
1039                                             'type': 'int'
1040                                         },
1041                                         {
1042                                             'name': 'pohead_cohead_id_cohead_shiptoname',
1043                                             'type': 'string'
1044                                         },
1045                                         {
1046                                             'name': 'pohead_cohead_id_cohead_shiptoaddress1',
1047                                             'type': 'string'
1048                                         },
1049                                         {
1050                                             'name': 'pohead_cohead_id_cohead_shiptoaddress2',
1051                                             'type': 'string'
1052                                         },
1053                                         {
1054                                             'name': 'pohead_cohead_id_cohead_shiptoaddress3',
1055                                             'type': 'string'
1056                                         },
1057                                         {
1058                                             'name': 'pohead_cohead_id_cohead_shiptoaddress4',
1059                                             'type': 'string'
1060                                         },
1061                                         {
1062                                             'name': 'pohead_cohead_id_cohead_shiptoaddress5',
1063                                             'type': 'string'
1064                                         },
1065                                         {
1066                                             'name': 'pohead_cohead_id_cohead_salesrep_id',
1067                                             'type': 'int'
1068                                         },
1069                                         {
1070                                             'name': 'pohead_cohead_id_cohead_terms_id',
1071                                             'type': 'int'
1072                                         },
1073                                         {
1074                                             'name': 'pohead_cohead_id_cohead_origin',
1075                                             'type': 'string'
1076                                         },
1077                                         {
1078                                             'name': 'pohead_cohead_id_cohead_fob',
1079                                             'type': 'string'
1080                                         },
1081                                         {
1082                                             'name': 'pohead_cohead_id_cohead_shipvia',
1083                                             'type': 'string'
1084                                         },
1085                                         {
1086                                             'name': 'pohead_cohead_id_cohead_shiptocity',
1087                                             'type': 'string'
1088                                         },
1089                                         {
1090                                             'name': 'pohead_cohead_id_cohead_shiptostate',
1091                                             'type': 'string'
1092                                         },
1093                                         {
1094                                             'name': 'pohead_cohead_id_cohead_shiptozipcode',
1095                                             'type': 'string'
1096                                         },
1097                                         {
1098                                             'name': 'pohead_cohead_id_cohead_freight',
1099                                             'type': 'float'
1100                                         },
1101                                         {
1102                                             'name': 'pohead_cohead_id_cohead_misc',
1103                                             'type': 'float'
1104                                         },
1105                                         {
1106                                             'name': 'pohead_cohead_id_cohead_imported',
1107                                             'type': 'int'
1108                                         },
1109                                         {
1110                                             'name': 'pohead_cohead_id_cohead_ordercomments',
1111                                             'type': 'string'
1112                                         },
1113                                         {
1114                                             'name': 'pohead_cohead_id_cohead_shipcomments',
1115                                             'type': 'string'
1116                                         },
1117                                         {
1118                                             'name': 'pohead_cohead_id_cohead_shiptophone',
1119                                             'type': 'string'
1120                                         },
1121                                         {
1122                                             'name': 'pohead_cohead_id_cohead_shipchrg_id',
1123                                             'type': 'int'
1124                                         },
1125                                         {
1126                                             'name': 'pohead_cohead_id_cohead_shipform_id',
1127                                             'type': 'int'
1128                                         },
1129                                         {
1130                                             'name': 'pohead_cohead_id_cohead_billtoname',
1131                                             'type': 'string'
1132                                         },
1133                                         {
1134                                             'name': 'pohead_cohead_id_cohead_billtoaddress1',
1135                                             'type': 'string'
1136                                         },
1137                                         {
1138                                             'name': 'pohead_cohead_id_cohead_billtoaddress2',
1139                                             'type': 'string'
1140                                         },
1141                                         {
1142                                             'name': 'pohead_cohead_id_cohead_billtoaddress3',
1143                                             'type': 'string'
1144                                         },
1145                                         {
1146                                             'name': 'pohead_cohead_id_cohead_billtocity',
1147                                             'type': 'string'
1148                                         },
1149                                         {
1150                                             'name': 'pohead_cohead_id_cohead_billtostate',
1151                                             'type': 'string'
1152                                         },
1153                                         {
1154                                             'name': 'pohead_cohead_id_cohead_billtozipcode',
1155                                             'type': 'string'
1156                                         },
1157                                         {
1158                                             'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1159                                             'type': 'int'
1160                                         },
1161                                         {
1162                                             'name': 'pohead_cohead_id_cohead_misc_accnt_id',
1163                                             'type': 'int'
1164                                         },
1165                                         {
1166                                             'name': 'pohead_cohead_id_cohead_misc_descrip',
1167                                             'type': 'string'
1168                                         },
1169                                         {
1170                                             'name': 'pohead_cohead_id_cohead_commission',
1171                                             'type': 'float'
1172                                         },
1173                                         {
1174                                             'name': 'pohead_cohead_id_cohead_miscdate',
1175                                             'type': 'date'
1176                                         },
1177                                         {
1178                                             'name': 'pohead_cohead_id_cohead_holdtype',
1179                                             'type': 'string'
1180                                         },
1181                                         {
1182                                             'name': 'pohead_cohead_id_cohead_packdate',
1183                                             'type': 'date'
1184                                         },
1185                                         {
1186                                             'name': 'pohead_cohead_id_cohead_prj_id',
1187                                             'type': 'int'
1188                                         },
1189                                         {
1190                                             'name': 'pohead_cohead_id_cohead_wasquote',
1191                                             'type': 'int'
1192                                         },
1193                                         {
1194                                             'name': 'pohead_cohead_id_cohead_lastupdated',
1195                                             'type': 'date'
1196                                         },
1197                                         {
1198                                             'name': 'pohead_cohead_id_cohead_shipcomplete',
1199                                             'type': 'int'
1200                                         },
1201                                         {
1202                                             'name': 'pohead_cohead_id_cohead_created',
1203                                             'type': 'date'
1204                                         },
1205                                         {
1206                                             'name': 'pohead_cohead_id_cohead_creator',
1207                                             'type': 'string'
1208                                         },
1209                                         {
1210                                             'name': 'pohead_cohead_id_cohead_quote_number',
1211                                             'type': 'string'
1212                                         },
1213                                         {
1214                                             'name': 'pohead_cohead_id_cohead_billtocountry',
1215                                             'type': 'string'
1216                                         },
1217                                         {
1218                                             'name': 'pohead_cohead_id_cohead_shiptocountry',
1219                                             'type': 'string'
1220                                         },
1221                                         {
1222                                             'name': 'pohead_cohead_id_cohead_curr_id',
1223                                             'type': 'int'
1224                                         },
1225                                         {
1226                                             'name': 'pohead_cohead_id_cohead_calcfreight',
1227                                             'type': 'int'
1228                                         },
1229                                         {
1230                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_id',
1231                                             'type': 'int'
1232                                         },
1233                                         {
1234                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_honorific',
1235                                             'type': 'string'
1236                                         },
1237                                         {
1238                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_first_name',
1239                                             'type': 'string'
1240                                         },
1241                                         {
1242                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_middle',
1243                                             'type': 'string'
1244                                         },
1245                                         {
1246                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_last_name',
1247                                             'type': 'string'
1248                                         },
1249                                         {
1250                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_suffix',
1251                                             'type': 'string'
1252                                         },
1253                                         {
1254                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_phone',
1255                                             'type': 'string'
1256                                         },
1257                                         {
1258                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_title',
1259                                             'type': 'string'
1260                                         },
1261                                         {
1262                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_fax',
1263                                             'type': 'string'
1264                                         },
1265                                         {
1266                                             'name': 'pohead_cohead_id_cohead_shipto_cntct_email',
1267                                             'type': 'string'
1268                                         },
1269                                         {
1270                                             'name': 'pohead_cohead_id_cohead_billto_cntct_id',
1271                                             'type': 'int'
1272                                         },
1273                                         {
1274                                             'name': 'pohead_cohead_id_cohead_billto_cntct_honorific',
1275                                             'type': 'string'
1276                                         },
1277                                         {
1278                                             'name': 'pohead_cohead_id_cohead_billto_cntct_first_name',
1279                                             'type': 'string'
1280                                         },
1281                                         {
1282                                             'name': 'pohead_cohead_id_cohead_billto_cntct_middle',
1283                                             'type': 'string'
1284                                         },
1285                                         {
1286                                             'name': 'pohead_cohead_id_cohead_billto_cntct_last_name',
1287                                             'type': 'string'
1288                                         },
1289                                         {
1290                                             'name': 'pohead_cohead_id_cohead_billto_cntct_suffix',
1291                                             'type': 'string'
1292                                         },
1293                                         {
1294                                             'name': 'pohead_cohead_id_cohead_billto_cntct_phone',
1295                                             'type': 'string'
1296                                         },
1297                                         {
1298                                             'name': 'pohead_cohead_id_cohead_billto_cntct_title',
1299                                             'type': 'string'
1300                                         },
1301                                         {
1302                                             'name': 'pohead_cohead_id_cohead_billto_cntct_fax',
1303                                             'type': 'string'
1304                                         },
1305                                         {
1306                                             'name': 'pohead_cohead_id_cohead_billto_cntct_email',
1307                                             'type': 'string'
1308                                         },
1309                                         {
1310                                             'name': 'pohead_cohead_id_cohead_taxzone_id',
1311                                             'type': 'int'
1312                                         },
1313                                         {
1314                                             'name': 'pohead_cohead_id_cohead_taxtype_id',
1315                                             'type': 'int'
1316                                         },
1317                                         {
1318                                             'name': 'pohead_cohead_id_cohead_ophead_id',
1319                                             'type': 'int'
1320                                         },
1321                                         {
1322                                             'name': 'pohead_cohead_id_cohead_status',
1323                                             'type': 'string'
1324                                         },
1325                                         {
1326                                             'name': 'pohead_cohead_id_cohead_targetdate',
1327                                             'type': 'date'
1328                                         },
1329                                         {
1330                                             'name': 'pohead_cohead_id_cohead_location_src',
1331                                             'type': 'int'
1332                                         }
1333                                     ]
1334                                 }
1335                             },
1336                             footer : {
1337                                 xtype: 'PagingToolbar',
1338                                 xns: Roo,
1339                                 pageSize : 25,
1340                                 displayInfo : true,
1341                                 displayMsg : "Displaying pohead{0} - {1} of {2}",
1342                                 emptyMsg : "No pohead found"
1343                             },
1344                             toolbar : {
1345                                 xtype: 'Toolbar',
1346                                 xns: Roo,
1347                                 items : [
1348                                     {
1349                                         xtype: 'ComboBox',
1350                                         xns: Roo.form,
1351                                         listeners : {
1352                                             render : function (_self)
1353                                             {
1354                                               _this.status = _self;
1355                                             },
1356                                             select : function (combo, record, index)
1357                                             {
1358
1359                                                 _this.grid.footer.onClick('first');
1360                                             }
1361                                         },
1362                                         allowBlank : false,
1363                                         displayField : 'fname',
1364                                         editable : false,
1365                                         fieldLabel : 'Status',
1366                                         hiddenName : 'cm_status',
1367                                         listWidth : 200,
1368                                         mode : 'local',
1369                                         name : 'cm_status_name',
1370                                         triggerAction : 'all',
1371                                         value : "OU",
1372                                         valueField : 'ftype',
1373                                         width : 150,
1374                                         store : {
1375                                             xtype: 'SimpleStore',
1376                                             xns: Roo.data,
1377                                             data : [
1378                                                 [ 'OU', "Open And Unreleased"],
1379                                                 [ 'O', "Open"],
1380                                                 [ 'C' , "Closed"],
1381                                                 [ 'U', "Unreleased"],
1382                                                 [ 'E' , "Has Errors" ]
1383                                             ],
1384                                             fields : [  'ftype', 'fname']
1385                                         }
1386                                     },
1387                                     {
1388                                         xtype: 'TextField',
1389                                         xns: Roo.form,
1390                                         listeners : {
1391                                             specialkey : function (_self, e)
1392                                             {
1393                                               _this.grid.footer.onClick('first');
1394                                             },
1395                                             render : function (_self)
1396                                             {
1397                                                 _this.searchBox = _self;
1398                                             }
1399                                         }
1400                                     },
1401                                     {
1402                                         xtype: 'Button',
1403                                         xns: Roo.Toolbar,
1404                                         listeners : {
1405                                             click : function (_self, e)
1406                                             {
1407                                             _this.grid.footer.onClick('first');
1408                                             }
1409                                         },
1410                                         cls : 'x-btn-icon',
1411                                         icon : rootURL + '/Pman/templates/images/search.gif'
1412                                     },
1413                                     {
1414                                         xtype: 'Button',
1415                                         xns: Roo.Toolbar,
1416                                         listeners : {
1417                                             click : function (_self, e)
1418                                             {
1419                                                 _this.searchBox.setValue('');
1420
1421
1422                                                 _this.grid.footer.onClick('first');
1423                                             }
1424                                         },
1425                                         cls : 'x-btn-icon',
1426                                         icon : rootURL + '/Pman/templates/images/edit-clear.gif'
1427                                     },
1428                                     {
1429                                         xtype: 'Fill',
1430                                         xns: Roo.Toolbar
1431                                     },
1432                                     {
1433                                         xtype: 'Button',
1434                                         xns: Roo.Toolbar,
1435                                         listeners : {
1436                                             click : function()
1437                                             {
1438
1439                                                Pman.Dialog.XtuplePurchaseOrderNew.show( {} , function(v) {
1440                                                     Pman.Dialog.XtuplePurchaseOrder.show(v , function() {
1441                                                         _this.grid.footer.onClick('first');
1442                                                     });
1443                                                });
1444                                             }
1445                                         },
1446                                         cls : 'x-btn-text-icon',
1447                                         text : "Add",
1448                                         icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
1449                                     },
1450                                     {
1451                                         xtype: 'Separator',
1452                                         xns: Roo.Toolbar
1453                                     },
1454                                     {
1455                                         xtype: 'Button',
1456                                         xns: Roo.Toolbar,
1457                                         listeners : {
1458                                             click : function (_self, e)
1459                                             {
1460                                                 var sel = _this.grid.selModel.getSelected();
1461                                                 if (!sel) {
1462                                                     Roo.MessageBox.alert("Error", "Select a row");
1463                                                     return;
1464                                                 }
1465
1466                                                 var print = function(){
1467                                                     var params  =   {
1468                                                         template: 'Purchase-Order',
1469                                                         filename : 'Purchase-Order-' + sel.data.pohead_number +
1470                                                             '-' + (new Date()).format('Y-m-d'),
1471                                                         'param[0]':   "pohead_id:number=" + sel.data.pohead_id
1472                                                     };
1473
1474                                                     new Pman.Download({
1475                                                       url : baseURL + '/Xtuple/Print',
1476
1477                                                       params :   params,
1478                                                       method : 'GET'
1479                                                     });
1480                                                     Roo.MessageBox.alert("Notice", "Report will download shortly");
1481
1482                                                 }
1483
1484
1485                                                 if(!sel.data.pohead_printed){
1486                                                     new Pman.Request({
1487                                                         url : baseURL + '/Roo/pohead',
1488                                                         mask : 'Updating',
1489                                                         method : 'POST',
1490                                                         params : {
1491                                                             pohead_id : sel.data.pohead_id,
1492                                                             _print : 1
1493                                                         },
1494                                                         success : function() {
1495                                                             print();
1496                                                         }
1497                                                     });
1498
1499                                                     return;
1500                                                 }
1501
1502                                                 print();
1503
1504                                             }
1505                                         },
1506                                         cls : 'x-btn-text-icon',
1507                                         text : "Print",
1508                                         icon : rootURL + '/Pman/templates/images/pdf.gif'
1509                                     },
1510                                     {
1511                                         xtype: 'Separator',
1512                                         xns: Roo.Toolbar
1513                                     },
1514                                     {
1515                                         xtype: 'Button',
1516                                         xns: Roo.Toolbar,
1517                                         cls : 'x-btn-text-icon',
1518                                         text : "Change Status",
1519                                         icon : Roo.rootURL + 'images/default/tree/leaf.gif',
1520                                         menu : {
1521                                             xtype: 'Menu',
1522                                             xns: Roo.menu,
1523                                             items : [
1524                                                 {
1525                                                     xtype: 'Item',
1526                                                     xns: Roo.menu,
1527                                                     listeners : {
1528                                                         click : function (_self, e)
1529                                                         {
1530                                                             var sel = _this.grid.selModel.getSelected();
1531                                                             if (!sel) {
1532                                                                 Roo.MessageBox.alert("Error", "Select a row");
1533                                                                 return;
1534                                                             }
1535
1536                                                             if (sel.data.pohead_status == 'C') {
1537                                                                 Roo.MessageBox.alert("Error", "Purchase order is already closed");
1538                                                                 return;
1539                                                             }
1540
1541                                                             new Pman.Request({
1542                                                                 url : baseURL + '/Roo/pohead',
1543                                                                 mask : 'Closing',
1544                                                                 method : 'POST',
1545                                                                 params : {
1546                                                                     pohead_id : sel.data.pohead_id,
1547                                                                     _close : 1
1548                                                                 },
1549                                                                 success : function() {
1550                                                                     _this.grid.footer.onClick('refresh');
1551                                                                 }
1552                                                             });
1553
1554
1555                                                         }
1556                                                     },
1557                                                     text : "Close Selected",
1558                                                     icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1559                                                 },
1560                                                 {
1561                                                     xtype: 'Item',
1562                                                     xns: Roo.menu,
1563                                                     listeners : {
1564                                                         click : function (_self, e)
1565                                                         {
1566                                                             var sel = _this.grid.selModel.getSelected();
1567                                                             if (!sel) {
1568                                                                 Roo.MessageBox.alert("Error", "Select a row");
1569                                                                 return;
1570                                                             }
1571
1572
1573                                                             if (sel.data.pohead_status != 'O') {
1574                                                                 Roo.MessageBox.alert("Error", "Purchase order is not Open");
1575                                                                 return;
1576                                                             }
1577
1578                                                             new Pman.Request({
1579                                                                 url : baseURL + '/Roo/pohead',
1580                                                                 mask : 'Unreleasing',
1581                                                                 method : 'POST',
1582                                                                 params : {
1583                                                                     pohead_id : sel.data.pohead_id,
1584                                                                     _unrelease : 1
1585                                                                 },
1586                                                                 success : function() {
1587                                                                     _this.grid.footer.onClick('refresh');
1588                                                                 }
1589                                                             });
1590
1591
1592                                                         }
1593                                                     },
1594                                                     text : "Unrelease Selected",
1595                                                     icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1596                                                 },
1597                                                 {
1598                                                     xtype: 'Item',
1599                                                     xns: Roo.menu,
1600                                                     listeners : {
1601                                                         click : function (_self, e)
1602                                                         {
1603                                                             var sel = _this.grid.selModel.getSelected();
1604                                                             if (!sel) {
1605                                                                 Roo.MessageBox.alert("Error", "Select a row");
1606                                                                 return;
1607                                                             }
1608
1609                                                             if (sel.data.pohead_status == 'O') {
1610                                                                 Roo.MessageBox.alert("Error", "Purchase order is already Open");
1611                                                                 return;
1612                                                             }
1613
1614                                                             new Pman.Request({
1615                                                                 url : baseURL + '/Roo/pohead',
1616                                                                 mask : 'Reopening',
1617                                                                 method : 'POST',
1618                                                                 params : {
1619                                                                     pohead_id : sel.data.pohead_id,
1620                                                                     _reopen : 1
1621                                                                 },
1622                                                                 success : function() {
1623                                                                     _this.grid.footer.onClick('refresh');
1624                                                                 }
1625                                                             });
1626
1627
1628                                                         }
1629                                                     },
1630                                                     text : "Reopen",
1631                                                     icon : Roo.rootURL + 'images/default/tree/leaf.gif'
1632                                                 }
1633                                             ]
1634                                         }
1635                                     },
1636                                     {
1637                                         xtype: 'Separator',
1638                                         xns: Roo.Toolbar
1639                                     },
1640                                     {
1641                                         xtype: 'TextItem',
1642                                         xns: Roo.Toolbar,
1643                                         text : "Report Since"
1644                                     },
1645                                     {
1646                                         xtype: 'DateField',
1647                                         xns: Roo.form,
1648                                         listeners : {
1649                                             render : function (_self)
1650                                             {
1651                                                 _this.reportSince = _self;
1652
1653                                                 this.setValue((new Date()).add(Date.MONTH, -1)) ; //.format('Y-m-d');
1654                                             }
1655                                         },
1656                                         format : 'd/M/Y',
1657                                         useIso : true,
1658                                         width : 100
1659                                     },
1660                                     {
1661                                         xtype: 'Button',
1662                                         xns: Roo.Toolbar,
1663                                         cls : 'x-btn-text-icon',
1664                                         text : "Reports",
1665                                         icon : rootURL + '/Pman/templates/images/spreadsheet.gif',
1666                                         menu : {
1667                                             xtype: 'Menu',
1668                                             xns: Roo.menu,
1669                                             items : [
1670                                                 {
1671                                                     xtype: 'Item',
1672                                                     xns: Roo.menu,
1673                                                     text : "AP Aging Report",
1674                                                     menu : {
1675                                                         xtype: 'Menu',
1676                                                         xns: Roo.menu,
1677                                                         items : [
1678                                                             {
1679                                                                 xtype: 'Item',
1680                                                                 xns: Roo.menu,
1681                                                                 listeners : {
1682                                                                     click : function (_self, e)
1683                                                                     {
1684                                                                         var dt = (new Date()).format('Y-m-d');
1685
1686                                                                         var params = {
1687                                                                             '_group' : 'apAging',
1688                                                                             '_name' : 'bydate',
1689                                                                             'limit' : 99999,
1690                                                                             'relDate:text' : dt,
1691                                                                             'useDocDate:text' : 'TRUE',
1692                                                                             'csvTitles' : '*',
1693                                                                             'csvCols' : '*'
1694                                                                         };
1695                                                                         var s = _this.grid.getSelectionModel().getSelected();
1696
1697                                                                         if(s){
1698                                                                             if(s.data.pohead_vend_id > 0){
1699                                                                                 params['vend_id:number'] = s.data.pohead_vend_id;
1700                                                                             }
1701                                                                         }
1702
1703                                                                         new Pman.Download({\r
1704                                                                           url : baseURL + '/Roo/Metasql',\r
1705                                                                           params :   params,\r
1706                                                                           method : 'GET'\r
1707                                                                         });\r
1708                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");\r
1709                                                                         \r
1710                                                                     }
1711                                                                 },
1712                                                                 text : "as Excel"
1713                                                             },
1714                                                             {
1715                                                                 xtype: 'Item',
1716                                                                 xns: Roo.menu,
1717                                                                 listeners : {
1718                                                                     click : function (_self, e)
1719                                                                     {
1720
1721                                                                         var params  =   {
1722                                                                             template: 'APAging',
1723                                                                             filename : 'ARAging-' + (new Date()).format('Y-m-d'),
1724                                                                             'param[0]':   "relDate:string='" + (new Date()).format('Y-m-d') + "'",
1725                                                                             'param[1]':   "useDocDate:number=1"
1726                                                                         };
1727
1728                                                                         var s = _this.grid.getSelectionModel().getSelected();
1729
1730                                                                         if(s){
1731                                                                             if(s.data.pohead_vend_id > 0){
1732                                                                                 params['param[2]'] = 'vend_id:number=' + s.data.pohead_vend_id;
1733                                                                             }
1734                                                                         }
1735
1736
1737                                                                         new Pman.Download({
1738                                                                           url : baseURL + '/Xtuple/Print',
1739                                                                           params :   params,
1740                                                                           method : 'GET'
1741                                                                         });
1742                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");
1743                                                                     }
1744                                                                 },
1745                                                                 text : "as PDF"
1746                                                             }
1747                                                         ]
1748                                                     }
1749                                                 },
1750                                                 {
1751                                                     xtype: 'Item',
1752                                                     xns: Roo.menu,
1753                                                     text : "Goods Reciept Report",
1754                                                     menu : {
1755                                                         xtype: 'Menu',
1756                                                         xns: Roo.menu,
1757                                                         items : [
1758                                                             {
1759                                                                 xtype: 'Item',
1760                                                                 xns: Roo.menu,
1761                                                                 listeners : {
1762                                                                     click : function (_self, e)
1763                                                                     {
1764                                                                         var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1765
1766                                                                         var params = {
1767                                                                             '_group' : 'recvgrp',
1768                                                                             '_name' : 'byorder',
1769                                                                             'limit' : 99999,
1770                                                                             'startDate:text' : dt.format('Y-m-d'),
1771                                                                             'endDate:text' : dt.add(Date.MONTH,1).format('Y-m-d'),
1772                                                                             'csvTitles' : '*',
1773                                                                             'csvCols' : '*'
1774                                                                         };
1775
1776                                                                         new Pman.Download({\r
1777                                                                           url : baseURL + '/Roo/Metasql',\r
1778                                                                           params :   params,\r
1779                                                                           method : 'GET'\r
1780                                                                         });\r
1781                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");\r
1782                                                                         \r
1783                                                                     }
1784                                                                 },
1785                                                                 text : "For 1 month"
1786                                                             },
1787                                                             {
1788                                                                 xtype: 'Item',
1789                                                                 xns: Roo.menu,
1790                                                                 listeners : {
1791                                                                     click : function (_self, e)
1792                                                                     {
1793                                                                         var dt = Date.parseDate( _this.reportSince.getValue(), 'Y-m-d');
1794
1795                                                                         var params = {
1796                                                                             '_group' : 'recvgrp',
1797                                                                             '_name' : 'byorder',
1798                                                                             'limit' : 99999,
1799                                                                             'startDate:text' : dt.format('Y-m-d'),
1800                                                                             'endDate:text' : dt.add(Date.YEAR,1).format('Y-m-d'),
1801                                                                             'csvTitles' : '*',
1802                                                                             'csvCols' : '*'
1803                                                                         };
1804
1805                                                                         new Pman.Download({\r
1806                                                                           url : baseURL + '/Roo/Metasql',\r
1807                                                                           params :   params,\r
1808                                                                           method : 'GET'\r
1809                                                                         });\r
1810                                                                         Roo.MessageBox.alert("Notice", "Report will download shortly");\r
1811                                                                         \r
1812                                                                     }
1813                                                                 },
1814                                                                 text : "For 1 year"
1815                                                             }
1816                                                         ]
1817                                                     }
1818                                                 }
1819                                             ]
1820                                         }
1821                                     }
1822                                 ]
1823                             },
1824                             colModel : [
1825                                 {
1826                                     xtype: 'ColumnModel',
1827                                     xns: Roo.grid,
1828                                     dataIndex : 'pohead_number',
1829                                     header : 'No#',
1830                                     sortable : true,
1831                                     width : 150,
1832                                     renderer : function(v,x,r) {
1833                                         var vv =v;
1834                                         var nn  = '';
1835                                         if (vv.indexOf(',') > -1) {
1836                                             vv = vv.split(',').shift();
1837
1838                                         }
1839                                         if (vv.match(/^NSPO-/)) {
1840                                             vv = vv.replace(/^NSPO-/, '');
1841                                             nn = 'ns:&nbsp;';
1842                                         }
1843
1844                                         return String.format('<i>'+ nn +'</i><b qtip="{1}">{0}</b> {2}', vv,v, r.data.pohead_comments );
1845
1846
1847                                      }
1848                                 },
1849                                 {
1850                                     xtype: 'ColumnModel',
1851                                     xns: Roo.grid,
1852                                     dataIndex : 'pohead_orderdate',
1853                                     header : 'Ordered',
1854                                     sortable : true,
1855                                     width : 75,
1856                                     renderer : function(v) { return String.format('{0}', v ? v.format('d/M/Y') : ''); }
1857                                 },
1858                                 {
1859                                     xtype: 'ColumnModel',
1860                                     xns: Roo.grid,
1861                                     dataIndex : 'pohead_vend_id_vend_name',
1862                                     header : 'Vendor',
1863                                     sortable : true,
1864                                     width : 75,
1865                                     renderer : function(v) { return String.format('{0}', v); }
1866                                 },
1867                                 {
1868                                     xtype: 'ColumnModel',
1869                                     xns: Roo.grid,
1870                                     dataIndex : 'pohead_curr_id_curr_abbr',
1871                                     header : 'Currency',
1872                                     width : 75,
1873                                     renderer : function(v) { return String.format('{0}', v); }
1874                                 },
1875                                 {
1876                                     xtype: 'ColumnModel',
1877                                     xns: Roo.grid,
1878                                     align : 'right',
1879                                     dataIndex : 'pohead_val',
1880                                     header : 'PO value',
1881                                     width : 75,
1882                                     renderer : function(v,x,r) {
1883
1884                                         var f = (Math.round(v*100) != Math.round(r.data.pohead_vouchered*100)) ? '<span style="color:red;font-weight:bold">{0}</span>' : '{0}';
1885                                         return String.format(f,  v ? Roo.util.Format.usMoney( v) : '' );
1886
1887                                      }
1888                                 },
1889                                 {
1890                                     xtype: 'ColumnModel',
1891                                     xns: Roo.grid,
1892                                     align : 'right',
1893                                     dataIndex : 'pohead_vouchered',
1894                                     header : 'Vouchered',
1895                                     width : 75,
1896                                     renderer : function(v,x,r) {
1897
1898                                         Roo.log(v*1);
1899                                         var f =  '<span style="{0}">{1}</span>';
1900
1901                                         var style = '';
1902
1903                                         if(Math.round(v*100) != Math.round(r.data.pohead_paid*100)){
1904                                             style = 'color:red;font-weight:bold';
1905                                         }
1906
1907                                         if(Math.round(v*100) < Math.round(r.data.pohead_val*100)){
1908                                             f = '<img class="x-grid-check-icon" src="' + Roo.BLANK_IMAGE_URL + '"/> &nbsp;' +
1909                                                  '<span style="{0}">{1}</span>';
1910                                         }
1911
1912                                         return String.format(f,  style, v * 1 ? Roo.util.Format.usMoney(v) : '' );
1913                                      }
1914                                 },
1915                                 {
1916                                     xtype: 'ColumnModel',
1917                                     xns: Roo.grid,
1918                                     align : 'right',
1919                                     dataIndex : 'pohead_paid',
1920                                     header : 'Paid',
1921                                     width : 75,
1922                                     renderer : function(v) { return v ? Roo.util.Format.usMoney( v) : ''; }
1923                                 },
1924                                 {
1925                                     xtype: 'ColumnModel',
1926                                     xns: Roo.grid,
1927                                     align : 'right',
1928                                     dataIndex : 'landed_cost',
1929                                     header : 'Landed',
1930                                     width : 75,
1931                                     renderer : function(v,x,r) {
1932                                         if (r.data.landed_missing * 1) {
1933                                                 return v ? ('<b style="color:red">' + Roo.util.Format.usMoney( v) + '</b>') : '';
1934                                         }
1935
1936                                         return v ? Roo.util.Format.usMoney( v) : '';
1937                                     }
1938                                 },
1939                                 {
1940                                     xtype: 'ColumnModel',
1941                                     xns: Roo.grid,
1942                                     align : 'right',
1943                                     dataIndex : 'pohead_qty',
1944                                     header : 'Order Qty',
1945                                     width : 75,
1946                                     renderer : function(v) { return String.format('{0}', v ? (1*v).toFixed(0) : ''); }
1947                                 },
1948                                 {
1949                                     xtype: 'ColumnModel',
1950                                     xns: Roo.grid,
1951                                     align : 'right',
1952                                     dataIndex : 'pohead_qty_in_transit',
1953                                     header : 'In Transit',
1954                                     hidden : true,
1955                                     width : 75,
1956                                     renderer : function(v,x,r) {
1957                                          var vv = v - (1*r.data.pohead_qty_transfered_unposted) -
1958                                              (1*r.data.pohead_qty_transfered) ;
1959                                          return String.format('{0}',vv ? (1*vv).toFixed(0) : '');
1960
1961                                      }
1962                                 },
1963                                 {
1964                                     xtype: 'ColumnModel',
1965                                     xns: Roo.grid,
1966                                     align : 'right',
1967                                     dataIndex : 'pohead_qty_recv',
1968                                     header : 'Received',
1969                                     width : 75,
1970                                     renderer : function(v,x,r) {
1971
1972                                         // total recieved = recv + recv_transfered - intransit?
1973
1974                                         // old style = 0 in transit
1975                                         // all delivered direct to warehouse
1976                                         // 0 in
1977
1978                                         // new style = 100 in transit
1979                                         // it will record 100 in transit, and 100 recieved
1980                                         // and
1981
1982                                         // recv 610,unposted = 0 , transfer 610, in transit 610
1983
1984                                          var recv = (1*r.data.pohead_qty_recv) +
1985                                                (1*r.data.pohead_qty_transfered_unposted) +
1986                                                  (1*r.data.pohead_qty_transfered)  ;
1987
1988
1989                                         if(r.data.pohead_qty_transfered_unposted * 1 > 0){
1990                                             return String.format('<b style="color:red" qtip="{1} are Unposted">{0}</b>', recv ? (1*recv).toFixed(0) : '',
1991                                             r.data.pohead_qty_transfered_unposted);
1992                                         }
1993
1994                                         var format = '{0}';
1995                                         if(recv != r.data.pohead_qty){
1996                                             format = '<span style="color:red">{0}</span>';
1997                                         }
1998
1999                                         return String.format(format, recv ? (1*recv).toFixed(0) : '');
2000
2001                                      }
2002                                 }
2003                             ]
2004                         }
2005                     },
2006                     {
2007                         xtype: 'NestedLayoutPanel',
2008                         xns: Roo,
2009                         background : true,
2010                         fitContainer : true,
2011                         fitToFrame : true,
2012                         region : 'east',
2013                         layout : {
2014                             xtype: 'BorderLayout',
2015                             xns: Roo,
2016                             items : [
2017                                 {
2018                                     xtype: 'GridPanel',
2019                                     xns: Roo,
2020                                     listeners : {
2021                                         activate : function() {
2022                                             _this.rgpanel = this;
2023                                             if (_this.rggrid) {
2024                                                 //_this.rggrid.ds.load({});
2025                                             }
2026                                         }
2027                                     },
2028                                     background : true,
2029                                     fitContainer : true,
2030                                     fitToframe : true,
2031                                     region : 'center',
2032                                     tableName : 'recvgrp',
2033                                     title : "recvgrp",
2034                                     grid : {
2035                                         xtype: 'Grid',
2036                                         xns: Roo.grid,
2037                                         listeners : {
2038                                             render : function()
2039                                             {
2040                                                 _this.rggrid = this;
2041                                                 //_this.dialog = Pman.Dialog.FILL_IN
2042                                                 if (_this.rgpanel.active) {
2043                                                    //this.ds.load({});
2044                                                 }
2045                                             },
2046                                             rowdblclick : function (_self, rowIndex, e)
2047                                             {
2048                                                  var s  = _this.rggrid.ds.getAt(rowIndex);
2049
2050                                                 Pman.Dialog.XtupleRecvGrp.show( {
2051                                                      recvgrp_id : s.data.recvgrp_id
2052
2053                                                  } , function() {
2054                                                     _this.grid.footer.onClick('refresh');
2055                                                });
2056                                             },
2057                                             rowclick : function (_self, rowIndex, e)
2058                                             {
2059                                                 (function() { _this.rgrid.footer.onClick('first');}).defer(100);
2060                                             }
2061                                         },
2062                                         autoExpandColumn : 'recvgrp_number',
2063                                         loadMask : true,
2064                                         dataSource : {
2065                                             xtype: 'Store',
2066                                             xns: Roo.data,
2067                                             listeners : {
2068                                                 beforeload : function (_self, options)
2069                                                 {
2070                                                     if (!_this.grid || !_this.grid.selModel.getSelected()) {
2071                                                          this.removeAll();
2072                                                          if (_this.rgrid) {
2073                                                             _this.rgrid.ds.removeAll();
2074                                                         }
2075                                                         return false;
2076                                                     }
2077                                                     var r = _this.grid.selModel.getSelected();
2078
2079
2080                                                     options.params = options.params || {};
2081                                                     options.params.recvgrp_pohead_id = r.data.pohead_id;
2082
2083                                                 },
2084                                                 load : function (_self, records, options)
2085                                                 {
2086                                                     _this.rgrid.footer.onClick('first');
2087                                                 }
2088                                             },
2089                                             remoteSort : true,
2090                                             sortInfo : { field : 'recvgrp_id', direction: 'ASC' },
2091                                             proxy : {
2092                                                 xtype: 'HttpProxy',
2093                                                 xns: Roo.data,
2094                                                 method : 'GET',
2095                                                 url : baseURL + '/Roo/recvgrp.php'
2096                                             },
2097                                             reader : {
2098                                                 xtype: 'JsonReader',
2099                                                 xns: Roo.data,
2100                                                 totalProperty : 'total',
2101                                                 root : 'data',
2102                                                 id : 'id',
2103                                                 fields : [
2104                                                     {
2105                                                         'name': 'recv_id',
2106                                                         'type': 'int'
2107                                                     },
2108                                                     {
2109                                                         'name': 'recv_order_type',
2110                                                         'type': 'string'
2111                                                     },
2112                                                     {
2113                                                         'name': 'recv_order_number',
2114                                                         'type': 'string'
2115                                                     },
2116                                                     {
2117                                                         'name': 'recv_orderitem_id',
2118                                                         'type': 'int'
2119                                                     },
2120                                                     {
2121                                                         'name': 'recv_agent_username',
2122                                                         'type': 'string'
2123                                                     },
2124                                                     {
2125                                                         'name': 'recv_itemsite_id',
2126                                                         'type': 'int'
2127                                                     },
2128                                                     {
2129                                                         'name': 'recv_vend_id',
2130                                                         'type': 'int'
2131                                                     },
2132                                                     {
2133                                                         'name': 'recv_vend_item_number',
2134                                                         'type': 'string'
2135                                                     },
2136                                                     {
2137                                                         'name': 'recv_vend_item_descrip',
2138                                                         'type': 'string'
2139                                                     },
2140                                                     {
2141                                                         'name': 'recv_vend_uom',
2142                                                         'type': 'string'
2143                                                     },
2144                                                     {
2145                                                         'name': 'recv_purchcost',
2146                                                         'type': 'float'
2147                                                     },
2148                                                     {
2149                                                         'name': 'recv_purchcost_curr_id',
2150                                                         'type': 'int'
2151                                                     },
2152                                                     {
2153                                                         'name': 'recv_duedate',
2154                                                         'type': 'date',
2155                                                         'dateFormat': 'Y-m-d'
2156                                                     },
2157                                                     {
2158                                                         'name': 'recv_qty',
2159                                                         'type': 'float'
2160                                                     },
2161                                                     {
2162                                                         'name': 'recv_recvcost',
2163                                                         'type': 'float'
2164                                                     },
2165                                                     {
2166                                                         'name': 'recv_recvcost_curr_id',
2167                                                         'type': 'int'
2168                                                     },
2169                                                     {
2170                                                         'name': 'recv_freight',
2171                                                         'type': 'float'
2172                                                     },
2173                                                     {
2174                                                         'name': 'recv_freight_curr_id',
2175                                                         'type': 'int'
2176                                                     },
2177                                                     {
2178                                                         'name': 'recv_date',
2179                                                         'type': 'date',
2180                                                         'dateFormat': 'Y-m-d'
2181                                                     },
2182                                                     {
2183                                                         'name': 'recv_value',
2184                                                         'type': 'float'
2185                                                     },
2186                                                     {
2187                                                         'name': 'recv_posted',
2188                                                         'type': 'int'
2189                                                     },
2190                                                     {
2191                                                         'name': 'recv_invoiced',
2192                                                         'type': 'int'
2193                                                     },
2194                                                     {
2195                                                         'name': 'recv_vohead_id',
2196                                                         'type': 'int'
2197                                                     },
2198                                                     {
2199                                                         'name': 'recv_voitem_id',
2200                                                         'type': 'int'
2201                                                     },
2202                                                     {
2203                                                         'name': 'recv_trans_usr_name',
2204                                                         'type': 'string'
2205                                                     },
2206                                                     {
2207                                                         'name': 'recv_notes',
2208                                                         'type': 'string'
2209                                                     },
2210                                                     {
2211                                                         'name': 'recv_gldistdate',
2212                                                         'type': 'date',
2213                                                         'dateFormat': 'Y-m-d'
2214                                                     },
2215                                                     {
2216                                                         'name': 'recv_splitfrom_id',
2217                                                         'type': 'int'
2218                                                     },
2219                                                     {
2220                                                         'name': 'recv_rlsd_duedate',
2221                                                         'type': 'date',
2222                                                         'dateFormat': 'Y-m-d'
2223                                                     },
2224                                                     {
2225                                                         'name': 'recv_voitem_id_voitem_id',
2226                                                         'type': 'int'
2227                                                     },
2228                                                     {
2229                                                         'name': 'recv_voitem_id_voitem_vohead_id',
2230                                                         'type': 'int'
2231                                                     },
2232                                                     {
2233                                                         'name': 'recv_voitem_id_voitem_poitem_id',
2234                                                         'type': 'int'
2235                                                     },
2236                                                     {
2237                                                         'name': 'recv_voitem_id_voitem_close',
2238                                                         'type': 'int'
2239                                                     },
2240                                                     {
2241                                                         'name': 'recv_voitem_id_voitem_qty',
2242                                                         'type': 'float'
2243                                                     },
2244                                                     {
2245                                                         'name': 'recv_voitem_id_voitem_freight',
2246                                                         'type': 'float'
2247                                                     },
2248                                                     {
2249                                                         'name': 'recv_voitem_id_voitem_taxtype_id',
2250                                                         'type': 'int'
2251                                                     },
2252                                                     {
2253                                                         'name': 'recv_vohead_id_vohead_id',
2254                                                         'type': 'int'
2255                                                     },
2256                                                     {
2257                                                         'name': 'recv_vohead_id_vohead_number',
2258                                                         'type': 'string'
2259                                                     },
2260                                                     {
2261                                                         'name': 'recv_vohead_id_vohead_pohead_id',
2262                                                         'type': 'int'
2263                                                     },
2264                                                     {
2265                                                         'name': 'recv_vohead_id_vohead_posted',
2266                                                         'type': 'int'
2267                                                     },
2268                                                     {
2269                                                         'name': 'recv_vohead_id_vohead_duedate',
2270                                                         'type': 'date'
2271                                                     },
2272                                                     {
2273                                                         'name': 'recv_vohead_id_vohead_invcnumber',
2274                                                         'type': 'string'
2275                                                     },
2276                                                     {
2277                                                         'name': 'recv_vohead_id_vohead_amount',
2278                                                         'type': 'float'
2279                                                     },
2280                                                     {
2281                                                         'name': 'recv_vohead_id_vohead_docdate',
2282                                                         'type': 'date'
2283                                                     },
2284                                                     {
2285                                                         'name': 'recv_vohead_id_vohead_1099',
2286                                                         'type': 'int'
2287                                                     },
2288                                                     {
2289                                                         'name': 'recv_vohead_id_vohead_distdate',
2290                                                         'type': 'date'
2291                                                     },
2292                                                     {
2293                                                         'name': 'recv_vohead_id_vohead_reference',
2294                                                         'type': 'string'
2295                                                     },
2296                                                     {
2297                                                         'name': 'recv_vohead_id_vohead_terms_id',
2298                                                         'type': 'int'
2299                                                     },
2300                                                     {
2301                                                         'name': 'recv_vohead_id_vohead_vend_id',
2302                                                         'type': 'int'
2303                                                     },
2304                                                     {
2305                                                         'name': 'recv_vohead_id_vohead_curr_id',
2306                                                         'type': 'int'
2307                                                     },
2308                                                     {
2309                                                         'name': 'recv_vohead_id_vohead_adjtaxtype_id',
2310                                                         'type': 'int'
2311                                                     },
2312                                                     {
2313                                                         'name': 'recv_vohead_id_vohead_freighttaxtype_id',
2314                                                         'type': 'int'
2315                                                     },
2316                                                     {
2317                                                         'name': 'recv_vohead_id_vohead_gldistdate',
2318                                                         'type': 'date'
2319                                                     },
2320                                                     {
2321                                                         'name': 'recv_vohead_id_vohead_misc',
2322                                                         'type': 'int'
2323                                                     },
2324                                                     {
2325                                                         'name': 'recv_vohead_id_vohead_taxzone_id',
2326                                                         'type': 'int'
2327                                                     },
2328                                                     {
2329                                                         'name': 'recv_vohead_id_vohead_taxtype_id',
2330                                                         'type': 'int'
2331                                                     },
2332                                                     {
2333                                                         'name': 'recv_vohead_id_vohead_notes',
2334                                                         'type': 'string'
2335                                                     },
2336                                                     {
2337                                                         'name': 'recv_vend_id_vend_id',
2338                                                         'type': 'int'
2339                                                     },
2340                                                     {
2341                                                         'name': 'recv_vend_id_vend_name',
2342                                                         'type': 'string'
2343                                                     },
2344                                                     {
2345                                                         'name': 'recv_vend_id_vend_lastpurchdate',
2346                                                         'type': 'date'
2347                                                     },
2348                                                     {
2349                                                         'name': 'recv_vend_id_vend_active',
2350                                                         'type': 'int'
2351                                                     },
2352                                                     {
2353                                                         'name': 'recv_vend_id_vend_po',
2354                                                         'type': 'int'
2355                                                     },
2356                                                     {
2357                                                         'name': 'recv_vend_id_vend_comments',
2358                                                         'type': 'string'
2359                                                     },
2360                                                     {
2361                                                         'name': 'recv_vend_id_vend_pocomments',
2362                                                         'type': 'string'
2363                                                     },
2364                                                     {
2365                                                         'name': 'recv_vend_id_vend_number',
2366                                                         'type': 'string'
2367                                                     },
2368                                                     {
2369                                                         'name': 'recv_vend_id_vend_1099',
2370                                                         'type': 'int'
2371                                                     },
2372                                                     {
2373                                                         'name': 'recv_vend_id_vend_exported',
2374                                                         'type': 'int'
2375                                                     },
2376                                                     {
2377                                                         'name': 'recv_vend_id_vend_fobsource',
2378                                                         'type': 'string'
2379                                                     },
2380                                                     {
2381                                                         'name': 'recv_vend_id_vend_fob',
2382                                                         'type': 'string'
2383                                                     },
2384                                                     {
2385                                                         'name': 'recv_vend_id_vend_terms_id',
2386                                                         'type': 'int'
2387                                                     },
2388                                                     {
2389                                                         'name': 'recv_vend_id_vend_shipvia',
2390                                                         'type': 'string'
2391                                                     },
2392                                                     {
2393                                                         'name': 'recv_vend_id_vend_vendtype_id',
2394                                                         'type': 'int'
2395                                                     },
2396                                                     {
2397                                                         'name': 'recv_vend_id_vend_qualified',
2398                                                         'type': 'int'
2399                                                     },
2400                                                     {
2401                                                         'name': 'recv_vend_id_vend_ediemail',
2402                                                         'type': 'string'
2403                                                     },
2404                                                     {
2405                                                         'name': 'recv_vend_id_vend_ediemailbody',
2406                                                         'type': 'string'
2407                                                     },
2408                                                     {
2409                                                         'name': 'recv_vend_id_vend_edisubject',
2410                                                         'type': 'string'
2411                                                     },
2412                                                     {
2413                                                         'name': 'recv_vend_id_vend_edifilename',
2414                                                         'type': 'string'
2415                                                     },
2416                                                     {
2417                                                         'name': 'recv_vend_id_vend_accntnum',
2418                                                         'type': 'string'
2419                                                     },
2420                                                     {
2421                                                         'name': 'recv_vend_id_vend_emailpodelivery',
2422                                                         'type': 'int'
2423                                                     },
2424                                                     {
2425                                                         'name': 'recv_vend_id_vend_restrictpurch',
2426                                                         'type': 'int'
2427                                                     },
2428                                                     {
2429                                                         'name': 'recv_vend_id_vend_edicc',
2430                                                         'type': 'string'
2431                                                     },
2432                                                     {
2433                                                         'name': 'recv_vend_id_vend_curr_id',
2434                                                         'type': 'int'
2435                                                     },
2436                                                     {
2437                                                         'name': 'recv_vend_id_vend_cntct1_id',
2438                                                         'type': 'int'
2439                                                     },
2440                                                     {
2441                                                         'name': 'recv_vend_id_vend_cntct2_id',
2442                                                         'type': 'int'
2443                                                     },
2444                                                     {
2445                                                         'name': 'recv_vend_id_vend_addr_id',
2446                                                         'type': 'int'
2447                                                     },
2448                                                     {
2449                                                         'name': 'recv_vend_id_vend_match',
2450                                                         'type': 'int'
2451                                                     },
2452                                                     {
2453                                                         'name': 'recv_vend_id_vend_ach_enabled',
2454                                                         'type': 'int'
2455                                                     },
2456                                                     {
2457                                                         'name': 'recv_vend_id_vend_ach_accnttype',
2458                                                         'type': 'string'
2459                                                     },
2460                                                     {
2461                                                         'name': 'recv_vend_id_vend_ach_use_vendinfo',
2462                                                         'type': 'int'
2463                                                     },
2464                                                     {
2465                                                         'name': 'recv_vend_id_vend_ach_indiv_number',
2466                                                         'type': 'string'
2467                                                     },
2468                                                     {
2469                                                         'name': 'recv_vend_id_vend_ach_indiv_name',
2470                                                         'type': 'string'
2471                                                     },
2472                                                     {
2473                                                         'name': 'recv_vend_id_vend_ediemailhtml',
2474                                                         'type': 'int'
2475                                                     },
2476                                                     {
2477                                                         'name': 'recv_vend_id_vend_ach_routingnumber',
2478                                                         'type': 'text'
2479                                                     },
2480                                                     {
2481                                                         'name': 'recv_vend_id_vend_ach_accntnumber',
2482                                                         'type': 'text'
2483                                                     },
2484                                                     {
2485                                                         'name': 'recv_vend_id_vend_taxzone_id',
2486                                                         'type': 'int'
2487                                                     },
2488                                                     {
2489                                                         'name': 'recv_splitfrom_id_recv_id',
2490                                                         'type': 'int'
2491                                                     },
2492                                                     {
2493                                                         'name': 'recv_splitfrom_id_recv_order_type',
2494                                                         'type': 'string'
2495                                                     },
2496                                                     {
2497                                                         'name': 'recv_splitfrom_id_recv_order_number',
2498                                                         'type': 'string'
2499                                                     },
2500                                                     {
2501                                                         'name': 'recv_splitfrom_id_recv_orderitem_id',
2502                                                         'type': 'int'
2503                                                     },
2504                                                     {
2505                                                         'name': 'recv_splitfrom_id_recv_agent_username',
2506                                                         'type': 'string'
2507                                                     },
2508                                                     {
2509                                                         'name': 'recv_splitfrom_id_recv_itemsite_id',
2510                                                         'type': 'int'
2511                                                     },
2512                                                     {
2513                                                         'name': 'recv_splitfrom_id_recv_vend_id',
2514                                                         'type': 'int'
2515                                                     },
2516                                                     {
2517                                                         'name': 'recv_splitfrom_id_recv_vend_item_number',
2518                                                         'type': 'string'
2519                                                     },
2520                                                     {
2521                                                         'name': 'recv_splitfrom_id_recv_vend_item_descrip',
2522                                                         'type': 'string'
2523                                                     },
2524                                                     {
2525                                                         'name': 'recv_splitfrom_id_recv_vend_uom',
2526                                                         'type': 'string'
2527                                                     },
2528                                                     {
2529                                                         'name': 'recv_splitfrom_id_recv_purchcost',
2530                                                         'type': 'float'
2531                                                     },
2532                                                     {
2533                                                         'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
2534                                                         'type': 'int'
2535                                                     },
2536                                                     {
2537                                                         'name': 'recv_splitfrom_id_recv_duedate',
2538                                                         'type': 'date'
2539                                                     },
2540                                                     {
2541                                                         'name': 'recv_splitfrom_id_recv_qty',
2542                                                         'type': 'float'
2543                                                     },
2544                                                     {
2545                                                         'name': 'recv_splitfrom_id_recv_recvcost',
2546                                                         'type': 'float'
2547                                                     },
2548                                                     {
2549                                                         'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
2550                                                         'type': 'int'
2551                                                     },
2552                                                     {
2553                                                         'name': 'recv_splitfrom_id_recv_freight',
2554                                                         'type': 'float'
2555                                                     },
2556                                                     {
2557                                                         'name': 'recv_splitfrom_id_recv_freight_curr_id',
2558                                                         'type': 'int'
2559                                                     },
2560                                                     {
2561                                                         'name': 'recv_splitfrom_id_recv_date',
2562                                                         'type': 'date'
2563                                                     },
2564                                                     {
2565                                                         'name': 'recv_splitfrom_id_recv_value',
2566                                                         'type': 'float'
2567                                                     },
2568                                                     {
2569                                                         'name': 'recv_splitfrom_id_recv_posted',
2570                                                         'type': 'int'
2571                                                     },
2572                                                     {
2573                                                         'name': 'recv_splitfrom_id_recv_invoiced',
2574                                                         'type': 'int'
2575                                                     },
2576                                                     {
2577                                                         'name': 'recv_splitfrom_id_recv_vohead_id',
2578                                                         'type': 'int'
2579                                                     },
2580                                                     {
2581                                                         'name': 'recv_splitfrom_id_recv_voitem_id',
2582                                                         'type': 'int'
2583                                                     },
2584                                                     {
2585                                                         'name': 'recv_splitfrom_id_recv_trans_usr_name',
2586                                                         'type': 'string'
2587                                                     },
2588                                                     {
2589                                                         'name': 'recv_splitfrom_id_recv_notes',
2590                                                         'type': 'string'
2591                                                     },
2592                                                     {
2593                                                         'name': 'recv_splitfrom_id_recv_gldistdate',
2594                                                         'type': 'date'
2595                                                     },
2596                                                     {
2597                                                         'name': 'recv_splitfrom_id_recv_splitfrom_id',
2598                                                         'type': 'int'
2599                                                     },
2600                                                     {
2601                                                         'name': 'recv_splitfrom_id_recv_rlsd_duedate',
2602                                                         'type': 'date'
2603                                                     },
2604                                                     {
2605                                                         'name': 'recv_recvcost_curr_id_curr_id',
2606                                                         'type': 'int'
2607                                                     },
2608                                                     {
2609                                                         'name': 'recv_recvcost_curr_id_curr_base',
2610                                                         'type': 'int'
2611                                                     },
2612                                                     {
2613                                                         'name': 'recv_recvcost_curr_id_curr_name',
2614                                                         'type': 'string'
2615                                                     },
2616                                                     {
2617                                                         'name': 'recv_recvcost_curr_id_curr_symbol',
2618                                                         'type': 'string'
2619                                                     },
2620                                                     {
2621                                                         'name': 'recv_recvcost_curr_id_curr_abbr',
2622                                                         'type': 'string'
2623                                                     },
2624                                                     {
2625                                                         'name': 'recv_purchcost_curr_id_curr_id',
2626                                                         'type': 'int'
2627                                                     },
2628                                                     {
2629                                                         'name': 'recv_purchcost_curr_id_curr_base',
2630                                                         'type': 'int'
2631                                                     },
2632                                                     {
2633                                                         'name': 'recv_purchcost_curr_id_curr_name',
2634                                                         'type': 'string'
2635                                                     },
2636                                                     {
2637                                                         'name': 'recv_purchcost_curr_id_curr_symbol',
2638                                                         'type': 'string'
2639                                                     },
2640                                                     {
2641                                                         'name': 'recv_purchcost_curr_id_curr_abbr',
2642                                                         'type': 'string'
2643                                                     },
2644                                                     {
2645                                                         'name': 'recv_itemsite_id_itemsite_id',
2646                                                         'type': 'int'
2647                                                     },
2648                                                     {
2649                                                         'name': 'recv_itemsite_id_itemsite_item_id',
2650                                                         'type': 'int'
2651                                                     },
2652                                                     {
2653                                                         'name': 'recv_itemsite_id_itemsite_warehous_id',
2654                                                         'type': 'int'
2655                                                     },
2656                                                     {
2657                                                         'name': 'recv_itemsite_id_itemsite_qtyonhand',
2658                                                         'type': 'float'
2659                                                     },
2660                                                     {
2661                                                         'name': 'recv_itemsite_id_itemsite_reorderlevel',
2662                                                         'type': 'float'
2663                                                     },
2664                                                     {
2665                                                         'name': 'recv_itemsite_id_itemsite_ordertoqty',
2666                                                         'type': 'float'
2667                                                     },
2668                                                     {
2669                                                         'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
2670                                                         'type': 'int'
2671                                                     },
2672                                                     {
2673                                                         'name': 'recv_itemsite_id_itemsite_datelastcount',
2674                                                         'type': 'date'
2675                                                     },
2676                                                     {
2677                                                         'name': 'recv_itemsite_id_itemsite_datelastused',
2678                                                         'type': 'date'
2679                                                     },
2680                                                     {
2681                                                         'name': 'recv_itemsite_id_itemsite_loccntrl',
2682                                                         'type': 'int'
2683                                                     },
2684                                                     {
2685                                                         'name': 'recv_itemsite_id_itemsite_safetystock',
2686                                                         'type': 'float'
2687                                                     },
2688                                                     {
2689                                                         'name': 'recv_itemsite_id_itemsite_minordqty',
2690                                                         'type': 'float'
2691                                                     },
2692                                                     {
2693                                                         'name': 'recv_itemsite_id_itemsite_multordqty',
2694                                                         'type': 'float'
2695                                                     },
2696                                                     {
2697                                                         'name': 'recv_itemsite_id_itemsite_leadtime',
2698                                                         'type': 'int'
2699                                                     },
2700                                                     {
2701                                                         'name': 'recv_itemsite_id_itemsite_abcclass',
2702                                                         'type': 'string'
2703                                                     },
2704                                                     {
2705                                                         'name': 'recv_itemsite_id_itemsite_issuemethod',
2706                                                         'type': 'string'
2707                                                     },
2708                                                     {
2709                                                         'name': 'recv_itemsite_id_itemsite_controlmethod',
2710                                                         'type': 'string'
2711                                                     },
2712                                                     {
2713                                                         'name': 'recv_itemsite_id_itemsite_active',
2714                                                         'type': 'int'
2715                                                     },
2716                                                     {
2717                                                         'name': 'recv_itemsite_id_itemsite_plancode_id',
2718                                                         'type': 'int'
2719                                                     },
2720                                                     {
2721                                                         'name': 'recv_itemsite_id_itemsite_costcat_id',
2722                                                         'type': 'int'
2723                                                     },
2724                                                     {
2725                                                         'name': 'recv_itemsite_id_itemsite_eventfence',
2726                                                         'type': 'int'
2727                                                     },
2728                                                     {
2729                                                         'name': 'recv_itemsite_id_itemsite_sold',
2730                                                         'type': 'int'
2731                                                     },
2732                                                     {
2733                                                         'name': 'recv_itemsite_id_itemsite_stocked',
2734                                                         'type': 'int'
2735                                                     },
2736                                                     {
2737                                                         'name': 'recv_itemsite_id_itemsite_freeze',
2738                                                         'type': 'int'
2739                                                     },
2740                                                     {
2741                                                         'name': 'recv_itemsite_id_itemsite_location_id',
2742                                                         'type': 'int'
2743                                                     },
2744                                                     {
2745                                                         'name': 'recv_itemsite_id_itemsite_useparams',
2746                                                         'type': 'int'
2747                                                     },
2748                                                     {
2749                                                         'name': 'recv_itemsite_id_itemsite_useparamsmanual',
2750                                                         'type': 'int'
2751                                                     },
2752                                                     {
2753                                                         'name': 'recv_itemsite_id_itemsite_soldranking',
2754                                                         'type': 'int'
2755                                                     },
2756                                                     {
2757                                                         'name': 'recv_itemsite_id_itemsite_createpr',
2758                                                         'type': 'int'
2759                                                     },
2760                                                     {
2761                                                         'name': 'recv_itemsite_id_itemsite_location',
2762                                                         'type': 'string'
2763                                                     },
2764                                                     {
2765                                                         'name': 'recv_itemsite_id_itemsite_location_comments',
2766                                                         'type': 'string'
2767                                                     },
2768                                                     {
2769                                                         'name': 'recv_itemsite_id_itemsite_notes',
2770                                                         'type': 'string'
2771                                                     },
2772                                                     {
2773                                                         'name': 'recv_itemsite_id_itemsite_perishable',
2774                                                         'type': 'int'
2775                                                     },
2776                                                     {
2777                                                         'name': 'recv_itemsite_id_itemsite_nnqoh',
2778                                                         'type': 'float'
2779                                                     },
2780                                                     {
2781                                                         'name': 'recv_itemsite_id_itemsite_autoabcclass',
2782                                                         'type': 'int'
2783                                                     },
2784                                                     {
2785                                                         'name': 'recv_itemsite_id_itemsite_ordergroup',
2786                                                         'type': 'int'
2787                                                     },
2788                                                     {
2789                                                         'name': 'recv_itemsite_id_itemsite_disallowblankwip',
2790                                                         'type': 'int'
2791                                                     },
2792                                                     {
2793                                                         'name': 'recv_itemsite_id_itemsite_maxordqty',
2794                                                         'type': 'float'
2795                                                     },
2796                                                     {
2797                                                         'name': 'recv_itemsite_id_itemsite_mps_timefence',
2798                                                         'type': 'int'
2799                                                     },
2800                                                     {
2801                                                         'name': 'recv_itemsite_id_itemsite_createwo',
2802                                                         'type': 'int'
2803                                                     },
2804                                                     {
2805                                                         'name': 'recv_itemsite_id_itemsite_warrpurc',
2806                                                         'type': 'int'
2807                                                     },
2808                                                     {
2809                                                         'name': 'recv_itemsite_id_itemsite_autoreg',
2810                                                         'type': 'int'
2811                                                     },
2812                                                     {
2813                                                         'name': 'recv_itemsite_id_itemsite_costmethod',
2814                                                         'type': 'string'
2815                                                     },
2816                                                     {
2817                                                         'name': 'recv_itemsite_id_itemsite_value',
2818                                                         'type': 'float'
2819                                                     },
2820                                                     {
2821                                                         'name': 'recv_itemsite_id_itemsite_ordergroup_first',
2822                                                         'type': 'int'
2823                                                     },
2824                                                     {
2825                                                         'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
2826                                                         'type': 'int'
2827                                                     },
2828                                                     {
2829                                                         'name': 'recv_itemsite_id_itemsite_planning_type',
2830                                                         'type': 'string'
2831                                                     },
2832                                                     {
2833                                                         'name': 'recv_itemsite_id_itemsite_wosupply',
2834                                                         'type': 'int'
2835                                                     },
2836                                                     {
2837                                                         'name': 'recv_itemsite_id_itemsite_posupply',
2838                                                         'type': 'int'
2839                                                     },
2840                                                     {
2841                                                         'name': 'recv_itemsite_id_itemsite_lsseq_id',
2842                                                         'type': 'int'
2843                                                     },
2844                                                     {
2845                                                         'name': 'recv_itemsite_id_itemsite_cosdefault',
2846                                                         'type': 'string'
2847                                                     },
2848                                                     {
2849                                                         'name': 'recv_itemsite_id_itemsite_createsopr',
2850                                                         'type': 'int'
2851                                                     },
2852                                                     {
2853                                                         'name': 'recv_itemsite_id_itemsite_createsopo',
2854                                                         'type': 'int'
2855                                                     },
2856                                                     {
2857                                                         'name': 'recv_itemsite_id_itemsite_dropship',
2858                                                         'type': 'int'
2859                                                     },
2860                                                     {
2861                                                         'name': 'recv_freight_curr_id_curr_id',
2862                                                         'type': 'int'
2863                                                     },
2864                                                     {
2865                                                         'name': 'recv_freight_curr_id_curr_base',
2866                                                         'type': 'int'
2867                                                     },
2868                                                     {
2869                                                         'name': 'recv_freight_curr_id_curr_name',
2870                                                         'type': 'string'
2871                                                     },
2872                                                     {
2873                                                         'name': 'recv_freight_curr_id_curr_symbol',
2874                                                         'type': 'string'
2875                                                     },
2876                                                     {
2877                                                         'name': 'recv_freight_curr_id_curr_abbr',
2878                                                         'type': 'string'
2879                                                     }
2880                                                 ]
2881                                             }
2882                                         },
2883                                         toolbar : {
2884                                             xtype: 'Toolbar',
2885                                             xns: Roo,
2886                                             items : [
2887                                                 {
2888                                                     xtype: 'Button',
2889                                                     xns: Roo.Toolbar,
2890                                                     listeners : {
2891                                                         click : function (_self, e)
2892                                                         {
2893
2894                                                            var sel =  _this.rggrid.selModel.getSelected();
2895                                                            if (!sel) {
2896                                                                 Roo.MessageBox.alert("Error", "Select Item receipt");
2897                                                                 return;
2898                                                             }
2899
2900
2901
2902                                                             Pman.Dialog.XtupleTransfer.show({ createFromRev : sel.data.recvgrp_id },
2903                                                                 function() {
2904                                                                     _this.grid.ds.load({});
2905                                                                 }
2906                                                                 );
2907                                                         }
2908                                                     },
2909                                                     cls : 'x-btn-text-icon',
2910                                                     hidden : true,
2911                                                     text : "Create Transfer",
2912                                                     icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2913                                                 },
2914                                                 {
2915                                                     xtype: 'Fill',
2916                                                     xns: Roo.Toolbar
2917                                                 },
2918                                                 {
2919                                                     xtype: 'Button',
2920                                                     xns: Roo.Toolbar,
2921                                                     listeners : {
2922                                                         click : function()
2923                                                         {
2924                                                              var s  = _this.grid.selModel.getSelected();
2925                                                              if (!s) {
2926                                                                 Roo.MessageBox.alert("Error", "Select a purchase order");
2927                                                                 return
2928                                                             }
2929
2930                                                             Pman.Dialog.XtupleRecvGrp.show( {
2931                                                                  recvgrp_pohead_id : s.data.pohead_id ,
2932                                                                  recvgrp_pohead_id_pohead_number : s.data.pohead_number
2933                                                              } , function() {
2934                                                                 _this.grid.footer.onClick('refresh');
2935                                                            });
2936                                                         }
2937                                                     },
2938                                                     cls : 'x-btn-text-icon',
2939                                                     text : "Add Receipt",
2940                                                     icon : Roo.rootURL + 'images/default/dd/drop-add.gif'
2941                                                 }
2942                                             ]
2943                                         },
2944                                         colModel : [
2945                                             {
2946                                                 xtype: 'ColumnModel',
2947                                                 xns: Roo.grid,
2948                                                 dataIndex : 'recvgrp_number',
2949                                                 header : 'ref#',
2950                                                 width : 120,
2951                                                 renderer : function(v,x,r) {
2952                                                     var vv =v;
2953                                                     var nn  = '';
2954                                                     if (vv.indexOf(',') > -1) {
2955                                                         vv = vv.split(',').shift();
2956
2957                                                     }
2958                                                     if (vv.match(/^NSPO-/)) {
2959                                                         vv = vv.replace(/^NSPO-/, '');
2960                                                         nn = 'ns:&nbsp;';
2961                                                     }
2962
2963                                                     var format = '<i>'+ nn +'</i><b qtip="{1}">{0}</b>';
2964                                                     if (r.data.recvgrp_void *1) {
2965                                                         format = '<s>'  + format + '</s>';
2966                                                     }
2967                                                     return String.format(format, vv,v);
2968
2969
2970                                                  }
2971                                             },
2972                                             {
2973                                                 xtype: 'ColumnModel',
2974                                                 xns: Roo.grid,
2975                                                 dataIndex : 'recvgrp_location_id_location_name',
2976                                                 header : 'To',
2977                                                 width : 80,
2978                                                 renderer : function(v,x,r) {
2979
2980                                                     return String.format('{0}',  v);
2981
2982
2983                                                  }
2984                                             },
2985                                             {
2986                                                 xtype: 'ColumnModel',
2987                                                 xns: Roo.grid,
2988                                                 align : 'right',
2989                                                 dataIndex : 'recvgrp_date',
2990                                                 header : 'Date',
2991                                                 width : 75,
2992                                                 renderer : function(v) { return v ? v.format('d/M/Y')  : ''; }
2993                                             },
2994                                             {
2995                                                 xtype: 'ColumnModel',
2996                                                 xns: Roo.grid,
2997                                                 align : 'right',
2998                                                 dataIndex : 'total_landed_cost',
2999                                                 header : 'Landed Cost',
3000                                                 width : 80,
3001                                                 renderer : function(v,x,r) {
3002                                                     return String.format('{1}{0}', v, r.data.base_curr_symbol);
3003                                                 }
3004                                             }
3005                                         ]
3006                                     }
3007                                 },
3008                                 {
3009                                     xtype: 'GridPanel',
3010                                     xns: Roo,
3011                                     listeners : {
3012                                         activate : function() {
3013                                             _this.rpanel = this;
3014                                             if (_this.rgrid) {
3015                                                 _this.rgrid.footer.onClick('first');
3016                                             }
3017                                         }
3018                                     },
3019                                     background : true,
3020                                     fitContainer : true,
3021                                     fitToframe : false,
3022                                     region : 'south',
3023                                     tableName : 'poitem',
3024                                     title : "Items",
3025                                     grid : {
3026                                         xtype: 'Grid',
3027                                         xns: Roo.grid,
3028                                         listeners : {
3029                                             render : function()
3030                                             {
3031                                                 _this.rgrid = this;
3032                                                 //_this.dialog = Pman.Dialog.FILL_IN
3033                                                 if (_this.rpanel.active) {
3034                                                    this.footer.onClick('first');
3035                                                 }
3036                                             }
3037                                         },
3038                                         autoExpandColumn : 'item_number',
3039                                         loadMask : true,
3040                                         dataSource : {
3041                                             xtype: 'Store',
3042                                             xns: Roo.data,
3043                                             listeners : {
3044                                                 beforeload : function (_self, options)
3045                                                 {
3046                                                     if (!_this.grid || !_this.grid.selModel.getSelected()) {
3047                                                         return false;
3048                                                     }
3049
3050                                                     var r = _this.grid.selModel.getSelected();
3051
3052
3053
3054                                                     options.params.poitem_pohead_id = r.data.pohead_id;
3055
3056                                                     var rr = _this.rggrid.selModel.getSelected();
3057
3058                                                     options.params.recvgrp_id = 0;
3059                                                     if (rr) {
3060                                                         options.params.recvgrp_id = rr.data.recvgrp_id;
3061                                                     }
3062
3063                                                     options.params._with_item  = 1;
3064                                                     options.params.item_type = 'P';
3065                                                 }
3066                                             },
3067                                             remoteSort : true,
3068                                             sortInfo : { field : 'recv_order_type', direction: 'ASC' },
3069                                             proxy : {
3070                                                 xtype: 'HttpProxy',
3071                                                 xns: Roo.data,
3072                                                 method : 'GET',
3073                                                 url : baseURL + '/Roo/poitem.php'
3074                                             },
3075                                             reader : {
3076                                                 xtype: 'JsonReader',
3077                                                 xns: Roo.data,
3078                                                 totalProperty : 'total',
3079                                                 root : 'data',
3080                                                 id : 'id',
3081                                                 fields : [
3082                                                     {
3083                                                         'name': 'recv_id',
3084                                                         'type': 'int'
3085                                                     },
3086                                                     {
3087                                                         'name': 'recv_order_type',
3088                                                         'type': 'string'
3089                                                     },
3090                                                     {
3091                                                         'name': 'recv_order_number',
3092                                                         'type': 'string'
3093                                                     },
3094                                                     {
3095                                                         'name': 'recv_orderitem_id',
3096                                                         'type': 'int'
3097                                                     },
3098                                                     {
3099                                                         'name': 'recv_agent_username',
3100                                                         'type': 'string'
3101                                                     },
3102                                                     {
3103                                                         'name': 'recv_itemsite_id',
3104                                                         'type': 'int'
3105                                                     },
3106                                                     {
3107                                                         'name': 'recv_vend_id',
3108                                                         'type': 'int'
3109                                                     },
3110                                                     {
3111                                                         'name': 'recv_vend_item_number',
3112                                                         'type': 'string'
3113                                                     },
3114                                                     {
3115                                                         'name': 'recv_vend_item_descrip',
3116                                                         'type': 'string'
3117                                                     },
3118                                                     {
3119                                                         'name': 'recv_vend_uom',
3120                                                         'type': 'string'
3121                                                     },
3122                                                     {
3123                                                         'name': 'recv_purchcost',
3124                                                         'type': 'float'
3125                                                     },
3126                                                     {
3127                                                         'name': 'recv_purchcost_curr_id',
3128                                                         'type': 'int'
3129                                                     },
3130                                                     {
3131                                                         'name': 'recv_duedate',
3132                                                         'type': 'date',
3133                                                         'dateFormat': 'Y-m-d'
3134                                                     },
3135                                                     {
3136                                                         'name': 'recv_qty',
3137                                                         'type': 'float'
3138                                                     },
3139                                                     {
3140                                                         'name': 'recv_recvcost',
3141                                                         'type': 'float'
3142                                                     },
3143                                                     {
3144                                                         'name': 'recv_recvcost_curr_id',
3145                                                         'type': 'int'
3146                                                     },
3147                                                     {
3148                                                         'name': 'recv_freight',
3149                                                         'type': 'float'
3150                                                     },
3151                                                     {
3152                                                         'name': 'recv_freight_curr_id',
3153                                                         'type': 'int'
3154                                                     },
3155                                                     {
3156                                                         'name': 'recv_date',
3157                                                         'type': 'date',
3158                                                         'dateFormat': 'Y-m-d'
3159                                                     },
3160                                                     {
3161                                                         'name': 'recv_value',
3162                                                         'type': 'float'
3163                                                     },
3164                                                     {
3165                                                         'name': 'recv_posted',
3166                                                         'type': 'int'
3167                                                     },
3168                                                     {
3169                                                         'name': 'recv_invoiced',
3170                                                         'type': 'int'
3171                                                     },
3172                                                     {
3173                                                         'name': 'recv_vohead_id',
3174                                                         'type': 'int'
3175                                                     },
3176                                                     {
3177                                                         'name': 'recv_voitem_id',
3178                                                         'type': 'int'
3179                                                     },
3180                                                     {
3181                                                         'name': 'recv_trans_usr_name',
3182                                                         'type': 'string'
3183                                                     },
3184                                                     {
3185                                                         'name': 'recv_notes',
3186                                                         'type': 'string'
3187                                                     },
3188                                                     {
3189                                                         'name': 'recv_gldistdate',
3190                                                         'type': 'date',
3191                                                         'dateFormat': 'Y-m-d'
3192                                                     },
3193                                                     {
3194                                                         'name': 'recv_splitfrom_id',
3195                                                         'type': 'int'
3196                                                     },
3197                                                     {
3198                                                         'name': 'recv_rlsd_duedate',
3199                                                         'type': 'date',
3200                                                         'dateFormat': 'Y-m-d'
3201                                                     },
3202                                                     {
3203                                                         'name': 'recv_voitem_id_voitem_id',
3204                                                         'type': 'int'
3205                                                     },
3206                                                     {
3207                                                         'name': 'recv_voitem_id_voitem_vohead_id',
3208                                                         'type': 'int'
3209                                                     },
3210                                                     {
3211                                                         'name': 'recv_voitem_id_voitem_poitem_id',
3212                                                         'type': 'int'
3213                                                     },
3214                                                     {
3215                                                         'name': 'recv_voitem_id_voitem_close',
3216                                                         'type': 'int'
3217                                                     },
3218                                                     {
3219                                                         'name': 'recv_voitem_id_voitem_qty',
3220                                                         'type': 'float'
3221                                                     },
3222                                                     {
3223                                                         'name': 'recv_voitem_id_voitem_freight',
3224                                                         'type': 'float'
3225                                                     },
3226                                                     {
3227                                                         'name': 'recv_voitem_id_voitem_taxtype_id',
3228                                                         'type': 'int'
3229                                                     },
3230                                                     {
3231                                                         'name': 'recv_vohead_id_vohead_id',
3232                                                         'type': 'int'
3233                                                     },
3234                                                     {
3235                                                         'name': 'recv_vohead_id_vohead_number',
3236                                                         'type': 'string'
3237                                                     },
3238                                                     {
3239                                                         'name': 'recv_vohead_id_vohead_pohead_id',
3240                                                         'type': 'int'
3241                                                     },
3242                                                     {
3243                                                         'name': 'recv_vohead_id_vohead_posted',
3244                                                         'type': 'int'
3245                                                     },
3246                                                     {
3247                                                         'name': 'recv_vohead_id_vohead_duedate',
3248                                                         'type': 'date'
3249                                                     },
3250                                                     {
3251                                                         'name': 'recv_vohead_id_vohead_invcnumber',
3252                                                         'type': 'string'
3253                                                     },
3254                                                     {
3255                                                         'name': 'recv_vohead_id_vohead_amount',
3256                                                         'type': 'float'
3257                                                     },
3258                                                     {
3259                                                         'name': 'recv_vohead_id_vohead_docdate',
3260                                                         'type': 'date'
3261                                                     },
3262                                                     {
3263                                                         'name': 'recv_vohead_id_vohead_1099',
3264                                                         'type': 'int'
3265                                                     },
3266                                                     {
3267                                                         'name': 'recv_vohead_id_vohead_distdate',
3268                                                         'type': 'date'
3269                                                     },
3270                                                     {
3271                                                         'name': 'recv_vohead_id_vohead_reference',
3272                                                         'type': 'string'
3273                                                     },
3274                                                     {
3275                                                         'name': 'recv_vohead_id_vohead_terms_id',
3276                                                         'type': 'int'
3277                                                     },
3278                                                     {
3279                                                         'name': 'recv_vohead_id_vohead_vend_id',
3280                                                         'type': 'int'
3281                                                     },
3282                                                     {
3283                                                         'name': 'recv_vohead_id_vohead_curr_id',
3284                                                         'type': 'int'
3285                                                     },
3286                                                     {
3287                                                         'name': 'recv_vohead_id_vohead_adjtaxtype_id',
3288                                                         'type': 'int'
3289                                                     },
3290                                                     {
3291                                                         'name': 'recv_vohead_id_vohead_freighttaxtype_id',
3292                                                         'type': 'int'
3293                                                     },
3294                                                     {
3295                                                         'name': 'recv_vohead_id_vohead_gldistdate',
3296                                                         'type': 'date'
3297                                                     },
3298                                                     {
3299                                                         'name': 'recv_vohead_id_vohead_misc',
3300                                                         'type': 'int'
3301                                                     },
3302                                                     {
3303                                                         'name': 'recv_vohead_id_vohead_taxzone_id',
3304                                                         'type': 'int'
3305                                                     },
3306                                                     {
3307                                                         'name': 'recv_vohead_id_vohead_taxtype_id',
3308                                                         'type': 'int'
3309                                                     },
3310                                                     {
3311                                                         'name': 'recv_vohead_id_vohead_notes',
3312                                                         'type': 'string'
3313                                                     },
3314                                                     {
3315                                                         'name': 'recv_vend_id_vend_id',
3316                                                         'type': 'int'
3317                                                     },
3318                                                     {
3319                                                         'name': 'recv_vend_id_vend_name',
3320                                                         'type': 'string'
3321                                                     },
3322                                                     {
3323                                                         'name': 'recv_vend_id_vend_lastpurchdate',
3324                                                         'type': 'date'
3325                                                     },
3326                                                     {
3327                                                         'name': 'recv_vend_id_vend_active',
3328                                                         'type': 'int'
3329                                                     },
3330                                                     {
3331                                                         'name': 'recv_vend_id_vend_po',
3332                                                         'type': 'int'
3333                                                     },
3334                                                     {
3335                                                         'name': 'recv_vend_id_vend_comments',
3336                                                         'type': 'string'
3337                                                     },
3338                                                     {
3339                                                         'name': 'recv_vend_id_vend_pocomments',
3340                                                         'type': 'string'
3341                                                     },
3342                                                     {
3343                                                         'name': 'recv_vend_id_vend_number',
3344                                                         'type': 'string'
3345                                                     },
3346                                                     {
3347                                                         'name': 'recv_vend_id_vend_1099',
3348                                                         'type': 'int'
3349                                                     },
3350                                                     {
3351                                                         'name': 'recv_vend_id_vend_exported',
3352                                                         'type': 'int'
3353                                                     },
3354                                                     {
3355                                                         'name': 'recv_vend_id_vend_fobsource',
3356                                                         'type': 'string'
3357                                                     },
3358                                                     {
3359                                                         'name': 'recv_vend_id_vend_fob',
3360                                                         'type': 'string'
3361                                                     },
3362                                                     {
3363                                                         'name': 'recv_vend_id_vend_terms_id',
3364                                                         'type': 'int'
3365                                                     },
3366                                                     {
3367                                                         'name': 'recv_vend_id_vend_shipvia',
3368                                                         'type': 'string'
3369                                                     },
3370                                                     {
3371                                                         'name': 'recv_vend_id_vend_vendtype_id',
3372                                                         'type': 'int'
3373                                                     },
3374                                                     {
3375                                                         'name': 'recv_vend_id_vend_qualified',
3376                                                         'type': 'int'
3377                                                     },
3378                                                     {
3379                                                         'name': 'recv_vend_id_vend_ediemail',
3380                                                         'type': 'string'
3381                                                     },
3382                                                     {
3383                                                         'name': 'recv_vend_id_vend_ediemailbody',
3384                                                         'type': 'string'
3385                                                     },
3386                                                     {
3387                                                         'name': 'recv_vend_id_vend_edisubject',
3388                                                         'type': 'string'
3389                                                     },
3390                                                     {
3391                                                         'name': 'recv_vend_id_vend_edifilename',
3392                                                         'type': 'string'
3393                                                     },
3394                                                     {
3395                                                         'name': 'recv_vend_id_vend_accntnum',
3396                                                         'type': 'string'
3397                                                     },
3398                                                     {
3399                                                         'name': 'recv_vend_id_vend_emailpodelivery',
3400                                                         'type': 'int'
3401                                                     },
3402                                                     {
3403                                                         'name': 'recv_vend_id_vend_restrictpurch',
3404                                                         'type': 'int'
3405                                                     },
3406                                                     {
3407                                                         'name': 'recv_vend_id_vend_edicc',
3408                                                         'type': 'string'
3409                                                     },
3410                                                     {
3411                                                         'name': 'recv_vend_id_vend_curr_id',
3412                                                         'type': 'int'
3413                                                     },
3414                                                     {
3415                                                         'name': 'recv_vend_id_vend_cntct1_id',
3416                                                         'type': 'int'
3417                                                     },
3418                                                     {
3419                                                         'name': 'recv_vend_id_vend_cntct2_id',
3420                                                         'type': 'int'
3421                                                     },
3422                                                     {
3423                                                         'name': 'recv_vend_id_vend_addr_id',
3424                                                         'type': 'int'
3425                                                     },
3426                                                     {
3427                                                         'name': 'recv_vend_id_vend_match',
3428                                                         'type': 'int'
3429                                                     },
3430                                                     {
3431                                                         'name': 'recv_vend_id_vend_ach_enabled',
3432                                                         'type': 'int'
3433                                                     },
3434                                                     {
3435                                                         'name': 'recv_vend_id_vend_ach_accnttype',
3436                                                         'type': 'string'
3437                                                     },
3438                                                     {
3439                                                         'name': 'recv_vend_id_vend_ach_use_vendinfo',
3440                                                         'type': 'int'
3441                                                     },
3442                                                     {
3443                                                         'name': 'recv_vend_id_vend_ach_indiv_number',
3444                                                         'type': 'string'
3445                                                     },
3446                                                     {
3447                                                         'name': 'recv_vend_id_vend_ach_indiv_name',
3448                                                         'type': 'string'
3449                                                     },
3450                                                     {
3451                                                         'name': 'recv_vend_id_vend_ediemailhtml',
3452                                                         'type': 'int'
3453                                                     },
3454                                                     {
3455                                                         'name': 'recv_vend_id_vend_ach_routingnumber',
3456                                                         'type': 'text'
3457                                                     },
3458                                                     {
3459                                                         'name': 'recv_vend_id_vend_ach_accntnumber',
3460                                                         'type': 'text'
3461                                                     },
3462                                                     {
3463                                                         'name': 'recv_vend_id_vend_taxzone_id',
3464                                                         'type': 'int'
3465                                                     },
3466                                                     {
3467                                                         'name': 'recv_splitfrom_id_recv_id',
3468                                                         'type': 'int'
3469                                                     },
3470                                                     {
3471                                                         'name': 'recv_splitfrom_id_recv_order_type',
3472                                                         'type': 'string'
3473                                                     },
3474                                                     {
3475                                                         'name': 'recv_splitfrom_id_recv_order_number',
3476                                                         'type': 'string'
3477                                                     },
3478                                                     {
3479                                                         'name': 'recv_splitfrom_id_recv_orderitem_id',
3480                                                         'type': 'int'
3481                                                     },
3482                                                     {
3483                                                         'name': 'recv_splitfrom_id_recv_agent_username',
3484                                                         'type': 'string'
3485                                                     },
3486                                                     {
3487                                                         'name': 'recv_splitfrom_id_recv_itemsite_id',
3488                                                         'type': 'int'
3489                                                     },
3490                                                     {
3491                                                         'name': 'recv_splitfrom_id_recv_vend_id',
3492                                                         'type': 'int'
3493                                                     },
3494                                                     {
3495                                                         'name': 'recv_splitfrom_id_recv_vend_item_number',
3496                                                         'type': 'string'
3497                                                     },
3498                                                     {
3499                                                         'name': 'recv_splitfrom_id_recv_vend_item_descrip',
3500                                                         'type': 'string'
3501                                                     },
3502                                                     {
3503                                                         'name': 'recv_splitfrom_id_recv_vend_uom',
3504                                                         'type': 'string'
3505                                                     },
3506                                                     {
3507                                                         'name': 'recv_splitfrom_id_recv_purchcost',
3508                                                         'type': 'float'
3509                                                     },
3510                                                     {
3511                                                         'name': 'recv_splitfrom_id_recv_purchcost_curr_id',
3512                                                         'type': 'int'
3513                                                     },
3514                                                     {
3515                                                         'name': 'recv_splitfrom_id_recv_duedate',
3516                                                         'type': 'date'
3517                                                     },
3518                                                     {
3519                                                         'name': 'recv_splitfrom_id_recv_qty',
3520                                                         'type': 'float'
3521                                                     },
3522                                                     {
3523                                                         'name': 'recv_splitfrom_id_recv_recvcost',
3524                                                         'type': 'float'
3525                                                     },
3526                                                     {
3527                                                         'name': 'recv_splitfrom_id_recv_recvcost_curr_id',
3528                                                         'type': 'int'
3529                                                     },
3530                                                     {
3531                                                         'name': 'recv_splitfrom_id_recv_freight',
3532                                                         'type': 'float'
3533                                                     },
3534                                                     {
3535                                                         'name': 'recv_splitfrom_id_recv_freight_curr_id',
3536                                                         'type': 'int'
3537                                                     },
3538                                                     {
3539                                                         'name': 'recv_splitfrom_id_recv_date',
3540                                                         'type': 'date'
3541                                                     },
3542                                                     {
3543                                                         'name': 'recv_splitfrom_id_recv_value',
3544                                                         'type': 'float'
3545                                                     },
3546                                                     {
3547                                                         'name': 'recv_splitfrom_id_recv_posted',
3548                                                         'type': 'int'
3549                                                     },
3550                                                     {
3551                                                         'name': 'recv_splitfrom_id_recv_invoiced',
3552                                                         'type': 'int'
3553                                                     },
3554                                                     {
3555                                                         'name': 'recv_splitfrom_id_recv_vohead_id',
3556                                                         'type': 'int'
3557                                                     },
3558                                                     {
3559                                                         'name': 'recv_splitfrom_id_recv_voitem_id',
3560                                                         'type': 'int'
3561                                                     },
3562                                                     {
3563                                                         'name': 'recv_splitfrom_id_recv_trans_usr_name',
3564                                                         'type': 'string'
3565                                                     },
3566                                                     {
3567                                                         'name': 'recv_splitfrom_id_recv_notes',
3568                                                         'type': 'string'
3569                                                     },
3570                                                     {
3571                                                         'name': 'recv_splitfrom_id_recv_gldistdate',
3572                                                         'type': 'date'
3573                                                     },
3574                                                     {
3575                                                         'name': 'recv_splitfrom_id_recv_splitfrom_id',
3576                                                         'type': 'int'
3577                                                     },
3578                                                     {
3579                                                         'name': 'recv_splitfrom_id_recv_rlsd_duedate',
3580                                                         'type': 'date'
3581                                                     },
3582                                                     {
3583                                                         'name': 'recv_recvcost_curr_id_curr_id',
3584                                                         'type': 'int'
3585                                                     },
3586                                                     {
3587                                                         'name': 'recv_recvcost_curr_id_curr_base',
3588                                                         'type': 'int'
3589                                                     },
3590                                                     {
3591                                                         'name': 'recv_recvcost_curr_id_curr_name',
3592                                                         'type': 'string'
3593                                                     },
3594                                                     {
3595                                                         'name': 'recv_recvcost_curr_id_curr_symbol',
3596                                                         'type': 'string'
3597                                                     },
3598                                                     {
3599                                                         'name': 'recv_recvcost_curr_id_curr_abbr',
3600                                                         'type': 'string'
3601                                                     },
3602                                                     {
3603                                                         'name': 'recv_purchcost_curr_id_curr_id',
3604                                                         'type': 'int'
3605                                                     },
3606                                                     {
3607                                                         'name': 'recv_purchcost_curr_id_curr_base',
3608                                                         'type': 'int'
3609                                                     },
3610                                                     {
3611                                                         'name': 'recv_purchcost_curr_id_curr_name',
3612                                                         'type': 'string'
3613                                                     },
3614                                                     {
3615                                                         'name': 'recv_purchcost_curr_id_curr_symbol',
3616                                                         'type': 'string'
3617                                                     },
3618                                                     {
3619                                                         'name': 'recv_purchcost_curr_id_curr_abbr',
3620                                                         'type': 'string'
3621                                                     },
3622                                                     {
3623                                                         'name': 'recv_itemsite_id_itemsite_id',
3624                                                         'type': 'int'
3625                                                     },
3626                                                     {
3627                                                         'name': 'recv_itemsite_id_itemsite_item_id',
3628                                                         'type': 'int'
3629                                                     },
3630                                                     {
3631                                                         'name': 'recv_itemsite_id_itemsite_warehous_id',
3632                                                         'type': 'int'
3633                                                     },
3634                                                     {
3635                                                         'name': 'recv_itemsite_id_itemsite_qtyonhand',
3636                                                         'type': 'float'
3637                                                     },
3638                                                     {
3639                                                         'name': 'recv_itemsite_id_itemsite_reorderlevel',
3640                                                         'type': 'float'
3641                                                     },
3642                                                     {
3643                                                         'name': 'recv_itemsite_id_itemsite_ordertoqty',
3644                                                         'type': 'float'
3645                                                     },
3646                                                     {
3647                                                         'name': 'recv_itemsite_id_itemsite_cyclecountfreq',
3648                                                         'type': 'int'
3649                                                     },
3650                                                     {
3651                                                         'name': 'recv_itemsite_id_itemsite_datelastcount',
3652                                                         'type': 'date'
3653                                                     },
3654                                                     {
3655                                                         'name': 'recv_itemsite_id_itemsite_datelastused',
3656                                                         'type': 'date'
3657                                                     },
3658                                                     {
3659                                                         'name': 'recv_itemsite_id_itemsite_loccntrl',
3660                                                         'type': 'int'
3661                                                     },
3662                                                     {
3663                                                         'name': 'recv_itemsite_id_itemsite_safetystock',
3664                                                         'type': 'float'
3665                                                     },
3666                                                     {
3667                                                         'name': 'recv_itemsite_id_itemsite_minordqty',
3668                                                         'type': 'float'
3669                                                     },
3670                                                     {
3671                                                         'name': 'recv_itemsite_id_itemsite_multordqty',
3672                                                         'type': 'float'
3673                                                     },
3674                                                     {
3675                                                         'name': 'recv_itemsite_id_itemsite_leadtime',
3676                                                         'type': 'int'
3677                                                     },
3678                                                     {
3679                                                         'name': 'recv_itemsite_id_itemsite_abcclass',
3680                                                         'type': 'string'
3681                                                     },
3682                                                     {
3683                                                         'name': 'recv_itemsite_id_itemsite_issuemethod',
3684                                                         'type': 'string'
3685                                                     },
3686                                                     {
3687                                                         'name': 'recv_itemsite_id_itemsite_controlmethod',
3688                                                         'type': 'string'
3689                                                     },
3690                                                     {
3691                                                         'name': 'recv_itemsite_id_itemsite_active',
3692                                                         'type': 'int'
3693                                                     },
3694                                                     {
3695                                                         'name': 'recv_itemsite_id_itemsite_plancode_id',
3696                                                         'type': 'int'
3697                                                     },
3698                                                     {
3699                                                         'name': 'recv_itemsite_id_itemsite_costcat_id',
3700                                                         'type': 'int'
3701                                                     },
3702                                                     {
3703                                                         'name': 'recv_itemsite_id_itemsite_eventfence',
3704                                                         'type': 'int'
3705                                                     },
3706                                                     {
3707                                                         'name': 'recv_itemsite_id_itemsite_sold',
3708                                                         'type': 'int'
3709                                                     },
3710                                                     {
3711                                                         'name': 'recv_itemsite_id_itemsite_stocked',
3712                                                         'type': 'int'
3713                                                     },
3714                                                     {
3715                                                         'name': 'recv_itemsite_id_itemsite_freeze',
3716                                                         'type': 'int'
3717                                                     },
3718                                                     {
3719                                                         'name': 'recv_itemsite_id_itemsite_location_id',
3720                                                         'type': 'int'
3721                                                     },
3722                                                     {
3723                                                         'name': 'recv_itemsite_id_itemsite_useparams',
3724                                                         'type': 'int'
3725                                                     },
3726                                                     {
3727                                                         'name': 'recv_itemsite_id_itemsite_useparamsmanual',
3728                                                         'type': 'int'
3729                                                     },
3730                                                     {
3731                                                         'name': 'recv_itemsite_id_itemsite_soldranking',
3732                                                         'type': 'int'
3733                                                     },
3734                                                     {
3735                                                         'name': 'recv_itemsite_id_itemsite_createpr',
3736                                                         'type': 'int'
3737                                                     },
3738                                                     {
3739                                                         'name': 'recv_itemsite_id_itemsite_location',
3740                                                         'type': 'string'
3741                                                     },
3742                                                     {
3743                                                         'name': 'recv_itemsite_id_itemsite_location_comments',
3744                                                         'type': 'string'
3745                                                     },
3746                                                     {
3747                                                         'name': 'recv_itemsite_id_itemsite_notes',
3748                                                         'type': 'string'
3749                                                     },
3750                                                     {
3751                                                         'name': 'recv_itemsite_id_itemsite_perishable',
3752                                                         'type': 'int'
3753                                                     },
3754                                                     {
3755                                                         'name': 'recv_itemsite_id_itemsite_nnqoh',
3756                                                         'type': 'float'
3757                                                     },
3758                                                     {
3759                                                         'name': 'recv_itemsite_id_itemsite_autoabcclass',
3760                                                         'type': 'int'
3761                                                     },
3762                                                     {
3763                                                         'name': 'recv_itemsite_id_itemsite_ordergroup',
3764                                                         'type': 'int'
3765                                                     },
3766                                                     {
3767                                                         'name': 'recv_itemsite_id_itemsite_disallowblankwip',
3768                                                         'type': 'int'
3769                                                     },
3770                                                     {
3771                                                         'name': 'recv_itemsite_id_itemsite_maxordqty',
3772                                                         'type': 'float'
3773                                                     },
3774                                                     {
3775                                                         'name': 'recv_itemsite_id_itemsite_mps_timefence',
3776                                                         'type': 'int'
3777                                                     },
3778                                                     {
3779                                                         'name': 'recv_itemsite_id_itemsite_createwo',
3780                                                         'type': 'int'
3781                                                     },
3782                                                     {
3783                                                         'name': 'recv_itemsite_id_itemsite_warrpurc',
3784                                                         'type': 'int'
3785                                                     },
3786                                                     {
3787                                                         'name': 'recv_itemsite_id_itemsite_autoreg',
3788                                                         'type': 'int'
3789                                                     },
3790                                                     {
3791                                                         'name': 'recv_itemsite_id_itemsite_costmethod',
3792                                                         'type': 'string'
3793                                                     },
3794                                                     {
3795                                                         'name': 'recv_itemsite_id_itemsite_value',
3796                                                         'type': 'float'
3797                                                     },
3798                                                     {
3799                                                         'name': 'recv_itemsite_id_itemsite_ordergroup_first',
3800                                                         'type': 'int'
3801                                                     },
3802                                                     {
3803                                                         'name': 'recv_itemsite_id_itemsite_supply_itemsite_id',
3804                                                         'type': 'int'
3805                                                     },
3806                                                     {
3807                                                         'name': 'recv_itemsite_id_itemsite_planning_type',
3808                                                         'type': 'string'
3809                                                     },
3810                                                     {
3811                                                         'name': 'recv_itemsite_id_itemsite_wosupply',
3812                                                         'type': 'int'
3813                                                     },
3814                                                     {
3815                                                         'name': 'recv_itemsite_id_itemsite_posupply',
3816                                                         'type': 'int'
3817                                                     },
3818                                                     {
3819                                                         'name': 'recv_itemsite_id_itemsite_lsseq_id',
3820                                                         'type': 'int'
3821                                                     },
3822                                                     {
3823                                                         'name': 'recv_itemsite_id_itemsite_cosdefault',
3824                                                         'type': 'string'
3825                                                     },
3826                                                     {
3827                                                         'name': 'recv_itemsite_id_itemsite_createsopr',
3828                                                         'type': 'int'
3829                                                     },
3830                                                     {
3831                                                         'name': 'recv_itemsite_id_itemsite_createsopo',
3832                                                         'type': 'int'
3833                                                     },
3834                                                     {
3835                                                         'name': 'recv_itemsite_id_itemsite_dropship',
3836                                                         'type': 'int'
3837                                                     },
3838                                                     {
3839                                                         'name': 'recv_freight_curr_id_curr_id',
3840                                                         'type': 'int'
3841                                                     },
3842                                                     {
3843                                                         'name': 'recv_freight_curr_id_curr_base',
3844                                                         'type': 'int'
3845                                                     },
3846                                                     {
3847                                                         'name': 'recv_freight_curr_id_curr_name',
3848                                                         'type': 'string'
3849                                                     },
3850                                                     {
3851                                                         'name': 'recv_freight_curr_id_curr_symbol',
3852                                                         'type': 'string'
3853                                                     },
3854                                                     {
3855                                                         'name': 'recv_freight_curr_id_curr_abbr',
3856                                                         'type': 'string'
3857                                                     }
3858                                                 ]
3859                                             }
3860                                         },
3861                                         footer : {
3862                                             xtype: 'PagingToolbar',
3863                                             xns: Roo,
3864                                             displayInfo : true,
3865                                             displayMsg : " ",
3866                                             emptyMsg : "No recv found",
3867                                             pageSize : 100
3868                                         },
3869                                         colModel : [
3870                                             {
3871                                                 xtype: 'ColumnModel',
3872                                                 xns: Roo.grid,
3873                                                 align : 'right',
3874                                                 dataIndex : 'item_number',
3875                                                 header : 'Item',
3876                                                 width : 75,
3877                                                 renderer : function(v) { return String.format('{0}', v); }
3878                                             },
3879                                             {
3880                                                 xtype: 'ColumnModel',
3881                                                 xns: Roo.grid,
3882                                                 align : 'right',
3883                                                 dataIndex : 'poitem_qty_ordered',
3884                                                 header : 'Ordered',
3885                                                 width : 60,
3886                                                 renderer : function(v) { return String.format('{0}', v); }
3887                                             },
3888                                             {
3889                                                 xtype: 'ColumnModel',
3890                                                 xns: Roo.grid,
3891                                                 align : 'right',
3892                                                 dataIndex : 'r.data.poitem_qty_received',
3893                                                 header : 'Outstanding',
3894                                                 width : 60,
3895                                                 renderer : function(v,x,r) {
3896
3897
3898                                                     var  d = r.data.poitem_qty_ordered - ( r.data.poitem_qty_received - r.data.poitem_qty_returned);
3899
3900                                                     if (!d) {
3901                                                         return '';
3902                                                     }
3903                                                     return String.format('<b style="color:red">{0}</b>', d);
3904                                                  }
3905                                             },
3906                                             {
3907                                                 xtype: 'ColumnModel',
3908                                                 xns: Roo.grid,
3909                                                 align : 'right',
3910                                                 dataIndex : 'recv_qty_in_transit',
3911                                                 header : 'In Transit',
3912                                                 width : 60,
3913                                                 renderer : function(v,x,r) {
3914                                                     // recv_qty
3915                                                     // this should show in transit.. (only applicable to
3916                                                     //var rr = _this.rggrid.selModel.getSelected();
3917                                                         //if (rr) {
3918                                                             //return '';
3919                                                     //    }
3920
3921                                                     // in transit = recieved, but not transfered.
3922                                                     if ((v*1) == 0.0) {
3923                                                         return '';
3924                                                     }
3925                                                     return String.format('{0}',  (v*1).toFixed(0));
3926                                                 /*
3927                                                         // no reciept selected..
3928                                                     d = r.data.poitem_qty_received - r.data.poitem_qty_returned ;
3929                                                     d -= (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3930
3931                                                     if (!d) {
3932                                                         return '';
3933                                                     }
3934                                                     return String.format('{0}',  d);
3935                                                     */
3936                                                  }
3937                                             },
3938                                             {
3939                                                 xtype: 'ColumnModel',
3940                                                 xns: Roo.grid,
3941                                                 align : 'right',
3942                                                 dataIndex : 'recv_qty',
3943                                                 header : 'Recieved',
3944                                                 width : 60,
3945                                                 renderer : function(v,x,r) {
3946
3947                                                     var d = parseInt(v);;
3948                                                     var rr = _this.rggrid.selModel.getSelected();
3949                                                     if (!rr) {
3950                                                         // show summary
3951                                                         //d = r.data.poitem_qty_received - r.data.poitem_qty_returned;
3952                                                         // real recived amount = the total that has been transfered out
3953
3954
3955
3956                                                        //d =  (r.data.poitem_qty_transfered_unposted*1 + r.data.poitem_qty_transfered*1) ;
3957                                                         //var tot_rec =  r.data.poitem_qty_received - r.data.poitem_qty_returned;
3958                                                         //if (d < tot_rec) {
3959                                                         //    return String.format('<b style="color:red">{0}</b>',  d);
3960                                                         //}
3961
3962                                                         //return String.format('{0}',  d);
3963
3964
3965                                                     }
3966
3967
3968                                                     if (!d) {
3969                                                         return '';
3970                                                     }
3971                                                     if (rr && rr.data.recvgrp_void *1 ) {
3972                                                             return String.format('<s>{0}</s>',  d);
3973
3974                                                     }
3975
3976
3977
3978                                                     return String.format('{0}',  d);
3979                                                  }
3980                                             }
3981                                         ]
3982                                     }
3983                                 }
3984                             ],
3985                             center : {
3986                                 xtype: 'LayoutRegion',
3987                                 xns: Roo,
3988                                 title : "Item Receipts",
3989                                 titlebar : true
3990                             },
3991                             south : {
3992                                 xtype: 'LayoutRegion',
3993                                 xns: Roo,
3994                                 height : 450,
3995                                 split : true,
3996                                 title : "Items"
3997                             }
3998                         }
3999                     }
4000                 ],
4001                 center : {
4002                     xtype: 'LayoutRegion',
4003                     xns: Roo
4004                 },
4005                 east : {
4006                     xtype: 'LayoutRegion',
4007                     xns: Roo,
4008                     split : true,
4009                     width : 340
4010                 }
4011             }
4012         };
4013     }
4014 });