AB_SQL

Question 1

What DB table is called to find, “FI / SMB / User “ lookup?

Answer 1

nationalS

Question 2

Where do you SELECT *

FROM to query for the, “ FI /SMB / “User”?

Answer 2

APH_PROFILE.dbo.Nationals

Question 3

Nationals

Answer 3

Our BaNking clients

Question 4

Primary Key of “Nationals” table?

Answer 4

NationalID

Question 5

What special symbol can be used in the WHERE clause to search for any character?

Answer 5

%WILDCARD%

Question 6

“Nationals” also called “clients” = banking clients is queried using what table?

Answer 6

Aph_profile.dbo.nationals

Question 7

“Chapters” also called “groups” are

Answer 7

Our SMB’s

Question 8

How to query all SMB’s?

Answer 8

Aph_profile.
     Database 
Dbo.
     Schema 
Chapters
     Table

Question 9

How can i find information on our users

Answer 9

MemberInfo

Aph_profile.dbo.memberInfo

Question 10

The “parent” table for an invoice payment will be located on what table?

Answer 10

ChapMemberPayInfo table

Question 11

Child” table of invoice payment

Answer 11

ChapmemberPayments

Question 12

Categorized bank deposits and payment forma live where?

Answer 12

ChapPayInfo

Question 13

Bill payments, refunds, payroll, categorized bank withdraws are

Answer 13

ChapBillSchedule

Question 14

Table with bank accounts

Answer 14

OffPlatformAcconts

Question 15

Bank transactions table is

Answer 15

OffPlatformTeansactions

Question 16

Invoice table has a parent named?

What do we call it

Answer 16

ChapInvoiceMaster

Question 17

The offspring to chapInvoiceMaster is

Answer 17

ChapInvoiceDetail

Question 18

To find the line items on an invoice in the database, what table should you call?

Answer 18

ChapInvoiceItems

Question 19

Big dogg General ledger details

Answer 19

Aph_dw1.dbo.act_GLdetail

Question 20

Find AB fees

Answer 20

Alpha. Core.fees