Reference Account

The reference account view object contains information about reference accounts, including business unit, ledger, bills receivable account, unpaid bills receivable account, remitted bills receivable account, factored bills receivable account, clearing account, revenue account, freight account, receivable account, tax account, unbilled receivables account, unearned account, distribution set account, and suspense account.

Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReferenceAccountExtractPVO

Primary Keys : ArRefAccountSourceRefAccountId, ArRefAccountBuId, ArRefAccountSourceRefTable

Initial Extract Date : ArRefAccountCreationDate

Incremental Extract Date : ArRefAccountLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ArRefAccountBrFactorCcid	The identifier of the factored bills receivable reference account.
ArRefAccountBrRemitCcid	The identifier of the remitted bills receivable reference account.
ArRefAccountBrUnpaidCcid	The identifier of the unpaid bills receivable reference account.
ArRefAccountBuId	The identifier of the business unit associated with the reference account.
ArRefAccountClearingCcid	The identifier of the clearing reference account.
ArRefAccountCreatedBy	The user who created the reference account.
ArRefAccountCreationDate	The date and time the reference account was created.
ArRefAccountDistSetCcid	The identifier of the distribution set reference account.
ArRefAccountDrcCcid	The identifier of the suspense reference account.
ArRefAccountFreightCcid	The identifier of the freight reference account.
ArRefAccountLastUpdateDate	The date and time the reference account was last updated.
ArRefAccountLastUpdateLogin	The session login of the user who last updated the reference account.
ArRefAccountLastUpdatedBy	The user who last updated the reference account.
ArRefAccountLedgerId	The identifier of the primary ledger associated with the reference account.
ArRefAccountObjectVersionNumber	The number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a reference account to detect whether another session has updated the row since it was queried.
ArRefAccountRecCcid	The identifier of the receivable reference account.
ArRefAccountRevCcid	The identifier of the revenue reference account.
ArRefAccountSourceRefAccountId	The identifier of the source reference account.
ArRefAccountSourceRefTable	The source table of reference account values.
ArRefAccountTaxCcid	The identifier of the tax reference account.
ArRefAccountUnbilledCcid	The identifier of the unbilled receivables reference account.
ArRefAccountUnearnedCcid	The identifier of the unearned revenue reference account.