|
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. |