PO_ReceiptInvoiceVarianceWrk PO Receipt Invoice Variance WorkRel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReceiptRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptInvoiceVarianceWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . . 3 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE 4 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 5 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 6 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 7 LastInvoiceDate . . . . . . . 8 SNN Last Invoice Date . . . . . . .DATE 8 LastInvoiceNo . . . . . . . . 10 SNN Last Invoice Number . . . . . . 9 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 10 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 11 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 12 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 13 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 14 UnitOfMeasure . . . . . . . . 4 SNN Unit of Measure . . . . . . . . 15 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 16 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 17 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 18 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 19 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 20 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 21 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . 22 SubStepPrefix . . . . . . . . 1 SNN Sub Step-Prefix . . . . . . . . 23 SubStepSuffix . . . . . . . . 4 SNN Sub Step-Suffix . . . . . . . . 24 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . 25 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 26 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 27 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . . 28 ReceivedAmt . . . . . . . . . 12.2 NNN Received Amount . . . . . . . . 29 InvoicedAmt . . . . . . . . . 12.2 NNN Invoice Amount. . . . . . . . . 30 ReceivedAllocatedAmt. . . . . 12.2 NNN Received Allocated Amount . . . 31 InvoicedAllocatedAmt. . . . . 12.2 NNN Invoiced Allocated Amount . . .