This data object is used to return all checks that have been issued in the Fusion Business System.

URL

/frw/CheckRegister

Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the check was added.
AddUser This field displays the user name of the individual who added the given check.
Address1 This field displays the address line 1 of the check.
Address2 This field displays the address line 2 of the check.
APVendor If present, this field displays the Accounts Payable vendor to which the check was issued.
Bank This field displays the bank out of which the given check was issued.
CheckAmount This field displays the amount for which the given check was issued.
CheckDate This field displays the date on which the given check was issued.
CheckNumber This field displays the check number assigned to the given check.
CheckSource This field displays the type of the given check (A/P check, G/L check, notes payable check, refund check).
CheckStatus This field displays Voided if the given check has been voided, or Not Voided if the given check has not been voided.
City This field displays the city of the check.
Cleared This field displays whether or not the given check has been marked as cleared.
ClearedDate This field displays the date on which the given check was cleared.
ClearedStatus This field displays Cleared if the given check has been marked as cleared, or Not Cleared if the given check is not marked as cleared.
CustomerNumber If present, this field displays the customer number of the customer to which the check was issued.
LastUpdateDate This field displays the date on which the check was last updated.
LastUpdateUser This field displays the user name of the individual who last updated the given check.
Lender If present, this field displays the lender to which the check was issued.
PayeeName This field displays the payee name to which the check was issued.
PostalCode This field displays the postal code of the check.
PostingBranch This field displays the branch that posted the given check.
PostingPeriod This field displays the accounting posting period for which the given check was posted.
PostingSequence This field displays the accounting transaction posting sequence of the given check.
IsReconciled This field displays whether or not the given check has been reconciled in  Account Reconciliation.
Region This field displays the region of the check.
VoidDate This field displays the date on which the given check was voided.
VoidDescription This field displays the voided description for the given check.
VoidPeriod This field displays the accounting posting period into which the given check was voided.
VoidPostingSequence This field displays the voided posting sequence for the given check.
VoidUser This field displays the user name of the individual who voided the given check.
IsVoided This field displays whether or not the given check has been voided.