Custom Template Merge Fields

Merge Field

Description

<<AnnualFoodSales>>

This value comes from the ANNUALFOODSALES column of the VENDOR table. The value will print in monetary format.

<<AnnualGrossSales>>

This value comes from the ANNUALGROSSSALES column of the VENDOR table. The value will print in monetary format.

<<AnnualNonFoodSales>>

This value comes from the ANNUALNONFOODSALES column of the VENDOR table. The value will print in monetary format.

<<AppealComments>>

The data returned will be from last record in the APPEAL table for the Vendor. This value comes from the COMMENTS column of the APPEAL table.

<<AppealFiledDate>>

The data returned will be from last record in the APPEAL table for the Vendor. This value comes from the FILEDDATE column of the APPEAL table. The value will print in MM/DD/CCYY format.

<<AppealTypeDescription>>

The data returned will be from last record in the APPEAL table for the Vendor. This value comes from the DESCRIPTION column of the Reference Dictionary table (CATEGORY = 'APPEALTYPE').

<<BankAccountNumber>>

This value comes from the ACCOUNTNUMBER column of the VENDOR table.

<<BankName>>

This value comes from the BANKNAME column of the VENDOR table.

<<BankTransitNumber>>

This value comes from the BANKTRANSITNUMBER column of the VENDOR table.

<<Cashiers>>

This value comes from the CASHIERS column of the VENDOR table.

<<CheckOutRegisters>>

This value comes from the CHECKOUTREGISTERS column of the VENDOR table.

<<CorporateParentId>>

This value comes from the CORPORATEPARENTID column of the VENDOR table.

<<CorporateParentMailingAddress1>>

This value comes from the ADDRESS1 column of the v_CorporateParent_Address_Mailing view.

<<CorporateParentMailingAddress2>>

This value comes from the ADDRESS2 column of the v_CorporateParent_Address_Mailing view.

<<CorporateParentMailingAddressName>>

This value comes from the NAME column of the CORPORATEPARENT table.

<<CorporateParentMailingCity>>

This value comes from the CITY column of the v_CorporateParent_Address_Mailing view.

<<CorporateParentMailingStateCd>>

This value comes from the STATECD column of the v_CorporateParent_Address_Mailing view.

<<CorporateParentMailingZipCode>>

This value comes from the ZIPCODE column of the v_CorporateParent_Address_Mailing view. The value will print in 00000-0000 format.

<<CorporateParentName>>

This value comes from the NAME column of the CORPORATEPARENT table.

<<CorporateParentOwnerCell>>

This value comes from the CELLNUMBER column of the v_CorporateParent_Owner view. The value will print in 000-000-0000 format.

<<CorporateParentOwnerDateOfBirth>>

This value comes from the DATEOFBIRTH column of the v_CorporateParent_Owner view. The value will print in MM/DD/CCYY format.

<<CorporateParentOwnerEmailAddress>>

This value comes from the EMAILADDRESS column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerFax>>

This value comes from the FAXNUMBER column of the v_CorporateParent_Owner view. The value will print in 000-000-0000 format.

<<CorporateParentOwnerFirstName>>

This value comes from the FIRSTNAME column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerLastName>>

This value comes from the LASTNAME column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerMailingAddress1>>

This value comes from the ADDRESS1 column of the v_CorporateParent_Owner_Address_Mailing view.

<<CorporateParentOwnerMailingAddress2>>

This value comes from the ADDRESS2 column of the v_CorporateParent_Owner_Address_Mailing view.

<<CorporateParentOwnerMailingAddressName>>

This value comes from the NAME column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerMailingCity>>

This value comes from the CITY column of the v_CorporateParent_Owner_Address_Mailing view.

<<CorporateParentOwnerMailingStateCd>>

This value comes from the STATECD column of the v_CorporateParent_Owner_Address_Mailing view.

<<CorporateParentOwnerMailingZipCode>>

This value comes from the ZIPCODE column of the v_CorporateParent_Owner_Address_Mailing view. The value will print in 00000-0000 format.

<<CorporateParentOwnerMiddleInitial>>

This value comes from the MIDDLEINITIAL column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerName>>

This value comes from the NAME column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerNonWicStores>>

This value comes from the NONWICSTORES column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerPhone>>

