SA Total Head

User entered id to uniquely identify the total being calculated.

Sequential number to uniquely identify the generation of the total being calculated. This number will increment as a user edits an existing total calculation definition.

The metadata virtual row associated with the total.

The revision of the metadata virtual row associated with the total.

External name for the total created by the user.

Total type identifier used to determine whether the results of the total should be included in over/short calculations.

Over/Short group for the total. D is accounted for, B is accountable for.

Operator used to combine the total into the overall Over/Short. Valid values are + and -.

Indicates whether this definition refers to a total (composed of raw data from the database) or existing totals. Valid values are Y yes and N no.

Total category identifier used to group similar totals. The valid values for this field are in the code_type SATC.

Identifies the level (store or system balancing, which may also be either cashier or register) at which the total should be calculated and implies an implicit group by. The valid values are S (store), C (cashier) and R (register).

Contains the date and time the total calculation was initially created. Used to determine the order the calculations should occur.

Stored with each revision of the total. Allows the user to track who has edited total definitions.

Indicated whether the total is a count of occurrences or a sum of values.

Indicates that the total corresponds to the value polled from the POS. Valid values are Y - yes and N - no.

Indicates that the system should calculate a value for this total. Valid values are Y - yes and N - no.

Indicates that the total can be updated by store personnel. Valid values are Y - yes and N - no.

Indicates that the total can be updated by hq personnel. Valid values are Y - yes and N - no.

Indicates that the total is required by the system. Valid values are Y - yes and N - no.

Indicates that the total will be defined using the totaling wizard. Valid values are Y - yes and N - no.

Date this version of the total calculation definition becomes effective.

Date this version of the total calculation definition becomes ineffective.

The field will contain the sequence of a the first grouping parm in a total.

This field will contain the code in the code_type TRFL that should be the label of the first group by value on the Misc. Totals form. Valid values are in the code_type TRFL.

The field will contain the sequence of a the second grouping parm in a total.

This field will contain the code in the code_type TRFL that should be the label of the second group by value on the Misc. Totals form. Valid values are in the code_type TRFL.

The field will contain the sequence of a the third grouping parm in a total.

This field will contain the code in the code_type TRFL that should be the label of the third group by value on the Misc. Totals form. Valid values are in the code_type TRFL.

Contains the sequence number of the parm in the total definition that is being counted or summed.

Contains a code that corresponds to the order the total should be displayed in the over/short and miscellaneous totals forms.

This field holds the status of the total. The status determines which table the total value will be written to. If the status is either worksheet or approved, the value will be written to the sa_sys_value_wksht or sa_pos_value_wksht tables.