|
|
SNGLAMOUNT FILE
UPDATED BY
SNGL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SNA-COMPANY Numeric 4 SNGL.1
Element: Company 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.
SNA-ACCT-UNIT Alpha 15 SNGL.1
Element: Acct Unit 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.
SNA-SUMMARY-ACCT Alpha 12 SNGL.1
Element: Summary Acct
SNA-ACCOUNT Numeric 6 SNGL.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
SNA-SUB-ACCOUNT Numeric 4 SNGL.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
SNA-CUR-PRD-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-CUR-QTR-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-CUR-TOT-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-PRV-PRD-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-PRV-QTD-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-PRV-QTR-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-LYR-PRD-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-LYR-QTD-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-LYR-QTR-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-LYR-YTD-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-LYR-TOT-AMT Signed 18.2 SNGL.1
Element: Intl Amt
SNA-CUR-PRD-BUD Signed 18.2 SNGL.1
Element: Intl Amt
SNA-CUR-QTD-BUD Signed 18.2 SNGL.1
Element: Intl Amt
SNA-CUR-QTR-BUD Signed 18.2 SNGL.1
Element: Intl Amt
SNA-CUR-YTD-BUD Signed 18.2 SNGL.1
Element: Intl Amt
SNA-CUR-TOT-BUD Signed 18.2 SNGL.1
Element: Intl Amt
SNA-AU-DESC Alpha 30 (Lower Case) SNGL.1
Element: Description This field displays the description.
SNA-ACCOUNT-DESC Alpha 60 (Lower Case) SNGL.1
Element: Account Desc The account description.
SNA-AU-DEPTH Numeric 1 SNGL.1
Element: Level Depth The number of variable levels
pertaining
to this record.
SNA-ACCT-DEPTH Numeric 2 SNGL.1
Element: Depth The level depth of the summary account
category.
SNA-ACCT-STYLE Numeric 1 SNGL.1
Element: Consol Type 1 = Summary
2 = Detail
SNA-CHART-TYPE Numeric 1 SNGL.1
Element: Chart Type 1 = Asset
2 = Liability
3 = Equity
4 = Revenue
5 = Expense
6 = Net Income
SNA-PARENT-AU Alpha 15 SNGL.1
Element: Acct Unit 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.
SNGLAMOUNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SNASET1 COMPANY SNGL.1
ACCT-UNIT
SUMMARY-ACCT
ACCOUNT
SUB-ACCOUNT
SNASET2 COMPANY Subset
ACCT-UNIT Where ACCT-STYLE = 1
And CHART-TYPE = 4
SNASET3 COMPANY Subset
ACCT-UNIT Where ACCT-STYLE = 1
And CHART-TYPE = 5
SNGLAMOUNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
