Transaction Fields

Sage 300 ERP

Transaction Fields

Transaction fields include account master fields and account optional fields defined in G/L Setup, and the following transaction fields and transaction optional fields defined in FRPOST.

To retrieve account optional fields, add the prefix A. before a field name (for example, A.ACCTID). To retrieve transaction optional fields, add the prefix T. before the field name (for example, T.QTY). Be sure to include the period after these prefixes.

For more information, see Account Master Fields and FRPOST Function.

Name

Contents of the Field

FISCALYR

Fiscal Year

FISCALPERD

Fiscal Period

SRCECURN

Source Currency Code

SRCELEDGER

Source Ledger Code

SRCETYPE

Source Type

POSTINGSEQ

Posting Sequence Number

CNTDETAIL

Detail Count

JRNLDATE

Journal Date

BATCHNBR

Batch Number

ENTRYNBR

Journal Entry Number

TRANSNBR

Journal Transaction Number

CONSOLIDAT

Consolidation in Posting

JUNLDTLDESC

Journal Detail Description

JNLDTLREF

Journal Detail Reference

TRANSAMT

Journal Transaction Amount

TRANSQTY

Journal Transaction Quantity

SCURNAMT

Journal Source Amount

RPTAMT

Journal Reporting Amount

RATETYPE

Date of Currency Rate Selected

RATEDATE

Date of Currency Rate

CONVRATE

Currency Rate for Conversion

RATEOPER

Currency Rate Operator

Related Topics