Table: GAS_PARTICIPANT_DETAIL

GAS_PARTICIPANT_DETAIL

Name

GAS_PARTICIPANT_DETAIL

Comment

The details of all registered organisations i.e the BB Participants of the Bulletin Board over time


Primary Key Columns

Name

COMPANYID

EFFECTIVEDATE

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

COMPANYID

Number(10,0)

X

Unique company identifier

EFFECTIVEDATE

Date

X

Effective date for this operating state

VERSIONDATETIME

Date

X

Version date time for this operating state

COMPANYNAME

Varchar2 (50)

 

Name of company

ABN

Varchar2 (30)

 

Australian Business Number of company

ADDRESSTYPE

Varchar2 (40)

 

Type of address eg. Head Office, Postal Address etc.

ADDRESS

Varchar2 (120)

 

Address of company based on AddressType

LOCALE

Varchar2 (40)

 

City location of company

JURISDICTION

Varchar2 (5)

 

State location of company

POSTCODE

VARCHAR2(4)

 

Postcode of company

COMPANYPHONE

Varchar2 (30)

 

Main (reception) phone of company

COMPANYFAX

Varchar2 (30)

 

Main (reception) facsimile of company

AUTHORISEDDATE

Date

 

Date and time this operating state was authorised

AUTHORISEDBY

Varchar2 (30)

 

User which authorised the change

ORGANISATIONTYPENAME

VARCHAR2(40)

 

The type of organisation