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