This value comes from the TELEPHONE column of the v_CorporateParent_Owner view. The value will print in 000-000-0000 format.

<<CorporateParentOwnerPhoneExtension>>

This value comes from the EXTENSION column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerPhysicalAddress1>>

This value comes from the ADDRESS1 column of the v_CorporateParent_Owner_Address_Physical view.

<<CorporateParentOwnerPhysicalAddress2>>

This value comes from the ADDRESS2 column of the v_CorporateParent_Owner_Address_Physical view.

<<CorporateParentOwnerPhysicalCity>>

This value comes from the NAME column of the v_CorporateParent_Physical view.

<<CorporateParentOwnerPhysicalName>>

This value comes from the CITY column of the v_CorporateParent_Owner_Address_Physical view.

<<CorporateParentOwnerPhysicalStateCd>>

This value comes from the STATECD column of the v_CorporateParent_Owner_Address_Physical view.

<<CorporateParentOwnerPhysicalZipCode>>

This value comes from the ZIPCODE column of the v_CorporateParent_Owner_Address_Physical view. The value will print in 00000-0000 format.

<<CorporateParentOwnerSalutation>>

This value comes from the SALUTATION column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerSSN>>

This value comes from the SSN column of the v_CorporateParent_Owner view. The value will print in 000-00-0000 format.

<<CorporateParentOwnerTitle>>

This value comes from the TITLE column of the v_CorporateParent_Owner view.

<<CorporateParentOwnerWicStores>>

This value comes from the WICSTORES column of the v_CorporateParent_Owner view.

<<CorporateParentPhone>>

This value comes from the TELEPHONE column of the CORPORATEPARENT table. The value will print in 000-000-0000 format.

<<CorporateParentPhysicalAddress1>>

This value comes from the ADDRESS1 column of the v_CorporateParent_Address_Physical view.

<<CorporateParentPhysicalAddress2>>

This value comes from the ADDRESS2 column of the v_CorporateParent_Address_Physical view.

<<CorporateParentPhysicalAddressName>>

This value comes from the NAME column of the CORPORATEPARENT table.

<<CorporateParentPhysicalCity>>

This value comes from the CITY column of the v_CorporateParent_Address_Physical view.

<<CorporateParentPhysicalStateCd>>

This value comes from the STATECD column of the v_CorporateParent_Address_Physical view.

<<CorporateParentPhysicalZipCode>>

This value comes from the ZIPCODE column of the v_CorporateParent_Address_Physical view. The value will print in 00000-0000 format.

<<CurrentDate>>

This value comes from the date part of the WIC databases current time stamp. The value will print in MM/DD/CCYY format.

<<CurrentTime>>

This value comes from the time part of the WIC databases current time stamp. The value will print in HH:MM AMPM format.

<<CurrentUserId>>

This value is the userid of the user that is current logged into the WIC Application.

<<DenialDate>>

The data returned will be from last record in the DENIAL table for the Vendor. This value comes from the FINALDATE column of the DENIAL table. The value will print in MM/DD/CCYY format.

<<DenialLetterSentDate>>

The data returned will be from last record in the DENIAL table for the Vendor. This value comes from the FIRSTLETTERSENTDATE column of the DENIAL table. The value will print in MM/DD/CCYY format.

<<FederalTaxNumber>>

This value comes from the FEDERALTAXNUMBER column of the VENDOR table.

<<FineReceivedAmount>>

The data returned will be from last record in the FINE table for the Vendor. This value comes from the RECEIVEDAMOUNT column of the FINE table. The value will print in monetary format.

<<FineReceivedDate>>

The data returned will be from last record in the FINE table for the Vendor. This value comes from the RECEIVEDDATE column of the FINE table. The value will print in MM/DD/CCYY format.

<<FoodStampAuthorizationNumber>>

This value comes from the FSAUTHORIZATIONNUMBER column from the VENDOR table.

<<HearingDate>>

The data returned will be from last record in the HEARING table for the Vendor. This value comes from the HEARINGDATE column of the HEARING table. The value will print in MM/DD/CCYY format.

<<OtherOwnershipStructureDescription>>

This value comes from the DESCRIPTION column of the OTHEROWNERSHIPSTRUCTURE table.

