select and update Options

This topic contains the database table names and the associated field names that are available when using the select and update extended rules. Additional keys are also available for certain tables. Where applicable, a description of the key follows the field name.

Notes

When you use extended rules to reference a Sterling Gentran:Server® database table, the syntax used is different from the actual table name. The appropriate referencing syntax is outlined for each table in this section.

For example, to refer to the Document_tb in an extended rule, you would reference Document.

See select and update for more information about the functions.

Division

These are the field names that are available when using the select or update extended rules to reference the division partner on the Partner Table (Partner_tb).

Refer to this table as Division.

PARTNERNAME
EDICODE
APPLICATIONPARTNERKEY

DivisionLocation

These are the field names that are available when using the select or update extended rules to reference a division location on the Location Table (Location_tb).

Refer to this table as DivisionLocation.

CONTACTNAME
NAME
ADDRESS1
ADDRESS2
ADDRESS3
CITY
STATE
ZIP
COUNTRY
TELEPHONE
PRIMARYREFCODE
SECONDARYREFCODE
FAX

DivisionLookup

These are the field names that are available when using the select or update extended rules to reference a division lookup on the Lookup Table (Lookup_tb).

Refer to this table as DivisionLookup.

ITEM
DESCRIPTION
TEXT1
TEXT2
TEXT3
TEXT4

This is an additional key that is available for the DivisionLookup table.

TABLENAME

DivisionXref

These are the field names that are available when using the select or update extended rules to reference a division cross-reference on the Cross-reference Table (CrossReference_tb).

Refer to this table as DivisionXref.

MYITEM
PARTNERITEM
DESCRIPTION
TEXT1
TEXT2
TEXT3
TEXT4

This is an additional key that is available for the DivisionXref table.

TABLENAME

Document

These are the field names that are available when using the select or update extended rules on the Document Table (Document_tb).

This sub-table can only be accessed from the following map types; Transaction Break/Build, Import, Export, Print, Screen, Group Build, and Interchange Build.

The information that is accessed will be the information of the last document that was processed at the table level accessed by the rules. This must be taken into consideration when using rules that access these tables.

Refer to this table as Document.

TESTMODE
AGENCY
VERSION
TRANSACTIONSETID
RELEASE
DOCUMENTTYPE
REFERENCEDATA
DOCUMENTNAME
APPFIELD1
APPFIELD2
APPFIELD3
APPFIELD4
APPFIELD5
APPFIELD6
DOCUMENTPARTNERKEY
CONTROLNUMBER
PARTNERKEY
TABLEKEY (Select only)

GenericEnvelopeSegment

These are the field names that are available when using the select extended rule on the Generic Envelope Segment Table (GenericEnvelopeSegment_tb).

Refer to this table as GenericEnvelopeSegment.

CONTROLNUMBER
SUBCOUNT
FIELD1
FIELD2
FIELD3
FIELD4
FIELD5
FIELD6
FIELD7
FIELD8
FIELD9
FIELD10
FIELD11
FIELD12
FIELD13
FIELD14
FIELD15
FIELD16
FIELD17
FIELD18
FIELD19
FIELD20
FIELD21
FIELD22
FIELD23
FIELD24
FIELD25
FIELD26
FIELD27
FIELD28
FIELD29
FIELD30
FIELD31
FIELD32
FIELD33
FIELD34
FIELD35
FIELD36
FIELD37
FIELD38
FIELD39
FIELD40

Group

These are the field names that are available when using the select or update extended rules on the Group Table (Group_tb).

Can only be accessed from the following map types: Group Break or Build, Transaction Break, Export, and Interchange Build.

The information that is accessed will be the information of the last group that was processed at the table level accessed by the rules. This must be taken into consideration when using rules that access these tables.

Refer to this table as Group.

TESTMODE
CONTROLNUMBER
FUNCTIONALGROUPID
VERSION
APPFIELD1
APPFIELD2
APPFIELD3
APPFIELD4
APPFIELD5
APPFIELD6
AGENCY
TABLEKEY (Select only)

Interchange

These are the field names that are available when using the select or update extended rules on the Interchange Table (Interchange_tb).

This sub-table can only be accessed from the following map types: Interchange Break or Build, Group Break, Transaction Break, and Export.

The information that is accessed will be the information of the last interchange that was processed at the table level accessed by the rules. This must be taken into consideration when using rules that access these tables.

Refer to this table as Interchange.

TESTMODE
CONTROLNUMBER
VERSION
APPFIELD1
APPFIELD2
APPFIELD3
APPFIELD4
APPFIELD5
APPFIELD6
AGENCY
PARTNERKEY
TABLEKEY (Select only)

Partner

These are the field names that are available when using the select or update extended rules for a non-division partner on the Partner Table (Partner_tb).

Refer to this table as Partner.

PARTNERNAME
EDICODE
APPLICATIONPARTNERKEY

These are the additional keys that are available for the Partner table.

PARTNERKEY
ALTERNATEKEY (refers to Application Key)
APPLICATIONPARTNERKEY (refers to Application Key)

PartnerLocation

These are the field names that are available when using the select or update extended rules for a non-division location on the Location Table (Location_tb).

Refer to this table as PartnerLocation.

CONTACTNAME
NAME
ADDRESS1
ADDRESS2
ADDRESS3
CITY
STATE
ZIP
COUNTRY
TELEPHONE
PRIMARYREFCODE
SECONDARYREFCODE
FAX

PartnerLookup

These are the field names that are available when using the select or update extended rules for a non-division lookup on the Lookup Table (Lookup_tb).

Refer to this table as PartnerLookup.

ITEM
DESCRIPTION
TEXT1
TEXT2
TEXT3
TEXT4

This is an additional key that is available for the PartnerLookup table.

TABLENAME

PartnerXref

These are the field names that are available when using the select or update extended rules for a non-division cross-reference on the Cross-reference Table (CrossReference_tb).

Refer to this table as PartnerXref.

MYITEM
PARTNERITEM
DESCRIPTION
TEXT1
TEXT2
TEXT3
TEXT4

This is an additional key that is available for the PartnerXref table.

TABLENAME