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. . . . . . .