     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