PO_PurchaseOrderHeader PO Purchase Order Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_PurchaseOrder_bus,PO_ReceiptRegister_upd,PO_ReturnRegister_upd,PO_MaterialReqIssueRegister_ SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_PurchaseOrderHeader.M4T"
KPRIMARY: PurchaseOrderNo KVENDOR: APDivisionNo+VendorNo+PurchaseOrderNo
Fld Column Name M/L TUR Description/Notes Class
1 PurchaseOrderNo . . . . . . . 7 SYY Purchase Order Number . . . . .PURCHASEORDERNO FmtType:CHARNUM Next:Purchase OrderNo$ Notes: {PO1$(1,7)} 2 PurchaseOrderDate . . . . . . 8 SNY Purchase Order Date . . . . . .DATE Notes: {PO1$(8,6)} 3 OrderType . . . . . . . . . . 1 SYY Order Type. . . . . . . . . . . DfltVal:S Valid:S,D,M,R,X Notes: {PO1$(14,1)}(S=Standa rd, D=Drop Ship, M=Master, R=Repeating, X= Material Requisition) 4 MasterRepeatingOrderNo. . . . 7 SYN Master Repeating Order Number .PURCHASEORDERNO Mask:0000000 FmtType:CHARNUM DepVal:REQUIRED ValGroup:NotR epeatingOrMaster Notes: {PO1$(15,7)} 5 RequiredExpireDate. . . . . . 8 SNN Required/Expire Date. . . . . .DATE Notes: {PO1$(280,6)}(Types Sdx/Mr) 6 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 DepVal:REQUIRED ValGroup:NotMatReq Notes: {PO1$(22,2)} 7 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM DepVal:REQU IRED ValGroup:NotMatReq ChngTag:Replace1/APDivisionNo $ Notes: {PO1$(24,7)} 8 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . .NAME ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(31,30)} 9 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . .ADDRESSLINE ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(61,30)} 10 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . .ADDRESSLINE ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(91,30)} 11 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . .ADDRESSLINE ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(472,30)} 12 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . .CITY ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(121,20)} 13 PurchaseState . . . . . . . . 2 SYN Purchase State. . . . . . . . .STATE ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(141,2)} 14 PurchaseZipCode . . . . . . . 10 SYN Purchase Zip Code . . . . . . .ZIPCODE ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(143,10)} 15 PurchaseCountryCode . . . . . 3 SYN Purchase Country Code . . . . .COUNTRY ValGroup:NotMatReq,VendorRequ ired Notes: {PO1$(502,3)} 16 PurchaseAddressCode . . . . . 4 SYN Purchase Address Code . . . . .PURCHASEADDRCODE DepVal:REQUIRED ValGroup:NotM atReq,VendorRequired Notes: {PO1$(286,4)} 17 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . .SHIPTO Notes: {PO1$(153,4)} This is a dual purpose field and could hold either the PO Ship To Code or SO Ship To Code. 18 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME Notes: {PO1$(157,30)} 19 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE Notes: {PO1$(187,30)} 20 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE Notes: {PO1$(217,30)} 21 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE Notes: {PO1$(522,30)} 22 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY Notes: {PO1$(247,20)} 23 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE Notes: {PO1$(267,2)} 24 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE Notes: {PO1$(269,10)} 25 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY Notes: {PO1$(552,3)} 26 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . . DfltVal:N Valid:N,O,B,C,X Notes: {PO1$(279,1)}(N=New, O=Open, B=Backordered, C=Change, X=complete) 27 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:APSalesTax, NotMatReq Notes: {PO1$(290, 1)} 28 PrintPurchaseOrders . . . . . 1 SYN Print Purchase Orders . . . . .YESNO DfltVal:N Valid:Y,N Notes: {PO1$(291,1)} 29 OnHold. . . . . . . . . . . . 1 SYN On Hold . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {PO1$(292,1)} 30 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotMatReq Notes: {PO1$(293,1)} 31 BatchEmail. . . . . . . . . . 1 SYN Batch Email . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotMatReq 32 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 33 CompletionDate. . . . . . . . 8 SNN Completion Date . . . . . . . .DATE ValGroup:NotRepeatingOrMaster Notes: {PO1$(295,6)} 34 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {PO1$(301,15)} 35 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {PO1$(316,15)} 36 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:MultiWarehouse Notes: {PO1$(331,3)} 37 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . Notes: {PO1$(334,30)} 38 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {PO1$(364,30)} 39 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number If Drop ShipARDIVISION Mask:00 ValGroup:NotMatReq, DropShip Notes: {PO1$(394,2)} 40 CustomerNo. . . . . . . . . . 20 SNN Customer Number If Drop Ship P/CUSTOMERNO ValGroup:NotMatReq,DropShip ChngTag:Replace1/ARDivisionNo $ Notes: {PO1$(396,7)} 41 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .APTERMS Mask:00 FmtType:ZEROFILL ValGroup:NotMatReq Notes: {PO1$(403,2)} 42 LastInvoiceDate . . . . . . . 8 SNN Last Invoice Date . . . . . . .DATE Read Only:Y ValGroup:NotRepea tingOrMaster Notes: {PO1$(405,6)} 43 LastInvoiceNo . . . . . . . . 10 SNN Last AP Invoice Number. . . . .APINVOICE Read Only:Y ValGroup:NotRepea tingOrMaster Notes: {PO1$(411,10)} 44 Form1099. . . . . . . . . . . 1 SYN 1099 Form . . . . . . . . . . .FORM1099 DfltVal:N Valid:N,M,I,D DepVal:REQUIRED ValGroup:Ten9 9,NotMatReq Notes: {PO1$(421, 1)} 45 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .BOX1099 ValGroup:Ten99,NotMatReq Notes: {PO1$(422,2)} 46 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE Read Only:Y ValGroup:NotMatRe q Notes: {PO1$(431,6)} 47 LastIssueDate . . . . . . . . 8 SNN Last Issue Date . . . . . . . .DATE Read Only:Y ValGroup:NotMatRe q 48 LastPurchaseOrderDate . . . . 8 SNN Last PO Date. . . . . . . . . .DATE Read Only:Y ValGroup:NotMatRe q 49 LastReceiptNo . . . . . . . . 7 SNN Last Receipt Number . . . . . .RECEIPTNO Read Only:Y ValGroup:NotMatRe q Notes: {PO1$(437,7)} 50 LastIssueNo . . . . . . . . . 7 SNN Last Issue Number . . . . . . . Read Only:Y ValGroup:NotMatRe q 51 LastPurchaseOrderNo . . . . . 7 SNN Last PO Number. . . . . . . . . Read Only:Y ValGroup:NotMatRe q 52 PrepaidCheckNo. . . . . . . . 10 SYN Prepaid AP Check Number . . . .APCHECKNO ValGroup:NotMatReq Notes: {PO1$(466,6)} 53 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO ValGroup:NotMatReq Notes: {PO1$(505,17)} 54 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE DepVal:REQUIRED ValGroup:APSa lesTax,NotMatReq Notes: {PO1$(575,9)} 55 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO DfltVal:N Valid:Y,N ValGroup:NotMatReq,APSalesTax Notes: {PO1$(584,1)} 56 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . . FmtType:CHARNUM ValGroup:Vend orRequired 57 RequisitorName. . . . . . . . 30 SNN Requisitor Name . . . . . . . . 58 RequisitorDepartment. . . . . 30 SNN Requisitor Department . . . . . ValGroup:IsMatReq 59 PrepaidAmt. . . . . . . . . . 13.2 NNN Prepaid Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- ValGroup:NotMatReq Notes: {PO1[1]} 60 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- ValGroup:NotMatReq Notes: {PO1[2]} 61 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- ValGroup:NotMatReq Notes: {PO1[3]} 62 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- ValGroup:NotMatReq Notes: {PO1[5]} 63 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:NotMatReq Notes: {PO1[6]} 64 PrepaidFreightAmt . . . . . . 12.2 NNN Prepaid Freight Amount. . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:NotMatReq,NotRepeati ngOrMaster Notes: {PO1[11]} 65 InvoicedAmt . . . . . . . . . 13.2 NNN Invoiced Amount . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {PO1[7]} 66 ReceivedAmt . . . . . . . . . 13.2 NNN Received Amount . . . . . . . .AMOUNT Mask:###,###,###.00- ValGroup:NotMatReq Notes: {PO1[8]} 67 FreightSalesTaxInvAmt . . . . 13.2 NNN Freight and Sales Tax Invoiced AMOUNT Mask:###,###,###.00- ValGroup:NotMatReq Notes: {PO1[9]} 68 BackOrderLostAmt. . . . . . . 13.2 NNN Back Order Lost Amount. . . . .AMOUNT Mask:###,###,###.00- ValGroup:NotMatReq Notes: {PO1[10]} 69 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 70 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 71 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 72 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 73 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 74 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000