POMaster 
Default Table Name  POMaster 
Definition  
Purchasing Table - Purchase Order Master
 

POMaster Columns 
ColumnName  Domain  Datatype  NULL  Definition 
MasterPKey(PK)    varchar(32)  NO  
The master primary key.
 
PONumber    nvarchar(13)  NO  
The purchase order number.
 
Type    varchar(1)  NO  
The purchase order type. Valid options are R - Standard (the default setting), B - Blanket, and S- Service.
 
ReleaseNumber    nvarchar(13)  YES  
The purchase order's release order number.
 
Status    varchar(1)  NO  
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    datetime  YES  
The purchase order's date.
 
Vendor    nvarchar(20)  NO  
The vendor number.
 
Address    nvarchar(20)  NO  
The vendor address.
 
PayTerms    nvarchar(7)  YES  
The vendor's payment terms.
 
BillTo    nvarchar(20)  NO  
The purchase order's bill-to code.
 
ShipTo    nvarchar(20)  YES  
The purchase order's ship-to code.
 
FirmName    nvarchar(100)  YES  
The ship-to firm name, when the purchase order's ship-to code is OTHER.
 
Address1    nvarchar(50)  YES  
The first line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Address2    nvarchar(50)  YES  
The second line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Address3    nvarchar(50)  YES  
The third line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Address4    nvarchar(50)  YES  
The fourth line of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
City    nvarchar(30)  YES  
The city of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
State    nvarchar(10)  YES  
The state of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Zip    nvarchar(10)  YES  
The ZIP code of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Country    nvarchar(2)  YES  
The country of the ship-to firm's address, when the purchase order's ship-to code is OTHER.
 
Phone    nvarchar(24)  YES  
The ship-to firm's telephone number, when the purchase order's ship-to code is OTHER.
 
Fax    nvarchar(24)  YES  
The ship-to firm's facsimile transmission number, when the purchase order's ship-to code is OTHER.
 
EMail    nvarchar(50)  YES  
The ship-to firm's e-mail address, when the purchase order's ship-to code is OTHER.
 
ContactName    nvarchar(100)  YES  
The name of the ship-to firm's contact person, when the purchase order's ship-to code is OTHER.
 
ShipVia    nvarchar(20)  YES  
The ship-to firm's ship-via code, when the purchase order's ship-to code is OTHER.
 
FOB    nvarchar(20)  YES  
The ship-to firm's free on board code, when the purchase order's ship-to code is OTHER.
 
AuthorizedBy    nvarchar(20)  YES  
The employee number of the purchase order's approver.
 
Buyer    nvarchar(20)  YES  
The employee number of the purchase order's buyer.
 
StartDate    datetime  YES  
The agreement's starting date, for blanket and service purchase orders.
 
EndDate    datetime  YES  
The agreement's ending date, for blanket and service purchase orders.
 
NotToExceed    decimal(19, 4)  NO  
The agreement's Not to Exceed amount, for blanket and service purchase orders.
 
AllowExcess    varchar(1)  NO  
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    decimal(19, 4)  NO  
When AllowExcess equals Y, the excess percentage allowed in Receiving.
 
ExcessAmount    decimal(19, 4)  NO  
When AllowExcess equals Y, the excess amount allowed in Receiving.
 
ConfirmDate    datetime  YES  
Reserved for future use.
 
ConfirmWith    nvarchar(40)  YES  
Reserved for future use.
 
TopClause    nvarchar(4000)  YES  
The standard clause to print on the top of the purchase order.
 
BottomClause    nvarchar(4000)  YES  
The standard clause to print on the bottom of the purchase order.
 
Comments    nvarchar(4000)  YES  
The contents of the Terms field on the Agreement tab.
 
Descriptions    nvarchar(4000)  YES  
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    nvarchar(20)  YES  
The employee number of the person who submitted the purchase order for approval.
 
SubmittedDate    datetime  YES  
The date and time when the purchase order was submitted for approval.
 
AuthorizedDate    datetime  YES  
The date and time when the purchase order was approved.
 
Closed    varchar(1)  NO  
Variable indicating whether the Closed checkbox is selected for this purchase order. Valid options are Y - yes, and N - no (the default setting.)
 
Company    nvarchar(14)  NO  
The company to which the creator of this record belongs.
 
CurrencyCode    nvarchar(3)  YES  
The transaction currency for the entire purchase order.
 
PayDate    datetime  YES  
The payment date, if PayTerms is Date.
 
DistributionBase    int  NO  
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    nvarchar(24)  YES  
The number format to use for the Phone value.
 
FaxFormat    nvarchar(24)  YES  
The number format to use for the Fax value.
 
FinalPrintDate    datetime  YES  
This field stores the date of the Final Print for the Purchase Order
 
TotalNetAmount    decimal(19, 4)  NO  
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    decimal(19, 4)  NO  
The column that stores the sum of the Not to Exceed amount from the purchase order and its corresponding change orders.
 
POInternalNotes    nvarchar(4000)  YES  
The column that stores the internal comments for a purchase order.
 
CreateUser    nvarchar(20)  YES  
The username of the user logged in when this record was created.
 
CreateDate    datetime  YES  
The date and time when this record was created.
 
ModUser    nvarchar(20)  YES  
The username of the user logged in when this record was modified.
 
ModDate    datetime  YES  
The date and time when this record was modified.
 

POMaster Primary and Unique Keys 
Key Name  Key Type  Keys 
POMasterPK  PrimaryKey  MasterPKey 

POMaster Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication