SQL-035: Read COMPANY for clsCustomer

This statement supports clsCustomer by executing a read operation against COMPANY.

Classification

Field	Value
SQL ID	SQL-035
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsCustomer
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:CustomerID	Input	Decimal	N/A	Customer primary key

Tables

Table	Access	Columns used
COMPANY	SELECT	ACTIVE_FLAG, COMPANY_CODE, COMPANY_NAME, COMPANY_SEQ_NUM, COMPANY_SHORT_DESCR, CONTACT_NAME, EFF_DT, EXP_DT, EXTERNAL_REFERENCE_ID, INTERNAL_REFERENCE_ID, NOTE_TEXT, PERSON_FLAG, PRIMARY_FLAG, TAX_ID, UPDATE_DATE, UPDATE_USER

Sample SQL

Select COMPANY.COMPANY_SEQ_NUM as CustomerID, COMPANY.EFF_DT as EffectiveDate, COMPANY.EXP_DT as ExpirationDate, COMPANY.COMPANY_NAME as CustomerName, COMPANY.COMPANY_SHORT_DESCR as CustomerShortDescription, COMPANY.TAX_ID as TaxID, COMPANY.CONTACT_NAME as ContactName, COMPANY.COMPANY_CODE as CustomerTypeCode, COMPANY.ACTIVE_FLAG as IsActive, COMPANY.PRIMARY_FLAG as IsPrimary, COMPANY.PERSON_FLAG as IsPerson, COMPANY.INTERNAL_REFERENCE_ID as InternalReferenceID, COMPANY.EXTERNAL_REFERENCE_ID as ExternalReferenceID, COMPANY.NOTE_TEXT as NoteText, COMPANY.UPDATE_DATE as UpdateDate, COMPANY.UPDATE_USER as UpdateUser From COMPANY Where COMPANY.COMPANY_SEQ_NUM = :CustomerID

Operations and processes

• Customer CRUD with child persistence

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.CustomerContact\Customer\clsCustomer.vb