Table: OP_PRSL_HDR

Product:	GML - Process Manufacturing Logistics
Description:	Order Profile Header and Blanket Sales Order Header.
Implementation/DBA Data:	GML.OP_PRSL_HDR

Primary Key: OP_PRSL_HDRI1

1. ORGN_CODE
2. PRESALES_ORD_NO
3. PRESALES_ORD_TYPE

Primary Key: OP_PRSL_HDR_PK

1. PRESALES_ORD_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OP_PRSL_HDR		GL_CURR_MST	OP_PRSL_HDR.BILLING_CURRENCY
OP_PRSL_HDR		IC_WHSE_MST	OP_PRSL_HDR.FROM_WHSE
OP_PRSL_HDR		IC_WHSE_MST	OP_PRSL_HDR.TO_WHSE
OP_PRSL_HDR		OP_COMMISSION	OP_PRSL_HDR.COMMISSION_CODE
OP_PRSL_HDR		OP_CTRD_CLS	OP_PRSL_HDR.CUSTTRADE_CLASS
OP_PRSL_HDR		OP_CUST_CON	OP_PRSL_HDR.CONTACT_ID
OP_PRSL_HDR		OP_CUST_MST	OP_PRSL_HDR.SHIPCUST_ID
OP_PRSL_HDR		OP_CUST_MST	OP_PRSL_HDR.BILLCUST_ID
OP_PRSL_HDR		OP_CUST_MST	OP_PRSL_HDR.ULTIMATE_SHIPCUST_ID
OP_PRSL_HDR		OP_CUST_MST	OP_PRSL_HDR.SOLDTOCUST_ID
OP_PRSL_HDR		OP_CUST_MST	OP_PRSL_HDR.CONSIGNEE_ID
OP_PRSL_HDR		OP_FOBC_MST	OP_PRSL_HDR.FOB_CODE
OP_PRSL_HDR		OP_FRGT_MTH	OP_PRSL_HDR.FRTBILL_MTHD
OP_PRSL_HDR		OP_HOLD_CDS	OP_PRSL_HDR.HOLDREAS_CODE
OP_PRSL_HDR		OP_LKBX_MST	OP_PRSL_HDR.REMIT_TO_LOCKBOX
OP_PRSL_HDR		OP_PORT_MST	OP_PRSL_HDR.EMBARKATION_PORT
OP_PRSL_HDR		OP_PORT_MST	OP_PRSL_HDR.DEBARKATION_PORT
OP_PRSL_HDR		OP_PRSL_TYP_B	OP_PRSL_HDR.PRESALES_ORD_TYPE
OP_PRSL_HDR		OP_SHIP_MST	OP_PRSL_HDR.SHIPPER_CODE
OP_PRSL_HDR		OP_SHIP_MTH	OP_PRSL_HDR.SHIP_MTHD
OP_PRSL_HDR		OP_SLSR_MST	OP_PRSL_HDR.SLSREP_CODE
OP_PRSL_HDR		OP_TERM_MST	OP_PRSL_HDR.TERMS_CODE
OP_PRSL_HDR		OP_TEXT_HDR	OP_PRSL_HDR.TEXT_CODE
OP_PRSL_HDR		SY_ADDR_MST	OP_PRSL_HDR.SHIPADDR_ID
OP_ORDR_HDR		OP_PRSL_HDR	OP_ORDR_HDR.PRESALES_ORD_ID
OP_PRSL_CHG		OP_PRSL_HDR	OP_PRSL_CHG.PRESALES_ORD_ID
OP_PRSL_DTL		OP_PRSL_HDR	OP_PRSL_DTL.PRESALES_ORD_ID