PO_PurchaseOrderDetail PO Purchase Order Detail Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/PO"+%C$+"/PO_PurchaseOrderDetail.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: Y Create Tbl: N Bus Obj: PO_PurchaseOrderDetail_bus PO_ReceiptRegister_upd PO_ReturnRegister_upd PO_MaterialReqIssueRegister_upd Mirror Table: PO_PurchaseOrderHistoryDetail
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 . . . . . . . . Mask:000000 FmtType:ZEROFILL 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 DepVal:REQUIRED ValGroup:FAIn tegrated,NotComment, ItemRequired,ItemTypes 33 WeightReference . . . . . . . 10 SNN Weight Reference. . . . . . . . 34 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM ValGroup:SOSe tup,NotMasterRepeatingOrder, NotMatReq,NotComment 35 CustomerPONo. . . . . . . . . 30 SNN Customer PO Number. . . . . . .CUSTOMERPONO ValGroup:SOSetup,NotMasterRep eatingOrder,NotMatReq, NotComment 36 PurchaseOrderHistoryDtlSeqNo. 14 SNN Purchase Order History Detail S Mask:00000000000000 FmtType:ZEROFILL 37 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . .MISCAMOUNT Mask:#####.0000- ValGroup:Not Comment,ItemRequired, RegularItem 38 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NotMasterOrder 39 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:NotComme nt,ItemRequired,ItemTypes, NotMasterOrder 40 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered. . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NotMasterOrder 41 MasterOriginalQty . . . . . . 16.6 NNN Master Original Quantity. . . .QUANTITY Mask:##,###,###.000000- ValGroup:POMasterOrder 42 MasterQtyBalance. . . . . . . 16.6 NNN Master Quantity Balance . . . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:POMaster Order 43 MasterQtyOrderedToDate. . . . 16.6 NNN Master Quantity Ordered To DateQUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:POMaster Order 44 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 45 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 46 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . .COST Read Only:Y Mask:##,###, ###.000000- 47 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .AMOUNT Mask:###,###,###.00- ValGroup:NotComment, ItemRequired 48 ReceivedAmt . . . . . . . . . 12.2 NNN Received Amount . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00 49 InvoicedAmt . . . . . . . . . 12.2 NNN Invoiced Amount . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00 50 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Read Only:Y Mask:#####0.0000 51 ReceivedAllocatedAmt. . . . . 12.2 NNN Received Allocated Amount . . .AMOUNT Read Only:Y Mask:###,###, ###.00 52 InvoicedAllocatedAmt. . . . . 12.2 NNN Invoiced Allocated Amount . . .AMOUNT Read Only:Y Mask:###,###, ###.00