PO_MaterialReqHeader PO Material Requisition Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_MaterialReq_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_MaterialReqHeader.M4T"
KPRIMARY: IssueType+IssueNo KPONUMBER: PurchaseOrderNo+IssueType+IssueNo KBATCH: BatchNo+IssueType+IssueNo
Fld Column Name M/L TUR Description/Notes Class
1 IssueType . . . . . . . . . . 1 SYY Issue Type. . . . . . . . . . . DfltVal:M Valid:M Notes: {POH$(1,1)} 2 IssueNo . . . . . . . . . . . 6 SYY Issue Number. . . . . . . . . .ISSUENO FmtType:CHARNUM Next:IssueNo$ Notes: {POH$(2,6)} 3 IssueDate . . . . . . . . . . 8 SNN Issue Date. . . . . . . . . . .DATE Notes: {POH$(8,6)} 4 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO FmtType:CHARNUM Notes: {POH$(15,7)} 5 RequestedByName . . . . . . . 30 SNN Requested By Name . . . . . . .NAME Notes: {POH$(31,30)} 6 RequestedByDept . . . . . . . 30 SNN Requested By Department . . . . Notes: {POH$(61,30)} 7 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . . Notes: {POH$(153,4)} 8 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME Notes: {POH$(157,30)} 9 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE Notes: {POH$(187,30)} 10 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE Notes: {POH$(217,30)} 11 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE Notes: {POH$(471,30)} 12 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY Notes: {POH$(247,20)} 13 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE Notes: {POH$(267,2)} 14 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE Notes: {POH$(269,10)} 15 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY Notes: {POH$(501,3)} 16 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {POH$(301,15)} 17 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . . Valid:N,O,B,C,X Notes: {POH$(279,1)}(N=New, O=Open, B=Backordered, C=Change, X=complete) 18 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Valid:S,D,M,R,X Notes: {POH$(459,1)} (X=Material Request) 19 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE Notes: {POH$(460,6)} 20 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE Notes: {POH$(280,6)} 21 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {POH$(316,15)} 22 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:MultiWarehouse Notes: {POH$(331,3)} 23 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . Notes: {POH$(334,30)} 24 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 25 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {POH$(364,30)} 26 LastIssueDate . . . . . . . . 8 SNN Last Issue Date . . . . . . . .DATE Read Only:Y Notes: {POH$(431, 6)} 27 LastIssueNo . . . . . . . . . 7 SNN Last Issue Number . . . . . . .ISSUENO Read Only:Y Notes: {POH$(437, 7)} 28 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . .BATCHNO Notes: {POH$(466,5)} 29 TotalRequisitionAmt . . . . . 13.2 NNN Total Requisition Amount. . . .AMOUNT Mask:###,###,###.00- Notes: {POH[2]} 30 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 31 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 32 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 33 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 34 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 35 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000