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