|
|
ADMASTER FILE
The AD Master file contains the company, accounting unit, account, and
subaccount AD records. It stores the average daily balances for the month,
quarter, and year. When Transaction Posting (AD190) calculates the average
daily balance for each AD account, the result is output to the AD master
file.
UPDATED BY
GL122 GL121 GL20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADM-COMPANY Numeric 4 GL121 GL122
Element: Company The company number represents an GL20.2
established company and is entered on
all function codes.
ADM-ACCT-UNIT Alpha 15 GL121 GL122
Element: Accounting UniThe accounting unit is a shorthand GL20.2
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.
ADM-ACCOUNT Numeric 6 GL121 GL122
Element: Account This field along with the accounting GL20.2
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ADM-SUB-ACCOUNT Numeric 4 GL121 GL122
Element: Subaccount GL20.2
ADM-CHART-NAME Alpha 12 GL121 GL122
Element: Name User This is the name you assigned to the GL20.2
chart of accounts when you defined your
company structure in the General Ledger
system.
ADM-PER-DAYS Numeric 2
Element: Posting Day
ADM-YEAR-DAYS Numeric 3
Normal Days to Ship
Order
ADM-INT-ACCT-UNIT Alpha 15
Element: Accounting Unit
ADM-INT-ACCOUNT Numeric 6
Element: Account
ADM-INT-SUB-ACCT Numeric 4
Element: Subaccount
ADM-INT-RATIO Alpha 10
Element: Int Ratio
ADMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADMSET1 COMPANY GL122 GL121
ACCT-UNIT GL20.2
ACCOUNT
SUB-ACCOUNT
ADMSET2 COMPANY KeyChange, Subset
INT-RATIO Where INT-RATIO != Spaces
ACCT-UNIT Or (INT-ACCT-UNIT != Spaces
ACCOUNT And INT-ACCOUNT != Zeroes )
SUB-ACCOUNT
|
