AB_SQL Flashcards
What DB table is called to find, “FI / SMB / User “ lookup?
nationalS
Where do you SELECT *
FROM to query for the, “ FI /SMB / “User”?
APH_PROFILE.dbo.Nationals
Nationals
Our BaNking clients
Primary Key of “Nationals” table?
NationalID
What special symbol can be used in the WHERE clause to search for any character?
%WILDCARD%
“Nationals” also called “clients” = banking clients is queried using what table?
Aph_profile.dbo.nationals
“Chapters” also called “groups” are
Our SMB’s
How to query all SMB’s?
Aph_profile.
Database
Dbo.
Schema
Chapters
TableHow can i find information on our users
MemberInfo
Aph_profile.dbo.memberInfo
The “parent” table for an invoice payment will be located on what table?
ChapMemberPayInfo table
Child” table of invoice payment
ChapmemberPayments
Categorized bank deposits and payment forma live where?
ChapPayInfo
Bill payments, refunds, payroll, categorized bank withdraws are
ChapBillSchedule
Table with bank accounts
OffPlatformAcconts
Bank transactions table is
OffPlatformTeansactions
Invoice table has a parent named?
What do we call it
ChapInvoiceMaster
The offspring to chapInvoiceMaster is
ChapInvoiceDetail
To find the line items on an invoice in the database, what table should you call?
ChapInvoiceItems
Big dogg General ledger details
Aph_dw1.dbo.act_GLdetail
Find AB fees
Alpha. Core.fees
