Table Name:	purchase_ord
Table Number:	226
Group:	Sales Mgr
Description:	Describes a payment method, often a purchase order, related to a contract schedule or line items
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_purchase_ord

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
address	CHAR	varchar		80			Street address of the person whose name appears on the payment means
auth_num	CHAR	varchar		25			Authorization number returned by the credit card company
auth_status	CHAR	varchar		2			Status of the authorization returned by the validation system
card_num	CHAR	varchar		25			For credit cards, the credit card number	Search (1)
cc_exp_mo	CHAR	varchar		2			2-digit number of the month when the card expires	Search (1)
cc_exp_yr	CHAR	varchar		4			2- or 4-digit number of the year in which the credit card expires	Search (1)
cc_name	CHAR	varchar		80			Complete name of the credit card owner as it appears on the card	Search (1)
cc_type	CHAR	varchar		40			The credit card type populated from a user defined pop-up with the title 'cctype'	Search (1)
city	CHAR	varchar		30			The city for the bill address
country	CHAR	varchar		40			The country of the bill address
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
expire_date	CLK_TIME	datetime					The last date the payment means is effective
first_name	CHAR	varchar		30			For personal payment means, the first name of person that owns it
last_name	CHAR	varchar		30			Last name of person who appears on the payment means
objid	LONG	int	3			DIRECT	Internal record number	Search (3)
pay_option	CHAR	varchar		40			The payment option for this line item; e.g., purchase order, credit card, etc. This is from a user-defined popup with default name PAY_METHOD	Search (1)
po_amt	DECIMAL	decimal (19,4)				CURRENCY	Total currency amount of the purchase order	Search (1)
po_date	CLK_TIME	datetime					The date identified on the payment method	Search (1)
po_id	CHAR	varchar		60			The unique purchase order ID	Search (1)
po_terms	CHAR	varchar		40			The type of payment. This is from a user-defined popup with default name PAYMENT_TERMS
ref_num	CHAR	varchar		25			Reference number for letter of credit, etc
state_prov	CHAR	varchar		80			The state/province of the bill address
status	CHAR	varchar		40			User-defined status of the payment means. This is a user-defined popup with default name PO Status	Search (1)
zipcode	CHAR	varchar		25			Zipcode or postal code of the person whose name appears on the payment means

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
payment2contr_itm	OTM	contr_itm	contr_itm2purchase_ord	Contract line items using the payment method
payment2contr_schedule	MTO	contr_schedule	schedule2purchase_ord	Contract schedules using the payment method
purchase_ord2contract	MTO	contract	contract2purchase_ord	Order paid by purchase order	Search (1)
payment2pay_means	MTO	pay_means	pay_means2purchase_ord	The payment means used by the payment	Search (1)
payment2quick_quote	MTO	quick_quote	q_quote2purchase_ord	Quick Quote for the payment. Reserved; obsolete

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
purch_ord_ind	payment2contr_schedule:payment2quick_quote:po_id:card_num:ref_num:purchase_ord2contract	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_payment2contr_schedule	payment2contr_schedule	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
po2c0226	purchase_ord2contract	nonclustered located on PRIMARY
purch_ord_ind	payment2contr_schedule, payment2quick_quote, po_id, card_num, ref_num, purchase_ord2contract	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5065	contract_itm_lst	contr_itm, contr_schedule, mod_level, part_num, price_inst, purchase_ord, site, site_part
5842	po_curr_contr_v	contract, currency, pay_means, purchase_ord
6066	contr_itm_lst_vw	contr_itm, contr_schedule, contract, currency, mod_level, part_num, price_inst, purchase_ord, site, site_part

My Recent Objects

purchase_ord

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog