PO_ReceiptVarianceCalculation PO Receipt Variance CalculationRel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReceiptRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptVarianceCalculation.M4T"
KPRIMARY: PurchaseOrderNo+LineKey KREGISTERNO: SourceJournal+RegisterNo+PurchaseOrderNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . . 2 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 3 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL Notes: Validated against GL_SourceJournal 4 RegisterNo. . . . . . . . . . 6 SNY Register Number . . . . . . . . Mask:000000 FmtType:ZEROFILL 5 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE 6 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 7 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 8 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . . 9 LastInvoiceDate . . . . . . . 8 SNN Last Invoice Date . . . . . . .DATE 10 LastInvoiceNo . . . . . . . . 10 SNN Last Invoice Number . . . . . . 11 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 12 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 13 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 14 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 15 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 16 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 17 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 18 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 19 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 20 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 21 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 22 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 23 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . 24 SubStepPrefix . . . . . . . . 1 SNN Sub Step Prefix . . . . . . . . 25 SubStepSuffix . . . . . . . . 4 SNN Sub Step Suffix . . . . . . . . 26 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . 27 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . . 28 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 29 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . . 30 ReceivedAmt . . . . . . . . . 12.2 NNN Received Amount . . . . . . . . 31 InvoicedAmt . . . . . . . . . 12.2 NNN Invoiced Amount . . . . . . . . 32 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Read Only:Y Mask:#####0.0000 33 ReceivedAllocatedAmt. . . . . 12.2 NNN Received Allocated Amount . . . 34 InvoicedAllocatedAmt. . . . . 12.2 NNN Invoiced Allocated Amount . . .