<<OtherOwnershipStructureId>>

This value comes from the OTHEROWNERSHIPSTRUCTUREID column of the VENDOR table.

<<PeerGroupDescription>>

This value comes from the DESCRIPTION column of the PEERGROUP table.

<<PeerGroupId>>

This value comes from the PEERGROUP column of the VENDOR table.

<<ProbationEndDate>>

The data returned will be from last record in the PROBATION table for the Vendor. This value comes from the ENDDATE column of the PROBATION table. The value will print in MM/DD/CCYY format.

<<ProbationStartDate>>

The data returned will be from last record in the PROBATION table for the Vendor. This value comes from the STARTDATE column of the PROBATION table. The value will print in MM/DD/CCYY format.

<<SanctionAmount>>

The data returned will be from last record in the SANCTION table for the Vendor. This value comes from the AMOUNTASSESSED column of the SANCTION table. The value will print in monetary format.

<<SanctionDate>>

The data returned will be from last record in the SANCTION table for the Vendor. This value comes from the OCCURREDDATE column of the SANCTION table. The value will print in MM/DD/CCYY format.

<<SanctionList>>

This is an alphabetical listing where each line is comprised of the sanction assess with the amount of sanction points assigned for the sanction.

<<SquareFootage>>

This value comes from the SQUAREFOOTAGE column of the VENDOR table.

<<StampBankActivatedDate>>

This value comes from the BANKDATEACTIVATED column of the VENDORSTAMP table. The value will print in MM/DD/CCYY format.

<<StampBankDeactivationDate>>

This value comes from the DEACTBANKEFFECTIVEDATE column of the VENDORSTAMP table. The value will print in MM/DD/CCYY format.

<<StampIssuedDate>>

This value comes from the ISSUEDDATE column of the VENDORSTAMP table. The value will print in MM/DD/CCYY format.

<<StampNumber>>

This value comes from the STAMPNUMBER column of the VENDOR table.

<<StampReasonDeactivatedDescription>>

This value comes from the DESCRIPTION column of the V_VENDOR_STAMPRETURNREASON view.

<<StampReasonDeactivatedId>>

This value comes from the REASONDEACTIVATED column of the VENDORSTAMP table.

<<StateSalesTaxNumber>>

This value comes from the STATESALESTAXNUMBER column of the VENDOR table.

<<TelephoneCallComments>>

This value comes from the COMMENTS column of the TELEPHONECALL table.

<<TelephoneCallDate>>

This value comes from the CALLDATE column of the TELEPHONECALL table. The value will print in MM/DD/CCYY format.

<<TradeName>>

This value comes from the TRADENAME column of the VENDOR table.

<<VendorAuthorizedAgentCell>>

This value comes from the CELLNUMBER column of the v_Vendor_AuthAgent view. The value will print in 000-000-0000 format.

<<VendorAuthorizedAgentDateOfBirth>>

This value comes from the DATEOFBIRTH column of the v_Vendor_AuthAgent view. The value will print in MM/DD/CCYY format.

<<VendorAuthorizedAgentEmailAddress>>

This value comes from the EMAILADDRESS column of thev_Vendor_AuthAgent view.

<<VendorAuthorizedAgentFax>>

This value comes from the FAXNUMBER column of the v_Vendor_AuthAgent view. The value will print in 000-000-0000 format.

<<VendorAuthorizedAgentFirstName>>

This value comes from the FIRSTNAME column of the v_Vendor_AuthAgent view.

<<VendorAuthorizedAgentLastName>>

This value comes from the LASTNAME column of the v_Vendor_AuthAgent view.

<<VendorAuthorizedAgentMiddleInitial>>

This value comes from the MIDDLEINITIAL column of the v_Vendor_AuthAgent view.

<<VendorAuthorizedAgentNonWicStores>>

This value comes from the NONWICSTORES column of the v_Vendor_AuthAgent view.

<<VendorAuthorizedAgentPhone>>

This value comes from the TELEPHONE column of the v_Vendor_AuthAgent view. The value will print in 000-000-0000 format.

<<VendorAuthorizedAgentPhoneExtension>>

This value comes from the EXTENSION column of the v_Vendor_AuthAgent view.

<<VendorAuthorizedAgentSalutation>>

