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

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