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