FDDETAIL – Budget Detail

System
General Ledger Setup (IF)
Prefix
FDD
Primary key
USER-DIM-NAME, MBR-TYPE, MBR-NAME
Fields
5
Updated by
2 programs
Referenced by
2 programs

FDDETAIL is the Budget Detail table in Lawson General Ledger Setup (prefix FDD). It is indexed by USER-DIM-NAME, MBR-TYPE, MBR-NAME (FDDSET1). It is updated by IFAS.1 and IFOS.1 and referenced by IFBA.1 and IFBO.1. The table has 5 fields, 1 index and 0 documented relations.

About FDDETAIL

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the FDD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
FDD-USER-DIM-NAME PK
USER_DIM_NAME		Alpha 50 (Lower Case)The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.IFAS.1, IFOS.1
FDD-MBR-TYPE PK
MBR_TYPE		Alpha 2The Member Type field specifies the member type. Valid values are:
  • BD Budget
  • BV Budget Variance
  • CH Alternate Chart
  • FY Fiscal Year
  • PD Period
  • PY Period Year-to-Date
  • QR Quarter
  • QY Quarter Year-to-Date
  • SA Subaccount
  • VW View
  • YV Year Variance
IFAS.1, IFOS.1
FDD-MBR-NAME PK
MBR_NAME		Alpha 30 (Lower Case)The Member Name field contains the user-defined member name for the income statement member. This name can contain up to 30 characters of any kind.IFAS.1, IFOS.1
FDD-ATTRIBUTE-NAME
ATTRIBUTE_NAME		Alpha 50 (Lower Case)——
FDD-GEN-LEVEL-NBR
GEN_LEVEL_NBR		Numeric 2——

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FDDSET1USER-DIM-NAME, MBR-TYPE, MBR-NAMEPrimaryIFAS.1, IFBA.1, IFBO.1, IFOS.1

Programs

Updated by (2)

Referenced by (2)