Detail codes

This table lists the detail codes and their corresponding VALIDATION_CODE.

Detail Code Detail Type VALIDATION_CODE
ATTACH Attached file or URL G.ATTACH
BYPROD ByProduct G.FORMBYPROD
COMP Composition G.FORMCOMP
CONTEXT Context G.OBJECTCONTEXT
DOC Attached text G.DOCUMENT
DTL File Path G.FILELOCATIONDTL
INGR Ingredient G.FORMINGRED
LRSECT

LRSUBSECT

Ingredient Statement Rule G.LRULESECTION

G.LRULESUBSECTION

PER Security / Permissions G.OBJSECURITY
ST Set G.SETFORMULA

G.SETITEM

STATUS Status G.STATUSOBJ
TP Parameter for specifications G.SPECPARAM
TPALL Parameter for formulas and items G.TECHPVAL
TP0 Rollup Parameter G.TECHPVAL
TP1 Information Parameter G.TECHPVAL
TP2 Equation Total Parameter G.TECHPVAL
TP3 Cost Parameter G.TECHPVAL

You must use these details for PropertyName if the VALIDATION_SUBCODE has a value.

Part Description
PropertyName

(VALIDATION_SUBCODE is blank)

FIELD_NAME

When the VALIDATION_SUBCODE is blank, use the entry for FIELD_NAME as the PropertyName.

PropertyName

(VALIDATION_SUBCODE has a value)

FIELD_NAME. DetailCode.

If VALIDATION_SUBCODE has a value, then you must use the RowKey, ColumnKey parameters.

Symbol Type of object. Leave out or use empty quotation marks for the current symbol for the workflow or equation, or new object for a copy method.

Object

Object for which to obtain a property. Leave out or use empty quotation marks for the current object for the workflow or equation, or new object for the copy method.

RowKey VALIDATION_SUBCODE. Key for the row where the value exists.

Include only if VALIDATION_SUBCODE has a value.

ColumnKey In some sections of rows, the FIELD_NAMES are not unique and the VALIDATION_SUBCODE has a value.

In this case, look for the row where:

  • FIELD_NAME = KEYCODE for formulas
  • FIELD_NAME = PARAMCODE for specifications.

In that row, take the FIELD_NO value for KEYCODE or PARAMCODE and divide it by 100.

Use this number for the ColumnKey argument. You can also use the FIELD_NAME KEYCODE or PARAMCODE as the argument.

Include only if VALIDATION_SUBCODE has a value. For example:

objProperty("VALUE.TPALL", "","","CALCIUM",2)