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