PO_ReceiptDetail PO Receipt Detail Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptDetail.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: Y Create Tbl: N Bus Obj: PO_ReceiptOfGoodsDetail_bus PO_ReceiptOfInvoiceDetail_bus BC_CommonImport Record ID Column: ItemType
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 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . .SALESORDERNO Read Only:Y FmtType:CHARNUM ValGroup:SOSetup 36 CustomerPONo. . . . . . . . . 30 SNN Customer PO Number. . . . . . .CUSTOMERPONO Read Only:Y ValGroup:SOSetup 37 Weight. . . . . . . . . . . . 16.6 NNN Weight. . . . . . . . . . . . .MISCAMOUNT Mask:#####.0000- ValGroup:Not Comment,ItemRequired, RegularItem 38 AllocatedFreightAmt . . . . . 12.2 NNN Allocated Freight Amount. . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- ValGroup:Goods Notes: (Calc At Pre_Updt) 39 AllocatedLandedCostAmt. . . . 12.2 NNN Allocated Landed Cost Amount. .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- 40 AllocatedTaxAmt . . . . . . . 12.2 NNN Allocated Tax Amount. . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- 41 OriginalQtyOrdered. . . . . . 16.6 NNN Original Quantity Ordered . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes, NewLine 42 BalanceQtyBackordered . . . . 16.6 NNN Balance Quantity Backordered. .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes Notes: (Receipt)Was combined with OrigOrdQty 43 OriginalOrderQty. . . . . . . 16.6 NNN Original Order Quanity. . . . .QUANTITY Mask:##,###,###.000000- 44 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes Notes: (Receipt) 45 QuantityInvoiced. . . . . . . 16.6 NNN Quantity Invoiced . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes Notes: was combined with backordered qty 46 QuantityBackordered . . . . . 16.6 NNN Quantity Backordered (Receipt).QUANTITY Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 47 PreviousQtyReceived . . . . . 16.6 NNN Previous Quantity Received. . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:NotComme nt,ItemRequired,ItemTypes 48 PreviousQtyInvoiced . . . . . 16.6 NNN Previous Quantity Invoiced. . .QUANTITY Read Only:Y Mask:##,###, ###.000000- ValGroup:NotComme nt,ItemRequired,ItemTypes 49 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- ValGroup:NotComment, ItemRequired,ItemTypes 50 OriginalUnitCost. . . . . . . 16.6 NNN Original Unit Cost. . . . . . .COST Read Only:Y Mask:##,###, ###.000000- 51 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .MISCAMOUNT Mask:###,###,###.00- ValGroup:NotComment, ItemRequired 52 ExtendedNegQtyAdj . . . . . . 12.2 NNN Extended Negative Quanity AdjusMISCAMOUNT Read Only:Y Mask:###,###, ###.00 53 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Read Only:Y Mask:#####0.0000