BUILD

Holds the internal build number information for the Siebel Business Analytics Repository.

CAL_MONTH_YEAR_AGO

Returns the value of Previous Year Month in the YYYY/MM format.

CURRENT_DAY

Returns the value of Current Date in the MM/DD/YYYY format

CURRENT_FSCL_MONTH

Returns the value of Current Fiscal Month in the YYYY/MM format.

CURRENT_FSCL_QUARTER

Returns the value of Current Fiscal Quarter in the YYYY Q n format.

CURRENT_FSCL_WEEK

Returns the value of Current Fiscal Week in the YYYY Week nn format.

CURRENT_FSCL_YEAR

Returns the value of Current Fiscal Year in the FYYYYY format.

CURRENT_JULIAN_DAY_NUM

Returns the value of Current Julian Date Number.

CURRENT_MONTH

Returns the value of Current Month in the YYYY/MM format.

CURRENT_QTR

Returns the value of Current Fiscal Quarter in YYYY Q n format.

CURRENT_WEEK

Returns the value of Current Week in the YYYY Week nn format.

CURRENT_YEAR

Returns the value of Current Year in the YYYY format.

FSCL_MONTH_YEAR_AGO

Returns the value of Previous Year Fiscal Month in YYYY/MM format.

FSCL_QTR_YEAR_AGO

Returns the value of Previous Year Fiscal Quarter in YYYY Q n format.

PREVIOUS_FSCL_MONTH

Returns the value of Previous Fiscal Month in the YYYY/MM format.

PREVIOUS_FSCL_QUARTER

Returns the value of Previous Fiscal Quarter in the YYYY Q n format.

PREVIOUS_FSCL_WEEK

Returns the value of Previous Fiscal Week in the YYYY Weeknn format.

PREVIOUS_FSCL_YEAR

Returns the value of Previous Fiscal Year in the FYYYYY format.

PREVIOUS_MONTH

Returns the value of Previous Month in the YYYY/MM format.

PREVIOUS_QUARTER

Returns the value of Previous Fiscal Quarter in the YYYY Q n.

PREVIOUS_WEEK

Returns the value of Previous Week in the YYYY Weeknn format.

PREVIOUS_YEAR

Returns the value of Previous Year in the YYYY format.

NEXT_FSCL_MONTH

Returns the value of Next Fiscal Month in the YYYY / MM format.

NEXT_FSCL_QUARTER

Returns the value of Next Fiscal Quarter in the YYYY Q n.

NEXT_FSCL_WEEK

Returns the value of Next Fiscal Week in the YYYY Weeknn format.

NEXT_FSCL_YEAR

Returns the value of Next Fiscal Year in the FYYYYY format.

NEXT_MONTH

Returns the value of Next Month in the YYYY / MM format.

NEXT_QUARTER

Returns the value of Next Fiscal Quarter in the YYYY Q n.

NEXT_WEEK

Returns the value of Next Week in the YYYY Weeknn format.

NEXT_YEAR

Returns the value of Next Year in the YYYY format.

YEAR_AGO_DAY

Returns the value of year ago date in the mm/dd/yyyy format.

TIME_OFFSET

Returns the difference between the current date and a given number of days value. It is primarily used for testing to simulate an earlier or later date. You could set the variable to the number of days you want the preceding date variables to be moved back.

REF_JULIAN_DATE

Stores the start date of the Julian calendar and should not be changed.

REF_JULIAN_DATE_NUM

Stores the Julian number for the start of the Julian calendar and should not be changed.

IS_CME_ORDER_NUM

Set to 1 if the Order is a CME Order. This variable should not be changed.

CURRENT_BALANCE_DK_AP

Returns the value of the last date key for the available Accounts Payable balance. It is used in Accounts Payable Account Balance Computation.

CURRENT_BALANCE_DK_AR

Returns the value of the last date key for the available Accounts Receivables balance. It is used in Accounts Receivable Account Balance Computation.

CURRENT_BALANCE_DK_GL

Returns the value of the last date key for the available General Ledger balance. It is used in General Ledger Account Balance Computation.