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