This value comes from the SALUTATION column of the v_Vendor_AuthAgent view.

<<VendorAuthorizedAgentSSN>>

This value comes from the SSN column of the v_Vendor_AuthAgent view. The value will print in 000-00-0000 format.

<<VendorAuthorizedAgentTitle>>

This value comes from the TITLE column of the v_Vendor_AuthAgent view.

<<VendorAuthorizedAgentWicStores>>

This value comes from the WICSTORES column of the v_Vendor_AuthAgent view.

<<VendorFormulaWholesalerId>>

This value comes from the FORMULAWHOLESALERID column of the VENDOR table.

<<VendorFormulaWholesalerName>>

This value comes from the NAME column of the WHOLESALER table.

<<VendorGrocerySupplierId>>

This value comes from the GROCERYSUPPLIERID column of the VENDOR table.

<<VendorGrocerySupplierName>>

This value comes from the NAME column of the WHOLESALER table.

<<VendorId>>

This value comes from the VENDORID column of the VENDOR table.

<<VendorMailingAddress1>>

This value comes from the ADDRESS1 column of the v_Vendor_Address_Mailing view.

<<VendorMailingAddress2>>

This value comes from the ADDRESS2 column of the v_Vendor_Address_Mailing view.

<<VendorMailingAddressName>>

This value comes from the TRADENAME column of the VENDOR table.

<<VendorMailingCity>>

This value comes from the CITY column of the v_Vendor_Address_Mailing view.

<<VendorMailingStateCd>>

This value comes from the STATECD column of the v_Vendor_Address_Mailing view.

<<VendorMailingZipCode>>

This value comes from the ZIPCODE column of the v_Vendor_Address_Mailing view. The value will print in 00000-0000 format.

<<VendorMilkWholesalerId>>

This value comes from the MILKWHOLESALERID column of the VENDOR table.

<<VendorMilkWholesalerName>>

This value comes from the NAME column of the WHOLESALER table.

<<VendorNote>>

This value comes from the DESCRIPTION column of the VENDORNOTE table.

<<VendorNoteText>>

This value comes from the TEXT column of the VENDORNOTE table.

<<VendorOwnerCell>>

This value comes from the CELLNUMBER column of the v_Vendor_Owner view. The value will print in 000-000-0000 format.

<<VendorOwnerDateOfBirth>>

This value comes from the DATEOFBIRTH column of the v_Vendor_Owner view. The value will print in MM/DD/CCYY format.

<<VendorOwnerEmailAddress>>

This value comes from the EMAILADDRESS column of the v_Vendor_Owner view.

<<VendorOwnerFax>>

This value comes from the FAXNUMBER column of the v_Vendor_Owner view. The value will print in 000-000-0000 format.

<<VendorOwnerFirstName>>

This value comes from the FIRSTNAME column of the v_Vendor_Owner view.

<<VendorOwnerLastName>>

This value comes from the LASTNAME column of the v_Vendor_Owner view.

<<VendorOwnerMailingAddress1>>

This value comes from the ADDRESS1 column of the v_Vendor_Owner_Address_Mailing view.

<<VendorOwnerMailingAddress2>>

This value comes from the ADDRESS2 column of the v_Vendor_Owner_Address_Mailing view.

<<VendorOwnerMailingAddressName>>

This value comes from the NAME column of the v_Vendor_Owner_Address_Mailing view.

<<VendorOwnerMailingCity>>

This value comes from the CITY column of the v_Vendor_Owner_Address_Mailing view.

<<VendorOwnerMailingStateCd>>

This value comes from the STATECD column of the v_Vendor_Owner_Address_Mailing view.

<<VendorOwnerMailingZipCode>>

This value comes from the ZIPCODE column of the v_Vendor_Owner_Address_Mailing view. The value will print in 00000-0000 format.

<<VendorOwnerMiddleInitial>>

This value comes from the MIDDLEINITIAL column of the v_Vendor_Owner view.

<<VendorOwnerName>>

This value comes from the NAME column of the v_Vendor_Owner view.

<<VendorOwnerNonWicStores>>

This value comes from the NONWICSTORES column of the v_Vendor_Owner view.

<<VendorOwnerPhone>>

