SOC_LOG: Kassalogboek |
Name: SOC_LOG
Catalog: AccountView
Label: Kassalogboek
Partition-specific: true
Select: true
Insert: false
Update: false
Delete: false
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CLOSE_DATE |
datetime |
Datum afsluiting |
☐ |
|
CUR_AMT |
int64 |
Valutabedrag |
☐ |
|
CUR_CODE |
string(3) |
Valutacode |
☐ |
|
EXCH_RATE |
decimal |
Valutakoers |
☐ |
|
HDR_ID |
string(10) |
Verk.hist-ident.nr |
☐ |
|
INV_NR |
string(10) |
Verkoopfactuur |
☐ |
|
IS_PROC |
boolean |
Verwerkt |
☐ |
|
LOG_TYPE |
decimal |
Type |
☐ |
|
partition_code |
string |
Partitiecode |
☑ |
|
partition_name |
string |
Partitie Naam |
☑ |
|
PAY_AMT |
int64 |
Bedrag |
☐ |
|
POS_ID |
string(10) |
Kassacode |
☐ |
|
REC_ID |
string(10) |
Unieke code |
☐ |
|
SOC_CODE |
string(20) |
Betaalwijze |
☐ |
|
TRN_DATE |
datetime |
Mutatiedatum |
☐ |
|
07-10-2019 20:5217.33.149-BETA+2365