PO_PurchaseOrderDetail PO Purchase Order Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_PurchaseOrderDetail_bus,PO_ReceiptRegister_upd,PO_ReturnRegister_upd,PO_MaterialReqIssueReg SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_PurchaseOrderDetail.M4T"
KPRIMARY: PurchaseOrderNo+LineKey KDISPLAY: PurchaseOrderNo+LineSeqNo+LineKey KEXTENDEDDESC: ExtendedDescriptionKey+PurchaseOrderNo+LineKey KITEMTYPE: ItemType+ItemCode+PurchaseOrderNo+LineKey KITEMWHSE: ItemCode+WarehouseCode+PurchaseOrderNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO Read Only:Y 2 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 3 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 4 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE ChngTag:Replace0 5 ExtendedDescriptionKey. . . . 10 SNN Extended Description Key. . . .EXTDESCKEY Read Only:Y ValGroup:NotComme nt,ItemRequired 6 ItemType. . . . . . . . . . . 1 SNN 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=Miscellaneou s Item 7 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION ValGroup:NotComment, ItemRequired 8 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, ItemRequired 9 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE ValGroup:NotComment, ItemRequired,NotCharge 10 VendorPriceCode . . . . . . . 4 SNN Vendor Price Code . . . . . . . Read Only:Y 11 PurchasesAcctKey. . . . . . . 9 SYN Purchases Account Key . . . . .ACCOUNT DepVal:REQUIRED ValGroup:NotC omment,ItemRequired 12 Valuation . . . . . . . . . . 1 SNN Valuation . . . . . . . . . . . Read Only:Y Valid:1,2,3,4,5, 6 Notes: 1=Standard, 2=Average,3=Fifo, 4=Lifo, 5=Lot,6=Serial 13 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE DepVal:REQUIRED ValGroup:NotC omment,ItemRequired, ItemTypes 14 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:IMIntegrated, NotComment,MultiWarehouse, ItemRequired,RegularItem, NotNulWarehouseCode 15 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE Read Only:Y FmtType:CHARNUM 16 MasterLineKey . . . . . . . . 6 SNN Master Line Key . . . . . . . . Read Only:Y 17 Reschedule. . . . . . . . . . 1 SYN Reschedule. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: Dflt:N (If Mrp Integrated) 18 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:JCIntegrated, ItemRequired 19 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE DepVal:REQUIRED ValGroup:JCIn tegrated,JobNo,ItemRequired 20 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE DepVal:REQUIRED ValGroup:JCIn tegrated,JobNo,ItemRequired 21 ReceiptOfGoodsUpdated . . . . 1 SNN Receipt Of Goods Updated. . . .YESNO Read Only:Y DfltVal:N Valid:Y,N 22 WorkOrderNo . . . . . . . . . 7 SYN Work Order Number . . . . . . .WORKORDERNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:WOIntegrated, ItemRequired 23 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . DepVal:REQUIRED ValGroup:WOIn tegrated,WorkOrderNo, ItemRequired 24 SubStepPrefix . . . . . . . . 1 SNN Sub-Step Prefix . . . . . . . . DepVal:REQUIRED ValGroup:WOIn tegrated,WorkOrderNo, ItemRequired 25 SubStepSuffix . . . . . . . . 4 SNN Sub-Step Suffix . . . . . . . . DepVal:REQUIRED ValGroup:WOIn tegrated,WorkOrderNo, ItemRequired 26 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . DepVal:REQUIRED ValGroup:WOIn tegrated,WorkOrderNo, ItemRequired 27 AllocateLandedCost. . . . . . 1 SYN Allocate Landed Cost. . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotComment, ItemRequired,ItemTypes 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. . . . . . . . . . DepVal:REQUIRED ValGroup:Item Required 31 AssetAccount. . . . . . . . . 1 SYN Asset Account . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:FAIntegration, NotComment,ItemRequired, ItemTypes 32 AssetTemplate . . . . . . . . 25 SNN Asset Template. . . . . . . . .ASSETTEMPLATE ValGroup:FAIntegrated, NotComment,ItemRequired, ItemTypes 33 WeightReference . . . . . . . 10 SNN Weight Reference. . . . . . . . 34 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . .MISCAMOUNT Mask:#####.0000- ValGroup:Not Comment,ItemRequired, RegularItem 35 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NotMasterOrder 36 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:NotComme nt,ItemRequired,ItemTypes, NotMasterOrder 37 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NotMasterOrder 38 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . .QUANTITY Mask:##,###,###.000000- ValGroup:MasterOrder 39 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:MasterOr der 40 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To DateQUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:MasterOr der 41 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 42 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 43 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . .COST Read Only:Y Mask:##,###, ###.000000- 44 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .AMOUNT Mask:###,###,###.00- ValGroup:NotComment, ItemRequired 45 ReceivedAmt . . . . . . . . . 12.2 NNN Received Amount . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00 46 InvoicedAmt . . . . . . . . . 12.2 NNN Invoiced Amount . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00 47 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Read Only:Y Mask:#####0.0000 48 ReceivedAllocatedAmt. . . . . 12.2 NNN Received Allocated Amount . . .AMOUNT Read Only:Y Mask:###,###, ###.00 49 InvoicedAllocatedAmt. . . . . 12.2 NNN Invoiced Allocated Amount . . .AMOUNT Read Only:Y Mask:###,###, ###.00