MasterPKey 
ColumnName  MasterPKey 
Definition  
The master primary key.
 
PONumber 
ColumnName  PONumber 
Definition  
The purchase order number.
 
Type 
ColumnName  Type 
Definition  
The purchase order type. Valid options are R - Standard (the default setting), B - Blanket, and S- Service.
 
ReleaseNumber 
ColumnName  ReleaseNumber 
Definition  
The purchase order's release order number.
 
Status 
ColumnName  Status 
Definition  
The purchase order's processing status. Valid options are: N - In Progress, S - Submitted, A - Approved, J - Rejected, R - Released (Blanket purchase orders only, P - Printed, G- Changed, C - Cancelled
 
OrderDate 
ColumnName  OrderDate 
Definition  
The purchase order's date.
 
Vendor 
ColumnName  Vendor 
Definition  
The vendor number.
 
Address 
ColumnName  Address 
Definition  
The vendor address.
 
PayTerms 
ColumnName  PayTerms 
Definition  
The vendor's payment terms.
 
BillTo 
ColumnName  BillTo 
Definition  
The purchase order's bill-to code.
 
ShipTo 
ColumnName  ShipTo 
Definition  
The purchase order's ship-to code.
 
FirmName 
ColumnName  FirmName 
Definition  
The ship-to firm name, when the purchase order's ship-to code is OTHER.
 
Address1 
ColumnName  Address1 
Definition  
The first line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Address2 
ColumnName  Address2 
Definition  
The second line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Address3 
ColumnName  Address3 
Definition  
The third line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Address4 
ColumnName  Address4 
Definition  
The fourth line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
City 
ColumnName  City 
Definition  
The city of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
State 
ColumnName  State 
Definition  
The state of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Zip 
ColumnName  Zip 
Definition  
The ZIP code of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Country 
ColumnName  Country 
Definition  
The country of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Phone 
ColumnName  Phone 
Definition  
The ship-to firm's telephone number, when the purchase order's ship-to code is OTHER.
 
Fax 
ColumnName  Fax 
Definition  
The ship-to firm's facsimile transmission number, when the purchase order's ship-to code is OTHER.
 
EMail 
ColumnName  EMail 
Definition  
The ship-to firm's e-mail address, when the purchase order's ship-to code is OTHER.
 
ContactName 
ColumnName  ContactName 
Definition  
The name of the ship-to firm's contact person, when the purchase order's ship-to code is OTHER.
 
ShipVia 
ColumnName  ShipVia 
Definition  
The ship-to firm's ship-via code, when the purchase order's ship-to code is OTHER.
 
FOB 
ColumnName  FOB 
Definition  
The ship-to firm's free on board code, when the purchase order's ship-to code is OTHER.
 
AuthorizedBy 
ColumnName  AuthorizedBy 
Definition  
The employee number of the purchase order's approver.
 
Buyer 
ColumnName  Buyer 
Definition  
The employee number of the purchase order's buyer.
 
StartDate 
ColumnName  StartDate 
Definition  
The agreement's starting date, for blanket and service purchase orders.
 
EndDate 
ColumnName  EndDate 
Definition  
The agreement's ending date, for blanket and service purchase orders.
 
NotToExceed 
ColumnName  NotToExceed 
Definition  
The agreement's Not to Exceed amount, for blanket and service purchase orders.
 
AllowExcess 
ColumnName  AllowExcess 
Definition  
Variable indicating whether the Allow Excess Receiving checkbox is selected for the purchase order.  Valid options are Y - yes, and N - No (the default setting).
 
ExcessPct 
ColumnName  ExcessPct 
Definition  
When AllowExcess equals Y, the excess percentage allowed in Receiving.
 
ExcessAmount 
ColumnName  ExcessAmount 
Definition  
When AllowExcess equals Y, the excess amount allowed in Receiving.
 
ConfirmDate 
ColumnName  ConfirmDate 
Definition  
Reserved for future use.
 
ConfirmWith 
ColumnName  ConfirmWith 
Definition  
Reserved for future use.
 
TopClause 
ColumnName  TopClause 
Definition  
The standard clause to print on the top of the purchase order.
 
BottomClause 
ColumnName  BottomClause 
Definition  
The standard clause to print on the bottom of the purchase order.
 
Comments 
ColumnName  Comments 
Definition  
The contents of the Terms field on the Agreement tab.
 
Descriptions 
ColumnName  Descriptions 
Definition  
For blanket and service orders, the Description field's user-entered text; for example, a description of the items or services covered by the purchase order.
 
SubmittedBy 
ColumnName  SubmittedBy 
Definition  
The employee number of the person who submitted the purchase order for approval.
 
SubmittedDate 
ColumnName  SubmittedDate 
Definition  
The date and time when the purchase order was submitted for approval.
 
AuthorizedDate 
ColumnName  AuthorizedDate 
Definition  
The date and time when the purchase order was approved.
 
Closed 
ColumnName  Closed 
Definition  
Variable indicating whether the Closed checkbox is selected for this purchase order. Valid options are Y - yes, and N - no (the default setting.)
 
Company 
ColumnName  Company 
Definition  
The company to which the creator of this record belongs.
 
CurrencyCode 
ColumnName  CurrencyCode 
Definition  
The transaction currency for the entire purchase order.
 
PayDate 
ColumnName  PayDate 
Definition  
The payment date, if PayTerms is Date.
 
DistributionBase 
ColumnName  DistributionBase 
Definition  
The option selected on the Cost Distribution tab of the line item's detail dialog, when Distribution Overrides is selected. Valid options are Percentage Base and Unit Base.
 
PhoneFormat 
ColumnName  PhoneFormat 
Definition  
The number format to use for the Phone value.
 
FaxFormat 
ColumnName  FaxFormat 
Definition  
The number format to use for the Fax value.
 
FinalPrintDate 
ColumnName  FinalPrintDate 
Definition  
This field stores the date of the Final Print for the Purchase Order
 
TotalNetAmount 
ColumnName  TotalNetAmount 
Definition  
The column that stores the sum of the net amount of PO line items. If multicurrency is enabled, the functional currency of the PO company is used.
 
TotalNotToExceed 
ColumnName  TotalNotToExceed 
Definition  
The column that stores the sum of the Not to Exceed amount from the purchase order and its corresponding change orders.
 
POInternalNotes 
ColumnName  POInternalNotes 
Definition  
The column that stores the internal comments for a purchase order.
 
CreateUser 
ColumnName  CreateUser 
Definition  
The username of the user logged in when this record was created.
 
CreateDate 
ColumnName  CreateDate 
Definition  
The date and time when this record was created.
 
ModUser 
ColumnName  ModUser 
Definition  
The username of the user logged in when this record was modified.
 
ModDate 
ColumnName  ModDate 
Definition  
The date and time when this record was modified.