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