SNGLAMOUNT

UPDATED BY
SNGL.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SNA-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
SNGL.1
SNA-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
SNGL.1
SNA-SUMMARY-ACCT
Element: Summary Acct
Alpha 12
SNGL.1
SNA-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
SNGL.1
SNA-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
SNGL.1
SNA-CUR-PRD-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-CUR-QTR-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-CUR-TOT-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-PRV-PRD-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-PRV-QTD-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-PRV-QTR-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-LYR-PRD-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-LYR-QTD-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-LYR-QTR-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-LYR-YTD-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-LYR-TOT-AMT
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-CUR-PRD-BUD
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-CUR-QTD-BUD
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-CUR-QTR-BUD
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-CUR-YTD-BUD
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-CUR-TOT-BUD
Element: Intl Amt
Signed 18.2
SNGL.1
SNA-AU-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
SNGL.1
SNA-ACCOUNT-DESC
Element: Account Desc
Alpha 60 (Lower Case)
The account description.
SNGL.1
SNA-AU-DEPTH
Element: Level Depth
Numeric 1
The number of variable levels pertaining to this record.
SNGL.1
SNA-ACCT-DEPTH
Element: Depth
Numeric 2
The level depth of the summary account category.
SNGL.1
SNA-ACCT-STYLE
Element: Consol Type
Numeric 1

1 = Summary
2 = Detail
SNGL.1
SNA-CHART-TYPE
Element: Chart Type
Numeric 1

1 = Asset
2 = Liability
3 = Equity
4 = Revenue
5 = Expense
6 = Net Income
SNGL.1
SNA-PARENT-AU
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
SNGL.1


SNGLAMOUNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SNASET1 COMPANY
ACCT-UNIT
SUMMARY-ACCT
ACCOUNT
SUB-ACCOUNT
SNGL.1
SNASET2 COMPANY
ACCT-UNIT
Subset
WhereACCT-STYLE =1
AndCHART-TYPE =4
SNASET3 COMPANY
ACCT-UNIT
Subset
WhereACCT-STYLE =1
AndCHART-TYPE =5


SNGLAMOUNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Expense SNGLAMOUNT Not Required
SNA-COMPANY->SNA-COMPANY (SNASET3)
SNA-ACCT-UNIT->SNA-ACCT-UNIT
Revenue SNGLAMOUNT Not Required
SNA-COMPANY->SNA-COMPANY
SNA-ACCT-UNIT->SNA-ACCT-UNIT


File created: Thu Jun 09 11:29:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.