This value comes from the TELEPHONE column of the v_Vendor_Owner view. The value will print in 000-000-0000 format.

<<VendorOwnerPhoneExtension>>

This value comes from the EXTENSION column of the v_Vendor_Owner view.

<<VendorOwnerPhysicalAddress1>>

This value comes from the ADDRESS1 column of the v_Vendor_Owner_Address_Physical view.

<<VendorOwnerPhysicalAddress2>>

This value comes from the ADDRESS2 column of the v_Vendor_Owner_Address_Physical view.

<<VendorOwnerPhysicalCity>>

This value comes from the NAME column of the v_Vendor_Owner_Address_Physical view.

<<VendorOwnerPhysicalName>>

This value comes from the CITY column of the v_Vendor_Owner_Address_Physical view.

<<VendorOwnerPhysicalStateCd>>

This value comes from the STATECD column of the v_Vendor_Owner_Address_Physical view.

<<VendorOwnerPhysicalZipCode>>

This value comes from the ZIPCODE column of the v_Vendor_Owner_Address_Physical view. The value will print in 00000-0000 format.

<<VendorOwnerSalutation>>

This value comes from the SALUTATION column of the v_Vendor_Owner view.

<<VendorOwnerSSN>>

This value comes from the SSN column of the v_Vendor_Owner view. The value will print in 000-00-0000 format.

<<VendorOwnerTitle>>

This value comes from the TITLE column of the v_Vendor_Owner view.

<<VendorOwnerWicStores>>

This value comes from the WICSTORES column of the v_Vendor_Owner view.

<<VendorPharmacyWholesalerId>>

This value comes from the PHARMACYWHOLESALERID column of the VENDOR table.

<<VendorPharmacyWholesalerName>>

This value comes from the NAME column of the WHOLESALER table.

<<VendorPhysicalAddress1>>

This value comes from the ADDRESS1 column of the v_Vendor_Address_Physical view.

<<VendorPhysicalAddress2>>

This value comes from the ADDRESS2 column of the v_Vendor_Address_Physical view.

<<VendorPhysicalAddressCountyCd>>

This value comes from the CountyCd column of the v_Vendor_Address_Physical view.

<<VendorPhysicalAddressCountyName>>

This value comes from the CountyName column of the v_Vendor_Address_Physical view.

<<VendorPhysicalAddressName>>

This value comes from the NAME column of the v_Vendor_Address_Physical view.

<<VendorPhysicalCity>>

This value comes from the CITY column of the v_Vendor_Address_Physical view.

<<VendorPhysicalStateCd>>

This value comes from the STATECD column of the v_Vendor_Address_Physical view.

<<VendorPhysicalZipCode>>

This value comes from the ZIPCODE column of the v_Vendor_Address_Physical view. The value will print in 00000-0000 format.

<<VendorWicContactCell>>

This value comes from the CELLNUMBER column of the v_Vendor_WICContact view. The value will print in 000-000-0000 format.

<<VendorWicContactDateOfBirth>>

This value comes from the DATEOFBIRTH column of the v_Vendor_WICContact view. The value will print in MM/DD/CCYY format.

<<VendorWicContactEmailAddress>>

This value comes from the EMAILADDRESS column of the v_Vendor_WICContact view.

<<VendorWicContactFax>>

This value comes from the FAXNUMBER column of the v_Vendor_WICContact view. The value will print in 000-000-0000 format.

<<VendorWicContactFirstName>>

This value comes from the FIRSTNAME column of the v_Vendor_WICContact view.

<<VendorWicContactLastName>>

This value comes from the LASTNAME column of the v_Vendor_WICContact view.

<<VendorWicContactMiddleInitial>>

This value comes from the MIDDLEINITIAL column of the v_Vendor_WICContact view.

<<VendorWicContactNonWicStores>>

This value comes from the NONWICSTORES column of the v_Vendor_WICContact view.

<<VendorWicContactPhone>>

This value comes from the TELEPHONE column of the v_Vendor_WICContact view. The value will print in 000-000-0000 format.

<<VendorWicContactPhoneExtension>>

This value comes from the EXTENSION column of the v_Vendor_WICContact view.

<<VendorWicContactSalutation>>

This value comes from the SALUTATION column of the v_Vendor_WICContact view.

