PO_ReturnDetail                        PO Return Detail               Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: PO_ReturnDetail_bus
 SQL Def: Y  SysDB: N                                       "MAS_"+%C$+"/PO"+%C$+"/PO_ReturnDetail.M4T"

 KPRIMARY: ReturnType+ReturnNo+LineKey
 KDISPLAY: ReturnType+ReturnNo+LineSeqNo+LineKey
 KITEMWHSE: ItemCode+WarehouseCode+ReturnType+ReturnNo+LineKey
 KEXTENDEDDESC: ExtendedDescriptionKey+ReturnType+ReturnNo+LineKey

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ReturnType. . . . . . . . . .     1 SYY  Return Type . . . . . . . . . .
                                                Read Only:Y DfltVal:R
                                                Valid:R Notes: R=Return
   2  ReturnNo. . . . . . . . . . .     6 SYY  Return Number . . . . . . . . .RETURNNO
                                                Read Only:Y Mask:000000
                                                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  ReturnsAcctKey. . . . . . . .     9 SYN  Returns 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 DistribributedYESNO
                                                DfltVal:Y Valid:Y,N
                                                DepVal:REQUIRED ValGroup:NotC
                                                omment,ItemRequired
  17  OrderWarehouseCode. . . . . .     3 SYN  Order Warehouse . . . . . . . .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  VendorAliasItemNo . . . . . .    30 SYN  Vendor Alias Item Number. . . .
                                                ValGroup:NotComment,
                                                ItemRequired,RegularItem
  29  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                DepVal:REQUIRED ValGroup:NotC
                                                omment
  30  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
                                                DepVal:REQUIRED ValGroup:Item
                                                Required
  31  WeightReference . . . . . . .    10 SNN  Weight Reference. . . . . . . .
  32  Weight. . . . . . . . . . . . 16.6  NNN  Weight. . . . . . . . . . . . .MISCAMOUNT
                                                Mask:#####.0000- ValGroup:Not
                                                Comment,ItemRequired,
                                                RegularItem
  33  AllocatedFreightAmt . . . . . 12.2  NNN  Allocated Freight Amount. . . .MISCAMOUNT
                                                Mask:##,###,###.00-
  34  AllocatedTaxAmt . . . . . . . 12.2  NNN  Allocated Tax Amount. . . . . .MISCAMOUNT
                                                Read Only:Y Mask:##,###,
                                                ###.00-
  35  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  36  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  37  QuantityReturned. . . . . . . 16.6  NNN  Quantity Returned . . . . . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  38  OriginalQtyOrdered. . . . . . 16.6  NNN  Original Quantity Ordered . . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  39  PreviousQtyInvoiced . . . . . 16.6  NNN  Previous Quantity Invoiced. . .QUANTITY
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  40  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  41  OriginalUnitCost. . . . . . . 16.6  NNN  Original Unit Cost. . . . . . .COST
                                                Read Only:Y Mask:##,###,
                                                ###.000000-
  42  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .MISCAMOUNT
                                                Mask:###,###,###.00
                                                ValGroup:NotComment,
                                                ItemRequired
  43  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                Read Only:Y Mask:#####0.0000
  44  ActualUnitCost. . . . . . . . 16.6  NNN  Actual Unit Cost From Pre-UpdatCOST
                                                Mask:##,###,###.000000-
                                                ValGroup:NotComment,
                                                ItemRequired,ItemTypes
  45  ActualExtendedCost. . . . . . 12.2  NNN  Actual Extended Cost. . . . . .MISCAMOUNT
                                                Mask:###,###,###.00