     PO_ReceiptDetail                       PO Receipt Detail              Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: PO_ReceiptOfGoodsDetail_bus,PO_ReceiptOfInvoiceDetail_bus,BC_CommonImport
     SQL Def: Y  SysDB: N                                      "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptDetail.M4T"

     KPRIMARY: ReceiptType+ReceiptNo+LineKey
     KDISPLAY: ReceiptType+ReceiptNo+LineSeqNo+LineKey
     KEXTENDEDDESC: ExtendedDescriptionKey+ReceiptType+ReceiptNo+LineKey
     KITEMWHSE: ItemCode+WarehouseCode+ReceiptType+ReceiptNo+LineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ReceiptType . . . . . . . . .     1 SYY  Receipt Type. . . . . . . . . .
                                                    Read Only:Y Valid:G,I Notes:
                                                    G=Goods, I=Invoice
       2  ReceiptNo . . . . . . . . . .     6 SYY  Receipt Number. . . . . . . . .RECEIPTNO
                                                    Read Only:Y FmtType:CHARNUM
       3  LineKey . . . . . . . . . . .     6 SNY  Line Key. . . . . . . . . . . .
                                                    Read Only:Y Mask:000000
                                                    FmtType:ZEROFILL
       4  LineSeqNo . . . . . . . . . .    14 SNY  Line Sequence Number. . . . . .
                                                    Read Only:Y Mask:000000000000
                                                    00 FmtType:ZEROFILL
       5  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
       6  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y ValGroup:NotComme
                                                    nt,ItemRequired
       7  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                    Read Only:Y Valid:1,2,3,4,5
                                                    Notes: 1=Regular Item,
                                                    2=Special Item, 3=Charge
                                                    Item, 4=Comment Item,
                                                    5=Miscellaneous Item
       8  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                    ValGroup:NotComment,
                                                    ItemRequired
       9  UseTax. . . . . . . . . . . .     1 SYN  Use Tax . . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment,
                                                    ItemRequired
      10  RequiredDate. . . . . . . . .     8 SNN  Required Date . . . . . . . . .DATE
                                                    ValGroup:NotComment,
                                                    ItemRequired,NotCharge
      11  VendorPriceCode . . . . . . .     4 SYN  Vendor Price Code . . . . . . .
                                                    Read Only:Y
      12  PurchasesAcctKey. . . . . . .     9 SYN  Purchases Account Key . . . . .ACCOUNT
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired
      13  Valuation . . . . . . . . . .     1 SYN  Valuation . . . . . . . . . . .
                                                    Read Only:Y Valid:1,2,3,4,5,
                                                    6 Notes: 1=Standard,
                                                    2=Average, 3=Fifo, 4=Lifo,
                                                    5=Lot, 6=Serial
      14  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired,
                                                    ItemTypes
      15  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:IMIntegrated,
                                                    NotComment,MultiWarehouse,
                                                    ItemRequired,RegularItem,
                                                    NotNulWarehouseCode
      16  LotSerialFullyDistributed . .     1 SYN  Lot/Serial Fully Distributed. .YESNO
                                                    DfltVal:Y Valid:Y,N
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired,Goods
      17  OrderWarehouseCode. . . . . .     3 SYN  Order Warehouse Code. . . . . .WAREHOUSE
                                                    Read Only:Y FmtType:CHARNUM
                                                    ValGroup:IMIntegrated,
                                                    NotComment,MultiWarehouse,
                                                    ItemRequired,RegularItem,
                                                    NotNulWarehouseCode
      18  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    Read Only:Y FmtType:CHARNUM
      19  OrderLineKey. . . . . . . . .     6 SNN  Order Line Key. . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    ValGroup:NotComment
      20  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:JCIntegrated,
                                                    ItemRequired
      21  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo,ItemRequired
      22  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo,ItemRequired
      23  WorkOrderNo . . . . . . . . .     7 SYN  Work Order Number . . . . . . .WORKORDERNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:WOIntegrated,
                                                    ItemRequired
      24  StepNo. . . . . . . . . . . .     4 SNN  Step Number . . . . . . . . . .
                                                    Mask:0000 DepVal:REQUIRED
                                                    ValGroup:WOIntegrated,
                                                    WorkOrderNo,ItemRequired
      25  SubStepPrefix . . . . . . . .     1 SYN  Sub-Step Prefix . . . . . . . .
                                                    DepVal:REQUIRED ValGroup:WOIn
                                                    tegrated,WorkOrderNo,
                                                    ItemRequired
      26  SubStepSuffix . . . . . . . .     4 SNN  Sub-Step Suffix . . . . . . . .
                                                    Mask:0000 DepVal:REQUIRED
                                                    ValGroup:WOIntegrated,
                                                    WorkOrderNo,ItemRequired
      27  WorkOrderType . . . . . . . .     1 SNN  Work Order Type . . . . . . . .
                                                    Mask:0 DepVal:REQUIRED
                                                    ValGroup:WOIntegrated,
                                                    WorkOrderNo,ItemRequired
      28  AllocateLandedCost. . . . . .     1 SYN  Allocate Landed Cost. . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      29  VendorAliasItemNo . . . . . .    30 SYN  Vendor Alias Item Number. . . .
                                                    ValGroup:NotComment,
                                                    ItemRequired,RegularItem
      30  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment
      31  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
                                                    DepVal:REQUIRED ValGroup:Item
                                                    Required
      32  AssetAccount. . . . . . . . .     1 SYN  Assett Account. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:FAIntegrated,
                                                    NotComment,ItemRequired,
                                                    ItemTypes
      33  AssetTemplate . . . . . . . .    25 SNN  Asset Template. . . . . . . . .ASSETTEMPLATE
                                                    DepVal:REQUIRED ValGroup:FAIn
                                                    tegrated,NotComment,
                                                    ItemRequired,ItemTypes
      34  WeightReference . . . . . . .    10 SNN  Weight Reference. . . . . . . .
      35  Weight. . . . . . . . . . . . 16.6  NNN  Weight. . . . . . . . . . . . .MISCAMOUNT
                                                    Mask:#####.0000- ValGroup:Not
                                                    Comment,ItemRequired,
                                                    RegularItem
      36  AllocatedFreightAmt . . . . . 12.2  NNN  Allocated Freight Amount. . . .MISCAMOUNT
                                                    Read Only:Y Mask:##,###,
                                                    ###.00- ValGroup:Goods
                                                    Notes: (Calc At Pre_Updt)
      37  AllocatedLandedCostAmt. . . . 12.2  NNN  Allocated Landed Cost Amount. .MISCAMOUNT
                                                    Read Only:Y Mask:##,###,
                                                    ###.00-
      38  AllocatedTaxAmt . . . . . . . 12.2  NNN  Allocated Tax Amount. . . . . .MISCAMOUNT
                                                    Read Only:Y Mask:##,###,
                                                    ###.00-
      39  OriginalQtyOrdered. . . . . . 16.6  NNN  Original Quantity Ordered . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes,
                                                    NewLine
      40  BalanceQtyBackordered . . . . 16.6  NNN  Balance Quantity Backordered. .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: (Receipt)Was
                                                    combined with OrigOrdQty
      41  OriginalOrderQty. . . . . . . 16.6  NNN  Original Order Quanity. . . . .QUANTITY
                                                    Mask:##,###,###.000000-
      42  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: (Receipt)
      43  QuantityInvoiced. . . . . . . 16.6  NNN  Quantity Invoiced . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: was combined with
                                                    backordered qty
      44  QuantityBackordered . . . . . 16.6  NNN  Quantity Backordered (Receipt).QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      45  PreviousQtyReceived . . . . . 16.6  NNN  Previous Quantity Received. . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ValGroup:NotComme
                                                    nt,ItemRequired,ItemTypes
      46  PreviousQtyInvoiced . . . . . 16.6  NNN  Previous Quantity Invoiced. . .QUANTITY
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000- ValGroup:NotComme
                                                    nt,ItemRequired,ItemTypes
      47  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
      48  OriginalUnitCost. . . . . . . 16.6  NNN  Original Unit Cost. . . . . . .COST
                                                    Read Only:Y Mask:##,###,
                                                    ###.000000-
      49  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .MISCAMOUNT
                                                    Mask:###,###,###.00
                                                    ValGroup:NotComment,
                                                    ItemRequired
      50  ExtendedNegQtyAdj . . . . . . 12.2  NNN  Extended Negative Quanity AdjusMISCAMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00
      51  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Read Only:Y Mask:#####0.0000