PO_ReceiptHistoryDetail PO Receipt History Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReceiptRegister_upd,PO_ReceiptHistoryDetail_bus,PO_ReturnRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptHistoryDetail.M4T"
KPRIMARY: PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+ItemType+ItemCode+LineKey KDISPLAY: PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+LineSeqNo+LineKey+ItemType+ItemCode KEXTENDEDDESC: ExtendedDescriptionKey+PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo+ItemType+ItemCo de+LineKey(**) **=Case Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO Mask:0000000 Notes: {POM$(1, 7)} 2 ReceiptType . . . . . . . . . 1 SYY Receipt Type. . . . . . . . . . Valid:G,I Notes: {POM$(8,1)} 3 ReceiptNo . . . . . . . . . . 6 SYY Receipt Number. . . . . . . . .RECEIPTNO Mask:0000000 Notes: {POM$(9, 6)} 4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 5 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 Notes: {POM$(16,15)} 6 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {POM$(36,5)} 7 ItemType. . . . . . . . . . . 1 SYN Item Type . . . . . . . . . . . Valid:1,2,5 Notes: {POM$(15, 1)}1=Regular Item, 2=Special Item, 3=Charge Item, 4=Comment Item, 5=Miscellaneous Item 8 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . FmtType:ZEROFILL 9 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION Notes: {POM$(41,30)} 10 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY Read Only:Y 11 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {POM$(71,3)} 12 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE Notes: {POM$(74,4)} 13 AllocateLandedCost. . . . . . 1 SYN Allocate Landed Cost. . . . . .YESNO DfltVal:N Valid:Y,N Notes: {POM$(78,1)} 14 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {POM$(79,1)} 15 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM Notes: {POM$(80,7)} 16 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE Notes: {POM$(87,9)} 17 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE Notes: {POM$(96,1)} 18 WorkOrderNo . . . . . . . . . 7 SYN Work Order Number . . . . . . .WORKORDERNO FmtType:CHARNUM ValGroup:WOIn tegrated Notes: {POM$(80,7)} 19 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . Mask:0000 ValGroup:WOIntegrat ed Notes: {POM$(87,4)} 20 SubStepPrefix . . . . . . . . 1 SYN Sub Step Prefix . . . . . . . . ValGroup:WOIntegrated Notes: {POM$(91,1)} 21 SubStepSuffix . . . . . . . . 1 SYN Sub Step Suffix . . . . . . . . ValGroup:WOIntegrated Notes: {POM$(92,4)} 22 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . Mask:0 ValGroup:WOIntegrated Notes: {POM$(96,1)} 23 Valuation . . . . . . . . . . 1 SYN Valuation . . . . . . . . . . . Valid:1,2,3,4,5,6 Notes: 1=Standard, 2=Average, 3=Fifo, 4=Lifo, 5=Lot, 6=Serial {POM$(97,1)} 24 ExpenseAcctKey. . . . . . . . 9 SNN Expense Account Key . . . . . .ACCOUNT Notes: {POM$(98,9)} 25 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE Notes: {POM$(107,6)} 26 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS Notes: {POM$(113,2)} 27 VendorPriceCode . . . . . . . 4 SYN Vendor Price Code . . . . . . . Notes: {POM$(133,4)} 28 OrderWarehouseCode. . . . . . 3 SNN Order Warehouse Code. . . . . .WAREHOUSE FmtType:CHARNUM Notes: {POM$(137,3)} 29 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE Notes: {POM$(140,4)} 30 VendorAliasItemNo . . . . . . 30 SYN Vendor Alias Item Number. . . . Notes: {POM$(154,30)} 31 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 32 WeightReference . . . . . . . 10 SNN Weight Reference. . . . . . . . 33 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POM$(144,10)} 34 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: {POM[0]} 35 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POM[1]} 36 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- Notes: {POM[2]} 37 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . .COST Mask:##,###,###.000000- 38 OriginalQuantityOrdered . . . 16.6 NNN Original Quantity Ordered . . .QUANTITY Mask:##,###,###.000000- Notes: {POM[3]} 39 PreviousQuantityReceived. . . 16.6 NNN Previous Quantity Received. . .QUANTITY Mask:##,###,###.000000- Notes: {POM[5]} 40 PreviousQuantityInvoiced. . . 16.6 NNN Previous Quantity Invoiced. . .QUANTITY Mask:##,###,###.000000- Notes: {POM[6]} 41 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 Notes: {POM[4]}