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 GL20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADM-COMPANY Numeric 4 GL122 GL20.2
Company The company number represents an
established company and is entered on
all function codes.
ADM-ACCT-UNIT Alpha 15 GL122 GL20.2
Accounting 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.
ADM-ACCOUNT Numeric 6 GL122 GL20.2
Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ADM-SUB-ACCOUNT Numeric 4 GL122 GL20.2
Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ADM-CHART-NAME Alpha 12 GL122 GL20.2
Chart Name This is the name you assigned to the
chart of accounts when you defined your
company structure in the General Ledger
system.
ADM-PER-DAYS Numeric 2
Per Days
ADM-YEAR-DAYS Numeric 3
Year Days
ADM-INT-ACCT-UNIT Alpha 15
Intransit Account
Unit
ADM-INT-ACCOUNT Numeric 6
Intransit Account
Nbr
ADM-INT-SUB-ACCT Numeric 4
Intransit Subacount
ADM-INT-RATIO Alpha 10
Int Ratio
ADMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADMSET1 COMPANY GL122 GL20.2
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
ADMSET2 COMPANY Subset
INT-RATIO Where INT-RATIO != Spaces
ACCT-UNIT Or (INT-ACCT-UNIT != Spaces
ACCOUNT And INT-ACCOUNT != Zeroes )
SUB-ACCOUNT
|
