BANK_ASS: Bankrekeningnummers per licentie |
Name: BANK_ASS
Catalog: AccountView
Label: Bankrekeningnummers per licentie
Partition-specific: true
Select: true
Insert: false
Update: false
Delete: false
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACCT_NAME |
string(40) |
Bedrijfsnaam |
☐ |
|
ASS_CODE |
string(10) |
Serienummer |
☐ |
|
BANK_ACCT |
string(34) |
Bankrekeningnummer |
☐ |
|
BANK_CODE |
string(20) |
Bankcode |
☐ |
|
CNG_DATE |
datetime |
Wijzigingsdatum |
☐ |
|
CNG_NR |
int32 |
Wijzignummer |
☐ |
|
CNG_USR |
string(20) |
Medewerker laatste wijziging |
☐ |
|
CONT_MAIL |
string(50) |
☐ |
|
|
CONT_NAME |
string(40) |
Contactpersoon |
☐ |
|
DATE_END |
datetime |
Einddatum |
☐ |
|
DATE_START |
datetime |
Ingangsdatum |
☐ |
|
INP_DATE |
datetime |
Invoerdatum |
☐ |
|
INP_USR |
string(20) |
Invoermedewerker |
☐ |
|
partition_code |
string |
Partitiecode |
☑ |
|
partition_name |
string |
Partitie Naam |
☑ |
|
REC_ID |
string(10) |
Unieke code |
☐ |
|
REG_ID |
string(38) |
Bankrekeningregistratiecode |
☐ |
|
STATE |
int32 |
Status |
☐ |
|
USG_DD |
boolean |
Incasso |
☐ |
|
USG_PAY |
boolean |
Betalingen |
☐ |
|
USG_TRN |
boolean |
Afschriften |
☐ |
|
07-10-2019 20:5217.33.149-BETA+2365