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:
|
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 |
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.
See also