|
ARDISTBAL FILE
UPDATED BY
AR197 AR99.6
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RBL-GL-COMPANY Numeric 4 AR197 AR99.6
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.
RBL-ACCT-UNIT Alpha 15 AR197 AR99.6
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.
RBL-ACCOUNT Numeric 6 AR197 AR99.6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RBL-SUB-ACCT Numeric 4 AR197 AR99.6
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.
RBL-BAL-DATE Numeric 8 (yyyymmdd) AR197 AR99.6
Element: Date This field displays the system date
when this was created.
RBL-BASE-AMOUNT Signed 18.2 AR197 AR99.6
Element: Intl Amt
RBL-USER Alpha 10 (Lower Case) AR197 AR99.6
Element: User
RBL-DATE Numeric 8 (yyyymmdd) AR197 AR99.6
Element: Date This field displays the system date
when this was created.
RBL-TIME Numeric 8 AR197 AR99.6
Element: Time This field is updated automatically to
indicate the time that the GL entry was
created. It is system-maintained.
RBL-DISTRIB-UPDTED Alpha 1 AR197 AR99.6
Element: Flag This flag indicates the source of its
creation and is useful for delete logic.
N = AR99 created, Y = AR197 updated.
ARDISTBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RBLSET1 GL-COMPANY AR197 AR99.6
ACCT-UNIT
ACCOUNT
SUB-ACCT
BAL-DATE
RBLSET2 GL-COMPANY AR197
ACCT-UNIT
ACCOUNT
SUB-ACCT
BAL-DATE*
RBLSET3 GL-COMPANY AR197 AR99.6
BAL-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCT
|