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