| CHEKBKID |
char(15)
''
|
Checkbook ...(more) Join Now
|
|
|
join ... more text available
|
| EFTBankType |
smallint
0
|
EFT Bank T...(more) Join Now
|
|
|
|
| AcctHolder |
char(21)
''
|
Account Ho...(more) Join Now
|
|
|
|
| EFTBankAcct |
char(35)
''
|
EFT Bank A...(more) Join Now
|
|
|
|
| EFTBankBranch |
char(15)
''
|
EFT Bank B...(more) Join Now
|
|
|
|
| EFTBankCode |
char(15)
''
|
EFT Bank C...(more) Join Now
|
|
|
|
| EFTBankBranchCode |
char(5)
''
|
EFT Bank B...(more) Join Now
|
|
|
|
| EFTBankCheckDigit |
char(3)
''
|
EFT Bank C...(more) Join Now
|
|
|
|
| IntlBankAcctNum |
char(35)
''
|
Internatio...(more) Join Now
|
|
|
|
| TXRGNNUM |
char(25)
''
|
Tax Regist...(more) Join Now
|
|
|
|
| DomPmtsFile |
char(255)
''
|
Domestic P...(more) Join Now
|
|
|
|
| ForeignPmtsFile |
char(255)
''
|
Foreign Pa...(more) Join Now
|
|
|
|
| DomDirDbtCollectFile |
char(255)
''
|
Domestic D...(more) Join Now
|
|
|
|
| DomDirDbtRefundFile |
char(255)
''
|
Domestic D...(more) Join Now
|
|
|
|
| BankIDNum |
char(31)
''
|
Bank Ident...(more) Join Now
|
|
|
|
| BankInfo1 |
smallint
0
|
Bank Info ...(more) Join Now
|
|
|
|
| BankInfo2 |
smallint
0
|
Bank Info ...(more) Join Now
|
|
|
|
| BankInfo3 |
smallint
0
|
Bank Info ...(more) Join Now
|
|
|
|
| BankInfo4 |
smallint
0
|
Bank Info ...(more) Join Now
|
|
|
|
| BankInfo5 |
smallint
0
|
Bank Info ...(more) Join Now
|
|
|
|
| BankInfo6 |
smallint
0
|
Bank Info ...(more) Join Now
|
|
|
|
| FedResBankNum |
char(3)
''
|
Federal Re...(more) Join Now
|
|
|
|
| FedResClient |
char(5)
''
|
Federal Re...(more) Join Now
|
|
|
|
| FedResBranch |
char(3)
''
|
Federal Re...(more) Join Now
|
|
|
|
| EFTTransitRoutingNo |
char(11)
''
|
EFT Transi...(more) Join Now
|
|
|
|
| EFTPreTransitDigit |
char(1)
''
|
EFT Pre Tr...(more) Join Now
|
|
|
|
| EFTPriorityCode |
char(3)
''
|
EFT Priori...(more) Join Now
|
|
|
|
| EFTBlockingFactor |
char(3)
''
|
EFT Blocki...(more) Join Now
|
|
|
|
| EFTFormatCode |
char(1)
''
|
EFT Format...(more) Join Now
|
|
|
|
| EFTReference |
char(9)
''
|
EFT Refere...(more) Join Now
|
|
|
|
| EFTCompanyID |
char(11)
''
|
EFT Compan...(more) Join Now
|
|
|
|
| EFTBankCoName |
char(23)
''
|
EFT Bank C...(more) Join Now
|
|
|
|
| EFTSmallCoName |
char(17)
''
|
EFT Small ...(more) Join Now
|
|
|
|
| EFTServiceClassCode |
smallint
0
|
EFT Servic...(more) Join Now
|
|
|
|
| EFTCommunicationType |
smallint
0
|
EFT Commun...(more) Join Now
|
|
|
|
| EFTCommunicationFile |
char(81)
''
|
EFT Commun...(more) Join Now
|
|
|
|
| EFTUseOriginatingCur |
tinyint
0
|
EFT Use Or...(more) Join Now
|
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
|
| ISOCURRC |
char(3)
''
|
ISO Curren...(more) Join Now
|
|
|
|
| EFTDataCentreCode |
smallint
0
|
EFT Data C...(more) Join Now
|
|
|
|
| EFTNextFileNo |
smallint
0
|
EFT Next F...(more) Join Now
|
|
|
|
| EFTPMServClassAll |
char(15)
''
|
EFT PM Ser...(more) Join Now
|
|
|
|
| EFTPMServClassBus |
char(15)
''
|
EFT PM Ser...(more) Join Now
|
|
|
|
| EFTPMServClassCorp |
char(15)
''
|
EFT PM Ser...(more) Join Now
|
|
|
|
| EFTPMServClassForeign |
char(15)
''
|
EFT PM Ser...(more) Join Now
|
|
|
|
| EFTPMServClassPersonal |
char(15)
''
|
EFT PM Ser...(more) Join Now
|
|
|
|
| EFTPMNextNumber |
char(21)
''
|
EFT PM Nex...(more) Join Now
|
|
|
|
| EFTPMPrenoteRequired |
tinyint
0
|
EFT PM Pre...(more) Join Now
|
|
|
|
| EFTPMPrenoteGracePeriod |
smallint
0
|
EFT PM Pre...(more) Join Now
|
|
|
|
| EFTPMPrenoteFile |
char(255)
''
|
EFT PM Pre...(more) Join Now
|
|
|
|
| EFTPMReconcile |
tinyint
0
|
EFT PM Rec...(more) Join Now
|
|
|
|
| EFTPMTrxNumbers |
smallint
0
|
EFT PM Trx...(more) Join Now
|
|
|
|
| EFTRMBankFormat |
smallint
0
|
EFT RM Ban...(more) Join Now
|
|
|
|
| EFTRMServClassAll |
char(15)
''
|
EFT RM Ser...(more) Join Now
|
|
|
|
| EFTRMServClassBus |
char(15)
''
|
EFT RM Ser...(more) Join Now
|
|
|
|
| EFTRMServiceClassCorp |
char(15)
''
|
EFT RM Ser...(more) Join Now
|
|
|
|
| EFTRMServClassForeign |
char(15)
''
|
EFT RM Ser...(more) Join Now
|
|
|
|
| EFTRMServClassPersonal |
char(15)
''
|
EFT RM Ser...(more) Join Now
|
|
|
|
| EFTRMNextNumber |
char(21)
''
|
EFT RM Nex...(more) Join Now
|
|
|
|
| EFTRMPrenoteRequired |
tinyint
0
|
EFT RM Pre...(more) Join Now
|
|
|
|
| EFTRMPrenoteGracePeriod |
smallint
0
|
EFT RM Pre...(more) Join Now
|
|
|
|
| EFTRMPrenoteFile |
char(255)
''
|
EFT RM Pre...(more) Join Now
|
|
|
|
| EFTRMReconcile |
tinyint
0
|
EFT RM Rec...(more) Join Now
|
|
|
|
| RMUSEEFTNUM |
tinyint
0
|
RM Use EFT...(more) Join Now
|
|
|
|
| EFTRMPostBankRecSummary |
tinyint
0
|
EFT RM Pos...(more) Join Now
|
|
|
|
| EFTPMPostBankRecSummary |
tinyint
0
|
EFT PM Pos...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|