PO_PurchaseOrderRecap                  PO Purchase Order Recap        Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: N  SysDB: N                                 "MAS_"+%C$+"/PO"+%C$+"/PO_PurchaseOrderRecap.M4T"

 KPRIMARY: PurchaseOrderNo

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  PurchaseOrderNo . . . . . . .     7 SYN  Purchase Order Number . . . . .PURCHASEORDERNO
                                                Notes: {PO4$(1,7)}
   2  PurchaseOrderDate . . . . . .     8 SNN  Purchase Order Date . . . . . .DATE
                                                Notes: {PO4$(8,6)}
   3  OrderType . . . . . . . . . .     1 SYN  Order Type. . . . . . . . . . .
                                                DfltVal:S Valid:S,D,M,R,X
                                                Notes: {PO4$(14,1)}(S=Standa
                                                rd, D=Drop Ship, M=Master,
                                                R=Repeating, X= Material
                                                Requisition)
   4  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                Notes: {PO4$(15,2)}
   5  VendorNo. . . . . . . . . . .     7 SYN  Vendor Number . . . . . . . . .VENDORNO
                                                FmtType:MASTERNUM ChngTag:Rep
                                                lace1/APDivisionNo$ Notes:
                                                {PO4$(17,7)}
   6  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .NAME
                                                Notes: {PO4$(24,30)}
   7  OrderStatus . . . . . . . . .     1 SYN  Order Status. . . . . . . . . .
                                                DfltVal:N Valid:N,O,B,C,X,Z
                                                Notes: {PO4$(54,1)}(N=New,
                                                O=Open, B=Backordered,
                                                C=Change, X=complete,
                                                Z=Cancelled)
   8  RequiredExpireDate. . . . . .     8 SNN  Required Expire Date. . . . . .DATE
                                                Notes: {PO4$(55,6)}
   9  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .COMMENT30
                                                Notes: {PO4$(61,30)}
  10  LastInvoiceDate . . . . . . .     8 SNN  Last Invoice Date . . . . . . .DATE
                                                Notes: {PO4$(91,6)}
  11  LastInvoiceNo . . . . . . . .    10 SNN  Last AP Invoice Number. . . . .APINVOICE
                                                Notes: {PO4$(97,10)}
  12  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
                                                Notes: {PO4$(107,6)}
  13  LastPurchaseOrderDate . . . .     8 SNN  Last Purchase Order Date. . . .DATE
  14  LastReceiptNo . . . . . . . .     7 SNN  Last Receipt Number . . . . . .RECEIPTNO
                                                Notes: {PO4$(113,7)}
  15  LastPurchaseOrderNo . . . . .     7 SNN  Last Purchase Order Number. . .PURCHASEORDERNO
                                                Mask:0000000
  16  OrderTotal. . . . . . . . . . 13.2  NNN  Order Total . . . . . . . . . .AMOUNT
                                                Mask:###,###,###.00- Notes:
                                                {PO4[0]}
  17  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  18  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  19  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000