     CI_MiscellaneousItemListingWrk        CI Miscellaneous Item Listing WoRel: 4.40  Bld: 398  8/28/2009
     Bus Obj: CI_MiscellaneousItemListing_rpt
     SQL Def: Y  SysDB: N                 "MAS_"+%C$+"/CI"+%C$+"/CI_MiscellaneousItemListingWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  ReportSection . . . . . . . .     1 SNN  Report Section. . . . . . . . .
       4  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
       5  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
       6  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
       7  UseInAR . . . . . . . . . . .     1 SNN  Use In AR . . . . . . . . . . .
       8  UseInSO . . . . . . . . . . .     1 SNN  Use In SO . . . . . . . . . . .
       9  UseInPO . . . . . . . . . . .     1 SNN  Use In PO . . . . . . . . . . .
      10  UseInBM . . . . . . . . . . .     1 SNN  Use In BM . . . . . . . . . . .
      11  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      12  SalesUnitOfMeasure. . . . . .     4 SNN  Sales Unit of Measure . . . . .
      13  PurchaseUnitOfMeasure . . . .     4 SNN  Purchase Unit of Measure. . . .
      14  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit of Measure. . . .
      15  AllowTradeDiscount. . . . . .     1 SNN  Allow Trade Discount. . . . . .
      16  CalculateCommission . . . . .     1 SNN  Calculate Commission. . . . . .
      17  DropShip. . . . . . . . . . .     1 SNN  Drop Ship . . . . . . . . . . .
      18  AllowReturns. . . . . . . . .     1 SNN  Allow Returns . . . . . . . . .
      19  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      20  PurchasesTaxClass . . . . . .     2 SNN  Purchases Tax Class . . . . . .
      21  PostToGLByDivision. . . . . .     1 SNN  Post To GL By Division. . . . .
      22  EBMEnabled. . . . . . . . . .     1 SNN  EBM Enabled . . . . . . . . . .
      23  AllocateLandedCost. . . . . .     1 SNN  Allocate LandedCost . . . . . .
      24  VendorItemCode. . . . . . . .    30 SNN  Vendor ItemCode . . . . . . . .
      25  SetupCharge . . . . . . . . .     1 SNN  Setup Charge. . . . . . . . . .
      26  CostOfGoodsSoldAcctKey. . . .     9 SNN  Cost Of Goods Sold Account Key.
      27  CostOfGoodsSoldAccount. . . .    41 SNN  Fully Formatted Cost Of Goods S
      28  CostOfGoodsSoldAccountDesc. .    50 SNN  Cost Of Goods Sold Account Desc
      29  SalesAcctKey. . . . . . . . .     9 SNN  Sales Account Key . . . . . . .
      30  SalesAccount. . . . . . . . .    41 SNN  Fully Formatted Sales Account .
      31  SalesAccountDesc. . . . . . .    50 SNN  Sales Account Description . . .
      32  InventoryAcctKey. . . . . . .     9 SNN  Inventory Account Key . . . . .
      33  InventoryAccount. . . . . . .    41 SNN  Fully Formatted Inventory Accou
      34  InventoryAccountDesc. . . . .    50 SNN  Inventory Account Description .
      35  PurchaseAcctKey . . . . . . .     9 SNN  Purchase Account Key. . . . . .
      36  PurchaseAccount . . . . . . .    41 SNN  Fully Formatted Purchase Accoun
      37  PurchaseAccountDesc . . . . .    50 SNN  Purchase Account Description. .
      38  ManufacturingCostAcctKey. . .     9 SNN  Manufacturing Cost Account Key.
      39  ManufacturingCostAccount. . .    41 SNN  Fully Formatted Manufacturing C
      40  ManufacturingCostAccountDesc.    50 SNN  Manufacturing Cost Account Desc
      41  InternetItemName. . . . . . .    50 SNN  Internet Item Name. . . . . . .
      42  ImageFile . . . . . . . . . .    30 SNN  Image File. . . . . . . . . . .
      43  ThumbnailImage. . . . . . . .    30 SNN  Thumbnail Image File Name . . .
      44  AttachmentHREF1 . . . . . . .   128 SNN  Attachment HREF 1 . . . . . . .
      45  AttachmentHREF2 . . . . . . .   128 SNN  Attachment HREF 2 . . . . . . .
      46  AttachmentHREF3 . . . . . . .   128 SNN  Attachment HREF 3 . . . . . . .
      47  AttachmentHREF4 . . . . . . .   128 SNN  Attachment HREF 4 . . . . . . .
      48  AttachmentHREF5 . . . . . . .   128 SNN  Attachment HREF 5 . . . . . . .
      49  AttachmentHREF6 . . . . . . .   128 SNN  Attachment HREF 6 . . . . . . .
      50  AttachmentHREF7 . . . . . . .   128 SNN  Attachment HREF 7 . . . . . . .
      51  AttachmentHREF8 . . . . . . .   128 SNN  Attachment HREF 8 . . . . . . .
      52  AttachmentDesc1 . . . . . . .   128 SNN  Attachment Description 1. . . .
      53  AttachmentDesc2 . . . . . . .   128 SNN  Attachment Description 2. . . .
      54  AttachmentDesc3 . . . . . . .   128 SNN  Attachment Description 3. . . .
      55  AttachmentDesc4 . . . . . . .   128 SNN  Attachment Description 4. . . .
      56  AttachmentDesc5 . . . . . . .   128 SNN  Attachment Description 5. . . .
      57  AttachmentDesc6 . . . . . . .   128 SNN  Attachment Description 6. . . .
      58  AttachmentDesc7 . . . . . . .   128 SNN  Attachment Description 7. . . .
      59  AttachmentDesc8 . . . . . . .   128 SNN  Attachment Description 8. . . .
      60  Category. . . . . . . . . . .    10 SNN  Category. . . . . . . . . . . .
      61  CategoryDesc. . . . . . . . .    30 SNN  Category Description. . . . . .
      62  QuantitySoldPTD . . . . . . . 16.6  NNN  Quantity Sold Period to Date. .
      63  QuantitySoldYTD . . . . . . . 16.6  NNN  Quantity Sold Year to Date. . .
      64  QuantitySoldPY. . . . . . . . 16.6  NNN  Quantity Sold Prior Year. . . .
      65  QuantityReturnedCustomerPTD . 16.6  NNN  Quantity Returned Customer Peri
      66  QuantityReturnedCustomerYTD . 16.6  NNN  Quantity Returned Customer Year
      67  QuantityReturnedCustomerPY. . 16.6  NNN  Quantity Returned Customer Prio
      68  QuantityReceivedPTD . . . . . 16.6  NNN  Quantity Received Period to Dat
      69  QuantityReceivedYTD . . . . . 16.6  NNN  Quantity Received Year to Date.
      70  QuantityReceivedPY. . . . . . 16.6  NNN  Quantity Received Prior Year. .
      71  QuantityReturnedVendorPTD . . 16.6  NNN  Quantity Returned Vendor Period
      72  QuantityReturnedVendorYTD . . 16.6  NNN  Quantity Returned Vendor Year t
      73  QuantityReturnedVendorPY. . . 16.6  NNN  Quantity Returned Vendor Prior
      74  CostOfGoodsSoldPTD. . . . . . 15.2  NNN  Cost Of Goods Sold Period to Da
      75  CostOfGoodsSoldYTD. . . . . . 15.2  NNN  Cost Of Goods Sold Year to Date
      76  CostOfGoodsSoldPY . . . . . . 15.2  NNN  Cost Of Goods Sold Prior Year .
      77  QuantityIssuedPTD . . . . . . 16.6  NNN  Quantity Issued Period to Date.
      78  QuantityIssuedYTD . . . . . . 16.6  NNN  Quantity Issued Year to Date. .
      79  QuantityIssuedPY. . . . . . . 16.6  NNN  Quantity Issued Prior Year. . .
      80  IssuesCostPTD . . . . . . . . 15.2  NNN  Issues Cost Period to Date. . .
      81  IssuesCostYTD . . . . . . . . 15.2  NNN  Issues Cost Year to Date. . . .
      82  IssuesCostPY. . . . . . . . . 15.2  NNN  Issues Cost  Prior Year . . . .
      83  DollarsSoldPTD. . . . . . . . 15.2  NNN  Dollars Sold Period to Date . .
      84  DollarsSoldYTD. . . . . . . . 15.2  NNN  Dollars Sold Year to Date . . .
      85  DollarsSoldPY . . . . . . . . 15.2  NNN  Dollars Sold Prior Year . . . .
      86  ReceivedCostPTD . . . . . . . 15.2  NNN  Received Cost Period to Date. .
      87  ReceivedCostYTD . . . . . . . 15.2  NNN  Received Cost Year to Date. . .
      88  ReceivedCostPY. . . . . . . . 15.2  NNN  Received Cost Prior Year. . . .
      89  StandardUnitPrice . . . . . . 16.6  NNN  Standard Unit Price . . . . . .
      90  StandardUnitCost. . . . . . . 16.6  NNN  Standard Unit Cost. . . . . . .