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