IM_ReceiptLabelsWork IM Receipt Labels Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_TransactionRegister_upd,PO_ReceiptRegister_upd Mirror: IM_InventoryLabelsWrk SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_ReceiptLabelsWork"+%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 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 4 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 5 LabelNumber . . . . . . . . . 14 SNN Label Number. . . . . . . . . . 6 CalculateCommission . . . . . 1 SNN Calculate Commission. . . . . . 7 PriceCode . . . . . . . . . . 4 SNN Price Code. . . . . . . . . . . 8 PriceCodeDesc . . . . . . . . 25 SNN Price Code Description. . . . . 9 AllowTradeDiscount. . . . . . 1 SNN Allow Trade Discount. . . . . . 10 SalesUnitOfMeasure. . . . . . 4 SNN Sales Unit Of Measure . . . . . 11 PurchaseUnitOfMeasure . . . . 4 SNN Purchase Unit Of Measure. . . . 12 StandardUnitOfMeasure . . . . 4 SNN Standard Unit Of Measure. . . . 13 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 14 PurchasesTaxClass . . . . . . 2 SNN Purchases Tax Class . . . . . . 15 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 16 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 17 ProductType . . . . . . . . . 1 SNN Product Type. . . . . . . . . . 18 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . 19 AllowBackOrders . . . . . . . 1 SNN Allow Back Orders . . . . . . . 20 DefaultWarehouseCode. . . . . 3 SNN Default Warehouse Code. . . . . 21 DefaultWarehouseDesc. . . . . 30 SNN Default Warehouse Description . 22 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 23 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 24 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 25 PrimaryVendorAliasItemNo. . . 30 SNN Primary Vendor Alias Item Numbe 26 NextAPDivisionNo. . . . . . . 2 SNN Next AP Division Number . . . . 27 NextVendorNo. . . . . . . . . 7 SNN Next Vendor Number. . . . . . . 28 NextVendorName. . . . . . . . 30 SNN Next Vendor Name. . . . . . . . 29 NextVendorAliasItemNo . . . . 30 SNN Next Vendor Alias Item Number . 30 LastSoldDate. . . . . . . . . 8 SNN Last Sold Date. . . . . . . . .DATE 31 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE 32 Category1Desc . . . . . . . . 15 SNN Category1Desc . . . . . . . . . 33 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 34 Category2Desc . . . . . . . . 15 SNN Category2Desc . . . . . . . . . 35 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 36 Category3Desc . . . . . . . . 15 SNN Category3Desc . . . . . . . . . 37 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 38 Category4Desc . . . . . . . . 15 SNN Category4Desc . . . . . . . . . 39 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 40 SalesPromotionCode. . . . . . 10 SNN Sales Promotion Code. . . . . . 41 SaleStartingDate. . . . . . . 8 SNN Sale Starting Date. . . . . . .DATE 42 SaleEndingDate. . . . . . . . 8 SNN Sale Ending Date. . . . . . . .DATE 43 SaleMethod. . . . . . . . . . 1 SNN Sale Method . . . . . . . . . . 44 ShipWeight. . . . . . . . . . 10 SNN Ship Weight . . . . . . . . . . 45 NextLotSerialNo . . . . . . . 15 SNN Next Lot Serial Number. . . . . 46 InventoryCycle. . . . . . . . 1 SNN Inventory Cycle . . . . . . . . 47 RoutingNo . . . . . . . . . . 20 SNN Routing Number. . . . . . . . . 48 ProcurementType . . . . . . . 1 SNN Procurement Type. . . . . . . . 49 ReorderWarehouseCode. . . . . 3 SNN Reorder Warehouse Code. . . . . 50 ReorderWarehouseDesc. . . . . 30 SNN Reorder Warehouse Description . 51 BinLocation . . . . . . . . . 10 SNN Bin Location. . . . . . . . . . 52 ReorderMethod . . . . . . . . 1 SNN Reorder Method. . . . . . . . . 53 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number - Auto Only . 54 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost. . . . . . . 55 StandardUnitPrice . . . . . . 16.6 NNN Standard Unit Price . . . . . . 56 LastTotalUnitCost . . . . . . 16.6 NNN Last Total Unit Cost. . . . . . 57 AverageUnitCost . . . . . . . 16.6 NNN Average Unit Cost . . . . . . . 58 SalesPromotionPrice . . . . . 16.6 NNN Sales Promotion Price . . . . . 59 SuggestedRetailPrice. . . . . 16.6 NNN Suggested Retail Price. . . . . 60 SalesPromotionDiscountPercent 12.3 NNN Sales Promotion Discount Percen 61 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . . 62 BaseCommAmt . . . . . . . . . 12.2 NNN Base Commission Amount. . . . . 63 PurchaseUMConvFctr. . . . . . 12.4 NNN Purchase Unit of Measure Conver 64 SalesUMConvFctr . . . . . . . 12.4 NNN Sales Unit of Measure Conversio 65 Volume. . . . . . . . . . . . 11.4 NNN Volume. . . . . . . . . . . . . 66 PrimaryVendorStandardLeadTime 6.0 NNN Primary Vendor Standard Lead Ti 67 NextVendorStandardLeadTime. . 6.0 NNN Next Vendor Standard Lead Time. 68 EconomicOrderQty. . . . . . . 16.6 NNN Economic Order Quantity . . . . 69 ReorderPointQty . . . . . . . 16.6 NNN Reorder Point Quantity. . . . . 70 MinimumOrderQty . . . . . . . 16.6 NNN Minimum Order Quantity. . . . . 71 MaximumOnHandQty. . . . . . . 16.6 NNN Maximum On Hand Quantity. . . . 72 ReceivedQty . . . . . . . . . 16.6 NNN Received Quantity . . . . . . .