Home > Technical > Table Definitions > ACEXPIRYRULES

ACEXPIRYRULES

Contains the rules for calculating the expiry date for a transaction

Column

Type

Description

STRGUID

VARCHAR(36)

A unique code assigned by the system.

STRLEDGERCODE

VARCHAR(10)

The account ledger to which this account belongs.
ACLEDGER.strLedgerCode

STRTRADECODE

VARCHAR(10)

The location to which the rule applies
TRADUNIT.strTradeCode

STRMEMBERTYPE

VARCHAR(10)

The type of customer to which the rule applies

STRDEPTCODE

VARCHAR(10)

Department to which this rule applies. If this it not entered, the rule applies to all departments within the location.
DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Category to which this rule applies. If this it not entered, the rule applies to all categories within the department.
CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Group to which this rule applies. If this it not entered, the rule applies to all  groups within the category.
GROUPS.strGroupCode

STRSUBGROUPCODE

VARCHAR(10)

The subgroup to which this rule applies. If this it not entered, the rule applies to all subgroups within the group.
SUBGROUP.strSubGroupCode

LINTITEMNUMBER

INT

The item to which this rule applies. If this is not entered, the rule applies to all items.
ITEM.lintItemNumber

INTTYPE

INT

Always 1.

INTDAYS

INT

The number of days until the transaction expires.

DTMTIMEOFDAY

DATETIME

The time of day the transaction expires. Midnight=0, Midday=0.5.

YSNENDOFMONTH

VARCHAR(1)

If 'T' the expiry date will be calculated and then adjusted to the end of the month.

 

Primary Key: STRGUID

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)