| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | BankCode | Bank Code | nvarchar | 30 | 0 | | | | Allow NULL? |
| 2 | BankName | Bank Name | nvarchar | 250 | 0 | | | | Allow NULL? |
| 3 | DfltAcct | Account for Outgoing Checks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | DfltBranch | Branch for Outgoing Checks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 5 | NextChckNo | Next Check Number | int | 11 | 0 | | | | Allow NULL? |
| 6 | Locked | Locked | char | 1 | 0 | | N | N=Changeable, Y=Locked | Allow NULL? |
| 7 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 8 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 9 | SwiftNum | BIC/SWIFT Code | nvarchar | 50 | 0 | | | | Allow NULL? |
| 10 | IBAN | IBAN | nvarchar | 50 | 0 | | | | Allow NULL? |
| 11 | CountryCod | Country Code | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 12 | PostOffice | Post Office | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | AliasName | Alias Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 14 | AbsEntry | Absolute entry | int | 11 | 0 | | | | Allow NULL? |
| 15 | DfltActKey | Default Bank Account Key | int | 11 | 0 | DSC1 | | | Allow NULL? |
| 16 | NextNum | Our Number in Next Boleto | int | 11 | 0 | | | | Allow NULL? |
| 17 | BsPstDate | Posting Date Definition | char | 1 | 0 | | C | C=Current Date, L=Row Date, S=Statement Date, V=Due Date | Allow NULL? |
| 18 | BsValDate | Due Date Definition | char | 1 | 0 | | C | C=Current Date, L=Row Date, S=Statement Date, V=Due Date | Allow NULL? |
| 19 | BnkOpCode | Bank Operation Code List | int | 11 | 0 | OBOC | | | Allow NULL? |
| 20 | BsDocDate | Document Date Definition | char | 1 | 0 | | C | C=Current Date, L=Row Date, S=Statement Date, V=Due Date | Allow NULL? |