<<VendorWicContactSSN>>

This value comes from the SSN column of the v_Vendor_WICContact view. The value will print in 000-00-0000 format.

<<VendorWicContactTitle>>

This value comes from the TITLE column of the v_Vendor_WICContact view.

<<VendorWicContactWicStores>>

This value comes from the WICSTORES column of the v_Vendor_WICContact view.

<<ViolationCategory>>

The data returned will be from last record in the VIOLATION table for the Vendor. This value comes from the category column of the VIOLATION table.

<<ViolationIdentifiedDate>>

The data returned will be from last record in the VIOLATION table for the Vendor. This value comes from the IDENTIFIEDDATE column of the VIOLATION table. The value will print in MM/DD/CCYY format.

<<ViolationOccurredDate>>

The data returned will be from last record in the VIOLATION table for the Vendor. This value comes from the OCCURREDDATE column of the VIOLATION table. The value will print in MM/DD/CCYY format.

<<ViolationSanctionPoints>>

The data returned will be from last record in the VIOLATION table for the Vendor. This value comes from the SANCTIONPOINTS column of the VIOLATION table.

<<ViolationSource>>

The data returned will be from last record in the VIOLATION table for the Vendor. This value comes from the VIOLATIONSOURCE column of the VIOLATION table.

<<ViolationTypeDescription>>

The data returned will be from last record in the VIOLATION table for the Vendor. This value comes from the DESCRIPTION column of the VIOLATIONTYPE table.

Column

Column Type

Description

SYSTEMNAME

VARCHAR(50)

Specifies the system that the current record is a part of. All mail merge records for this change order will have a SYSTEMNAME = "VENDOR".

PROCESSNAME

VARCHAR(50)

Specifies process that the current record is a part of. All mail merge records for this change order will have a PROCESSNAME = "CUSTOMMAILMERGE".

ALIAS

VARCHAR(50)

Specifies a user friendly name of a mail merge record, denoted as follows.

If OBJECTTYPE = "G", this is the value used in the GroupingAlias column.

If OBJECTTYPE = "U", this is the name of the user table.

IF OBJECTTYPE = "V", this is the name of the view.

IF OBJECTTYPE = "C", this is the name of the mail merge field.

OBJECTTYPE

VARCHAR(1)

Specifies the object type of the current record as follows

G = "GROUPING’

U = "USER TABLE"

V = "VIEW"

C = "COLUMN"

PARENTALIAS

VARCHAR(50)

Specifies the parent object of the current record.

GROUPALIAS

VARCHAR(50)

Specifies the logical grouping of the current record. This is used mainly to group addresses, but could be used for other types of groupings.

JOINTYPE

VARCHAR(50)

Overrides the Join Type Rules For Generating Mail Merge data as follows.

JOINTYPE should only be"INNER JOIN", "CROSS JOIN", or"LEFT JOIN".

IF JOINTYPE is not null then use JOINTYPE

IF JOINCOLUMNS AND PARENTJOINCOLUMNS are null then use "CROSS JOIN"

ELSE USE "LEFT JOIN"

This only applies when OBJECTYPE = "U" Or "OBJECTTYPE = "V".

JOINCOLUMNS

VARCHAR(1024)

Comma delimited list of columns used by the current mail merge record to perform a join with the parent mail merge record. In the case of multiple columns, logical "AND" will always be used.

PARENTJOINCOLUMNS

VARCHAR(1024)

Comma delimited list of columns used by the parent mail merge record to perform a join with the current mail merge record. In the case of multiple columns, logical "AND" will always be used.

OBJECTSQL

VARCHAR(MAX)

This field is used to generate view sql code for the mail merge engine.

This only applies when "OBJECTTYPE = "V".

ACTIVE

VARCHAR(1)

This field specifies when a column is active (ACTIVE="Y") or not active (ACTIVE="N").

This only applies when "OBJECTTYPE = "C".

CREATEUSERID

VARCHAR(20)

This field specifies the user or process that created the record

CREATEDTTM

DATETIME

This field specified the date when the record was created

MODIFYUSERID

VARCHAR(20)

This field specifies the last user or process that last modified the record.

MODIFYDTTM

DATETIME

This field specifies the last date when the record was modified.