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 |