GLTRANSFY – No description in the Lawson data dictionary
- System
- General Ledger (GL)
- Prefix
GFY- Primary key
COMPANY,FISCAL-YEAR,ACCT-PERIOD,CONTROL-GROUP,SYSTEM,JE-TYPE,JE-SEQUENCE,LINE-NBR- Fields
- 56
- Updated by
- 1 program
- Referenced by
- 0 programs
GLTRANSFY is a Lawson General Ledger table (prefix GFY); no description in the lawson data dictionary. It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR (GFYSET1). It is updated by GL500. The table has 56 fields, 1 index and 0 documented relations.
About GLTRANSFY
No description in the Lawson data dictionary.
Fields (56)
Column = COBOL field name without the GFY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#GFY-COMPANY PKCOMPANY | Numeric 4 | — | GL500 |
#GFY-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | — | GL500 |
#GFY-ACCT-PERIOD PKACCT_PERIOD | Numeric 2 | — | GL500 |
#GFY-CONTROL-GROUP PKCONTROL_GROUP | Numeric 8 | — | GL500 |
#GFY-SYSTEM PKSYSTEM | Alpha 2 | — | GL500 |
#GFY-JE-TYPE PKJE_TYPE | Alpha 1 | — | GL500 |
#GFY-JE-SEQUENCE PKJE_SEQUENCE | Numeric 2 | — | GL500 |
#GFY-LINE-NBR PKLINE_NBR | Numeric 6 | — | GL500 |
#GFY-OBJ-IDOBJ_ID | Numeric 12 | — | GL500 |
#GFY-STATUSSTATUS | Numeric 1 | — | GL500 |
#GFY-VAR-LEVELSVAR_LEVELS | Alpha 30 | — | GL500 |
#GFY-ACCT-UNITACCT_UNIT | Alpha 15 | — | GL500 |
#GFY-ACCOUNTACCOUNT | Numeric 6 | — | GL500 |
#GFY-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | — | GL500 |
#GFY-SOURCE-CODESOURCE_CODE | Alpha 2 | — | GL500 |
#GFY-DATEDATE | Numeric 8 (yyyymmdd) | — | GL500 |
#GFY-REFERENCEREFERENCE | Alpha 10 (Lower Case) | — | GL500 |
#GFY-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | GL500 |
#GFY-BASE-AMOUNTBASE_AMOUNT | Signed 18.2 | — | GL500 |
#GFY-BASE-NDBASE_ND | Numeric 1 | — | GL500 |
#GFY-UNITS-AMOUNTUNITS_AMOUNT | Signed 15.2 | — | GL500 |
#GFY-AUTO-REVAUTO_REV | Alpha 1 | — | GL500 |
#GFY-TO-COMPANYTO_COMPANY | Numeric 4 | — | GL500 |
#GFY-BASE-ZONEBASE_ZONE | Alpha 15 | — | GL500 |
#GFY-POSTING-DATEPOSTING_DATE | Numeric 8 (yyyymmdd) | — | GL500 |
#GFY-ACTIVITYACTIVITY | Alpha 15 | — | GL500 |
#GFY-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | — | GL500 |
#GFY-CURRENCY-CODECURRENCY_CODE | Alpha 5 | — | GL500 |
#GFY-BASERATEBASERATE | Signed 14.7 | — | GL500 |
#GFY-TRAN-AMOUNTTRAN_AMOUNT | Signed 18.2 | — | GL500 |
#GFY-TRAN-NDTRAN_ND | Numeric 1 | — | GL500 |
#GFY-ACCT-CURRENCYACCT_CURRENCY | Alpha 5 | — | GL500 |
#GFY-ACCT-RATEACCT_RATE | Signed 14.7 | — | GL500 |
#GFY-ACCT-AMOUNTACCT_AMOUNT | Signed 18.2 | — | GL500 |
#GFY-ACCT-NDACCT_ND | Numeric 1 | — | GL500 |
#GFY-ORIG-COMPANYORIG_COMPANY | Numeric 4 | — | GL500 |
#GFY-ORIG-PROGRAMORIG_PROGRAM | Alpha 5 | — | GL500 |
#GFY-OPERATOROPERATOR | Alpha 10 | — | GL500 |
#GFY-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | — | GL500 |
#GFY-TO-BASE-NDTO_BASE_ND | Numeric 1 | — | GL500 |
#GFY-TO-BASERATETO_BASERATE | Signed 14.7 | — | GL500 |
#GFY-TO-BASE-CURRTO_BASE_CURR | Alpha 5 | — | GL500 |
#GFY-RECONCILERECONCILE | Alpha 2 | — | GL500 |
#GFY-NEGATIVE-ADJNEGATIVE_ADJ | Alpha 1 | — | GL500 |
#GFY-EFFECT-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | — | GL500 |
#GFY-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | — | GL500 |
#GFY-SEQ-TRNS-NBRSEQ_TRNS_NBR | Numeric 10 | — | GL500 |
#GFY-JBK-TRNS-NBRJBK_TRNS_NBR | Numeric 10 | — | GL500 |
#GFY-CONSOL-AC-FLAGCONSOL_AC_FLAG | Alpha 1 | — | GL500 |
#GFY-CT-FR-COMPANYCT_FR_COMPANY | Numeric 4 | — | GL500 |
#GFY-RPT-AMOUNT-1RPT_AMOUNT_1 | Signed 18.2 | — | GL500 |
#GFY-RPT-RATE-1RPT_RATE_1 | Signed 14.7 | — | GL500 |
#GFY-RPT-ND-1RPT_ND_1 | Numeric 1 | — | GL500 |
#GFY-RPT-AMOUNT-2RPT_AMOUNT_2 | Signed 18.2 | — | GL500 |
#GFY-RPT-RATE-2RPT_RATE_2 | Signed 14.7 | — | GL500 |
#GFY-RPT-ND-2RPT_ND_2 | Numeric 1 | — | GL500 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GFYSET1 |
| Primary, KeyChange | GL500 |
Programs
Updated by (1)
- GL500 Fiscal Year Change