Table: BILLINGIRFM

BILLINGIRFM

Name

BILLINGIRFM

Comment

BILLINGIRFM shows billing amounts associated with Industrial Relations Forced Majeure events for each participant.


Description

BILLINGIRFM is confidential to the relevant participant.

Source

BILLINGIRFM is updated with each billing run as required.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

Settlement Year

WEEKNO

NUMBER(3,0)

X

Week number starting 1 Jan each year.

BILLRUNNO

NUMBER(3,0)

X

Unique bill run

PARTICIPANTID

VARCHAR2(10)

X

Participant Identifier

IRFMPAYMENT

NUMBER(15,5)

 

Industrial Relations Forced Majeure payment for the billing period.

LASTCHANGED

DATE

 

Last changed.