TLB_LINE: Telebankregels |
Name: TLB_LINE
Catalog: AccountView
Label: Telebankregels
Partition-specific: true
Select: true
Insert: false
Update: false
Delete: false
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACCT_NR |
string(10) |
Rekeningnummer |
☐ |
|
ADDRESS |
string(30) |
Adres |
☐ |
|
BANK_ACCT |
string(34) |
Bankrekeningnummer |
☐ |
|
BANK_ACCTV |
string(42) |
Bankrekeningnummer |
☐ |
|
BANK_AMT |
int64 |
Bedrag bankmutatie |
☐ |
|
BANK_DATE |
datetime |
Datum bankafschrift |
☐ |
|
BANK_DESC |
string(4) |
Omschrijving bankmutatie |
☐ |
|
BANK_ID |
string(10) |
Identificatie van telebankregel |
☐ |
|
BANK_REF |
string(20) |
Bankreferentie |
☐ |
|
COMP_NAME |
string(100) |
Bedrijfsnaam |
☐ |
|
DJ_CODE |
string(3) |
Dagboekcode |
☐ |
|
INV_NR |
string(12) |
Document-/factuurnummer |
☐ |
|
LINE_ACC |
boolean |
Mutatie geaccepteerd |
☐ |
|
LINE_OK |
boolean |
Regel correct |
☐ |
|
LINE_STAT |
string(4) |
Mutatiestatus |
☐ |
|
LINE_WARN |
string(4) |
Waarschuwing |
☐ |
|
PAGE_NR |
string(10) |
Bladzijdenummer (teken) |
☐ |
|
PART_CODE |
string(10) |
Vennoot |
☐ |
|
partition_code |
string |
Partitiecode |
☑ |
|
partition_name |
string |
Partitie Naam |
☑ |
|
PD_AMT |
int64 |
Bedrag betalingskorting |
☐ |
|
PD_PCT |
decimal |
Percentage betalingskorting |
☐ |
|
POST_CODE |
string(7) |
Postcode |
☐ |
|
PREF |
string(35) |
Batch ID |
☐ |
|
RECOG_STAT |
string(4) |
Status autoherkenning |
☐ |
|
REMI_INFO |
string(140) |
Boekingsinformatie |
☐ |
|
RTRN_CODE |
string(4) |
Afkeuringsreden incasso |
☐ |
|
STMT_KEY |
string(10) |
Unieke sleutel afschrift |
☐ |
|
TRAN_CODE |
string(5) |
Transactiecode |
☐ |
|
TRN_QTY |
decimal |
Aantal (agr) |
☐ |
|
TRN_WGT |
decimal |
Gewicht |
☐ |
|
07-10-2019 20:5217.33.149-BETA+2365