|
Data dictionary exactcs - 7.27
admdat - Company data1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | adm_nr_refxxx | integer | >>9 | | | 0 | Company | |
3 | adm_name | character | X(60) | | | | Description | |
4 | adm_mother | integer | >>>>>9 | | | 0 | Master company | |
5 | name | character | X(60) | | | | Name | |
6 | address | character | X(60) | | | | Address line 1 | |
7 | address_2 | character | X(60) | | | | Address line 2 | |
8 | address_3 | character | X(60) | | | | Address line 3 | |
9 | postal_code | character | x(8) | | | | Postal code | stpostal |
10 | city | character | X(60) | | | | City | |
11 | country | character | x(3) | | | | Country | countr |
12 | contact | character | X(60) | | | | Contact | |
13 | telephone | character | x(15) | | | | Telephone | |
14 | fax_nr | character | x(15) | | | | Fax | |
15 | interface | character | x(6) | | | | Interface | |
16 | e_mail | character | X(60) | | | | E-mail | |
17 | telex_nr | character | x(10) | | | | Telex number | |
18 | bank_acc_nr | character | x(34) | | | | Bank account | |
19 | postbank_acc_nr | character | x(34) | | | | Postbank | |
20 | chamber_of_commerce_nr | character | X(10) | | | | Chamber of Commerce number | |
21 | chamber_of_commerce_city | character | X(60) | | | | Chamber of Commerce city | |
22 | vat_nr | character | x(20) | | | | VAT number | |
23 | income_tax_nr | character | x(20) | | | | Income tax no. | |
24 | fiscal_nr | character | x(12) | | | | Fiscal ID | |
25 | corr_address | character | X(60) | | | | Correspondence: Address line 1 | |
26 | corr_address_2 | character | X(60) | | | | Correspondence: Address line 2 | |
27 | corr_address_3 | character | X(60) | | | | Correspondence: Address line 3 | |
28 | corr_postal_code | character | x(8) | | | | Correspondence: Postal code | stpostal |
29 | corr_city | character | X(60) | | | | Correspondence: City | |
30 | corr_country | character | x(3) | | | | Correspondence: Country | countr |
31 | corr_contact | character | X(60) | | | | Correspondence: Contact | |
32 | curr_code | character | x(3) | | | | Currency | |
33 | bgc_adm_nr | integer | >>>>>>9 | | | 0 | BGC company | |
34 | batchlevel | integer | >>>>>9 | | | 0 | Batch level | |
35 | source_lc | character | x(12) | | | | | |
36 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
37 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
38 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
39 | type_lc | character | x(8) | | | | | |
40 | xxxLicNumber | decimal | >>>>>>>>>>9 | 0 | | 0 | License number | |
41 | xxxLicSeq | integer | >>9 | | | 0 | Sequence | |
42 | bnk_curr_code | character | x(3) | | | | Currency (Bank) | curren |
43 | siret_number | character | x(20) | | | | Siret number | |
44 | func_desc | character | x(30) | | | | Position | |
45 | website | character | X(160) | | | | Website | |
46 | vat_nr_accountant | character | X(2000) | | | | Accountant: VAT number | |
47 | ext_file | character | X(80) | | | | External file | |
48 | deleted | logical | yes/no | | | no | Block | |
49 | type_company | integer | >>>>>9 | | | 0 | Company type | t_test: company-type |
50 | house_nr | integer | >>>>>9 | | | 0 | House number | |
51 | house_nr_addition | character | X(8) | | | | House number addition | |
52 | lang_code | character | x(3) | | | | Language | lang |
53 | corr_house_nr | integer | >>>>>9 | | | 0 | Correspondence: House number | |
54 | corr_house_nr_addition | character | X(8) | | | | Correspondence: House number addition | |
55 | corr_lang_code | character | x(3) | | | | Correspondence: Language | lang |
56 | wc_stylesheet | integer | >>>>>9 | | | 0 | WebClient: Stylesheet | t_test: wc_stylesheet |
57 | vat_nr_fiscal_unit | character | X(20) | | | | Fiscal unit: VAT number | |
58 | xml_definition_vat | character | x(12) | | | | XML definition code | stxlink |
59 | stylesheet_vat | integer | >>>>>9 | | | 0 | Stylesheet | t_test: vat-stylesheet |
60 | contact_type | integer | >>>>>9 | | | 0 | Contact type | t_test: contact_type |
61 | contact_id | character | X(15) | | | | Contact ID | |
62 | contact_name | character | X(30) | | | | Name | |
63 | contact_telephone | character | X(30) | | | | Contact: Telephone | |
64 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
admdatix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
admdat02ix
1 | adm_mother | integer | >>>>>9 | Master company |
2 | adm_nr | integer | >>>>>9 | Company |
Contents > admdat
admnac - Company: Delivery addresses1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | addr_code | character | x(12) | | | ? | Address | stnactype |
3 | name | character | X(100) | | | | Name | |
4 | address_1 | character | X(60) | | | | Address line 1 | |
5 | address_2 | character | X(60) | | | | Address line 2 | |
6 | address_3 | character | X(60) | | | | Address line 3 | |
7 | postal_code | character | x(8) | | | | Postal code | stpostal |
8 | city | character | X(60) | | | | City | |
9 | country | character | x(3) | | | | Country | countr |
10 | telephone | character | x(15) | | | | Telephone | |
11 | fax_nr | character | x(15) | | | | Fax | |
12 | title_code | character | x(4) | | | | Title | titles |
13 | initials | character | x(10) | | | | Initials | |
14 | contact | character | X(60) | | | | Contact | |
15 | func_desc | character | x(15) | | | | Position | |
16 | sex | integer | >>>>>9 | | | 0 | Sex | t_test: sex |
17 | lang_code | character | x(3) | | | | Language | lang |
18 | route_code | character | x(2) | | | | Route | |
19 | instr | character | x(80) | | | | Instruction | |
20 | source_lc | character | x(12) | | | | | |
21 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
22 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
23 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
24 | type_lc | character | x(8) | | | | | |
25 | e_mail | character | x(256) | | | | E-mail | |
26 | euserid_cr | character | x(20) | | | | Created: User | stuser |
27 | date_cr | date | 99/99/9999 | | | | Created: Date | |
28 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
29 | source_cr | character | x(12) | | | | Source creation | |
30 | entity_state | integer | >>>>>9 | | | 0 | State | |
31 | address_type_code | character | x(12) | | | | Address type code | stnactype |
32 | house_nr | integer | >>>>>9 | | | 0 | House number | |
33 | house_nr_addition | character | X(8) | | | | House number addition | |
34 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
admnacix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | addr_code | character | x(12) | Address |
admnac02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | addr_code | character | x(12) | Address |
admnac03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | address_type_code | character | x(12) | Address type code |
3 | addr_code | character | x(12) | Address |
admnac04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | postal_code | character | x(8) | Postal code |
3 | address_1 | character | X(60) | Address line 1 |
Contents > admnac
atrsh - Financial entries1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | fin_yr | integer | 9999 | | | ? | Year | |
3 | period | integer | >>9 | | | ? | Period | |
4 | journal_nr | integer | >>9 | | | ? | Journal number | journl |
5 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | |
6 | open_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Opening balance: Journal currency | |
7 | final_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Closing balance: Journal currency | |
8 | entry_nr_type | integer | >>>>>9 | | | 1 | Entry type | t_test: entry-nr-type |
9 | entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Outstanding item: Invoice number | |
10 | descr | character | X(60) | | | | Description | |
11 | date | date | 99/99/9999 | | | | Date | |
12 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | debtor |
13 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | credit |
14 | amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
15 | curr_code | character | x(3) | | | | Currency | curren |
16 | exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Exchange rate | |
17 | amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
18 | week_nr | integer | >9 | | | 0 | Due week | |
19 | acc_nr_transit | character | x(12) | | | | Transit account | |
20 | period_transit | integer | >>9 | | | 0 | Transit period | |
21 | pay_ref | character | X(32) | | | | Payment reference | |
22 | pay_method | integer | >>>>>9 | | | 0 | Payment method | t_test: pay-method |
23 | pay_condition | character | X(4) | | | | Payment condition | paycon |
24 | surch_disc | integer | >>>>>9 | | | 0 | Payment charge/discount | t_test: surch-disc |
25 | amt_credit_surch_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment charge: Amount 1 | |
26 | amt_credit_surch_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment charge: Amount 2 | |
27 | due_date_invoice | date | 99/99/9999 | | | | Due date | |
28 | due_date_surch_1 | date | 99/99/9999 | | | | Payment charge: Due date 1 | |
29 | due_date_surch_2 | date | 99/99/9999 | | | | Payment charge: Due date 2 | |
30 | perc_1 | decimal | ->>9.99 | 2 | | 0 | Payment charge: Percentage 1 | |
31 | perc_2 | decimal | ->>9.99 | 2 | | 0 | Payment charge: Percentage 2 | |
32 | amt_acc_nr_blocked | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount blocked bank account | |
33 | ext_entry_nr | character | X(30) | | | | Invoice number (Creditor) | |
34 | outst_item_created | logical | yes/no | | | no | Outstanding item created | |
35 | rev_entry | logical | yes/no | | | no | Reversal entry | |
36 | match_inv_type | integer | >>>>>9 | | | 1 | Invoice number matching type | |
37 | match_inv | int64 | >>>>>>>>>>>9 | | | 0 | Invoice number matching | |
38 | x_seqnr_boe | int64 | >>>>>>>>>9 | | | 0 | B/E number | boecrd |
39 | acc_nr | character | x(12) | | | | General ledger account | ledger |
40 | origin | integer | >>>>>9 | | | 0 | Origin | |
41 | source_lc | character | x(12) | | | | | |
42 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
43 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
44 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
45 | type_lc | character | x(8) | | | | | |
46 | ii_register | logical | yes/no | | | no | Incoming invoice | |
47 | ifall_block | logical | yes/no | | | no | Block for changes | |
48 | amt_credit_surch_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment charge: Amount 3 | |
49 | amt_credit_surch_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment charge: Amount 4 | |
50 | amt_credit_surch_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment charge: Amount 5 | |
51 | due_date_surch_3 | date | 99/99/9999 | | | | Payment charge: Due date 3 | |
52 | due_date_surch_4 | date | 99/99/9999 | | | | Payment charge: Due date 4 | |
53 | due_date_surch_5 | date | 99/99/9999 | | | | Payment charge: Due date 5 | |
54 | perc_3 | decimal | ->>9.99 | 2 | | 0 | Payment charge: Percentage 3 | |
55 | perc_4 | decimal | ->>9.99 | 2 | | 0 | Payment charge: Percentage 4 | |
56 | perc_5 | decimal | ->>9.99 | 2 | | 0 | Payment charge: Percentage 5 | |
57 | auth_entry | integer | >>9 | | | 0 | Authorisation of entry | |
58 | block_out_item | logical | yes/no | | | no | Outstanding item: Blocked | |
59 | entry_state | integer | >>>>>9 | | | 0 | Entry status | t_test: entry_state |
60 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
atrsh01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | period | integer | >>9 | Period |
4 | journal_nr | integer | >>9 | Journal number |
5 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
atrsh02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | fin_yr | integer | 9999 | Year |
4 | period | integer | >>9 | Period |
atrsh03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | fin_yr | integer | 9999 | Year |
4 | period | integer | >>9 | Period |
atrsh04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
4 | entry_nr | int64 | >>>>>>>>>>>9 | Outstanding item: Invoice number |
5 | entry_nr_type | integer | >>>>>9 | Entry type |
Contents > atrsh
balcen - Cost center balances1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | fin_yr | integer | 9999 | | | ? | Year | |
3 | acc_nr | character | x(12) | | | ? | General ledger account | ledger |
4 | cost_center | character | x(12) | | | ? | Cost center | ccent |
5 | period | integer | >>9 | | | ? | Period | |
6 | bal_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit DC | |
7 | bal_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit DC | |
8 | x_bud_amt_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount debit | |
9 | x_bud_amt_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount credit | |
10 | qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | |
11 | x_bud_qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Budget quantity | |
12 | source_lc | character | x(12) | | | | | |
13 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
16 | type_lc | character | x(8) | | | | | |
17 | bal_crd_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Credit balance (Entered) | |
18 | bal_deb_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Debit balance (Entered) | |
19 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
balcenix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | cost_center | character | x(12) | Cost center |
4 | acc_nr | character | x(12) | General ledger account |
5 | period | integer | >>9 | Period |
balcen2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | acc_nr | character | x(12) | General ledger account |
4 | cost_center | character | x(12) | Cost center |
5 | period | integer | >>9 | Period |
balcen3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | cost_center | character | x(12) | Cost center |
4 | period | integer | >>9 | Period |
Contents > balcen
balcun - Consolidated balance sheet1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | fin_yr | integer | 9999 | | | ? | Year | |
3 | acc_nr | character | x(12) | | | ? | General ledger account | ledger |
4 | cost_unit | character | x(12) | | | ? | Consolidated company | consco |
5 | period | integer | >>9 | | | ? | Period | |
6 | bal_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit DC | |
7 | bal_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit DC | |
8 | x_bud_amt_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount debit | |
9 | x_bud_amt_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount credit | |
10 | qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | |
11 | x_bud_qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Budget quantity | |
12 | source_lc | character | x(12) | | | | | |
13 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
16 | type_lc | character | x(8) | | | | | |
17 | bal_crd_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Credit balance (Entered) | |
18 | bal_deb_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Debit balance (Entered) | |
19 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
balcunix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | cost_unit | character | x(12) | Consolidated company |
4 | acc_nr | character | x(12) | General ledger account |
5 | period | integer | >>9 | Period |
balcun2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | acc_nr | character | x(12) | General ledger account |
4 | cost_unit | character | x(12) | Consolidated company |
5 | period | integer | >>9 | Period |
balcun3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | cost_unit | character | x(12) | Consolidated company |
4 | period | integer | >>9 | Period |
Contents > balcun
balsht - Balance sheet1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | fin_yr | integer | 9999 | | | ? | Year | |
3 | acc_nr | character | x(12) | | | ? | General ledger account | ledger |
4 | period | integer | >>9 | | | ? | Period | |
5 | deb_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit DC | |
6 | cred_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit DC | |
7 | x_bud_amt_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount debit | |
8 | x_bud_amt_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount credit | |
9 | qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | |
10 | x_bud_qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Budget quantity | |
11 | source_lc | character | x(12) | | | | | |
12 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
14 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
15 | type_lc | character | x(8) | | | | | |
16 | bal_deb_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Debit balance (Entered) | |
17 | bal_crd_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Credit balance (Entered) | |
18 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
balshtix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | acc_nr | character | x(12) | General ledger account |
4 | period | integer | >>9 | Period |
balsht2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | period | integer | >>9 | Period |
4 | acc_nr | character | x(12) | General ledger account |
Contents > balsht
bdalcch - Budget: Cost center allocations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | ccent_allocation_code | character | x(12) | | | ? | Allocation: Cost center | |
3 | description | character | X(60) | | | | Description | |
4 | descr_ml | character | X(60) | | 5 | | ML Description | |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | date_cr | date | 99/99/9999 | | | | Created: Date | |
7 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
8 | source_cr | character | x(12) | | | | Source creation | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
12 | source_lc | character | x(12) | | | | Source last changed | |
13 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
Indexes
bdalcch01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | ccent_allocation_code | character | x(12) | Allocation: Cost center |
Contents > bdalcch
bdalccl - Budget: Cost center allocation (Lines)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | ccent_allocation_code | character | x(12) | | | ? | Allocation: Cost center | bdalcch |
3 | cost_center | character | x(12) | | | ? | Cost center | ccent |
4 | units | decimal | >>,>>>,>>>,>>9.99 | 2 | | 0 | Units | |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | date_cr | date | 99/99/9999 | | | | Created: Date | |
7 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
8 | source_cr | character | x(12) | | | | Source creation | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
12 | source_lc | character | x(12) | | | | Source last changed | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdalccl01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | ccent_allocation_code | character | x(12) | Allocation: Cost center |
3 | cost_center | character | x(12) | Cost center |
Contents > bdalccl
bdalcuh - Budget: Cost unit allocations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cunit_allocation_code | character | x(12) | | | ? | Allocation: Cost unit | |
3 | description | character | X(60) | | | | Description | |
4 | descr_ml | character | X(60) | | 5 | | ML Description | |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
7 | source_cr | character | x(12) | | | | Source creation | |
8 | source_lc | character | x(12) | | | | Source last changed | |
9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
10 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
11 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
12 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
Indexes
bdalcuh01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cunit_allocation_code | character | x(12) | Allocation: Cost unit |
Contents > bdalcuh
bdalcul - Budget: Cost unit allocation (Lines)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cunit_allocation_code | character | x(12) | | | ? | Allocation: Cost unit | bdalcuh |
3 | cost_unit | character | x(12) | | | ? | Cost unit | cunit |
4 | units | decimal | >>,>>>,>>>,>>9.99 | 2 | | 0 | Units | |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
7 | source_cr | character | x(12) | | | | Source creation | |
8 | source_lc | character | x(12) | | | | Source last changed | |
9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdalcul01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cunit_allocation_code | character | x(12) | Allocation: Cost unit |
3 | cost_unit | character | x(12) | Cost unit |
Contents > bdalcul
bdalloch - Budget ccent allocation header1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | type_allocation | integer | >>>>>9 | | | ? | Allocation type | |
3 | allocation_code | character | X(12) | | | ? | Allocation | |
4 | description | character | X(60) | | | | Description | |
5 | descr_ml | character | X(60) | | 5 | | ML Description | |
6 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
10 | source_lc | character | X(8) | | | | Source last changed | |
Indexes
bdalloch01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | type_allocation | integer | >>>>>9 | Allocation type |
3 | allocation_code | character | X(12) | Allocation |
Contents > bdalloch
bdallocl - Budget ccent allocation line1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | type_allocation | integer | >>>>>9 | | | ? | Allocation type | |
3 | allocation_code | character | X(12) | | | ? | Cost center allocation | |
4 | entity_code | character | X(12) | | | ? | Entity | |
5 | units | decimal | >>,>>>,>>>,>>9.99 | 2 | | 0 | Units | |
6 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
9 | source_lc | character | X(8) | | | | Source last changed | |
Indexes
bdallocl01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | type_allocation | integer | >>>>>9 | Allocation type |
3 | allocation_code | character | X(12) | Cost center allocation |
4 | entity_code | character | X(12) | Entity |
Contents > bdallocl
bdalph - Budget: Period allocations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | period_allocation_code | character | x(12) | | | ? | Allocation: Period | |
3 | description | character | X(60) | | | | Description | |
4 | descr_ml | character | X(60) | | 5 | | ML Description | |
5 | periods | integer | >>9 | | | 0 | Number of periods | |
6 | euserid_cr | character | x(20) | | | | Created: User | stuser |
7 | date_cr | date | 99/99/9999 | | | | Created: Date | |
8 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
9 | source_cr | character | x(12) | | | | Source creation | |
10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
13 | source_lc | character | x(12) | | | | Source last changed | |
14 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
Indexes
bdalph01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | period_allocation_code | character | x(12) | Allocation: Period |
Contents > bdalph
bdalpl - Budget: Period allocation (Lines)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | period_allocation_code | character | x(12) | | | ? | Allocation: Period | bdalph |
3 | period | integer | >>9 | | | ? | Period | |
4 | units | decimal | >>,>>>,>>>,>>9.99 | 2 | | 0 | Units | |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | date_cr | date | 99/99/9999 | | | | Created: Date | |
7 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
8 | source_cr | character | x(12) | | | | Source creation | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
12 | source_lc | character | x(12) | | | | Source last changed | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdalpl01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | period_allocation_code | character | x(12) | Allocation: Period |
3 | period | integer | >>9 | Period |
Contents > bdalpl
bdcumdat - Budget cumulative data1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | version_code | character | X(12) | | | ? | Version | |
3 | type_path | integer | >>>>>9 | | | ? | Path type | |
4 | seqnr_bdpath | integer | >>>>>>>9 | | | ? | Sequence number path | |
5 | structure_code_1 | character | X(12) | | | ? | Structure 1 | |
6 | entity_code_1 | character | X(12) | | | ? | Entity 1 | |
7 | structure_code_2 | character | X(12) | | | ? | Structure 2 | |
8 | entity_code_2 | character | X(12) | | | ? | Entity 2 | |
9 | structure_code_3 | character | X(12) | | | ? | Structure 3 | |
10 | entity_code_3 | character | X(12) | | | ? | Entity 3 | |
11 | structure_code_4 | character | X(12) | | | ? | Structure 4 | |
12 | entity_code_4 | character | X(12) | | | ? | Entity 4 | |
13 | date_activation | integer | 99999999 | | | | Date activation | |
14 | seqnr_activation | integer | >>>>9 | | | ? | Sequence number activation | |
15 | quantity | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Quantity | |
16 | amount_debit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit | |
17 | amount_credit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit | |
18 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
19 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
20 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
21 | source_lc | character | X(8) | | | | Source last changed | |
Indexes
bdcumdat01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | X(12) | Version |
3 | type_path | integer | >>>>>9 | Path type |
4 | seqnr_bdpath | integer | >>>>>>>9 | Sequence number path |
5 | structure_code_1 | character | X(12) | Structure 1 |
6 | entity_code_1 | character | X(12) | Entity 1 |
7 | structure_code_2 | character | X(12) | Structure 2 |
8 | entity_code_2 | character | X(12) | Entity 2 |
9 | structure_code_3 | character | X(12) | Structure 3 |
10 | entity_code_3 | character | X(12) | Entity 3 |
11 | structure_code_4 | character | X(12) | Structure 4 |
12 | entity_code_4 | character | X(12) | Entity 4 |
13 | date_activation | integer | 99999999 | Date activation |
14 | seqnr_activation | integer | >>>>9 | Sequence number activation |
Contents > bdcumdat
bdeauth - Budget authorization entries1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdeauth | integer | >>>>>>>9 | | | ? | Budget authorization entry | |
4 | type_state_entry | integer | >>>>>9 | | | 0 | Status | t_test: state-budget-entry |
5 | description | character | X(60) | | | | Description | |
6 | date_active | date | 99/99/9999 | | | | Activation date | |
7 | notes | character | X(2000) | | | | Notes | |
8 | seqnr_bdpath | integer | >>>>>9 | | | 0 | Entry path | bdpath |
9 | euserid_cr | character | x(20) | | | | Created: User | stuser |
10 | date_cr | date | 99/99/9999 | | | | Created: Date | |
11 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
12 | source_cr | character | x(12) | | | | Source creation | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
16 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
bdeauth01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdeauth | integer | >>>>>>>9 | Budget authorization entry |
bdeauth02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | date_active | date | 99/99/9999 | Activation date |
Contents > bdeauth
bdeautl - Budget authorization entry (Lines)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdeauth | integer | >>>>>>>9 | | | ? | Budget authorization entry | bdeauth |
4 | linenr_bdeautl | integer | >>>9 | | | ? | Budget authorization entry line | |
5 | description | character | X(60) | | | | Description | |
6 | structure_code_acc_nr | character | x(12) | | | | Structure: G/L account | ststruc |
7 | level_code_acc_nr | character | x(12) | | | | G/L account: Base level | stblev,comp |
8 | acc_nr | character | x(12) | | | | General ledger account | stbent,ledger |
9 | structure_code_cost_center | character | x(12) | | | | Structure: Cost center | ststruc |
10 | level_code_cost_center | character | x(12) | | | | Cost center: Base level | stblev |
11 | cost_center | character | x(12) | | | | Cost center | stbent,ccent |
12 | structure_code_cost_unit | character | x(12) | | | | Structure: Cost unit | ststruc |
13 | level_code_cost_unit | character | x(12) | | | | Cost unit: Base level | stblev |
14 | cost_unit | character | x(12) | | | | Cost unit | stbent,cunit |
15 | year | integer | 9999 | | | 0 | Year | |
16 | period | integer | >>9 | | | 0 | Period | |
17 | user_id_manager | character | x(20) | | | | Budget manager | bdmng |
18 | quantity | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Quantity changed | |
19 | amount_debit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Debit changed | |
20 | amount_credit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Credit changed | |
21 | type_action | integer | >>>>>9 | | | 0 | Action | |
22 | euserid_cr | character | x(20) | | | | Created: User | stuser |
23 | date_cr | date | 99/99/9999 | | | | Created: Date | |
24 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
25 | source_cr | character | x(12) | | | | Source creation | |
26 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
27 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
28 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
29 | source_lc | character | x(12) | | | | Source last changed | |
30 | mdim_code_1 | character | X(12) | | | | Dimension 1 | |
31 | mdim_code_2 | character | X(12) | | | | Dimension 2 | |
32 | mdim_code_3 | character | X(12) | | | | Dimension 3 | |
33 | mdim_code_4 | character | X(12) | | | | Dimension 4 | |
34 | mdim_code_5 | character | X(12) | | | | Dimension 5 | |
35 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdeautl01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdeauth | integer | >>>>>>>9 | Budget authorization entry |
4 | linenr_bdeautl | integer | >>>9 | Budget authorization entry line |
Contents > bdeautl
bdenth - Budget entries1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdenth | integer | >>>>>>>9 | | | ? | Budget entry | |
4 | type_state_entry | integer | >>>>>9 | | | 0 | Status | t_test: state-budget-entry |
5 | description | character | X(60) | | | | Description | |
6 | date_active | date | 99/99/9999 | | | | Activation date | |
7 | quantity | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Quantity | |
8 | amount_debit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit | |
9 | amount_credit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit | |
10 | notes | character | X(2000) | | | | Notes | |
11 | seqnr_bdpath | integer | >>>>>9 | | | 0 | Entry path | bdpath |
12 | euserid_cr | character | x(20) | | | | Created: User | stuser |
13 | date_cr | date | 99/99/9999 | | | | Created: Date | |
14 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
15 | source_cr | character | x(12) | | | | Source creation | |
16 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
17 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
18 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
19 | source_lc | character | x(12) | | | | Source last changed | |
20 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdenth01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdenth | integer | >>>>>>>9 | Budget entry |
bdenth02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | type_state_entry | integer | >>>>>9 | Status |
4 | seqnr_bdenth | integer | >>>>>>>9 | Budget entry |
bdenth03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | date_active | date | 99/99/9999 | Activation date |
Contents > bdenth
bdentl - Budget entry (Lines)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdenth | integer | >>>>>>>9 | | | ? | Budget entry | bdenth |
4 | linenr_bdentl | integer | >>>9 | | | ? | Line | |
5 | type_state_entry | integer | >>>>>9 | | | 0 | Status | t_test: state-budent-line |
6 | description | character | X(60) | | | | Description | |
7 | structure_code_acc_nr | character | x(12) | | | | Structure: G/L account | ststruc |
8 | level_code_acc_nr | character | x(12) | | | | G/L account: Base level | stblev,comp |
9 | acc_nr | character | x(12) | | | | General ledger account | stbent,ledger |
10 | structure_code_cost_center | character | x(12) | | | | Structure: Cost center | ststruc |
11 | level_code_cost_center | character | x(12) | | | | Cost center: Base level | stblev |
12 | cost_center | character | x(12) | | | | Cost center | stbent,ccent |
13 | structure_code_cost_unit | character | x(12) | | | | Structure: Cost unit | ststruc |
14 | level_code_cost_unit | character | x(12) | | | | Cost unit: Base level | stblev |
15 | cost_unit | character | x(12) | | | | Cost unit | stbent,cunit |
16 | year | integer | 9999 | | | 0 | Year | |
17 | period | integer | >>9 | | | 0 | Period | |
18 | quantity | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Quantity changed | |
19 | amount_debit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Debit changed | |
20 | amount_credit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Credit changed | |
21 | period_allocation_code | character | x(12) | | | | Allocation: Period | bdalph |
22 | ccent_allocation_code | character | x(12) | | | | Allocation: Cost center | bdalcch |
23 | cunit_allocation_code | character | x(12) | | | | Allocation: Cost unit | bdalcuh |
24 | type_line | integer | >>>>>9 | | | 0 | Type | t_test: type-budent-line |
25 | euserid_cr | character | x(20) | | | | Created: User | stuser |
26 | date_cr | date | 99/99/9999 | | | | Created: Date | |
27 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
28 | source_cr | character | x(12) | | | | Source creation | |
29 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
30 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
31 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
32 | source_lc | character | x(12) | | | | Source last changed | |
33 | mdim_code_1 | character | X(12) | | | | Dimension 1 | |
34 | mdim_code_2 | character | X(12) | | | | Dimension 2 | |
35 | mdim_code_3 | character | X(12) | | | | Dimension 3 | |
36 | mdim_code_4 | character | X(12) | | | | Dimension 4 | |
37 | mdim_code_5 | character | X(12) | | | | Dimension 5 | |
38 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdentl01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdenth | integer | >>>>>>>9 | Budget entry |
4 | linenr_bdentl | integer | >>>9 | Line |
bdentl02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | type_state_entry | integer | >>>>>9 | Status |
4 | seqnr_bdenth | integer | >>>>>>>9 | Budget entry |
5 | linenr_bdentl | integer | >>>9 | Line |
bdentl03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdenth | integer | >>>>>>>9 | Budget entry |
4 | type_state_entry | integer | >>>>>9 | Status |
5 | linenr_bdentl | integer | >>>9 | Line |
Contents > bdentl
bdmng - Budget managers1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | euserid | character | x(20) | | | ? | User ID | stuser |
3 | version_code | character | x(12) | | | ? | Version | bdvers |
4 | euserid_cr | character | x(20) | | | | Created: User | stuser |
5 | date_cr | date | 99/99/9999 | | | | Created: Date | |
6 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
7 | source_cr | character | x(12) | | | | Source creation | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
10 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
11 | source_lc | character | x(12) | | | | Source last changed | |
12 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdmngix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | euserid | character | x(20) | User ID |
bdmng2ix - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | euserid | character | x(20) | User ID |
3 | version_code | character | x(12) | Version |
Contents > bdmng
bdpath - Budget entry paths1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | type_path | integer | >>>>>9 | | | ? | Type: Path | t_test: type_budget_path |
4 | seqnr_bdpath | integer | >>>>>>>9 | | | ? | Entry path | |
5 | description | character | X(60) | | | | Description | |
6 | order_acc_nr | integer | 9 | | | 0 | General ledger account | |
7 | order_cost_center | integer | 9 | | | 0 | Cost center | |
8 | order_cost_unit | integer | 9 | | | 0 | Cost unit | |
9 | order_year_period | integer | 9 | | | 0 | Year / Period | |
10 | structure_code_acc_nr | character | x(12) | | | | Structure: G/L account | ststruc |
11 | structure_code_cost_center | character | x(12) | | | | Structure: Cost center | ststruc |
12 | structure_code_cost_unit | character | x(12) | | | | Structure: Cost unit | ststruc |
13 | use_sub_classification | logical | yes/no | | | no | Use sub-classification | |
14 | euserid_cr | character | x(20) | | | | Created: User | stuser |
15 | date_cr | date | 99/99/9999 | | | | Created: Date | |
16 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
17 | source_cr | character | x(12) | | | | Source creation | |
18 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
19 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
20 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
21 | source_lc | character | x(12) | | | | Source last changed | |
22 | order_mdim_code_1 | integer | 9 | | | 0 | Dimension 1 | |
23 | order_mdim_code_2 | integer | 9 | | | 0 | Dimension 2 | |
24 | order_mdim_code_3 | integer | 9 | | | 0 | Dimension 3 | |
25 | order_mdim_code_4 | integer | 9 | | | 0 | Dimension 4 | |
26 | order_mdim_code_5 | integer | 9 | | | 0 | Dimension 5 | |
27 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdpath01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | type_path | integer | >>>>>9 | Type: Path |
4 | seqnr_bdpath | integer | >>>>>>>9 | Entry path |
Contents > bdpath
bdtaut - Budget authorization transactions1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdtautt | integer | >>>>>>>9 | | | ? | Budget authorization transaction note | |
4 | linenr_bdtaut | integer | >>>9 | | | ? | Budget authorization transaction | |
5 | date_active | date | 99/99/9999 | | | | Activation date | |
6 | description | character | X(60) | | | | Description | |
7 | structure_code_acc_nr | character | x(12) | | | | Structure: G/L account | ststruc |
8 | level_code_acc_nr | character | x(12) | | | | G/L account: Base level | |
9 | acc_nr | character | x(12) | | | | General ledger account | ledger |
10 | structure_code_cost_center | character | x(12) | | | | Structure: Cost center | ststruc |
11 | level_code_cost_center | character | x(12) | | | | Cost center: Base level | |
12 | cost_center | character | x(12) | | | | Cost center | ccent |
13 | structure_code_cost_unit | character | x(12) | | | | Structure: Cost unit | ststruc |
14 | level_code_cost_unit | character | x(12) | | | | Cost unit: Base level | |
15 | cost_unit | character | x(12) | | | | Cost unit | cunit |
16 | year | integer | 9999 | | | 0 | Year | |
17 | period | integer | >>9 | | | 0 | Period | |
18 | user_id_manager | character | x(20) | | | | Budget manager | bdmng |
19 | quantity | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Quantity | |
20 | amount_debit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit DC | |
21 | amount_credit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit DC | |
22 | type_action | integer | >>>>>9 | | | 0 | Action | |
23 | euserid_cr | character | x(20) | | | | Created: User | stuser |
24 | date_cr | date | 99/99/9999 | | | | Created: Date | |
25 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
26 | source_cr | character | x(12) | | | | Source creation | |
27 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
28 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
29 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
30 | source_lc | character | x(12) | | | | Source last changed | |
31 | mdim_code_1 | character | X(12) | | | | Dimension 1 | |
32 | mdim_code_2 | character | X(12) | | | | Dimension 2 | |
33 | mdim_code_3 | character | X(12) | | | | Dimension 3 | |
34 | mdim_code_4 | character | X(12) | | | | Dimension 4 | |
35 | mdim_code_5 | character | X(12) | | | | Dimension 5 | |
36 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdtaut01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdtautt | integer | >>>>>>>9 | Budget authorization transaction note |
4 | linenr_bdtaut | integer | >>>9 | Budget authorization transaction |
bdtaut02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | structure_code_acc_nr | character | x(12) | Structure: G/L account |
4 | level_code_acc_nr | character | x(12) | G/L account: Base level |
5 | acc_nr | character | x(12) | General ledger account |
6 | structure_code_cost_center | character | x(12) | Structure: Cost center |
7 | level_code_cost_center | character | x(12) | Cost center: Base level |
8 | cost_center | character | x(12) | Cost center |
9 | structure_code_cost_unit | character | x(12) | Structure: Cost unit |
10 | level_code_cost_unit | character | x(12) | Cost unit: Base level |
11 | cost_unit | character | x(12) | Cost unit |
12 | year | integer | 9999 | Year |
13 | period | integer | >>9 | Period |
14 | user_id_manager | character | x(20) | Budget manager |
15 | date_active | date | 99/99/9999 | Activation date |
bdtaut03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | user_id_manager | character | x(20) | Budget manager |
4 | structure_code_acc_nr | character | x(12) | Structure: G/L account |
5 | level_code_acc_nr | character | x(12) | G/L account: Base level |
6 | acc_nr | character | x(12) | General ledger account |
7 | structure_code_cost_center | character | x(12) | Structure: Cost center |
8 | level_code_cost_center | character | x(12) | Cost center: Base level |
9 | cost_center | character | x(12) | Cost center |
10 | structure_code_cost_unit | character | x(12) | Structure: Cost unit |
11 | level_code_cost_unit | character | x(12) | Cost unit: Base level |
12 | cost_unit | character | x(12) | Cost unit |
13 | year | integer | 9999 | Year |
14 | period | integer | >>9 | Period |
15 | date_active | date | 99/99/9999 | Activation date |
Contents > bdtaut
bdtautt - Budget authorization transaction notes1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdtautt | integer | >>>>>>>9 | | | ? | Budget authorization transaction note | |
4 | description | character | X(60) | | | | Description | |
5 | date_active | date | 99/99/9999 | | | | Activation date | |
6 | notes | character | X(2000) | | | | Notes | |
7 | euserid_cr | character | x(20) | | | | Created: User | stuser |
8 | date_cr | date | 99/99/9999 | | | | Created: Date | |
9 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
10 | source_cr | character | x(12) | | | | Source creation | |
11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
13 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
14 | source_lc | character | x(12) | | | | Source last changed | |
15 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdtautt01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdtautt | integer | >>>>>>>9 | Budget authorization transaction note |
Contents > bdtautt
bdtrs - Budget transactions1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdtrst | integer | >>>>>>>9 | | | ? | Budget: Transaction | |
4 | linenr_bdtrs | integer | >>>>>>>9 | | | ? | Line | |
5 | date_active | date | 99/99/9999 | | | | Activation date | |
6 | description | character | X(60) | | | | Description | |
7 | structure_code_acc_nr | character | x(12) | | | | Structure: G/L account | ststruc |
8 | level_code_acc_nr | character | x(12) | | | | G/L account: Base level | |
9 | acc_nr | character | x(12) | | | | General ledger account | ledger |
10 | structure_code_cost_center | character | x(12) | | | | Structure: Cost center | ststruc |
11 | level_code_cost_center | character | x(12) | | | | Cost center: Base level | |
12 | cost_center | character | x(12) | | | | Cost center | ccent |
13 | structure_code_cost_unit | character | x(12) | | | | Structure: Cost unit | ststruc |
14 | level_code_cost_unit | character | x(12) | | | | Cost unit: Base level | |
15 | cost_unit | character | x(12) | | | | Cost unit | cunit |
16 | year | integer | 9999 | | | 0 | Year | |
17 | period | integer | >>9 | | | 0 | Period | |
18 | quantity | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Quantity | |
19 | amount_debit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit DC | |
20 | amount_credit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit DC | |
21 | period_allocation_code | character | x(12) | | | | Allocation: Period | bdalph |
22 | ccent_allocation_code | character | x(12) | | | | Allocation: Cost center | bdalcch |
23 | cunit_allocation_code | character | x(12) | | | | Allocation: Cost unit | bdalcuh |
24 | type_line | integer | >>>>>9 | | | 0 | Type | t_test: type-budtrs-line |
25 | euserid_cr | character | x(20) | | | | Created: User | stuser |
26 | date_cr | date | 99/99/9999 | | | | Created: Date | |
27 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
28 | source_cr | character | x(12) | | | | Source creation | |
29 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
30 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
31 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
32 | source_lc | character | x(12) | | | | Source last changed | |
33 | mdim_code_1 | character | X(12) | | | | Dimension 1 | |
34 | mdim_code_2 | character | X(12) | | | | Dimension 2 | |
35 | mdim_code_3 | character | X(12) | | | | Dimension 3 | |
36 | mdim_code_4 | character | X(12) | | | | Dimension 4 | |
37 | mdim_code_5 | character | X(12) | | | | Dimension 5 | |
38 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdtrs01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdtrst | integer | >>>>>>>9 | Budget: Transaction |
4 | linenr_bdtrs | integer | >>>>>>>9 | Line |
bdtrs02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | date_active | date | 99/99/9999 | Activation date |
bdtrs03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | type_line | integer | >>>>>9 | Type |
bdtrs04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | year | integer | 9999 | Year |
4 | period | integer | >>9 | Period |
5 | date_active | date | 99/99/9999 | Activation date |
Contents > bdtrs
bdtrst - Budget transaction notes1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | bdvers |
3 | seqnr_bdtrst | integer | >>>>>>>9 | | | ? | Budget: Transaction | |
4 | description | character | X(60) | | | | Description | |
5 | date_active | date | 99/99/9999 | | | | Activation date | |
6 | quantity | decimal | ->,>>>,>>>,>>9.99 | 4 | | 0 | Quantity | |
7 | amount_debit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount debit | |
8 | amount_credit_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount credit | |
9 | notes | character | X(2000) | | | | Notes | |
10 | euserid_cr | character | x(20) | | | | Created: User | stuser |
11 | date_cr | date | 99/99/9999 | | | | Created: Date | |
12 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
13 | source_cr | character | x(12) | | | | Source creation | |
14 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
15 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
16 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
17 | source_lc | character | x(12) | | | | Source last changed | |
18 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdtrst01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
3 | seqnr_bdtrst | integer | >>>>>>>9 | Budget: Transaction |
Contents > bdtrst
bdvers - Budget versions1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | version_code | character | x(12) | | | ? | Version | |
3 | description | character | X(60) | | | | Description | |
4 | descr_ml | character | X(60) | | 5 | | ML Description | |
5 | user_id_version_manager | character | x(20) | | | | Version manager | stuser |
6 | year_from | integer | 9999 | | | 0 | From year | |
7 | period_from | integer | >>9 | | | 0 | From period | |
8 | year_thru | integer | 9999 | | | 0 | To year | |
9 | period_thru | integer | >>9 | | | 0 | To period | |
10 | precision | integer | -9 | | | 0 | Precision | |
11 | blocked | logical | yes/no | | | FALSE | Block | |
12 | use_auth | logical | yes/no | | | FALSE | Use authorization | |
13 | XXXsclass_total | integer | >>>>>9 | | | 0 | Sub-classification | |
14 | XXXsclass_period | integer | >>>>>9 | | | 0 | Sub-classification | |
15 | XXXledger_total | integer | >>>>>9 | | | 0 | Account | |
16 | XXXledger_period | integer | >>>>>9 | | | 0 | Account | |
17 | XXXccent_total | integer | >>>>>9 | | | 0 | Cost center | |
18 | XXXccent_period | integer | >>>>>9 | | | 0 | Cost center | |
19 | XXXcunit_total | integer | >>>>>9 | | | 0 | Cost unit | |
20 | XXXcunit_period | integer | >>>>>9 | | | 0 | Cost unit | |
21 | XXXccent_ledger_total | integer | >>>>>9 | | | 0 | Account/Cost center | |
22 | XXXccent_ledger_period | integer | >>>>>9 | | | 0 | Account/Cost center | |
23 | XXXcunit_ledger_total | integer | >>>>>9 | | | 0 | Account/Cost unit | |
24 | XXXcunit_ledger_period | integer | >>>>>9 | | | 0 | Account/Cost unit | |
25 | XXXccent_ledger_cunit_tot | integer | >>>>>9 | | | 0 | Account/Cost center/unit | |
26 | XXXccent_ledger_cunit_per | integer | >>>>>9 | | | 0 | Account/Cost center/unit | |
27 | XXXccent_cunit_total | integer | >>>>>9 | | | 0 | Cost center/unit | |
28 | XXXccent_cunit_period | integer | >>>>>9 | | | 0 | Cost center/unit | |
29 | euserid_cr | character | x(20) | | | | Created: User | stuser |
30 | date_cr | date | 99/99/9999 | | | | Created: Date | |
31 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
32 | source_cr | character | x(12) | | | | Source creation | |
33 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
34 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
35 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
36 | source_lc | character | x(12) | | | | Source last changed | |
37 | budget_state | integer | >>>>>9 | | | 0 | Status | t_test: budget-state |
38 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
39 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
40 | use_history | integer | >>>>>9 | | | 0 | Use history | t_test: budget-use-history |
41 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bdversix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | version_code | character | x(12) | Version |
bdvers03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | budget_state | integer | >>>>>9 | Status |
3 | version_code | character | x(12) | Version |
bdvers2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | user_id_version_manager | character | x(20) | Version manager |
3 | version_code | character | x(12) | Version |
Contents > bdvers
bnkacc - Bank accounts1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_acc_nr | character | x(34) | | | ? | Bank account 2 | |
3 | accncd | character | x(3) | | | | Account type | bnktpe |
4 | bnkaccmsk | character | x(50) | | | | Mask account | |
5 | name | character | X(60) | | | | Bank name | |
6 | address_1 | character | X(60) | | | | Address line 1 | |
7 | address_2 | character | X(60) | | | | Address line 2 | |
8 | address_3 | character | X(60) | | | | Address line 3 | |
9 | postal_code | character | x(8) | | | | Postal code | stpostal |
10 | city | character | X(60) | | | | City | |
11 | country | character | x(3) | | | | Country | countr |
12 | telephone | character | x(15) | | | | Telephone | |
13 | fax_nr | character | x(15) | | | | Fax | |
14 | contact | character | X(60) | | | | Contact | |
15 | sex | integer | >>>>>9 | | | 0 | Sex | t_test: sex |
16 | title_code | character | x(4) | | | | Title | titles |
17 | initials | character | x(10) | | | | Initials | |
18 | func_desc | character | X(60) | | | | Position | |
19 | telephone_contact | character | x(15) | | | | Contact telephone | |
20 | enterprise_id | character | x(34) | | | | SEPA: Creditor ID | |
21 | acc_nr_bank | character | x(34) | | | | Bank account | |
22 | swift_address | character | x(11) | | | | Bank identifier code | stbic |
23 | source_lc | character | x(12) | | | | | |
24 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
25 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
26 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
27 | type_lc | character | x(8) | | | | | |
28 | e_mail | character | X(60) | | | | E-mail | |
29 | curr_code | character | x(3) | | | ? | Currency (Bank) | curren |
30 | house_nr | integer | >>>>>9 | | | 0 | House number | |
31 | house_nr_addition | character | X(8) | | | | House number addition | |
32 | lang_code | character | x(3) | | | | Language | lang |
Indexes
bnkaccix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account 2 |
3 | curr_code | character | x(3) | Currency (Bank) |
bnkacc2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | accncd | character | x(3) | Account type |
3 | bnkaccmsk | character | x(50) | Mask account |
Contents > bnkacc
bnklnk - Bank links1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | code_dc | character | X | | | ? | Type: Debtor/Creditor | |
3 | debcrd | int64 | >>>>>>>>>9 | | | ? | Debtor / Creditor | |
4 | bank_acc_nr | character | x(34) | | | ? | Bank account | bnkacc |
5 | curr_code | character | x(3) | | | ? | Currency | curren |
6 | source_lc | character | x(12) | | | | | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
Indexes
bnklnkix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | code_dc | character | X | Type: Debtor/Creditor |
3 | debcrd | int64 | >>>>>>>>>9 | Debtor / Creditor |
4 | bank_acc_nr | character | x(34) | Bank account |
5 | curr_code | character | x(3) | Currency |
bnklnk02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | curr_code | character | x(3) | Currency |
4 | code_dc | character | X | Type: Debtor/Creditor |
5 | debcrd | int64 | >>>>>>>>>9 | Debtor / Creditor |
Contents > bnklnk
bnktpe - Bank account types1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | accncd | character | x(3) | | | ? | Account type | |
3 | descr | character | X(60) | | | | Description | |
4 | accnmask | character | x(80) | | | | Mask account | |
5 | control_type | integer | >>>>>9 | | | 0 | Type of check | t_test: chk-bnk-type |
6 | nr_tests | integer | 9 | | | 0 | Number of tests | |
7 | x_wtable1 | integer | ->>>>9 | | 34 | 0 | Weighting table 1 | |
8 | addinddig1 | logical | yes/no | | | yes | Add up individual numbers | |
9 | modulus1 | integer | >>>>9 | | | 0 | Weighting table 1: Modulo | |
10 | x_wtable2 | integer | ->>>>9 | | 34 | 0 | Weighting table 2 | |
11 | addinddig2 | logical | yes/no | | | yes | Add up individual numbers | |
12 | modulus2 | integer | >>>>9 | | | 0 | Weighting table 2: Modulo | |
13 | and_or | integer | >>>>>9 | | | 0 | And/or | t_test: chk-and-or |
14 | sort_from | integer | >>>>>9 | | | 0 | From sorting code | |
15 | sort_thru | integer | >>>>>9 | | | 0 | To sorting code | |
16 | descr_ml | character | X(60) | | 5 | | ML description | |
17 | source_lc | character | x(12) | | | | | |
18 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
19 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
20 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
21 | type_lc | character | x(8) | | | | | |
22 | addzero | integer | >>>>>9 | | | 0 | Add zeros | t_test: bnktpe-zero |
23 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
24 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
25 | wtable1_01 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 1 | |
26 | wtable1_02 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 2 | |
27 | wtable1_03 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 3 | |
28 | wtable1_04 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 4 | |
29 | wtable1_05 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 5 | |
30 | wtable1_06 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 6 | |
31 | wtable1_07 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 7 | |
32 | wtable1_08 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 8 | |
33 | wtable1_09 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 9 | |
34 | wtable1_10 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 10 | |
35 | wtable1_11 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 11 | |
36 | wtable1_12 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 12 | |
37 | wtable1_13 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 13 | |
38 | wtable1_14 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 14 | |
39 | wtable1_15 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 15 | |
40 | wtable1_16 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 16 | |
41 | wtable1_17 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 17 | |
42 | wtable1_18 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 18 | |
43 | wtable1_19 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 19 | |
44 | wtable1_20 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 20 | |
45 | wtable1_21 | integer | ->>>>9 | | | 0 | Weighting table 1: Weighting 21 | |
46 | wtable2_01 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 1 | |
47 | wtable2_02 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 2 | |
48 | wtable2_03 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 3 | |
49 | wtable2_04 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 4 | |
50 | wtable2_05 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 5 | |
51 | wtable2_06 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 6 | |
52 | wtable2_07 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 7 | |
53 | wtable2_08 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 8 | |
54 | wtable2_09 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 9 | |
55 | wtable2_10 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 10 | |
56 | wtable2_11 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 11 | |
57 | wtable2_12 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 12 | |
58 | wtable2_13 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 13 | |
59 | wtable2_14 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 14 | |
60 | wtable2_15 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 15 | |
61 | wtable2_16 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 16 | |
62 | wtable2_17 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 17 | |
63 | wtable2_18 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 18 | |
64 | wtable2_19 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 19 | |
65 | wtable2_20 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 20 | |
66 | wtable2_21 | integer | ->>>>9 | | | 0 | Weighting table 2: Weighting 21 | |
67 | is_bic_mandatory | logical | true/false | | | FALSE | Mandatory: BIC | |
68 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
bnktpeix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | accncd | character | x(3) | Account type |
bnktpe02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | accncd | character | x(3) | Account type |
Contents > bnktpe
ccent - Cost centers1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cost_center | character | x(12) | | | ? | Cost center | |
3 | descr | character | X(60) | | | | Description | |
4 | distr_level | integer | ->9 | | | 0 | Allocation level | |
5 | distr_total | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Total allocated | |
6 | distr_tarif | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Standard rate | |
7 | descr_ml | character | X(60) | | 5 | | ML description | |
8 | source_lc | character | x(12) | | | | | |
9 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
12 | type_lc | character | x(8) | | | | | |
13 | block | logical | yes/no | | | no | Block | |
14 | manager | character | X(12) | | | | Manager | |
15 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
16 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
17 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ccentix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_center | character | x(12) | Cost center |
ccent03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | cost_center | character | x(12) | Cost center |
ccent2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | descr | character | X(60) | Description |
3 | cost_center | character | x(12) | Cost center |
Contents > ccent
ccnlnk - linking cost centers1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | cost_center | character | x(12) | | | ? | Cost center | |
3 | acc_nr | character | x(12) | | | | Account | |
4 | acc_nr_contra | character | x(12) | | | | Offset account | |
5 | descr | character | x(25) | | | | Description | |
6 | source_lc | character | x(12) | | | | | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
Indexes
ccnlnkix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_center | character | x(12) | Cost center |
ccnlnk2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | acc_nr | character | x(12) | Account |
3 | cost_center | character | x(12) | Cost center |
ccnlnk3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | acc_nr_contra | character | x(12) | Offset account |
3 | cost_center | character | x(12) | Cost center |
Contents > ccnlnk
ccntrs - Cost center transactions1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | seqnr_ccntrs | int64 | >>>>>>>>>9 | | | | Sequence number | |
3 | fin_yr | integer | 9999 | | | ? | Financial year | |
4 | period | integer | >>9 | | | ? | Period | |
5 | cost_center | character | x(12) | | | | Cost center | ccent |
6 | cost_center_target | character | x(12) | | | | Target cost center | ccent |
7 | date | date | 99/99/9999 | | | | Date | |
8 | acc_nr | character | x(12) | | | | General ledger account | ledger |
9 | acc_nr_contra | character | x(12) | | | | Offset account | ledger |
10 | acc_nr_transfer | character | x(12) | | | | Payment in transit account | ledger |
11 | amount_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
12 | quantity | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | |
13 | units | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Units | |
14 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
15 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
16 | time_lc | integer | >>,>>9 | | | ? | Modified: Time | |
17 | source_lc | character | x(12) | | | | | |
Indexes
ccntrs01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_ccntrs | int64 | >>>>>>>>>9 | Sequence number |
ccntrs02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | cost_center | character | x(12) | Cost center |
5 | cost_center_target | character | x(12) | Target cost center |
6 | date | date | 99/99/9999 | Date |
ccntrs03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | cost_center_target | character | x(12) | Target cost center |
5 | cost_center | character | x(12) | Cost center |
6 | date | date | 99/99/9999 | Date |
ccntrs04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Financial year |
3 | cost_center | character | x(12) | Cost center |
4 | period | integer | >>9 | Period |
5 | cost_center_target | character | x(12) | Target cost center |
6 | date | date | 99/99/9999 | Date |
ccntrs05ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Financial year |
3 | cost_center_target | character | x(12) | Target cost center |
4 | period | integer | >>9 | Period |
5 | cost_center | character | x(12) | Cost center |
6 | date | date | 99/99/9999 | Date |
Contents > ccntrs
colarr - Mandates1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | debtor |
3 | debtor_name | character | X(70) | | | | Mandate: Name | |
4 | mandate_ref | character | X(35) | | | ? | Mandate reference | |
5 | active | logical | yes/no | | | no | Active | |
6 | bgc_descr_1 | character | X(35) | | | | Description 1 | |
7 | bgc_descr_2 | character | X(35) | | | | Description 2 | |
8 | bgc_descr_3 | character | X(35) | | | | BGC Description 3 | |
9 | x_bank_giro | integer | >>>>>9 | | | 0 | Bank/giro | |
10 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
11 | descr | character | X(60) | | | | Description | |
12 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
14 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
15 | type_lc | character | x(8) | | | | | |
16 | source_lc | character | x(12) | | | | | |
17 | sepa_scheme | integer | >>>>>9 | | | 0 | SEPA: Scheme | t_test: sepa_dd_scheme |
18 | collection_code | character | x(12) | | | | Collection installment code | fipcolh |
19 | date_of_signature | date | 99/99/9999 | | | | Date: Signature | |
20 | sequence_type | integer | >>>>>9 | | | 0 | SEPA: Sequence type: Sequence type | t_test: sepa-dd-sequence |
21 | x_use_bank_account_from_oi | logical | TRUE/FALSE | | | FALSE | Use bank account from outstanding item | |
22 | mandate_ref_original | character | X(35) | | | | Mandate reference (Original) | |
23 | bank_acc_nr | character | x(34) | | | | Bank account | bnklnk |
24 | curr_code_bank_acc_nr | character | x(3) | | | | Currency (Bank) | curren |
25 | bank_acc_nr_original | character | X(34) | | | | Bank account (Original) | bnklnk |
26 | bic_original | character | x(11) | | | | Bank identifier code | stbic |
27 | date_cancel | date | 99/99/9999 | | | | Cancellation date | |
28 | entity_state | integer | >>>>>9 | | | 0 | State | |
29 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
30 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
colarr01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | mandate_ref | character | X(35) | Mandate reference |
colarr02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | mandate_ref | character | X(35) | Mandate reference |
colarr03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | active | logical | yes/no | Active |
3 | sepa_scheme | integer | >>>>>9 | SEPA: Scheme |
4 | journal_nr | integer | >>9 | Journal number |
5 | debtor | int64 | >>>>>>>>>9 | Debtor |
6 | mandate_ref | character | X(35) | Mandate reference |
Contents > colarr
combud - Year budgets (Commitments)1 | adm_nr | integer | >>>>>9 | | | | Company | admdat |
2 | fin_yr | integer | 9999 | | | ? | Year | |
3 | acc_nr | character | x(12) | | | ? | General ledger account | ledger |
4 | cost_center | character | x(12) | | | ? | Cost center | ccent |
5 | cost_unit | character | x(12) | | | ? | Cost unit | cunit |
6 | bud_amt_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Debit | |
7 | bud_amt_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget: Credit | |
8 | Com_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Outstanding commitments | |
9 | bal_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Debit balance | |
10 | bal_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Credit balance | |
11 | euserid_cr | character | x(20) | | | | Created: User | stuser |
12 | date_cr | date | 99/99/9999 | | | | Created: Date | |
13 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
14 | source_cr | character | X(40) | | | | Source creation | |
15 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
16 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
17 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
18 | source_lc | character | X(40) | | | | Source last changed | |
Indexes
combudix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | acc_nr | character | x(12) | General ledger account |
4 | cost_center | character | x(12) | Cost center |
5 | cost_unit | character | x(12) | Cost unit |
Contents > combud
comcls - Classifications1 | adm_nr | integer | >>>>>9 | | | | Company | admdat |
2 | class | character | X(2) | | | ? | Classification | |
3 | descr | character | X(60) | | | | Description | |
4 | euserid_cr | character | x(20) | | | | Created: User | stuser |
5 | date_cr | date | 99/99/9999 | | | | Created: Date | |
6 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
7 | source_cr | character | X(40) | | | | Source creation | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
10 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
11 | source_lc | character | X(40) | | | | Source last changed | |
12 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
13 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
14 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
comclsix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | class | character | X(2) | Classification |
comcls02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | class | character | X(2) | Classification |
Contents > comcls
comctr - Contracts1 | adm_nr | integer | >>>>>9 | | | | Company | admdat |
2 | cntr_nr | character | x(12) | | | ? | Contract number | |
3 | descr | character | X(60) | | | | Description | |
4 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | credit |
5 | cntr_date | date | 99/99/9999 | | | | Contract date | |
6 | start_date | date | 99/99/9999 | | | | Start date | |
7 | end_date | date | 99/99/9999 | | | | End date | |
8 | curr_code | character | X(3) | | | | Currency | curren |
9 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
10 | amt_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
11 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC | |
12 | euserid_cr | character | x(20) | | | | Created: User | stuser |
13 | date_cr | date | 99/99/9999 | | | | Created: Date | |
14 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
15 | source_cr | character | X(40) | | | | Source creation | |
16 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
17 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
18 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
19 | source_lc | character | X(40) | | | | Source last changed | |
20 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
21 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
22 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
comctrix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | cntr_nr | character | x(12) | Contract number |
comctr03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
4 | cntr_nr | character | x(12) | Contract number |
comctr2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | cntr_nr | character | x(12) | Contract number |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
Contents > comctr
comctr_t - Contract notes1 | adm_nr | integer | >>>>>9 | | | | Company | |
2 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | |
3 | cntr_nr | character | x(12) | | | ? | Contract Nr | |
4 | note | character | X(2000) | | | | Note | |
5 | link | character | X(255) | | | | Link | |
6 | euserid_cr | character | x(20) | | | | Created: User | stuser |
7 | date_cr | date | 99/99/9999 | | | | Created: Date | |
8 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
9 | source_cr | character | X(40) | | | | Source creation | |
10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
13 | source_lc | character | X(40) | | | | Source last changed | |
14 | seqnr_notes | integer | >9 | | | ? | Sequence number | |
Indexes
comctr_t01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | cntr_nr | character | x(12) | Contract Nr |
4 | seqnr_notes | integer | >9 | Sequence number |
Contents > comctr_t
comel - Commitment entries1 | adm_nr | integer | >>>>>9 | | | | Company | admdat |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | | | ? | Commitment | comhl |
3 | linenr_comsl | integer | >>>9 | | | ? | Commitment line | |
4 | descr | character | X(60) | | | | Description | |
5 | date | date | 99/99/9999 | | | | Date | |
6 | curr_code | character | X(3) | | | | Extra currency code | curren |
7 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate 2 | |
8 | amt_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
9 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
10 | qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | |
11 | state | integer | >>>>>>>9 | | | 0 | Commitment status | |
12 | euserid_cr | character | x(20) | | | | Created: User | stuser |
13 | date_cr | date | 99/99/9999 | | | | Created: Date | |
14 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
15 | source_cr | character | X(40) | | | | Source creation | |
16 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
17 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
18 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
19 | source_lc | character | X(40) | | | | Source last changed | |
20 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
comelix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
3 | linenr_comsl | integer | >>>9 | Commitment line |
Contents > comel
comhl - Commitments1 | adm_nr | integer | >>>>>9 | | | | Company | admdat |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | | | ? | Commitment | |
3 | search_code | character | x(12) | | | | Search code | |
4 | descr | character | X(60) | | | | Description | |
5 | class | character | X(2) | | | | Classification | comcls |
6 | block | logical | yes/no | | | no | Block | |
7 | euserid_cr | character | x(20) | | | | Created: User | stuser |
8 | date_cr | date | 99/99/9999 | | | | Created: Date | |
9 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
10 | source_cr | character | X(40) | | | | Source creation | |
11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
13 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
14 | source_lc | character | X(40) | | | | Source last changed | |
15 | state | integer | >>>>>>>9 | | | 0 | Status (Commitment) | t_test: commitment-state |
16 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
comhlix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
comhl2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | search_code | character | x(12) | Search code |
3 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
Contents > comhl
comp - Sub-classifications1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | comp_code | character | x(12) | | | ? | Sub-classification | |
3 | descr | character | X(60) | | | | Description | |
4 | main_comp_code | character | x(12) | | | | Main classification | mcomp |
5 | descr_ml | character | X(60) | | 5 | | ML description | |
6 | source_lc | character | x(12) | | | | | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
11 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
12 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
compix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | comp_code | character | x(12) | Sub-classification |
comp03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | comp_code | character | x(12) | Sub-classification |
comp2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | main_comp_code | character | x(12) | Main classification |
3 | comp_code | character | x(12) | Sub-classification |
Contents > comp
comsl - Commitment lines1 | adm_nr | integer | >>>>>9 | | | | Company | admdat |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | | | ? | Commitment | comhl |
3 | linenr_comsl | integer | >>>9 | | | ? | Commitment line | |
4 | linenr_comsl_user | integer | >>>9 | | | 0 | Line number (User) | |
5 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | credit |
6 | cntr_nr | character | x(12) | | | | Contract number | comctr |
7 | request_date | date | 99/99/9999 | | | | Request date | |
8 | start_date | date | 99/99/9999 | | | | Start date | |
9 | end_date | date | 99/99/9999 | | | | End date | |
10 | descr | character | X(60) | | | | Description: Commitment line | |
11 | fin_yr | integer | 9999 | | | 0 | Year | |
12 | acc_nr | character | x(12) | | | | General ledger account | ledger |
13 | cost_center | character | x(12) | | | | Cost center | ccent |
14 | cost_unit | character | x(12) | | | | Cost unit | cunit |
15 | qty_comm_entry | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Commitment: Quantity entered | |
16 | mcode1 | character | x(12) | | | | Dimension 1 | mdim1 |
17 | mcode2 | character | x(12) | | | | Dimension 2 | mdim2 |
18 | mcode3 | character | x(12) | | | | Dimension 3 | mdim3 |
19 | mcode4 | character | x(12) | | | | Dimension 4 | mdim4 |
20 | mcode5 | character | x(12) | | | | Dimension 5 | mdim5 |
21 | project_code | character | x(20) | | | | Project | prmst |
22 | pro_cost_cat | character | x(12) | | | | Project cost category | prccat |
23 | pro_cost_center | character | x(12) | | | | Project cost center | ccent |
24 | pro_qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Project quantity | |
25 | tot_amt_comm_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Commitment: Amount entered | |
26 | tot_amt_comm_post | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Commitment: Amount posted | |
27 | tot_amt_costs_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Costs: Amount entered | |
28 | tot_amt_costs_post | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Costs: Amount posted | |
29 | tot_amt_corr_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Correction: Amount entered | |
30 | tot_amt_corr_post | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Correction: Amount posted | |
31 | block | logical | yes/no | | | no | Block | |
32 | euserid_cr | character | x(20) | | | | Created: User | stuser |
33 | date_cr | date | 99/99/9999 | | | | Created: Date | |
34 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
35 | source_cr | character | X(40) | | | | Source creation | |
36 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
37 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
38 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
39 | source_lc | character | X(40) | | | | Source last changed | |
40 | qty_comm_post | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Commitment: Quantity posted | |
41 | qty_costs_entry | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Costs: Quantity entered | |
42 | qty_costs_post | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Costs: Quantity posted | |
43 | qty_corr_entry | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Correction: Quantity entered | |
44 | qty_corr_post | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Correction: Quantity posted | |
45 | period | integer | >>9 | | | 0 | Period | |
46 | amount_dc_purchase_costs | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 2 | | 0 | Purchase amount costs | |
47 | amount_dc_purchase_corr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 2 | | 0 | Purchase amount correction | |
48 | quantity_purchase_costs | decimal | ->>>>>>>>>9.99 | 2 | | 0 | Purchase quantity costs | |
49 | quantity_purchase_corr | decimal | ->>>>>>>>>9.99 | 2 | | 0 | Purchase quantity correction | |
50 | line_discount | logical | true/false | | | false | Include: Line discount | |
51 | price_differences | logical | true/false | | | false | Include: Price differences | |
52 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
comsl01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
3 | linenr_comsl | integer | >>>9 | Commitment line |
comsl02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | period | integer | >>9 | Period |
4 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
5 | linenr_comsl | integer | >>>9 | Commitment line |
comsl03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | fin_yr | integer | 9999 | Year |
4 | period | integer | >>9 | Period |
5 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
comsl04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | project_code | character | x(20) | Project |
3 | pro_cost_cat | character | x(12) | Project cost category |
4 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
5 | linenr_comsl | integer | >>>9 | Commitment line |
comsl05ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
3 | linenr_comsl_user | integer | >>>9 | Line number (User) |
comsl06ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | acc_nr | character | x(12) | General ledger account |
4 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
5 | linenr_comsl | integer | >>>9 | Commitment line |
Contents > comsl
comsl_t - Commitment notes1 | adm_nr | integer | >>>>>9 | | | | Company | |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | | | ? | Commitment number | |
3 | linenr_comsl | integer | >>>9 | | | ? | Commitment line | |
4 | note | character | X(2000) | | | | Note | |
5 | link | character | X(255) | | | | Link | |
6 | euserid_cr | character | x(20) | | | | Created: User | stuser |
7 | date_cr | date | 99/99/9999 | | | | Created: Date | |
8 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
9 | source_cr | character | X(40) | | | | Source creation | |
10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
13 | source_lc | character | X(40) | | | | Source last changed | |
Indexes
comsl_tix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment number |
3 | linenr_comsl | integer | >>>9 | Commitment line |
Contents > comsl_t
comtrs - Commitment transactions1 | adm_nr | integer | >>>>>9 | | | | Company | admdat |
2 | seqnr_comtrs | integer | >>>>>>>9 | | | ? | Sequence number | |
3 | commitment_nr | int64 | >>>>>>>>>>>9 | | | 0 | Commitment | comhl |
4 | linenr_comsl | integer | >>>>>>>9 | | | 0 | Commitment line | |
5 | type | integer | >>>>>9 | | | 1 | Type | t_test: commitment |
6 | date | date | 99/99/9999 | | | | Entry date | |
7 | descr | character | X(60) | | | | Description | |
8 | curr_code | character | X(3) | | | | Currency | curren |
9 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
10 | amount_fc_costs | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
11 | amount_dc_costs | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
12 | quantity_costs | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | |
13 | posting_nr | integer | >>>>>>>>>9 | | | 0 | Posting number | |
14 | entry_nr_type | integer | >>>>>9 | | | 1 | Entry type | t_test: entry-nr-type |
15 | entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | |
16 | period | integer | >>9 | | | 0 | Period | |
17 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
18 | XXXseq_nr_ledger | decimal | >>>>>>>>>9 | 0 | | 0 | Sequence number | |
19 | euserid_cr | character | x(20) | | | | Created: User | stuser |
20 | date_cr | date | 99/99/9999 | | | | Created: Date | |
21 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
22 | source_cr | character | X(40) | | | | Source creation | |
23 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
24 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
25 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
26 | source_lc | character | X(40) | | | | Source last changed | |
27 | amount_dc_correction | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 2 | | 0 | Amount correction DC | |
28 | amount_fc_correction | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 2 | | 0 | Amount correction FC | |
29 | quantity_correction | decimal | ->>>>>>>>>9.99 | 2 | | 0 | Quantity correction | |
30 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
comtrsix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_comtrs | integer | >>>>>>>9 | Sequence number |
comtrs2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
3 | linenr_comsl | integer | >>>>>>>9 | Commitment line |
4 | seqnr_comtrs | integer | >>>>>>>9 | Sequence number |
comtrs3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | type | integer | >>>>>9 | Type |
3 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
4 | linenr_comsl | integer | >>>>>>>9 | Commitment line |
5 | seqnr_comtrs | integer | >>>>>>>9 | Sequence number |
comtrs4ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | posting_nr | integer | >>>>>>>>>9 | Posting number |
3 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment |
4 | linenr_comsl | integer | >>>>>>>9 | Commitment line |
5 | seqnr_comtrs | integer | >>>>>>>9 | Sequence number |
Contents > comtrs
conscc - Consolidation cost centers1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cost_unit | character | x(12) | | | ? | Cost unit | |
3 | cost_center | character | x(12) | | | ? | Consolidated cost center | ccent |
4 | cost_center_consol | character | x(12) | | | ? | Consolidation cost center | ccent |
5 | descr | character | x(25) | | | | Description | |
6 | source_lc | character | x(12) | | | | | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
11 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
12 | adm_nr_consol | integer | >>>>>9 | | | ? | Consolidated company | consco |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
conscc01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit | character | x(12) | Cost unit |
3 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
4 | cost_center | character | x(12) | Consolidated cost center |
5 | cost_center_consol | character | x(12) | Consolidation cost center |
conscc02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_center_consol | character | x(12) | Consolidation cost center |
3 | cost_unit | character | x(12) | Cost unit |
4 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
5 | cost_center | character | x(12) | Consolidated cost center |
conscc03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit | character | x(12) | Cost unit |
3 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
4 | cost_center_consol | character | x(12) | Consolidation cost center |
5 | cost_center | character | x(12) | Consolidated cost center |
Contents > conscc
consco - Consolidation companies1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | adm_nr_consol | integer | >>>>>9 | | | ? | Consolidated company | |
3 | curr_code | character | x(3) | | | | Currency | |
4 | perc | decimal | ->>9.99 | 2 | | 0 | Percentage | |
5 | source_lc | character | x(12) | | | | | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | x(8) | | | | | |
Indexes
conscoix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
consco2ix
1 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
2 | adm_nr | integer | >>>>>9 | Company |
Contents > consco
conscu - Consolidation cost unit1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | adm_nr_consol | integer | >>>>>9 | | | ? | Company | |
3 | cost_unit | character | x(12) | | | ? | Cost unit | |
4 | cost_unit_consol | character | x(12) | | | ? | Cost unit | |
5 | descr | character | x(25) | | | | Description | |
6 | source_lc | character | x(12) | | | | | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
Indexes
conscuix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | adm_nr_consol | integer | >>>>>9 | Company |
3 | cost_unit | character | x(12) | Cost unit |
4 | cost_unit_consol | character | x(12) | Cost unit |
conscu2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit_consol | character | x(12) | Cost unit |
3 | adm_nr_consol | integer | >>>>>9 | Company |
4 | cost_unit | character | x(12) | Cost unit |
conscu3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | adm_nr_consol | integer | >>>>>9 | Company |
3 | cost_unit_consol | character | x(12) | Cost unit |
4 | cost_unit | character | x(12) | Cost unit |
Contents > conscu
consgg - Consolidation data1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | fin_yr | integer | 9999 | | | ? | Financial year | |
3 | cost_unit | character | x(12) | | | ? | Cost unit | |
4 | acc_nr | character | x(12) | | | ? | Account | |
5 | period | integer | >>9 | | | ? | Period | |
6 | cost_center | character | x(12) | | | ? | Cost center | |
7 | deb_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Debit balance | |
8 | cred_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Credit balance | |
9 | bud_amt_deb | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount debit | |
10 | bud_amt_cred | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Budget amount credit | |
11 | orig | integer | >>>>>9 | | | ? | Origin | |
12 | source_lc | character | x(12) | | | | | |
13 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
16 | type_lc | character | x(8) | | | | | |
17 | adm_nr_consol | integer | >>>>>9 | | | ? | Company | |
18 | version_code_from | character | x(12) | | | ? | Version | |
19 | version_code_to | character | x(12) | | | | Version | |
Indexes
consgg01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Financial year |
3 | cost_unit | character | x(12) | Cost unit |
4 | adm_nr_consol | integer | >>>>>9 | Company |
5 | period | integer | >>9 | Period |
6 | acc_nr | character | x(12) | Account |
7 | cost_center | character | x(12) | Cost center |
8 | orig | integer | >>>>>9 | Origin |
9 | version_code_from | character | x(12) | Version |
Contents > consgg
contab - Consolidation G/L accounts1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cost_unit | character | x(12) | | | ? | Cost unit | |
3 | acc_nr | character | x(12) | | | ? | Consolidated g/l account | ledger |
4 | acc_nr_consol | character | x(12) | | | ? | Consolidation account | ledger |
5 | descr | character | x(25) | | | | Description | |
6 | source_lc | character | x(12) | | | | | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
11 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
12 | adm_nr_consol | integer | >>>>>9 | | | ? | Consolidated company | consco |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
contab01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit | character | x(12) | Cost unit |
3 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
4 | acc_nr | character | x(12) | Consolidated g/l account |
5 | acc_nr_consol | character | x(12) | Consolidation account |
contab02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | acc_nr_consol | character | x(12) | Consolidation account |
3 | cost_unit | character | x(12) | Cost unit |
4 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
5 | acc_nr | character | x(12) | Consolidated g/l account |
contab03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit | character | x(12) | Cost unit |
3 | adm_nr_consol | integer | >>>>>9 | Consolidated company |
4 | acc_nr_consol | character | x(12) | Consolidation account |
5 | acc_nr | character | x(12) | Consolidated g/l account |
Contents > contab
countr - Countries1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | country | character | x(3) | | | ? | Country | |
3 | descr | character | X(60) | | | | Description | |
4 | curr_code | character | x(3) | | | | Currency | curren |
5 | vat_rep_nr | character | x(2) | | | | VAT fiscal representative | vatrep |
6 | country_iso | character | x(2) | | | | ISO country | isocnt |
7 | descr_ml | character | X(60) | | 5 | | ML description | |
8 | source_lc | character | x(12) | | | | | |
9 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
12 | type_lc | character | x(8) | | | | | |
13 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
14 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
15 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
countrix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | country | character | x(3) | Country |
countr04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | country | character | x(3) | Country |
countr2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | country_iso | character | x(2) | ISO country |
countr3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | country_iso | character | x(2) | ISO country |
3 | country | character | x(3) | Country |
Contents > countr
crdbal - Creditor balances1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | credit |
3 | fin_yr | integer | 9999 | | | ? | Year | |
4 | period | integer | >>9 | | | ? | Period | |
5 | open_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Opening balance (DC) | |
6 | revenue_excl | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Purchases (Excluding VAT) | |
7 | revenue_incl | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Purchases (Including VAT) | |
8 | amt_total | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Paid (DC) | |
9 | conversie | logical | yes/no | | | no | Originating from conversion | |
10 | source_lc | character | x(12) | | | | | |
11 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | type_lc | character | x(8) | | | | | |
15 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
crdbalix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | fin_yr | integer | 9999 | Year |
4 | period | integer | >>9 | Period |
Contents > crdbal
crdcat - Creditor categories1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cat | character | x(12) | | | ? | Category | |
3 | descr | character | X(60) | | | | Description | |
4 | source_lc | character | x(12) | | | | | |
5 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
6 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | type_lc | character | x(8) | | | | | |
9 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
10 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
11 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
crdcatix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cat | character | x(12) | Category |
crdcat02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | cat | character | x(12) | Category |
Contents > crdcat
crdnac - Order addresses1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | credit |
3 | addr_code | character | x(12) | | | ? | Address | stnactype |
4 | name | character | X(100) | | | | Name | |
5 | address_1 | character | X(60) | | | | Address line 1 | |
6 | address_2 | character | X(60) | | | | Address line 2 | |
7 | address_3 | character | X(60) | | | | Address line 3 | |
8 | postal_code | character | x(8) | | | | Postal code | stpostal |
9 | city | character | X(60) | | | | City | |
10 | country | character | x(3) | | | | Country | countr |
11 | telephone | character | x(15) | | | | Telephone | |
12 | fax_nr | character | x(15) | | | | Fax | |
13 | title_code | character | x(4) | | | | Title | titles |
14 | initials | character | x(10) | | | | Initials | |
15 | contact | character | X(60) | | | | Contact | |
16 | func_desc | character | X(60) | | | | Position | |
17 | sex | integer | >>>>>9 | | | 0 | Sex | t_test: sex |
18 | lang_code | character | x(3) | | | | Language | lang |
19 | route_code | character | x(2) | | | | Route | |
20 | instr | character | x(80) | | | | Instruction | |
21 | source_lc | character | x(12) | | | | | |
22 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
23 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
24 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
25 | type_lc | character | x(8) | | | | | |
26 | e_mail | character | x(256) | | | | E-mail | |
27 | euserid_cr | character | x(20) | | | | Created: User | stuser |
28 | date_cr | date | 99/99/9999 | | | | Created: Date | |
29 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
30 | source_cr | character | x(12) | | | | Source creation | |
31 | entity_state | integer | >>>>>9 | | | 0 | State | |
32 | address_type_code | character | x(12) | | | | Address type code | stnactype |
33 | house_nr | integer | >>>>>9 | | | 0 | House number | |
34 | house_nr_addition | character | X(8) | | | | House number addition | |
35 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
crdnacix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | addr_code | character | x(12) | Address |
crdnac02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
4 | addr_code | character | x(12) | Address |
crdnac03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | address_type_code | character | x(12) | Address type code |
4 | addr_code | character | x(12) | Address |
crdnac04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | postal_code | character | x(8) | Postal code |
3 | address_1 | character | X(60) | Address line 1 |
Contents > crdnac
crdout - Accounts payable1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | credit |
3 | entry_nr_type | integer | >>>>>9 | | | ? | Type: Entry number | t_test: entry-nr-type |
4 | entry_nr | int64 | >>>>>>>>>>>9 | | | ? | Entry number | |
5 | date | date | 99/99/9999 | | | | Date | |
6 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
7 | descr | character | X(60) | | | | Description | |
8 | amt_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC (after entry) | |
9 | amt_after_posting | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC (after posting) | |
10 | curr_code | character | x(3) | | | | Currency | curren |
11 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
12 | amt_curr_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (after entry) (DB) | |
13 | amt_curr_after_posting | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (after posting) | |
14 | amt_original | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (original) | |
15 | amt_acc_nr_blocked | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Blocked bank account: Amount | |
16 | due_date_surch_1 | date | 99/99/9999 | | | | Surcharge: Due date 1 | |
17 | due_date_surch_2 | date | 99/99/9999 | | | | Surcharge: Due date 2 | |
18 | due_date_invoice | date | 99/99/9999 | | | | Invoice: Due date | |
19 | surch_disc | integer | >>>>>9 | | | 0 | Payment charge/discount | t_test: surch-disc |
20 | amt_credit_surch_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 1 | |
21 | amt_credit_surch_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 2 | |
22 | block | logical | yes/no | | | no | Block | |
23 | last_entry_date | date | 99/99/9999 | | | | Last entry date | |
24 | pay_ref | character | X(32) | | | | Payment reference | |
25 | pay_ref_2 | character | x(20) | | | | Payment reference-2 | |
26 | pay_method | integer | >>>>>9 | | | 0 | Payment method | t_test: pay-method |
27 | week_nr | integer | >9 | | | 0 | Due week | |
28 | fin_yr | integer | 9999 | | | 0 | Year | |
29 | prepayment | logical | yes/no | | | no | Prepayment | |
30 | acc_nr_sub_adm | character | x(12) | | | | G/L account | ledger |
31 | deliv_ext_bureau | integer | >>>>>9 | | | 0 | Supplied to external bureau | |
32 | date_deliv | date | 99/99/9999 | | | | Delivery date | |
33 | pay_condition | character | X(4) | | | | Payment condition | paycon |
34 | source_lc | character | x(12) | | | | | |
35 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
36 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
37 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
38 | type_lc | character | x(8) | | | | | |
39 | struct_m | logical | yes/no | | | no | Structured announcement | |
40 | amt_credit_surch_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 3 | |
41 | amt_credit_surch_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 4 | |
42 | amt_credit_surch_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 5 | |
43 | due_date_surch_3 | date | 99/99/9999 | | | | Surcharge: Due date 3 | |
44 | due_date_surch_4 | date | 99/99/9999 | | | | Surcharge: Due date 4 | |
45 | due_date_surch_5 | date | 99/99/9999 | | | | Surcharge: Due date 5 | |
46 | ext_entry_nr | character | X(30) | | | | Invoice number (Creditor) | |
47 | bank_acc_nr | character | x(34) | | | | Bank account | |
48 | curr_code_bank_acc_nr | character | x(3) | | | | Currency (Bank) | |
49 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
crdoutix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
4 | entry_nr_type | integer | >>>>>9 | Type: Entry number |
crdout2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
3 | entry_nr_type | integer | >>>>>9 | Type: Entry number |
4 | creditor | int64 | >>>>>>>>>9 | Creditor |
crdout3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | curr_code | character | x(3) | Currency |
4 | amt_curr_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount FC (after entry) (DB) |
crdout4ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | amt_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount DC (after entry) |
crdout5ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | curr_code | character | x(3) | Currency |
3 | amt_curr_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount FC (after entry) (DB) |
crdout6ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | amt_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount DC (after entry) |
crdout7ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | ext_entry_nr | character | X(30) | Invoice number (Creditor) |
Contents > crdout
crdrev - Creditor revaluations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | credit |
3 | entry_nr_type | integer | >>>>>9 | | | ? | Entry type | t_test: entry-nr-type |
4 | entry_nr | int64 | >>>>>>>>>>>9 | | | ? | Entry number | |
5 | curr_code | character | x(3) | | | ? | Currency | curren |
6 | amt_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
7 | hist_exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Historical exchange rate | |
8 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
9 | amt_act | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC: Current | |
10 | amt_revalue | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC: Revaluation | |
11 | revalue_exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate: Revaluation | |
12 | revalue | logical | yes/no | | | no | Revalue | |
13 | cost_center | character | x(12) | | | | Cost center | ccent |
14 | acc_nr_revalue | character | x(12) | | | | Unfavorable revaluations | ledger |
15 | acc_nr_revalue_revenue | character | x(12) | | | | Favorable revaluations | ledger |
16 | source_lc | character | x(12) | | | | | |
17 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
18 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
19 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
20 | type_lc | character | x(8) | | | | | |
Indexes
crdrevix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | entry_nr_type | integer | >>>>>9 | Entry type |
4 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
5 | curr_code | character | x(3) | Currency |
Contents > crdrev
crdtrs - Creditor: Transactions1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | seqnr_crdtrs | int64 | >>>>>>>>>9 | | | ? | Creditor transaction: Sequence number | |
3 | fin_yr | integer | 9999 | | | 0 | Year | |
4 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | credit |
5 | date | date | 99/99/9999 | | | | Date | |
6 | period | integer | >>9 | | | 0 | Period | |
7 | entry_nr_type | integer | >>>>>9 | | | 1 | Entry type | t_test: entry-nr-type |
8 | entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Outstanding item: Invoice number | |
9 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
10 | descr | character | X(60) | | | | Description | |
11 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
12 | curr_code | character | x(3) | | | | Currency | curren |
13 | curr_code_extra | character | x(3) | | | | Extra currency code | curren |
14 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
15 | exch_rate_2 | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate 2 | |
16 | exch_rate3 | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate 3 | |
17 | amt_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
18 | entry_nr_fin | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | |
19 | posting_nr_journal | integer | ->>>>>>>>>9 | | | 0 | Posting number journal | |
20 | posting_nr | int64 | >>>>>>>>>9 | | | 0 | Posting number | |
21 | check_number | integer | ->>>>>>>>>9 | | | 0 | Check number | |
22 | closing_transac | logical | yes/no | | | no | Transaction after closing | |
23 | revalue_transact | logical | yes/no | | | no | Revalue | |
24 | match_inv | int64 | >>>>>>>>>>>9 | | | 0 | Matched: Invoice | |
25 | match_trs | logical | yes/no | | | no | Matching transaction | |
26 | rev_entry | logical | yes/no | | | no | Reversal entry | |
27 | seqnr_ledtrs | int64 | >>>>>>>>>9 | | | 0 | G/L transaction: Sequence number | |
28 | pay_condition | character | X(4) | | | | Payment condition | paycon |
29 | mcode1 | character | x(12) | | | | Dimension 1 | mdim1 |
30 | mcode2 | character | x(12) | | | | Dimension 2 | mdim2 |
31 | mcode3 | character | x(12) | | | | Dimension 3 | mdim3 |
32 | mcode4 | character | x(12) | | | | Dimension 4 | mdim4 |
33 | mcode5 | character | x(12) | | | | Dimension 5 | mdim5 |
34 | match_inv_type | integer | >>>>>9 | | | 1 | Invoice type | |
35 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
36 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
37 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
38 | type_lc | character | x(8) | | | | | |
39 | source_lc | character | x(12) | | | | | |
40 | ext_entry_nr | character | X(30) | | | | Invoice number (Creditor) | |
41 | seqnr_atrsh | integer | >>>>>>9 | | | 0 | Sequence number | |
42 | linenr_atrss | integer | >>>>>9 | | | 0 | Line number | |
43 | bank_acc_nr | character | x(34) | | | | Bank account | bnklnk |
44 | curr_code_bank_acc_nr | character | x(3) | | | | Currency (Bank) | curren |
45 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
crdtrs01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_crdtrs | int64 | >>>>>>>>>9 | Creditor transaction: Sequence number |
crdtrs02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
4 | date | date | 99/99/9999 | Date |
crdtrs03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
4 | entry_nr_type | integer | >>>>>9 | Entry type |
5 | entry_nr | int64 | >>>>>>>>>>>9 | Outstanding item: Invoice number |
6 | period | integer | >>9 | Period |
crdtrs04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
4 | period | integer | >>9 | Period |
5 | date | date | 99/99/9999 | Date |
crdtrs05ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | posting_nr | int64 | >>>>>>>>>9 | Posting number |
3 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
4 | linenr_atrss | integer | >>>>>9 | Line number |
crdtrs06ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | ext_entry_nr | character | X(30) | Invoice number (Creditor) |
crdtrs07ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | entry_nr | int64 | >>>>>>>>>>>9 | Outstanding item: Invoice number |
4 | entry_nr_type | integer | >>>>>9 | Entry type |
Contents > crdtrs
credit - Creditors1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | |
3 | name | character | X(100) | | | | Name | |
4 | address_1 | character | X(60) | | | | Address line 1 | |
5 | address_2 | character | X(60) | | | | Address line 2 | |
6 | address_3 | character | X(60) | | | | Address line 3 | |
7 | postal_code | character | x(8) | | | | Postal code | stpostal |
8 | city | character | X(60) | | | | City | |
9 | country | character | x(3) | | | | Country | countr |
10 | search_code | character | x(20) | | | | Search code | |
11 | curr_code | character | x(3) | | | | Currency | curren |
12 | telephone | character | x(15) | | | | Telephone | |
13 | fax_nr | character | x(15) | | | | Fax | |
14 | contact | character | X(60) | | | | Contact | |
15 | sex | integer | >>>>>9 | | | 0 | Sex | t_test: sex |
16 | title_code | character | x(4) | | | | Title | titles |
17 | initials | character | x(10) | | | | Initials | |
18 | func_desc | character | X(60) | | | | Position | |
19 | telephone_contact | character | x(15) | | | | Contact: Telephone | |
20 | bank_acc_nr_1 | character | x(34) | | | | Bank account | |
21 | bank_acc_nr_2 | character | x(34) | | | | Bank account (Blocked) | |
22 | postbank_acc_nr | character | x(34) | | | | Postbank | |
23 | pay_method | integer | >>>>>9 | | | 0 | Payment method | t_test: pay-method |
24 | acc_nr_contra | character | x(12) | | | | Offset account | ledger |
25 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
26 | attention | logical | yes/no | | | no | Attention field | |
27 | cat | character | x(12) | | | | Category | crdcat |
28 | surch | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Credit line | |
29 | auto_payment | logical | yes/no | | | yes | Automatic payment | |
30 | pay_condition | character | X(4) | | | | Payment condition | paycon |
31 | block | logical | yes/no | | | no | Block | |
32 | cust_nr | character | x(10) | | | | Customer | |
33 | pricelist_code | character | x(3) | | | | Price list | llplst |
34 | extra_item_code | character | x(2) | | | | Extra item | |
35 | disc_perc | decimal | ->>9.99 | 2 | | 0 | Discount percentage | |
36 | layoutcode | character | x(1) | | | | Layout | |
37 | lang_code | character | x(3) | | | | Language | lang |
38 | page_nr | integer | ->9 | | | 0 | Page number after compression | |
39 | open_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Outstanding balance | |
40 | amt_in_purch_order | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Total amount of purchase orders | |
41 | country_iso | character | x(2) | | | | ISO country | |
42 | vat_nr | character | x(20) | | | | VAT number | |
43 | check_date | date | 99/99/9999 | | | | Check date | |
44 | cat_belgium | logical | yes/no | | | yes | Liable to pay VAT | |
45 | stat_factor | character | x(3) | | | | Statistical factor | |
46 | vat_code | character | x(3) | | | 0 | VAT code | vattrs |
47 | change_vat | logical | yes/no | | | yes | VAT code adjustable | |
48 | stat_system | character | x(10) | | | | Statistical system | |
49 | change_system | logical | yes/no | | | yes | System adjustable | |
50 | cost_code | character | x(12) | | | | Cost code | llcoc |
51 | grouped_invoice | logical | yes/no | | | yes | Grouped invoice | |
52 | buyer_code | character | x(20) | | | | Buyer | stuser |
53 | change_trans_b | logical | yes/no | | | yes | Transaction B adjustable | |
54 | country_from | character | x(3) | | | | Country of origin | |
55 | change_from | logical | yes/no | | | yes | Country of origin adjustable | |
56 | country_origin | character | x(3) | | | | Country of assembly | |
57 | change_origin | logical | yes/no | | | yes | Country of assembly adjustable | |
58 | transport_code | character | x(10) | | | | Method of transportation | |
59 | change_transport | logical | yes/no | | | yes | Method of transportation adjustable | |
60 | city_of_ul | character | x(10) | | | | City of loading/unloading | |
61 | change_ul | logical | yes/no | | | yes | (Un)loading adjustable | |
62 | order_method | character | x(12) | | | | Delivery / Order method | lldome |
63 | change_deliv_method | logical | yes/no | | | yes | Terms of delivery adjustable | |
64 | trsshpm_code | character | x(10) | | | | Transshipment | |
65 | change_tshpm | logical | yes/no | | | yes | Transshipment adjustable | |
66 | country_abc | character | x(3) | | | | Country ABC transaction | |
67 | change_abc | logical | yes/no | | | yes | ABC country adjustable | |
68 | search_code_region | character | x(10) | | | | Area search code | |
69 | change_region | logical | yes/no | | | yes | Area adjustable | |
70 | link_recurring_invoices | integer | >>>>>9 | | | 0 | Link recurring invoices | |
71 | source_lc | character | x(12) | | | | | |
72 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
73 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
74 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
75 | type_lc | character | x(8) | | | | | |
76 | e_mail | character | X(60) | | | | E-mail | |
77 | honor_fee | logical | yes/no | | | no | Recipient of honorary fees | |
78 | ifall_block | logical | yes/no | | | no | Block for changes | |
79 | x_group_payments | integer | >>>>>9 | | | 0 | Group cheques or B/E's | t_test: boe-group-payments |
80 | bnk_curr_code_1 | character | x(3) | | | | Currency (Bank) | curren |
81 | bnk_curr_code_2 | character | x(3) | | | | Currency (Blocked) | curren |
82 | website | character | X(160) | | | | Web site | |
83 | exdescr_code | character | X(2) | | | | Extra description | lldesc |
84 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
85 | house_nr | integer | >>>>>9 | | | 0 | House number | |
86 | house_nr_addition | character | X(8) | | | | House number addition | |
87 | payment_specification | integer | >>>>>9 | | | 0 | Payment specification | t_test: sendingmethod |
88 | chamber_of_commerce_nr | character | X(10) | | | | Chamber of Commerce number | |
89 | organization_id | character | X(20) | | | | Organization ID | |
90 | duns_number | integer | >>>>>>>>> | | | 0 | DUNS number | |
91 | type_send_purch_order_by | integer | >>>>>9 | | | 0 | Purchase order (Send) | |
92 | type_send_receipt_by | integer | >>>>>9 | | | 0 | Receipt (Send) | |
93 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
creditix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
credit10ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
credit11ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | link_recurring_invoices | integer | >>>>>9 | Link recurring invoices |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
credit2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | search_code | character | x(20) | Search code |
credit3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | postal_code | character | x(8) | Postal code |
credit4ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr_1 | character | x(34) | Bank account |
credit5ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr_2 | character | x(34) | Bank account (Blocked) |
credit6ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | postbank_acc_nr | character | x(34) | Postbank |
credit7ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | name | character | X(100) | Name |
credit8ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | vat_nr | character | x(20) | VAT number |
credit9ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | date_lc | date | 99/99/9999 | Modified: Date |
3 | time_lc | integer | ->,>>>,>>9 | Modified: Time |
Contents > credit
credit_t - creditor notes1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | creditor | int64 | >>>>>>>>>9 | | | ? | Creditor | |
3 | note | character | x(2000) | | | | Note | |
4 | link | character | X(255) | | | | Link | |
5 | source_lc | character | x(12) | | | | | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | x(8) | | | | | |
10 | seqnr_notes | integer | >9 | | | ? | Sequence number | |
Indexes
credit-t01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | creditor | int64 | >>>>>>>>>9 | Creditor |
3 | seqnr_notes | integer | >9 | Sequence number |
Contents > credit_t
cstccn - Cost center allocations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cost_center | character | x(12) | | | ? | Cost center | ccent |
3 | target_cost_center | character | x(12) | | | ? | Target cost center | ccent |
4 | units | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Units | |
5 | source_lc | character | x(12) | | | | | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | x(8) | | | | | |
10 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
cstccnix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_center | character | x(12) | Cost center |
3 | target_cost_center | character | x(12) | Target cost center |
cstccn2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | target_cost_center | character | x(12) | Target cost center |
3 | cost_center | character | x(12) | Cost center |
Contents > cstccn
cstcun - Standard distr. cost units1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | cost_center | character | x(12) | | | ? | Cost center | |
3 | cost_unit | character | x(12) | | | ? | Cost unit | |
4 | units | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Units | |
5 | source_lc | character | x(12) | | | | | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | x(8) | | | | | |
Indexes
cstcunix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_center | character | x(12) | Cost center |
3 | cost_unit | character | x(12) | Cost unit |
cstcun2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit | character | x(12) | Cost unit |
3 | cost_center | character | x(12) | Cost center |
Contents > cstcun
cunit - Cost units1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cost_unit | character | x(12) | | | ? | Cost unit | |
3 | descr | character | X(60) | | | | Description | |
4 | adm_name | character | x(60) | | | | Company name | |
5 | local_admin | logical | yes/no | | | no | Local company | |
6 | adm_nr_ref | integer | >>>>>9 | | | 0 | Company | |
7 | curr_code | character | x(3) | | | | Currency | |
8 | perc | decimal | ->>9.99 | 2 | | 0 | Percentage | |
9 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
10 | exch_rate2 | decimal | >>>>9.999999 | 6 | | 1 | Second exchange rate field | |
11 | distr | character | x(1) | | | | Allocation | |
12 | descr_ml | character | X(60) | | 5 | | ML description | |
13 | source_lc | character | x(12) | | | | | |
14 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
15 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
16 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
17 | type_lc | character | x(8) | | | | | |
18 | block | logical | yes/no | | | no | Block | |
19 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
20 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
21 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
cunitix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit | character | x(12) | Cost unit |
cunit04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | cost_unit | character | x(12) | Cost unit |
cunit2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | adm_nr_ref | integer | >>>>>9 | Company |
3 | local_admin | logical | yes/no | Local company |
4 | cost_unit | character | x(12) | Cost unit |
cunit3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | descr | character | X(60) | Description |
3 | cost_unit | character | x(12) | Cost unit |
Contents > cunit
curren - Currencies1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | curr_code | character | x(3) | | | ? | Currency | |
3 | descr | character | X(60) | | | | Description | |
4 | abbrev | character | x(5) | | | | Abbreviation | |
5 | iso_cur_code | character | x(3) | | | | ISO currency | isocur |
6 | conv_factor | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Conversion factor | |
7 | acc_nr_xrate_loss_purchase | character | x(12) | | | | Foreign exchange loss purchase | ledger |
8 | acc_nr_xrate_gain_purchase | character | x(12) | | | | Foreign exchange gain purchase | ledger |
9 | acc_nr_xrate_loss_sales | character | x(12) | | | | Foreign exchange loss sales | ledger |
10 | acc_nr_xrate_gain_sales | character | x(12) | | | | Foreign exchange gain sales | ledger |
11 | acc_nr_revalue | character | x(12) | | | | Unfavorable revaluations | ledger |
12 | acc_nr_revalue_revenue | character | x(12) | | | | Favorable revaluations | ledger |
13 | vat_low_sales | character | x(3) | | | | VAT percentage low sales | |
14 | vat_high_sales | character | x(3) | | | | VAT percentage high sales | |
15 | vat_low_purch | character | x(3) | | | | VAT percentage low purchase | |
16 | vat_high_purch | character | x(3) | | | | VAT percentage high purchase | |
17 | current_rate | logical | yes/no | | | no | Variable exchange rate | |
18 | blocked | logical | yes/no | | | FALSE | Blocked | |
19 | post_curr_sales | logical | yes/no | | | yes | Post in currency sales | |
20 | revenue_code | integer | >>>>>9 | | | 0 | Revenue code | |
21 | entry_curr_purch | logical | yes/no | | | yes | Enter purchases in FC | |
22 | entry_curr_sales | logical | yes/no | | | yes | Enter sales orders/invoices in FC | |
23 | price_prec | integer | 9 | | | 0 | Precision for prices | |
24 | amt_prec | integer | 9 | | | 0 | Precision for amounts | |
25 | curr_abbrev | character | x(1) | | | | Currency character | |
26 | res_1 | decimal | ->>>9 | 0 | | 0 | Reserve 1 | |
27 | res_2 | decimal | ->>>9 | 0 | | 0 | Reserve 2 | |
28 | rate_prec | integer | >9 | | | 6 | Exchange rate precision | |
29 | res_4 | integer | ->>>9 | | | 0 | Reserve 4 | |
30 | descr_ml | character | X(60) | | 5 | | ML description | |
31 | source_lc | character | x(12) | | | | | |
32 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
33 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
34 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
35 | type_lc | character | x(8) | | | | | |
36 | curr_format | character | X(23) | | | | Amount format | |
37 | price_format | character | X(23) | | | | Price format | |
38 | emu_curr | logical | yes/no | | | no | EMU member | |
39 | emu_date | date | 99/99/9999 | | | 01/01/1999 | Date of joining EMU | |
40 | entry_format | character | X(23) | | | | Entry format | |
41 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
42 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
43 | write_off_using_oi_xrate | logical | true/false | | | FALSE | Use: Exchange rate (Outstanding item) | |
44 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
currenix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | curr_code | character | x(3) | Currency |
curren03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | curr_code | character | x(3) | Currency |
curren2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | descr | character | X(60) | Description |
3 | curr_code | character | x(3) | Currency |
Contents > curren
dbver - Database versions1 | db_ver_nr | character | X(8) | | | | Database version | |
2 | db_alias | character | X(8) | | | ? | DBAlias | |
3 | source_lc | character | x(12) | | | | | |
4 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
5 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
6 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
7 | type_lc | character | x(8) | | | | | |
Indexes
dbverix - primary - unique
1 | db_alias | character | X(8) | DBAlias |
Contents > dbver
debbal - Debtor balances1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | debtor |
3 | fin_yr | integer | 9999 | | | ? | Year | |
4 | period | integer | >>9 | | | ? | Period | |
5 | open_bal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Opening balance (DC) | |
6 | revenue_excl | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Revenue (Excluding VAT) | |
7 | revenue_incl | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Revenue (Including VAT) | |
8 | amt_total | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Paid (DC) | |
9 | conversie | logical | yes/no | | | no | Originating from conversion | |
10 | source_lc | character | x(12) | | | | | |
11 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | type_lc | character | x(8) | | | | | |
15 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
debbalix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | fin_yr | integer | 9999 | Year |
4 | period | integer | >>9 | Period |
Contents > debbal
debcat - Debtor categories1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | cat | character | x(12) | | | ? | Category | |
3 | descr | character | X(60) | | | | Description | |
4 | source_lc | character | x(12) | | | | | |
5 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
6 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | type_lc | character | x(8) | | | | | |
9 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
10 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
11 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
debcatix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | cat | character | x(12) | Category |
debcat02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | cat | character | x(12) | Category |
Contents > debcat
debout - Accounts receivable1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | debtor |
3 | entry_nr_type | integer | >>>>>9 | | | ? | Type: Entry number | t_test: entry-nr-type |
4 | entry_nr | int64 | >>>>>>>>>>>9 | | | ? | Entry number | |
5 | date | date | 99/99/9999 | | | | Date | |
6 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
7 | descr | character | X(60) | | | | Description | |
8 | amt_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC (after entry) | |
9 | amt_after_posting | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC (after posting) | |
10 | curr_code | character | x(3) | | | | Currency | curren |
11 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
12 | amt_curr_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (after entry) (DB) | |
13 | amt_curr_after_posting | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (after posting) | |
14 | amt_original | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (original) | |
15 | due_date_surch_1 | date | 99/99/9999 | | | | Surcharge: Due date 1 | |
16 | due_date_surch_2 | date | 99/99/9999 | | | | Surcharge: Due date 2 | |
17 | due_date_invoice | date | 99/99/9999 | | | | Invoice: Due date | |
18 | surch_disc | integer | >>>>>9 | | | 0 | Payment charge/discount | t_test: surch-disc |
19 | amt_credit_surch_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 1 | |
20 | amt_credit_surch_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 2 | |
21 | block | logical | yes/no | | | no | Block | |
22 | last_entry_date | date | 99/99/9999 | | | | Last entry date | |
23 | nr_reminders | integer | ->9 | | | 0 | Reminders | |
24 | date_last_reminder | date | 99/99/9999 | | | | Last reminder | |
25 | layoutcode | character | x(1) | | | | Layout | |
26 | week_nr | integer | >9 | | | 0 | Due week | |
27 | fin_yr | integer | 9999 | | | 0 | Year | |
28 | prepayment | logical | yes/no | | | no | Prepayment | |
29 | acc_nr_sub_adm | character | x(12) | | | | G/L account | ledger |
30 | deliv_ext_bureau | integer | >>>>>9 | | | 0 | Supplied to external bureau | |
31 | date_deliv | date | 99/99/9999 | | | | Delivery date | |
32 | pay_condition | character | X(4) | | | | Payment condition | paycon |
33 | source_lc | character | x(12) | | | | | |
34 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
35 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
36 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
37 | type_lc | character | x(8) | | | | | |
38 | pay_ref | character | X(32) | | | | Payment reference | |
39 | pay_ref_2 | character | x(20) | | | | Payment reference-2 | |
40 | pay_method | integer | >>>>>9 | | | 0 | Payment method | t_test: pay-method |
41 | collection_code | character | x(12) | | | | Collection code | |
42 | struct_m | logical | yes/no | | | no | Structured announcement | |
43 | due_date_surch_3 | date | 99/99/9999 | | | | Surcharge: Due date 3 | |
44 | due_date_surch_4 | date | 99/99/9999 | | | | Surcharge: Due date 4 | |
45 | due_date_surch_5 | date | 99/99/9999 | | | | Surcharge: Due date 5 | |
46 | amt_credit_surch_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 3 | |
47 | amt_credit_surch_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 4 | |
48 | amt_credit_surch_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Surcharge: Amount 5 | |
49 | amt_acc_nr_blocked | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Blocked bank account: Amount | |
50 | bank_acc_nr | character | x(34) | | | | Bank account | |
51 | curr_code_bank_acc_nr | character | x(3) | | | | Currency (Bank) | |
52 | mandate_ref | character | X(35) | | | | Mandate reference | colarr |
53 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
deboutix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
4 | entry_nr_type | integer | >>>>>9 | Type: Entry number |
debout2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
3 | entry_nr_type | integer | >>>>>9 | Type: Entry number |
4 | debtor | int64 | >>>>>>>>>9 | Debtor |
debout3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | curr_code | character | x(3) | Currency |
4 | amt_curr_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount FC (after entry) (DB) |
debout4ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | amt_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount DC (after entry) |
debout5ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | curr_code | character | x(3) | Currency |
3 | amt_curr_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount FC (after entry) (DB) |
debout6ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | amt_after_entry | decimal | ->>>,>>>,>>>,>>>,>>9.99 | Amount DC (after entry) |
Contents > debout
debrev - Debtor revaluations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | debtor |
3 | entry_nr_type | integer | >>>>>9 | | | ? | Entry type | t_test: entry-nr-type |
4 | entry_nr | int64 | >>>>>>>>>>>9 | | | ? | Entry number | |
5 | curr_code | character | x(3) | | | ? | Currency | curren |
6 | amt_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
7 | hist_exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Historical exchange rate | |
8 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
9 | amt_act | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC: Current | |
10 | amt_revalue | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC: Revaluation | |
11 | revalue_exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate: Revaluation | |
12 | revalue | logical | yes/no | | | no | Revalue | |
13 | cost_center | character | x(12) | | | | Cost center | ccent |
14 | acc_nr_revalue | character | x(12) | | | | Unfavorable revaluations | ledger |
15 | acc_nr_revalue_revenue | character | x(12) | | | | Favorable revaluations | ledger |
16 | source_lc | character | x(12) | | | | | |
17 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
18 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
19 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
20 | type_lc | character | x(8) | | | | | |
Indexes
debrevix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | entry_nr_type | integer | >>>>>9 | Entry type |
4 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
5 | curr_code | character | x(3) | Currency |
Contents > debrev
debtor - Debtors (Sales)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | |
3 | name | character | X(100) | | | | Name | |
4 | address_1 | character | X(60) | | | | Address line 1 | |
5 | address_2 | character | X(60) | | | | Address line 2 | |
6 | address_3 | character | X(60) | | | | Address line 3 | |
7 | postal_code | character | x(8) | | | | Postal code | stpostal |
8 | city | character | X(60) | | | | City | |
9 | country | character | x(3) | | | | Country | countr |
10 | search_code | character | x(20) | | | | Search code | |
11 | curr_code | character | x(3) | | | | Currency | curren |
12 | telephone | character | x(15) | | | | Telephone | |
13 | fax_nr | character | x(15) | | | | Fax | |
14 | contact | character | X(60) | | | | Contact | |
15 | sex | integer | >>>>>9 | | | 0 | Sex | t_test: sex |
16 | title_code | character | x(4) | | | | Title | titles |
17 | initials | character | x(10) | | | | Initials | |
18 | func_desc | character | X(60) | | | | Position | |
19 | telephone_contact | character | x(15) | | | | Contact: Telephone | |
20 | bank_acc_nr | character | x(34) | | | | Bank account | |
21 | postbank_acc_nr | character | x(34) | | | | Postbank | |
22 | pay_method | integer | >>>>>9 | | | 0 | Payment method | t_test: pay-method |
23 | acc_nr_contra | character | x(12) | | | | Offset account | ledger |
24 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
25 | attention | logical | yes/no | | | no | Attention field | |
26 | cat | character | x(12) | | | | Category | debcat |
27 | invoice_debtor | int64 | >>>>>>>>>9 | | | 0 | Invoice debtor | |
28 | surch | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Credit line | |
29 | pay_reminder | logical | yes/no | | | yes | Reminder | |
30 | pay_condition | character | X(4) | | | | Payment condition | paycon |
31 | block | logical | yes/no | | | no | Block | |
32 | representative | character | x(20) | | | | Representative | lsrep |
33 | pricelist_code | character | x(3) | | | | Price list | llplst |
34 | extra_item_code | character | x(2) | | | | Extra item | |
35 | delivery_method | character | x(12) | | | | Delivery method | lldome |
36 | disc_perc | decimal | ->>9.99 | 2 | | 0 | Discount percentage | |
37 | date_last_reminder | date | 99/99/9999 | | | | Last reminder | |
38 | layoutcode | character | x(1) | | | | Layout | |
39 | lang_code | character | x(3) | | | | Language | lang |
40 | amt_in_order | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount on order | |
41 | page_nr | integer | ->9 | | | 0 | Page number after compression | |
42 | debopensal | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Unused field | |
43 | factoring | logical | yes/no | | | no | Factoring | |
44 | country_iso | character | x(2) | | | | ISO country | |
45 | vat_nr | character | x(20) | | | | VAT number | |
46 | check_date | date | 99/99/9999 | | | | Check date | |
47 | cat_belgium | logical | yes/no | | | yes | Liable to pay VAT | |
48 | stat_factor | character | x(3) | | | | Statistical factor | |
49 | vat_code | character | x(3) | | | 0 | VAT code | vattrs |
50 | change_vat | logical | yes/no | | | yes | VAT code adjustable | |
51 | stat_system | character | x(10) | | | | Statistical system | |
52 | change_system | logical | yes/no | | | yes | System adjustable | |
53 | cost_code | character | x(12) | | | | Cost code | llcoc |
54 | change_trans_a | logical | yes/no | | | yes | Transaction A adjustable | |
55 | transact_b | character | x(10) | | | | Transaction B | |
56 | change_trans_b | logical | yes/no | | | yes | Transaction B adjustable | |
57 | country_dest | character | x(3) | | | | Country of destination | |
58 | change_dest | logical | yes/no | | | yes | Destination adjustable | |
59 | transport_code | character | x(10) | | | | Method of transportation | |
60 | change_transport | logical | yes/no | | | yes | Method of transportation | |
61 | city_of_ul | character | x(10) | | | | City of loading/unloading | |
62 | change_ul | logical | yes/no | | | yes | City of loading/unloading adjustable | |
63 | search_code_deliv_method | character | x(10) | | | | Delivery method | |
64 | change_deliv_method | logical | yes/no | | | yes | Terms of delivery adjustable | |
65 | trsshpm_code | character | x(10) | | | | Transshipment | |
66 | change_tshpm | logical | yes/no | | | yes | Transshipment adjustable | |
67 | country_abc | character | x(3) | | | | Country ABC transaction | |
68 | change_abc | logical | yes/no | | | yes | ABC country adjustable | |
69 | search_code_region | character | x(10) | | | | Area | |
70 | change_region | logical | yes/no | | | yes | Area adjustable | |
71 | sales_confirm | logical | yes/no | | | no | Sales order confirmation | |
72 | backorders | logical | yes/no | | | yes | Back orders allowed | |
73 | grouped_invoice | logical | yes/no | | | no | Grouped invoice | |
74 | link_recurring_invoices | integer | >>>>>9 | | | 0 | Link recurring invoices | t_test: link_recurring_inv |
75 | source_lc | character | x(12) | | | | | |
76 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
77 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
78 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
79 | type_lc | character | x(8) | | | | | |
80 | e_mail | character | X(60) | | | | E-mail | |
81 | adrnr_stat | character | X(10) | | | | Address number periodic overview | |
82 | date_stat | date | 99/99/9999 | | | | Date last periodic overview | |
83 | seq_stat | integer | >>>9 | | | 0 | Number last periodic overview | |
84 | print_stat | logical | yes/no | | | yes | Print periodic overview | |
85 | auto_payment | logical | yes/no | | | yes | Automatic payment | |
86 | ifall_block | logical | yes/no | | | no | Block for changes | |
87 | supp_nr | character | x(10) | | | | Invoice by | t_test: sendingmethod |
88 | x_group_payments | integer | >>>>>9 | | | 0 | Group cheques or B/E's | t_test: boe-group-payments |
89 | bnk_curr_code | character | x(3) | | | | Currency (Bank) | curren |
90 | website | character | X(160) | | | | Web site | |
91 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
92 | house_nr | integer | >>>>>9 | | | 0 | House number | |
93 | house_nr_addition | character | X(8) | | | | House number addition | |
94 | type_remind_by | integer | >>>>>9 | | | 0 | Remind by | t_test: sendingmethod |
95 | payment_specification | integer | >>>>>9 | | | 0 | Payment specification | t_test: sendingmethod |
96 | type_invoice_by | integer | >>>>>9 | | | 0 | Invoice by | |
97 | collection_specification | integer | >>>>>9 | | | 0 | Collection specification | t_test: sendingmethod |
98 | attachment_format | integer | >>>>>9 | | | 0 | Attachment (Format) | |
99 | xml_definition_e_invoice | character | X(12) | | | | XML definition (UBL) | |
100 | chamber_of_commerce_nr | character | X(10) | | | | Chamber of Commerce number | |
101 | organization_id | character | X(20) | | | | Organization ID | |
102 | duns_number | integer | >>>>>>>>> | | | 0 | DUNS number | |
103 | type_send_confirmation_by | integer | >>>>>9 | | | 0 | Confirmation (Send) | |
104 | type_send_delivery_note_by | integer | >>>>>9 | | | 0 | Delivery note (Send) | |
105 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
debtorix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
debtor09ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | debtor | int64 | >>>>>>>>>9 | Debtor |
debtor10ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | link_recurring_invoices | integer | >>>>>9 | Link recurring invoices |
3 | debtor | int64 | >>>>>>>>>9 | Debtor |
debtor11ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | invoice_debtor | int64 | >>>>>>>>>9 | Invoice debtor |
debtor2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | search_code | character | x(20) | Search code |
debtor3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | postal_code | character | x(8) | Postal code |
debtor4ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
debtor5ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | postbank_acc_nr | character | x(34) | Postbank |
debtor6ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | name | character | X(100) | Name |
debtor7ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | vat_nr | character | x(20) | VAT number |
debtor8ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | date_lc | date | 99/99/9999 | Modified: Date |
3 | time_lc | integer | ->,>>>,>>9 | Modified: Time |
Contents > debtor
debtor_t - debtor notes1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | |
3 | note | character | x(2000) | | | | Note | |
4 | link | character | X(255) | | | | Link | |
5 | source_lc | character | x(12) | | | | | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | x(8) | | | | | |
10 | seqnr_notes | integer | >9 | | | ? | Sequence number | |
Indexes
debtor-t01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | seqnr_notes | integer | >9 | Sequence number |
Contents > debtor_t
debtrs - Debtor: Transactions1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | seqnr_debtrs | int64 | >>>>>>>>>9 | | | ? | Debtor transaction: Sequence number | |
3 | fin_yr | integer | 9999 | | | 0 | Year | |
4 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | debtor |
5 | date | date | 99/99/9999 | | | | Date | |
6 | period | integer | >>9 | | | 0 | Period | |
7 | entry_nr_type | integer | >>>>>9 | | | 1 | Entry type | t_test: entry-nr-type |
8 | entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Outstanding item: Invoice number | |
9 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
10 | descr | character | X(60) | | | | Description | |
11 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
12 | curr_code | character | x(3) | | | | Currency | curren |
13 | curr_code_extra | character | x(3) | | | | Extra currency code | curren |
14 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
15 | exch_rate_2 | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate 2 | |
16 | exch_rate3 | decimal | >>>>>9.99999 | 6 | | 1 | Exchange rate 3 | |
17 | amt_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
18 | entry_nr_fin | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | |
19 | posting_nr_journal | integer | ->>>>>>>>>9 | | | 0 | Posting number journal | |
20 | posting_nr | int64 | >>>>>>>>>9 | | | 0 | Posting number | |
21 | check_number | integer | ->>>>>>>>>9 | | | 0 | Check number | |
22 | closing_transac | logical | yes/no | | | no | Transaction after closing | |
23 | revalue_transact | logical | yes/no | | | no | Revalue | |
24 | match_inv_type | integer | >>>>>9 | | | 1 | Invoice type | |
25 | match_inv | int64 | >>>>>>>>>>>9 | | | 0 | Matched: Invoice | |
26 | match_trs | logical | yes/no | | | no | Matching transaction | |
27 | rev_entry | logical | yes/no | | | no | Reversal entry | |
28 | seqnr_ledtrs | int64 | >>>>>>>>>9 | | | 0 | G/L transaction: Sequence number | |
29 | pay_condition | character | X(4) | | | | Payment condition | paycon |
30 | mcode1 | character | x(12) | | | | Dimension 1 | mdim1 |
31 | mcode2 | character | x(12) | | | | Dimension 2 | mdim2 |
32 | mcode3 | character | x(12) | | | | Dimension 3 | mdim3 |
33 | mcode4 | character | x(12) | | | | Dimension 4 | mdim4 |
34 | mcode5 | character | x(12) | | | | Dimension 5 | mdim5 |
35 | source_lc | character | x(12) | | | | | |
36 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
37 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
38 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
39 | type_lc | character | x(8) | | | | | |
40 | seqnr_atrsh | integer | >>>>>>9 | | | 0 | Sequence number | |
41 | linenr_atrss | integer | >>>>>9 | | | 0 | Line number | |
42 | bank_acc_nr | character | x(34) | | | | Bank account | bnklnk |
43 | curr_code_bank_acc_nr | character | x(3) | | | | Currency (Bank) | curren |
44 | mandate_ref | character | X(35) | | | | Mandate reference | colarr |
45 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
debtrs01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_debtrs | int64 | >>>>>>>>>9 | Debtor transaction: Sequence number |
debtrs02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | debtor | int64 | >>>>>>>>>9 | Debtor |
4 | date | date | 99/99/9999 | Date |
debtrs03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | debtor | int64 | >>>>>>>>>9 | Debtor |
4 | entry_nr_type | integer | >>>>>9 | Entry type |
5 | entry_nr | int64 | >>>>>>>>>>>9 | Outstanding item: Invoice number |
6 | period | integer | >>9 | Period |
debtrs04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Year |
3 | debtor | int64 | >>>>>>>>>9 | Debtor |
4 | period | integer | >>9 | Period |
5 | date | date | 99/99/9999 | Date |
debtrs05ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | posting_nr | int64 | >>>>>>>>>9 | Posting number |
3 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
4 | linenr_atrss | integer | >>>>>9 | Line number |
debtrs06ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | entry_nr | int64 | >>>>>>>>>>>9 | Outstanding item: Invoice number |
4 | entry_nr_type | integer | >>>>>9 | Entry type |
Contents > debtrs
delnac - Delivery addresses1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | debtor |
3 | addr_code | character | x(12) | | | ? | Address | stnactype |
4 | name | character | X(100) | | | | Name | |
5 | address_1 | character | X(60) | | | | Address line 1 | |
6 | address_2 | character | X(60) | | | | Address line 2 | |
7 | address_3 | character | X(60) | | | | Address line 3 | |
8 | postal_code | character | x(8) | | | | Postal code | stpostal |
9 | city | character | X(60) | | | | City | |
10 | country | character | x(3) | | | | Country | countr |
11 | telephone | character | x(15) | | | | Telephone | |
12 | fax_nr | character | x(15) | | | | Fax | |
13 | title_code | character | x(4) | | | | Title | titles |
14 | initials | character | x(10) | | | | Initials | |
15 | contact | character | X(60) | | | | Contact | |
16 | func_desc | character | X(60) | | | | Position | |
17 | sex | integer | >>>>>9 | | | 0 | Sex | t_test: sex |
18 | lang_code | character | x(3) | | | | Language | lang |
19 | route_code | character | x(2) | | | | Route | |
20 | instr | character | x(80) | | | | Instruction | |
21 | source_lc | character | x(12) | | | | | |
22 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
23 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
24 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
25 | type_lc | character | x(8) | | | | | |
26 | e_mail | character | x(256) | | | | E-mail | |
27 | euserid_cr | character | x(20) | | | | Created: User | stuser |
28 | date_cr | date | 99/99/9999 | | | | Created: Date | |
29 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
30 | source_cr | character | x(12) | | | | Source creation | |
31 | entity_state | integer | >>>>>9 | | | 0 | State | |
32 | address_type_code | character | x(12) | | | | Address type code | stnactype |
33 | house_nr | integer | >>>>>9 | | | 0 | House number | |
34 | house_nr_addition | character | X(8) | | | | House number addition | |
35 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
delnacix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | addr_code | character | x(12) | Address |
delnac04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | debtor | int64 | >>>>>>>>>9 | Debtor |
4 | addr_code | character | x(12) | Address |
delnac05ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | address_type_code | character | x(12) | Address type code |
4 | addr_code | character | x(12) | Address |
delnac06ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | postal_code | character | x(8) | Postal code |
3 | address_1 | character | X(60) | Address line 1 |
delnac2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | city | character | X(60) | City |
delnac3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | name | character | X(100) | Name |
Contents > delnac
dpr_cald - Calendar periods1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | book_calendar | character | x(12) | | | ? | Calendar | dpr_calm |
3 | fin_yr | integer | 9999 | | | ? | Year | |
4 | period | integer | >>9 | | | ? | Period | |
5 | start_date | date | 99/99/9999 | | | | Start date | |
6 | end_date | date | 99/99/9999 | | | | End date | |
7 | source_lc | character | x(12) | | | | Source last changed | |
8 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
9 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
11 | type_lc | character | X(8) | | | | Type last changed | |
12 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
dpr_caldix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | book_calendar | character | x(12) | Calendar |
3 | fin_yr | integer | 9999 | Year |
4 | period | integer | >>9 | Period |
dpr_cald2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | book_calendar | character | x(12) | Calendar |
3 | start_date | date | 99/99/9999 | Start date |
4 | end_date | date | 99/99/9999 | End date |
Contents > dpr_cald
dpr_calm - Depreciation calendars1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | book_calendar | character | x(12) | | | ? | Calendar | |
3 | descr | character | X(60) | | | | Description | |
4 | periods | integer | >>9 | | | 0 | Number of periods | |
5 | def_calendar | integer | 9999 | | | 0 | Default | |
6 | fin_yr_closed | integer | 9999 | | | 0 | Year closed | |
7 | period_closed | integer | >>9 | | | 0 | Closing period | |
8 | short_tax_yr | logical | yes/no | | | no | Short tax year | |
9 | source_lc | character | x(12) | | | | Source last changed | |
10 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
12 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
13 | type_lc | character | X(8) | | | | Type last changed | |
14 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
15 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
16 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
dpr_calmix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | book_calendar | character | x(12) | Calendar |
dpr_calm02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | book_calendar | character | x(12) | Calendar |
Contents > dpr_calm
dpr_idxd - Depreciation index details1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | table_id | character | x(12) | | | ? | Index table | dpr_idxm |
3 | year | integer | >>>9 | | | ? | Year | |
4 | percentage | decimal | >>9.99 | 2 | | 0 | Percentage | |
5 | source_lc | character | x(12) | | | | Source last changed | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | X(8) | | | | Type last changed | |
10 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
dpr_idxdix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | table_id | character | x(12) | Index table |
3 | year | integer | >>>9 | Year |
Contents > dpr_idxd
dpr_idxm - Depreciation index tables1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | table_id | character | x(12) | | | ? | Index table | |
3 | descr | character | X(60) | | | | Description | |
4 | source_lc | character | x(12) | | | | Source last changed | |
5 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
6 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | type_lc | character | X(8) | | | | Type last changed | |
9 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
10 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
dpr_idxmix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | table_id | character | x(12) | Index table |
Contents > dpr_idxm
dpr_mtab - Depreciation tables1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | asset_code | character | X(12) | | | ? | Asset | fas_ast |
3 | asset_book | character | x(12) | | | ? | Asset book | fas_book |
4 | period | integer | >>9 | | | ? | Period | |
5 | amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
6 | percentage | decimal | >>9.99 | 2 | | 0 | Percentage | |
7 | type | integer | >9 | | | 0 | Type | t_test: asset-depr-type |
8 | source_lc | character | x(12) | | | | Source last changed | |
9 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
12 | type_lc | character | X(8) | | | | Type last changed | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
dpr_mtabix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_code | character | X(12) | Asset |
3 | asset_book | character | x(12) | Asset book |
4 | period | integer | >>9 | Period |
Contents > dpr_mtab
dpr_trns - Depreciation transactions1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | asset_book | character | x(12) | | | ? | Asset book | fas_book |
3 | asset_code | character | X(12) | | | ? | Asset | fas_ast |
4 | date_trans | date | 99/99/9999 | | | | Transaction date | |
5 | trans_nr | integer | ->,>>>,>>9 | | | ? | Transaction number | |
6 | reversed | logical | Yes/No | | | ? | Reversal entry | |
7 | euserid | character | x(20) | | | | User ID | stuser |
8 | period_nr | integer | >>9 | | | 0 | Periods depreciated | |
9 | parent_master_asset | character | X(20) | | | | Main asset set | |
10 | parent_asset | character | X(12) | | | | Parent asset | |
11 | ownership_type | integer | >>>>>9 | | | 0 | Ownership type | |
12 | formula_id | character | X(8) | | | | Depreciation method | |
13 | acc_nr | character | x(12) | | | | General ledger account | ledger |
14 | x_journal_nr | integer | >>9 | | | 0 | Journal | |
15 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | debtor |
16 | sbd_sub | character | x(12) | | | | Sub account | |
17 | project_code | character | x(20) | | | | Project | prmst |
18 | cost_center | character | x(12) | | | | Cost center | ccent |
19 | cost_unit | character | x(12) | | | | Cost unit | cunit |
20 | profile_id | character | x(12) | | | | Asset group | fas_grp |
21 | descr | character | X(60) | | | | Description | |
22 | trans_code | integer | >>>>>9 | | | 0 | Transaction code | t_test: asset-trans-type |
23 | trans_type | integer | >>>>>9 | | | 0 | Transaction type | |
24 | department_code | character | x(12) | | | | Department | fas_dept |
25 | location_code | character | x(12) | | | | Location | fas_loc |
26 | qty_actual | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Quantity | |
27 | invoice_nr | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | |
28 | invoice_nr_sales | int64 | >>>>>>>>>>>9 | | | 0 | Invoice number | |
29 | state | integer | >>>>>9 | | | 0 | Status (Asset) | t_test: asset-state |
30 | order_nr | character | x(12) | | | | Purchase order number | |
31 | receipt_nr | character | x(12) | | | | Receipt number | |
32 | rent_nr | character | x(12) | | | | Number | |
33 | post_nr | integer | ->,>>>,>>9 | | | 0 | Posting number | |
34 | amt_trans | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
35 | curr_code | character | X(3) | | | | Currency | curren |
36 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
37 | amt_trans_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
38 | fin_yr | integer | 9999 | | | 0 | Year | |
39 | period | integer | >>9 | | | 0 | Period | |
40 | lat_mut | logical | yes/no | | | no | Transaction tax latency | |
41 | posted | logical | Yes/No | | | no | Posted | |
42 | source_lc | character | x(12) | | | | Source last changed | |
43 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
44 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
45 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
46 | type_lc | character | X(8) | | | | Type last changed | |
47 | cost_cat_code | character | x(12) | | | | Project cost category | prccat |
48 | project_cost_center | character | x(12) | | | | Project cost center | |
49 | project_descr | character | X(60) | | | | Project description | |
50 | result_type | integer | >>>>>9 | | | 0 | Project result type | t_test: pro_result_type |
51 | mdim_code_1 | character | x(12) | | | | Dimension 1 | |
52 | mdim_code_2 | character | x(12) | | | | Dimension 2 | |
53 | mdim_code_3 | character | x(12) | | | | Dimension 3 | |
54 | mdim_code_4 | character | x(12) | | | | Dimension 4 | |
55 | mdim_code_5 | character | x(12) | | | | Dimension 5 | |
Indexes
dpr_trnsix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
3 | asset_code | character | X(12) | Asset |
4 | date_trans | date | 99/99/9999 | Transaction date |
5 | trans_nr | integer | ->,>>>,>>9 | Transaction number |
6 | reversed | logical | Yes/No | Reversal entry |
dpr_trns3ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
3 | asset_code | character | X(12) | Asset |
4 | trans_code | integer | >>>>>9 | Transaction code |
5 | reversed | logical | Yes/No | Reversal entry |
6 | period_nr | integer | >>9 | Periods depreciated |
7 | date_trans | date | 99/99/9999 | Transaction date |
8 | trans_nr | integer | ->,>>>,>>9 | Transaction number |
dpr_trns4ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_code | character | X(12) | Asset |
3 | reversed | logical | Yes/No | Reversal entry |
4 | trans_code | integer | >>>>>9 | Transaction code |
5 | asset_book | character | x(12) | Asset book |
6 | period_nr | integer | >>9 | Periods depreciated |
7 | date_trans | date | 99/99/9999 | Transaction date |
8 | trans_nr | integer | ->,>>>,>>9 | Transaction number |
dpr_trnsix2
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
3 | asset_code | character | X(12) | Asset |
4 | fin_yr | integer | 9999 | Year |
5 | period | integer | >>9 | Period |
6 | trans_nr | integer | ->,>>>,>>9 | Transaction number |
7 | reversed | logical | Yes/No | Reversal entry |
Contents > dpr_trns
earole - Roles1 | roleid | character | x(12) | | | ? | Role | |
2 | description | character | X(60) | | | | Description | |
3 | euserid_cr | character | x(20) | | | | Created: User | stuser |
4 | date_cr | date | 99/99/9999 | | | | Created: Date | |
5 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
6 | source_cr | character | X(40) | | | | Source creation | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
10 | source_lc | character | X(40) | | | | Source last changed | |
11 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
12 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
earoleix - primary - unique
1 | roleid | character | x(12) | Role |
earole02ix
1 | roleid | character | x(12) | Role |
2 | entity_state | integer | >>>>>9 | State |
Contents > earole
earolrec - Data authorization1 | adm_nr | integer | ->,>>>,>>9 | | | ? | Company | admdat |
2 | accesstype | integer | ->,>>>,>>9 | | | ? | Table | t_test: data_authorization |
3 | roleid | character | x(12) | | | ? | Role | earole |
4 | recordkey | character | X(20) | | | ? | Records | ccent,cunit,journl,prmst,ddcapp |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | date_cr | date | 99/99/9999 | | | | Created: Date | |
7 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
8 | source_cr | character | X(40) | | | | Source creation | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
12 | source_lc | character | X(40) | | | | Source last changed | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
earolrecix - primary - unique
1 | adm_nr | integer | ->,>>>,>>9 | Company |
2 | accesstype | integer | ->,>>>,>>9 | Table |
3 | roleid | character | x(12) | Role |
4 | recordkey | character | X(20) | Records |
Contents > earolrec
earolusr - Roles per user1 | euserid | character | x(20) | | | ? | User ID | stuser |
2 | roleid | character | x(12) | | | ? | Role | earole |
3 | euserid_cr | character | x(20) | | | | Created: User | stuser |
4 | date_cr | date | 99/99/9999 | | | | Created: Date | |
5 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
6 | source_cr | character | X(40) | | | | Source creation | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
10 | source_lc | character | X(40) | | | | Source last changed | |
11 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
earolusrix - primary - unique
1 | euserid | character | x(20) | User ID |
2 | roleid | character | x(12) | Role |
earolusr2ix - unique
1 | roleid | character | x(12) | Role |
2 | euserid | character | x(20) | User ID |
Contents > earolusr
ebabnk - Banks1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_code | character | X(6) | | | ? | Bank code | |
3 | bank_path | character | X(200) | | | | Statement path | |
4 | descr | character | X(60) | | | | Description | |
5 | reg_nr | character | X(10) | | | | Registration number | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | x(8) | | | | | |
10 | source_lc | character | x(12) | | | | | |
11 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
12 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
13 | bank_identifier_code | character | X(8) | | | | Bank identifier code | |
14 | xml_definition_code | character | x(12) | | | | XML definition code | stxlinkimp |
15 | print_extra_gmu_data | logical | true/false | | | FALSE | Print extra-comptabel records (GMU) | |
16 | accept_duplicates | logical | true/false | | | FALSE | Accept: Statement duplicates | |
17 | gateway_code | character | X(12) | | | | Gateway | |
18 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ebabnkix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_code | character | X(6) | Bank code |
ebabnk02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | bank_code | character | X(6) | Bank code |
Contents > ebabnk
ebabnk_mt940 - Bank statement: MT940 codes1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_code | character | X(6) | | | ? | Bank code | ebabnk |
3 | bank_statement_entity | integer | >>>>>9 | | | ? | Entity | t_test: bank_stmt_entity |
4 | mt940_code | character | X(30) | | | ? | Code | t_tdsc |
5 | subfield | integer | >9 | | | 0 | Subfield | |
6 | euserid_cr | character | x(20) | | | | Created: User | stuser |
7 | date_cr | date | 99/99/9999 | | | | Created: Date | |
8 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
9 | source_cr | character | X(16) | | | | Source creation | |
10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
13 | source_lc | character | X(16) | | | | Source last changed | |
14 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ebabnk_mt94001ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_code | character | X(6) | Bank code |
3 | bank_statement_entity | integer | >>>>>9 | Entity |
4 | mt940_code | character | X(30) | Code |
Contents > ebabnk_mt940
ebabnk_txcd - Bank statement transaction codes1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_code | character | X(6) | | | ? | Bank code | ebabnk |
3 | transaction_code | character | X(35) | | | ? | Transaction code | |
4 | return_type | integer | >>>>>9 | | | 0 | Type | t_test: sdd_return_type |
5 | reverse_collection | logical | true/false | | | FALSE | Reverse collection | |
6 | update_mandate | logical | true/false | | | FALSE | Update: Mandates | |
7 | euserid_cr | character | x(20) | | | | Created: User | stuser |
8 | date_cr | date | 99/99/9999 | | | | Created: Date | |
9 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
10 | source_cr | character | X(16) | | | | Source creation | |
11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
13 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
14 | source_lc | character | X(16) | | | | Source last changed | |
15 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ebabnk_txcd01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_code | character | X(6) | Bank code |
3 | transaction_code | character | X(35) | Transaction code |
Contents > ebabnk_txcd
ebalnk - Bank links1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | journal_nr | integer | >>9 | | | ? | Journal | |
3 | bank_acc_nr | character | x(34) | | | | Bank account | |
4 | iso_cur_code | character | x(3) | | | | Currency | |
5 | descr | character | X(60) | | | | Description | |
6 | bank_code | character | X(6) | | | | Bank name | |
7 | acc_balance | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Balance accepted | |
8 | acc_date | date | 99/99/9999 | | | | Date accepted | |
9 | acc_seq_nr | int64 | >>>>>>>>>>>9 | | | 0 | Sequence number statement | |
10 | file | character | x(12) | | | | File | |
11 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | type_lc | character | x(8) | | | | | |
15 | source_lc | character | x(12) | | | | | |
16 | proc_bnk | integer | >>9 | | | 0 | Processing bank | |
17 | bnk_curr_code | character | x(3) | | | | Currency code of bank account number | |
18 | reversal_deadline | integer | >>>>>>>9 | | | 0 | Reversal deadline (Days) | |
19 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
Indexes
ebalnkix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | journal_nr | integer | >>9 | Journal |
ebalnk2ix - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | Currency |
Contents > ebalnk
ebasth - Bank statements1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_acc_nr | character | x(34) | | | ? | Bank account | |
3 | iso_cur_code | character | x(3) | | | ? | ISO currency | isocur |
4 | stat_number | int64 | >>>>>>>>>>>9 | | | ? | Statement number | |
5 | date | date | 99/99/9999 | | | | Bank statement: Date | |
6 | tot_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Total amount | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
11 | source_lc | character | x(12) | | | | | |
12 | pay_format | integer | 9 | | | 1 | Bank statement: Format | |
13 | bnk_curr_code | character | x(3) | | | | Currency code of bank account number | |
14 | extra_curr_code | character | X(3) | | | | Extra currency | |
15 | extra_tot_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Extra total amount | |
16 | extra_descr | character | X(30) | | | | Extra description | |
17 | extra_exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Extra exchange rate | |
18 | documents | integer | >>>>>>>> | | | 0 | Documents | |
19 | id | character | X(36) | | | | ID | |
Indexes
ebasthix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | ISO currency |
4 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
5 | date | date | 99/99/9999 | Bank statement: Date |
Contents > ebasth
ebasts - Bank statement (Lines)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_acc_nr | character | x(34) | | | ? | Bank account | |
3 | iso_cur_code | character | x(3) | | | ? | ISO currency | isocur |
4 | stat_number | int64 | >>>>>>>>>>>9 | | | ? | Statement number | ebasth |
5 | stat_line | integer | >>>>>9 | | | ? | Line number | |
6 | entry_date | date | 99/99/9999 | | | | Entry date | |
7 | curr_date | date | 99/99/9999 | | | | Currency date | |
8 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
9 | transaction_proprietary | character | x(35) | | | | Transaction code | |
10 | offset_account | character | x(34) | | | | Offset account | |
11 | name | character | X(60) | | | | Name | |
12 | address_1 | character | x(70) | | | | Address line 1 | |
13 | address_2 | character | x(70) | | | | Address line 2 | |
14 | address_3 | character | x(70) | | | | Address line 3 | |
15 | postal_code | character | x(8) | | | | Postal code | |
16 | city | character | X(60) | | | | City | |
17 | country | character | x(3) | | | | Country | countr |
18 | contact | character | X(60) | | | | Contact | |
19 | ref_debcrd | int64 | >>>>>>>>>9 | | | 0 | Debtor / Creditor | |
20 | ref_entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | |
21 | descr_0 | character | x(32) | | | | Description | |
22 | descr_1 | character | x(32) | | | | Description | |
23 | descr_2 | character | x(32) | | | | Description | |
24 | descr_3 | character | x(32) | | | | Description | |
25 | descr_4 | character | x(32) | | | | Description | |
26 | descr_5 | character | x(32) | | | | Description | |
27 | descr_6 | character | x(32) | | | | Description | |
28 | descr_7 | character | x(32) | | | | Description | |
29 | descr_8 | character | x(32) | | | | Description | |
30 | descr_9 | character | x(32) | | | | Description | |
31 | completed | logical | yes/no | | | no | Itemized | |
32 | rec_state | integer | ->>>>>>>>>9 | | | 0 | Line status | t_test: ebasts_status |
33 | date | date | 99/99/9999 | | | | Bank statement: Date | |
34 | struct_accounce | logical | yes/no | | | no | Structured reference | |
35 | actual_dc_ref | logical | yes/no | | | no | Deb/Cred Ref from statements | |
36 | actual_ent_ref | logical | yes/no | | | no | Entry ref from statement | |
37 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
38 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
39 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
40 | iso_reason_code | character | x(4) | | | | ISO reason code | |
41 | source_lc | character | x(12) | | | | | |
42 | bnk_curr_code | character | x(3) | | | | Currency code of bank account number | |
43 | extra_curr_code | character | X(3) | | | | Extra currency | |
44 | extra_tot_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Extra total amount | |
45 | scenario_code | character | x(12) | | | | Scenario | scencode |
46 | extra_exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Extra exchange rate | |
47 | remittance_unstructured | character | X(140) | | | | Reference | |
48 | remittance_structured | character | X(140) | | | | Structured reference | |
49 | issuer_structured | character | X(35) | | | | Issuer (Structured) | |
50 | additional_entry_info | character | X(500) | | | | Additional entry information | |
51 | transaction_domain | character | X(4) | | | | Domain (Bank transaction) | |
52 | transaction_sub_family | character | X(4) | | | | Sub-family (Bank transaction) | |
53 | transaction_family | character | X(4) | | | | Family (Bank transaction) | |
54 | payment_id | character | X(35) | | | | Payment ID | |
55 | instruction_id | character | X(35) | | | | Instruction ID | |
56 | end_to_end_id | character | X(35) | | | | End-to-end ID | |
57 | mandate_ref | character | X(35) | | | | Mandate reference | |
58 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
EBASTSIX - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | ISO currency |
4 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
5 | date | date | 99/99/9999 | Bank statement: Date |
6 | stat_line | integer | >>>>>9 | Line number |
Contents > ebasts
ebauit - Matched bank statements1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_acc_nr | character | x(34) | | | ? | Bank account | |
3 | iso_cur_code | character | x(3) | | | ? | ISO currency | isocur |
4 | stat_number | int64 | >>>>>>>>>>>9 | | | ? | Statement number | ebasth |
5 | stat_split | integer | >>9 | | | ? | Sequence number | |
6 | ebauit_seqnr_user | integer | >>9 | | | 0 | Line number (User) | |
7 | acc_nr | character | x(12) | | | | General ledger account | ledger |
8 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | debtor |
9 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | credit |
10 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
11 | amt_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
12 | exch_rate | decimal | >>>>9.999999 | 6 | | 1 | Exchange rate | |
13 | diff_code | integer | 9 | | | 1 | Difference code | t_test: diff-code |
14 | entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Outstanding item: Invoice number | debout,crdout,fiecol,fitcol |
15 | date | date | 99/99/9999 | | | | Date | |
16 | descr | character | X(60) | | | | Description | |
17 | vat_code | character | x(3) | | | 0 | VAT code | vattrs |
18 | vat_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | VAT amount DC | |
19 | vat_amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | VAT amount FC | |
20 | project_code | character | x(20) | | | | Project | prmst |
21 | proj_amt_rev | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount revenue | |
22 | proj_amt_exp | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount expenses | |
23 | outst_item_exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Outstanding item: Exchange rate | |
24 | outst_item_amount | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Outstanding item: Amount | |
25 | XXXproj_num_exp | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Number of expenses | |
26 | outst_item_curr_code | character | x(12) | | | | Outstanding item: Currency | curren |
27 | project_cost_center | character | x(12) | | | | Project cost center | ccent |
28 | qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | |
29 | stat_date | date | 99/99/9999 | | | | Bank statement: Date | |
30 | amt_cur_wo_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Discount amount | |
31 | amt_cur_wo_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment charge | |
32 | amt_cur_wo_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment difference | |
33 | amt_cur_wo_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 4 | |
34 | amt_cur_wo_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 5 | |
35 | stat_line | integer | >>>>>9 | | | ? | Line number | ebasts |
36 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
37 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
38 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
39 | type_lc | character | x(8) | | | | | |
40 | source_lc | character | x(12) | | | | | |
41 | rev_type | integer | 9 | | | 0 | Type of revenue/expenses | |
42 | cost_center | character | x(12) | | | | Cost center | ccent |
43 | cost_unit | character | x(12) | | | | Cost unit | cunit |
44 | entry_nr_type | integer | >>>>>9 | | | 1 | Outstanding item: Invoice type | t_test: entry-nr-type |
45 | bnk_curr_code | character | x(3) | | | | Currency code of bank account number | |
46 | project_descr | character | X(60) | | | | Project description | |
47 | cost_cat_code | character | x(12) | | | | Project cost category | prccat |
48 | mdim_code_1 | character | x(12) | | | | Dimension 1 | mdim1 |
49 | result_type | integer | >>>>>9 | | | 0 | Project result type | t_test: pro_result_type |
50 | mdim_code_2 | character | x(12) | | | | Dimension 2 | mdim2 |
51 | mdim_code_3 | character | x(12) | | | | Dimension 3 | mdim3 |
52 | mdim_code_4 | character | x(12) | | | | Dimension 4 | mdim4 |
53 | mdim_code_5 | character | x(12) | | | | Dimension 5 | mdim5 |
54 | run_nr_collection | integer | >>>>9 | | | 0 | Collection: Run number | |
55 | journal_nr_collection | integer | >>9 | | | 0 | Collection: Journal number | journl |
56 | nr_periods_per_alloc | integer | >9 | | | 0 | Number of periods | |
57 | year_start_per_alloc | integer | >>>9 | | | 0 | Start year period allocation | |
58 | period_start_per_alloc | integer | >9 | | | 0 | Start period period allocation | |
59 | installment_nr | integer | >>>>>9 | | | 0 | Collection installment number | |
60 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ebauit01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | ISO currency |
4 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
5 | stat_date | date | 99/99/9999 | Bank statement: Date |
6 | stat_line | integer | >>>>>9 | Line number |
7 | stat_split | integer | >>9 | Sequence number |
ebauit03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | ISO currency |
4 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
5 | stat_date | date | 99/99/9999 | Bank statement: Date |
6 | stat_line | integer | >>>>>9 | Line number |
7 | ebauit_seqnr_user | integer | >>9 | Line number (User) |
ebauit2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | creditor | int64 | >>>>>>>>>9 | Creditor |
4 | entry_nr | int64 | >>>>>>>>>>>9 | Outstanding item: Invoice number |
Contents > ebauit
faelaf - Link assets fin. entries1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | asset_book | character | x(12) | | | ? | Asset book | |
3 | asset_code | character | X(12) | | | ? | Asset | |
4 | date_trans | date | 99/99/9999 | | | | Date | |
5 | trans_nr | integer | ->,>>>,>>9 | | | ? | Number | |
6 | reversed | logical | Yes/No | | | ? | Reversed | |
7 | year | integer | 9999 | | | ? | Financial year | |
8 | period | integer | >>9 | | | ? | Period | |
9 | journal_nr | integer | >>9 | | | ? | Journal | |
10 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | |
11 | linenr_atrss | integer | >>>>>9 | | | ? | Line | |
12 | euserid_cr | character | x(20) | | | | Created: User | stuser |
13 | date_cr | date | 99/99/9999 | | | | Created: Date | |
14 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
15 | source_cr | character | x(12) | | | | Source creation | |
16 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
17 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
18 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
19 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
faelafix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
3 | asset_code | character | X(12) | Asset |
4 | date_trans | date | 99/99/9999 | Date |
5 | trans_nr | integer | ->,>>>,>>9 | Number |
6 | reversed | logical | Yes/No | Reversed |
7 | year | integer | 9999 | Financial year |
8 | period | integer | >>9 | Period |
9 | journal_nr | integer | >>9 | Journal |
10 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
11 | linenr_atrss | integer | >>>>>9 | Line |
faelaf2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | year | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | journal_nr | integer | >>9 | Journal |
5 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
6 | linenr_atrss | integer | >>>>>9 | Line |
7 | asset_book | character | x(12) | Asset book |
8 | asset_code | character | X(12) | Asset |
9 | date_trans | date | 99/99/9999 | Date |
10 | trans_nr | integer | ->,>>>,>>9 | Number |
11 | reversed | logical | Yes/No | Reversed |
Contents > faelaf
fas_asmb - Asset structures1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | asset_code | character | X(12) | | | ? | Parent asset | |
3 | child_asset_code | character | X(12) | | | ? | Child asset | fas_ast |
4 | source_lc | character | x(12) | | | | Source last changed | |
5 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
6 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | type_lc | character | X(8) | | | | Type last changed | |
Indexes
fas_asmbix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_code | character | X(12) | Parent asset |
3 | child_asset_code | character | X(12) | Child asset |
fas_asmb2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | child_asset_code | character | X(12) | Child asset |
3 | asset_code | character | X(12) | Parent asset |
Contents > fas_asmb
fas_ast - Fixed assets1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | master_asset_id | character | x(12) | | | | Asset set | fas_mast |
3 | asset_code | character | X(12) | | | ? | Asset | |
4 | euserid | character | x(20) | | | | Owner | stuser |
5 | curr_code | character | X(3) | | | | Currency | curren |
6 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | credit |
7 | seq_nr_purch | integer | >>>>9 | | | 0 | Purchase seqnr | |
8 | seq_nr_in_purch | integer | >>>>9 | | | 0 | Seqnr in purchase | |
9 | units_of_prod | integer | ->,>>>,>>9 | | | 0 | Units of production | |
10 | sbd_sub | character | x(12) | | | | Sub account | |
11 | x_project_code | character | x(12) | | | | Project | |
12 | cost_center | character | x(12) | | | | Cost center | ccent |
13 | cost_unit | character | x(12) | | | | Cost unit | cunit |
14 | descr | character | X(60) | | | | Description | |
15 | amt_purchase | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Purchase amount | |
16 | amt_curr_purchase | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (Purchase) | |
17 | qty_received | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Quantity received | |
18 | qty_org_in_purch | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Org. qty. in purch. | |
19 | qty_actual | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Actual quantity | |
20 | allocate | logical | yes/no | | | no | Allocate | |
21 | qty_in_seq_purch | decimal | ->>>>>>>>>9.99 | 0 | | 0 | Qty. in purchase seq. | |
22 | previous_state | integer | >>>>>9 | | | 0 | Previous status | |
23 | state | integer | >>>>>9 | | | 0 | Status (Asset) | t_test: asset-state |
24 | department_code | character | x(12) | | | | Department | fas_dept |
25 | ass_mst_replaced | character | x(12) | | | | Replaced asset set | |
26 | ass_code_replaced | character | X(12) | | | | Replaced asset | |
27 | asset_type | integer | >>>>>9 | | | 0 | Asset type | t_test: asset-type |
28 | fin_yr_purchase | integer | 9999 | | | 0 | Fin. year Purch. | |
29 | period_purchase | integer | >>9 | | | 0 | Period purchase | |
30 | date_purchase | date | 99/99/9999 | | | | Purchase date | |
31 | receipt_nr | character | x(12) | | | | Receipt number | |
32 | insured_value | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Insured value | |
33 | insurance_cat | character | X(18) | | | | Insurance category | |
34 | amt_subsidy | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount (Subsidy) | |
35 | date_next_maintenance | date | 99/99/9999 | | | | Date next maint. | |
36 | ownership_type | integer | >>>>>9 | | | 0 | Ownership type | |
37 | location_code | character | x(12) | | | | Location | fas_loc |
38 | date_service | date | 99/99/9999 | | | | Date in use | |
39 | susp_from | date | 99/99/9999 | | | | Suspended from | |
40 | susp_thru | date | 99/99/9999 | | | | Suspended thru | |
41 | source_lc | character | x(12) | | | | Source last changed | |
42 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
43 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
44 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
45 | type_lc | character | X(8) | | | | Type last changed | |
46 | perc_annuity | decimal | >>9.9999 | 2 | | 0 | Percentage annuity | |
47 | exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Exchange rate | |
48 | cost_cat_code | character | x(12) | | | | Cost category | |
49 | project_cost_center | character | x(12) | | | | Cost center | |
50 | project_descr | character | X(30) | | | | Description | |
51 | result_type | integer | >>>>>9 | | | 0 | Result type | |
52 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
53 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
54 | mdim_code_1 | character | x(12) | | | | Dimension 1 | mdim1 |
55 | mdim_code_2 | character | x(12) | | | | Dimension 2 | mdim2 |
56 | mdim_code_3 | character | x(12) | | | | Dimension 3 | mdim3 |
57 | mdim_code_4 | character | x(12) | | | | Dimension 4 | mdim4 |
58 | mdim_code_5 | character | x(12) | | | | Dimension 5 | mdim5 |
59 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_astix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_code | character | X(12) | Asset |
fas_ast11ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | asset_code | character | X(12) | Asset |
fas_astix10
1 | adm_nr | integer | >>>>>9 | Company |
2 | x_project_code | character | x(12) | Project |
3 | asset_code | character | X(12) | Asset |
fas_astix2
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_center | character | x(12) | Cost center |
3 | asset_code | character | X(12) | Asset |
fas_astix3
1 | adm_nr | integer | >>>>>9 | Company |
2 | cost_unit | character | x(12) | Cost unit |
3 | asset_code | character | X(12) | Asset |
fas_astix4
1 | adm_nr | integer | >>>>>9 | Company |
2 | euserid | character | x(20) | Owner |
3 | asset_code | character | X(12) | Asset |
fas_astix5
1 | adm_nr | integer | >>>>>9 | Company |
2 | state | integer | >>>>>9 | Status (Asset) |
3 | asset_code | character | X(12) | Asset |
fas_astix6
1 | adm_nr | integer | >>>>>9 | Company |
2 | department_code | character | x(12) | Department |
3 | asset_code | character | X(12) | Asset |
fas_astix7
1 | adm_nr | integer | >>>>>9 | Company |
2 | location_code | character | x(12) | Location |
3 | asset_code | character | X(12) | Asset |
fas_astix8
1 | adm_nr | integer | >>>>>9 | Company |
2 | master_asset_id | character | x(12) | Asset set |
3 | asset_code | character | X(12) | Asset |
fas_astix9
1 | adm_nr | integer | >>>>>9 | Company |
2 | sbd_sub | character | x(12) | Sub account |
3 | asset_code | character | X(12) | Asset |
Contents > fas_ast
fas_book - Asset books1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | asset_book | character | x(12) | | | ? | Asset book | |
3 | book_calendar | character | x(12) | | | | Calendar | dpr_calm |
4 | curr_code | character | X(3) | | | | Currency | curren |
5 | descr | character | X(60) | | | | Description | |
6 | posting_book | logical | yes/no | | | no | Posting book | |
7 | source_lc | character | x(12) | | | | Source last changed | |
8 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
9 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
11 | type_lc | character | X(8) | | | | Type last changed | |
12 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
13 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
14 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_bookix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
fas_book02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | asset_book | character | x(12) | Asset book |
Contents > fas_book
fas_depr - Asset depreciations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | asset_code | character | X(12) | | | ? | Asset | fas_ast |
3 | asset_book | character | x(12) | | | ? | Asset book | fas_book |
4 | org_base_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Base amount DC (Original) | |
5 | org_base_amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Base amount FC (Original) | |
6 | act_base_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Base amount DC | |
7 | act_base_amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Base amount FC | |
8 | amt_first_depr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount DC (First depreciation) | |
9 | amt_curr_first_depr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (First depreciation) | |
10 | fin_yr_first_depr | integer | 9999 | | | 0 | Year first depreciation | |
11 | period_first_depr | integer | >>9 | | | 0 | Period first depreciation | |
12 | org_salvage_value | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Salvage value DC (Original) | |
13 | org_salvage_value_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Salvage value FC (Original) | |
14 | act_salvage_value | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Salvage value DC | |
15 | act_salvage_value_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Salvage value FC | |
16 | amt_make_up | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Depreciation adjustment | |
17 | amt_curr_make_up | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Depr. adjustment FC | |
18 | org_amt_cum | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount depreciated DC (Entered) | |
19 | org_amt_curr_cum | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount depreciated FC (Entered) | |
20 | act_amt_cum | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount depreciated DC | |
21 | act_amt_curr_cum | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount depreciated FC | |
22 | per_to_depr | integer | ->,>>>,>>9 | | | 0 | Periods to depreciate | |
23 | nr_depr_periods | integer | ->,>>>,>>9 | | | 0 | Periods depreciated | |
24 | period_last_depr | integer | >>9 | | | 0 | Period last depreciation | |
25 | fin_yr_last_depr | integer | 9999 | | | 0 | Year last depreciation | |
26 | xxxamt_to_replace | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amt to replace | |
27 | xxxamt_curr_to_replace | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amt to replace FC | |
28 | amt_corr_depr_when_ent | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount depreciated DC (Entered: Correction) | |
29 | amount_fc_corr_dpr_entered | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount depreciated FC (Entered: Correction) | |
30 | xxxstate | integer | 99 | | | 0 | Not used | |
31 | conv_id | character | x(12) | | | | Convention | |
32 | conv_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Convention amount | |
33 | conv_amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Convention amount FC | |
34 | life_yr | integer | >>9 | | | 0 | Life (Years) | |
35 | life_per | integer | >>9 | | | 0 | Life (Periods) | |
36 | opt_switch | logical | yes/no | | | no | Optimum switch | |
37 | source_lc | character | x(12) | | | | Source last changed | |
38 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
39 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
40 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
41 | type_lc | character | X(8) | | | | Type last changed | |
42 | org_per_depr | integer | ->,>>>,>>9 | | | 0 | Periods depreciated (Original) | |
43 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_deprix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_code | character | X(12) | Asset |
3 | asset_book | character | x(12) | Asset book |
Contents > fas_depr
fas_dept - Departments1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | department_code | character | x(12) | | | ? | Department | |
3 | description | character | X(60) | | | | Description | |
4 | descr_ml | character | X(60) | | 5 | | ML description | |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | date_cr | date | 99/99/9999 | | | | Created: Date | |
7 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
8 | source_cr | character | X(40) | | | | Source creation | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
12 | source_lc | character | X(40) | | | | Source last changed | |
13 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
14 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
15 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_deptix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | department_code | character | x(12) | Department |
fas_dept02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | department_code | character | x(12) | Department |
Contents > fas_dept
fas_grp - Asset groups1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | profile_id | character | x(12) | | | ? | Asset group | |
3 | descr | character | X(60) | | | | Description | |
4 | source_lc | character | x(12) | | | | Source last changed | |
5 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
6 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
8 | type_lc | character | X(8) | | | | Type last changed | |
9 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
10 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
11 | acc_nr_purchase | character | x(12) | | | | Account purchase | ledger |
12 | acc_nr_depreciate | character | x(12) | | | | Account depreciation | ledger |
13 | acc_nr_pl_depreciate | character | x(12) | | | | P&L account depreciation | ledger |
14 | acc_nr_p_profit | character | x(12) | | | | Positive profit account | ledger |
15 | acc_nr_n_profit | character | x(12) | | | | Negative profit account | ledger |
16 | acc_nr_p_reval | character | x(12) | | | | Positive revaluation account | ledger |
17 | acc_nr_n_reval | character | x(12) | | | | Negative revaluation account | ledger |
18 | acc_nr_dispose | character | x(12) | | | | Suspense account | ledger |
19 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_grpix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | profile_id | character | x(12) | Asset group |
fas_grp02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | profile_id | character | x(12) | Asset group |
Contents > fas_grp
fas_loc - Asset: Locations1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | location_code | character | x(12) | | | ? | Location | |
3 | description | character | X(60) | | | | Description | |
4 | descr_ml | character | X(60) | | 5 | | ML description | |
5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
6 | date_cr | date | 99/99/9999 | | | | Created: Date | |
7 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
8 | source_cr | character | X(40) | | | | Source creation | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
11 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
12 | source_lc | character | x(12) | | | | Source last changed | |
13 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
14 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
15 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_locix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | location_code | character | x(12) | Location |
fas_loc02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | location_code | character | x(12) | Location |
Contents > fas_loc
fas_mast - Asset sets1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | master_asset_id | character | x(12) | | | ? | Asset set | |
3 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | |
4 | curr_code | character | X(3) | | | | Currency | |
5 | master_asset_type | integer | >>>>>9 | | | 0 | Type | t_test: master-asset-type |
6 | master_asset_long | character | X(20) | | | | Long asset set | |
7 | item_code | character | X(20) | | | | Item | |
8 | profile_id | character | x(12) | | | | Asset group | fas_grp |
9 | descr | character | X(60) | | | | Description | |
10 | amt_last_purch | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Last purchase price | |
11 | allow_assembled_asset | logical | yes/no | | | no | Link assets | |
12 | asset_card | logical | yes/no | | | no | Keep history | |
13 | tax_perc | decimal | ->>9.99 | 2 | | 0 | Tax burden percentage | |
14 | seq_last_purch | integer | >>>>9 | | | 0 | Last purchase | |
15 | source_lc | character | x(12) | | | | Source last changed | |
16 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
17 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
18 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
19 | type_lc | character | X(8) | | | | Type last changed | |
20 | entity_state | integer | >>>>>9 | | | 0 | State | t_test: entity-state |
21 | term_id | integer | >>>>>>>9 | | | 0 | Term ID | |
22 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_mastix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | master_asset_id | character | x(12) | Asset set |
fas_mast03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | entity_state | integer | >>>>>9 | State |
3 | master_asset_id | character | x(12) | Asset set |
fas_mastix2
1 | adm_nr | integer | >>>>>9 | Company |
2 | master_asset_id | character | x(12) | Asset set |
3 | profile_id | character | x(12) | Asset group |
Contents > fas_mast
fas_mnt - Asset maintenance data1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | asset_code | character | X(12) | | | ? | Asset | fas_ast |
3 | date_last_maintenance | date | 99/99/9999 | | | | Maintenance: Date | |
4 | costs_last_maintenance | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Maintenance: Costs | |
5 | source_lc | character | x(12) | | | | Source last changed | |
6 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
9 | type_lc | character | X(8) | | | | Type last changed | |
10 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_mntix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_code | character | X(12) | Asset |
3 | date_last_maintenance | date | 99/99/9999 | Maintenance: Date |
Contents > fas_mnt
fas_mthl - Asset set in book (Change)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | master_asset_id | character | x(12) | | | ? | Asset set | fas_mast |
3 | asset_book | character | x(12) | | | ? | Asset book | fas_book |
4 | formula_id | character | X(8) | | | | Formula code | stformula |
5 | table_id | character | x(12) | | | | Index table | dpr_idxm |
6 | source_lc | character | x(12) | | | | Source last changed | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | X(8) | | | | Type last changed | |
11 | life_years | integer | >>9 | | | 0 | Life (Years) | |
12 | life_periods | integer | >>9 | | | 0 | Life (Periods) | |
13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_mthlix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | master_asset_id | character | x(12) | Asset set |
3 | asset_book | character | x(12) | Asset book |
fas_mthlix2
1 | adm_nr | integer | >>>>>9 | Company |
2 | master_asset_id | character | x(12) | Asset set |
fas_mthlix3
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
fas_mthlix4
1 | adm_nr | integer | >>>>>9 | Company |
2 | formula_id | character | X(8) | Formula code |
Contents > fas_mthl
fas_prlnk - Link asset trans to project1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | asset_book | character | x(12) | | | ? | Asset book | |
3 | asset_code | character | X(12) | | | ? | Asset | |
4 | date_trans | date | 99/99/9999 | | | | Date | |
5 | trans_nr | integer | ->,>>>,>>9 | | | ? | Number | |
6 | reversed | logical | Yes/No | | | ? | Reversed | |
7 | seqnr_external | integer | >>>>>>>>9 | | | ? | Sequence number | |
8 | euserid_cr | character | x(20) | | | | Created: User | stuser |
9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
10 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
11 | source_cr | character | x(12) | | | | Source creation | |
12 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
14 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
15 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fas_prlnk01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
3 | asset_code | character | X(12) | Asset |
4 | date_trans | date | 99/99/9999 | Date |
5 | trans_nr | integer | ->,>>>,>>9 | Number |
6 | reversed | logical | Yes/No | Reversed |
7 | seqnr_external | integer | >>>>>>>>9 | Sequence number |
fas_prlnk02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_external | integer | >>>>>>>>9 | Sequence number |
3 | asset_book | character | x(12) | Asset book |
4 | asset_code | character | X(12) | Asset |
5 | date_trans | date | 99/99/9999 | Date |
6 | trans_nr | integer | ->,>>>,>>9 | Number |
7 | reversed | logical | Yes/No | Reversed |
Contents > fas_prlnk
fas_prmst - Projects per asset1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | asset_code | character | X(12) | | | ? | Asset | fas_ast |
3 | project_code | character | x(20) | | | ? | Project | prmst |
4 | cost_cat_code | character | x(12) | | | | Project cost category | prccat |
5 | project_cost_center | character | x(12) | | | | Project cost center | ccent |
6 | project_descr | character | X(60) | | | | Project description | |
7 | result_type | integer | >>>>>9 | | | 0 | Result type | |
8 | percentage | decimal | >>9.99 | 2 | | 0 | Percentage | |
9 | euserid_cr | character | x(20) | | | | Created: User | stuser |
10 | date_cr | date | 99/99/9999 | | | | Created: Date | |
11 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
12 | source_cr | character | x(12) | | | | Source creation | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
16 | source_lc | character | x(12) | | | | Source last changed | |
17 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fas_prmst01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_code | character | X(12) | Asset |
3 | project_code | character | x(20) | Project |
fas_prmst02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | project_code | character | x(20) | Project |
3 | asset_code | character | X(12) | Asset |
Contents > fas_prmst
fatlaf - Link assets fin. transactions1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | asset_book | character | x(12) | | | ? | Asset book | |
3 | asset_code | character | X(12) | | | ? | Asset | |
4 | date_trans | date | 99/99/9999 | | | | Date | |
5 | trans_nr | integer | ->,>>>,>>9 | | | ? | Number | |
6 | reversed | logical | Yes/No | | | ? | Reversed | |
7 | seqnr_ledtrs | int64 | >>>>>>>>>9 | | | ? | Sequence number | |
8 | euserid_cr | character | x(20) | | | | Created: User | stuser |
9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
10 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
11 | source_cr | character | x(12) | | | | Source creation | |
12 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
14 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
15 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fatlaf01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | asset_book | character | x(12) | Asset book |
3 | asset_code | character | X(12) | Asset |
4 | date_trans | date | 99/99/9999 | Date |
5 | trans_nr | integer | ->,>>>,>>9 | Number |
6 | reversed | logical | Yes/No | Reversed |
7 | seqnr_ledtrs | int64 | >>>>>>>>>9 | Sequence number |
fatlaf02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_ledtrs | int64 | >>>>>>>>>9 | Sequence number |
3 | asset_book | character | x(12) | Asset book |
4 | asset_code | character | X(12) | Asset |
5 | date_trans | date | 99/99/9999 | Date |
6 | trans_nr | integer | ->,>>>,>>9 | Number |
7 | reversed | logical | Yes/No | Reversed |
Contents > fatlaf
fiecol - Collection runs1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | type_collection | integer | >>>>>9 | | | ? | Collection: Type | t_test: collection-type |
3 | run_nr | integer | >>>>9 | | | ? | Collection: Run number | |
4 | journal_nr | integer | >>9 | | | ? | Journal number | journl |
5 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | debtor |
6 | invoice_nr | int64 | >>>>>>>>>>>9 | | | ? | Invoice number | |
7 | installment_nr | integer | >>>9 | | | ? | Collection installment number | |
8 | type_state | integer | >>>>>9 | | | 0 | Status | t_test: collection-state |
9 | description | character | X(60) | | | | Description | |
10 | curr_code | character | x(3) | | | | Currency | curren |
11 | amount_fc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
12 | amount_dc | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount: DC | |
13 | type_diff_code | integer | >>>>>9 | | | 0 | Difference code | t_test: diff-code |
14 | amount_fc_wo_code_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Discount amount | |
15 | amount_fc_wo_code_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment charge | |
16 | amount_fc_wo_code_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Payment difference | |
17 | amount_fc_wo_code_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 4 | |
18 | amount_fc_wo_code_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 5 | |
19 | bgc_description_1 | character | x(60) | | | | BGC description 1 | |
20 | bgc_description_2 | character | x(60) | | | | BGC description 2 | |
21 | bgc_description_3 | character | x(60) | | | | BGC description 3 | |
22 | type_bank_giro | integer | >>>>>9 | | | 0 | Bank/giro | |
23 | date_invoice_due | date | 99/99/9999 | | | | Invoice: Due date | |
24 | date_run | date | 99/99/9999 | | | | Date (Collection run) | |
25 | amount_fc_original | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC (original) | |
26 | date_original | date | 99/99/9999 | | | | Original date | |
27 | journal_nr_sales | integer | >>9 | | | 0 | Journal number: Sales | journl |
28 | type_invoice | integer | >>>>>9 | | | 1 | Invoice type | t_test: entry-nr-type |
29 | date_processed | date | 99/99/9999 | | | | Date (Processed) | |
30 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
31 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
32 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
33 | source_lc | character | x(12) | | | | | |
34 | mandate_ref | character | X(35) | | | | Mandate reference | |
35 | sequence_type | integer | >>>>>9 | | | 0 | SEPA: Sequence type: Sequence type | t_test: sepa-dd-sequence |
36 | bank_acc_nr | character | x(34) | | | | Bank account | |
37 | curr_code_bank_acc_nr | character | x(3) | | | | Currency (Bank) | curren |
38 | bic | character | x(11) | | | | Bank identifier code | |
39 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fiecol01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | type_collection | integer | >>>>>9 | Collection: Type |
3 | run_nr | integer | >>>>9 | Collection: Run number |
4 | journal_nr | integer | >>9 | Journal number |
5 | debtor | int64 | >>>>>>>>>9 | Debtor |
6 | invoice_nr | int64 | >>>>>>>>>>>9 | Invoice number |
7 | installment_nr | integer | >>>9 | Collection installment number |
fiecol02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | type_collection | integer | >>>>>9 | Collection: Type |
3 | run_nr | integer | >>>>9 | Collection: Run number |
4 | journal_nr | integer | >>9 | Journal number |
5 | type_state | integer | >>>>>9 | Status |
6 | debtor | int64 | >>>>>>>>>9 | Debtor |
7 | invoice_nr | int64 | >>>>>>>>>>>9 | Invoice number |
8 | installment_nr | integer | >>>9 | Collection installment number |
fiecol03ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | debtor | int64 | >>>>>>>>>9 | Debtor |
3 | type_invoice | integer | >>>>>9 | Invoice type |
4 | invoice_nr | int64 | >>>>>>>>>>>9 | Invoice number |
5 | installment_nr | integer | >>>9 | Collection installment number |
fiecol04ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | type_collection | integer | >>>>>9 | Collection: Type |
3 | run_nr | integer | >>>>9 | Collection: Run number |
4 | journal_nr | integer | >>9 | Journal number |
5 | sequence_type | integer | >>>>>9 | SEPA: Sequence type: Sequence type |
6 | debtor | int64 | >>>>>>>>>9 | Debtor |
Contents > fiecol
fielbsf - Link: Bank statement (Historic) to journal entry1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | bank_acc_nr | character | x(34) | | | ? | Bank account | |
3 | iso_cur_code | character | x(3) | | | ? | Currency | |
4 | stat_number | int64 | >>>>>>>>>>>9 | | | ? | Statement number | |
5 | date | date | 99/99/9999 | | | | Date statement | |
6 | stat_line | integer | >>>>>9 | | | ? | Statement line | |
7 | fin_yr | integer | 9999 | | | ? | Financial year | |
8 | period | integer | >>9 | | | ? | Period | |
9 | journal_nr | integer | >>9 | | | ? | Journal | |
10 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | |
11 | linenr_atrss | integer | >>>>>9 | | | ? | Line | |
12 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
14 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
15 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fielbsf01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | Currency |
4 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
5 | date | date | 99/99/9999 | Date statement |
6 | stat_line | integer | >>>>>9 | Statement line |
7 | fin_yr | integer | 9999 | Financial year |
8 | period | integer | >>9 | Period |
9 | journal_nr | integer | >>9 | Journal |
10 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
11 | linenr_atrss | integer | >>>>>9 | Line |
fielbsf02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | journal_nr | integer | >>9 | Journal |
5 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
6 | linenr_atrss | integer | >>>>>9 | Line |
7 | bank_acc_nr | character | x(34) | Bank account |
8 | iso_cur_code | character | x(3) | Currency |
9 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
10 | date | date | 99/99/9999 | Date statement |
11 | stat_line | integer | >>>>>9 | Statement line |
Contents > fielbsf
fielcf - Link collections fin. entries1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | type_collection | integer | >>>>>9 | | | ? | Collection type | |
3 | run_nr | integer | >>>>9 | | | ? | Run number | |
4 | journal_nr_collect | integer | >>9 | | | ? | Bank Journal | |
5 | debtor | int64 | >>>>>>>>>9 | | | ? | Debtor | |
6 | entry_nr | int64 | >>>>>>>>>>>9 | | | ? | Entry number | |
7 | installment_nr | integer | >>>9 | | | ? | Installment | |
8 | year | integer | 9999 | | | ? | Financial year | |
9 | period | integer | >>9 | | | ? | Period | |
10 | journal_nr_entry | integer | >>9 | | | ? | Journal number entry | |
11 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | |
12 | linenr_atrss | integer | >>>>>9 | | | ? | Line | |
13 | euserid_cr | character | x(20) | | | | Created: User | stuser |
14 | date_cr | date | 99/99/9999 | | | | Created: Date | |
15 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
16 | source_cr | character | x(12) | | | | Source creation | |
17 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
18 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
19 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
20 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fielcf01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | type_collection | integer | >>>>>9 | Collection type |
3 | run_nr | integer | >>>>9 | Run number |
4 | journal_nr_collect | integer | >>9 | Bank Journal |
5 | debtor | int64 | >>>>>>>>>9 | Debtor |
6 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
7 | installment_nr | integer | >>>9 | Installment |
8 | year | integer | 9999 | Financial year |
9 | period | integer | >>9 | Period |
10 | journal_nr_entry | integer | >>9 | Journal number entry |
11 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
12 | linenr_atrss | integer | >>>>>9 | Line |
fielcf02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | year | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | journal_nr_entry | integer | >>9 | Journal number entry |
5 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
6 | linenr_atrss | integer | >>>>>9 | Line |
7 | type_collection | integer | >>>>>9 | Collection type |
8 | run_nr | integer | >>>>9 | Run number |
9 | journal_nr_collect | integer | >>9 | Bank Journal |
10 | debtor | int64 | >>>>>>>>>9 | Debtor |
11 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
12 | installment_nr | integer | >>>9 | Installment |
Contents > fielcf
fielfc - Link atrss to comsl1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | year | integer | 9999 | | | ? | Financial year | |
3 | period | integer | >>9 | | | ? | Period | |
4 | journal_nr | integer | >>9 | | | ? | Journal | |
5 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | |
6 | linenr_atrss | integer | >>>>>9 | | | ? | Line | |
7 | seqnr_comtrs | integer | >>>>>>>9 | | | ? | seqnr_comtrs | |
8 | euserid_cr | character | x(20) | | | | Created: User | stuser |
9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
10 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
11 | source_cr | character | x(12) | | | | Source creation | |
12 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
14 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
15 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fielfc01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | year | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | journal_nr | integer | >>9 | Journal |
5 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
6 | linenr_atrss | integer | >>>>>9 | Line |
7 | seqnr_comtrs | integer | >>>>>>>9 | seqnr_comtrs |
fielfc02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_comtrs | integer | >>>>>>>9 | seqnr_comtrs |
3 | year | integer | 9999 | Financial year |
4 | period | integer | >>9 | Period |
5 | journal_nr | integer | >>9 | Journal |
6 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
7 | linenr_atrss | integer | >>>>>9 | Line |
Contents > fielfc
fielif - Link intercompany to finance1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | seqnr_ledtrs | int64 | >>>>>>>>>9 | | | ? | Sequence number | |
3 | adm_nr_target | integer | >>>>>9 | | | ? | Target: Company | |
4 | year_target | integer | 9999 | | | ? | Target: Financial year | |
5 | period_target | integer | >>9 | | | ? | Target: Period | |
6 | journal_nr_target | integer | >>9 | | | ? | Target: Journal number | |
7 | seqnr_atrsh_target | integer | >>>>>>9 | | | ? | Target: Sequence number | |
8 | linenr_atrss_target | integer | >>>>>9 | | | ? | Target: Line | |
9 | euserid_cr | character | x(20) | | | | Created: User | stuser |
10 | date_cr | date | 99/99/9999 | | | | Created: Date | |
11 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
12 | source_cr | character | x(12) | | | | Source creation | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
16 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fielif01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | seqnr_ledtrs | int64 | >>>>>>>>>9 | Sequence number |
3 | adm_nr_target | integer | >>>>>9 | Target: Company |
4 | year_target | integer | 9999 | Target: Financial year |
5 | period_target | integer | >>9 | Target: Period |
6 | journal_nr_target | integer | >>9 | Target: Journal number |
7 | seqnr_atrsh_target | integer | >>>>>>9 | Target: Sequence number |
8 | linenr_atrss_target | integer | >>>>>9 | Target: Line |
fielif02ix
1 | adm_nr_target | integer | >>>>>9 | Target: Company |
2 | year_target | integer | 9999 | Target: Financial year |
3 | period_target | integer | >>9 | Target: Period |
4 | journal_nr_target | integer | >>9 | Target: Journal number |
5 | seqnr_atrsh_target | integer | >>>>>>9 | Target: Sequence number |
6 | linenr_atrss_target | integer | >>>>>9 | Target: Line |
7 | adm_nr | integer | >>>>>9 | Company |
8 | seqnr_ledtrs | int64 | >>>>>>>>>9 | Sequence number |
Contents > fielif
fielpayf - Link: Payment (Historic) to journal entry1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | run_nr | integer | >>>>>>>>9 | | | ? | Run number | |
3 | seqnr_payfmt | integer | >>>>>>>>9 | | | ? | Seq nr. | |
4 | order_nr | integer | ->>>>>>>>9 | | | ? | Order number | |
5 | debcrd | int64 | >>>>>>>>>9 | | | ? | Debtor/Creditor | |
6 | entry_nr_type | integer | >>>>>9 | | | ? | Entry type | |
7 | entry_nr | int64 | >>>>>>>>>>>9 | | | ? | Entry number | |
8 | fin_yr | integer | 9999 | | | ? | Financial year | |
9 | period | integer | >>9 | | | ? | Period | |
10 | journal_nr | integer | >>9 | | | ? | Journal | |
11 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | |
12 | linenr_atrss | integer | >>>>>9 | | | ? | Line | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
16 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fielpayf01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | run_nr | integer | >>>>>>>>9 | Run number |
3 | seqnr_payfmt | integer | >>>>>>>>9 | Seq nr. |
4 | order_nr | integer | ->>>>>>>>9 | Order number |
5 | debcrd | int64 | >>>>>>>>>9 | Debtor/Creditor |
6 | entry_nr_type | integer | >>>>>9 | Entry type |
7 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
8 | fin_yr | integer | 9999 | Financial year |
9 | period | integer | >>9 | Period |
10 | journal_nr | integer | >>9 | Journal |
11 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
12 | linenr_atrss | integer | >>>>>9 | Line |
fielpayf02ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | fin_yr | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | journal_nr | integer | >>9 | Journal |
5 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
6 | linenr_atrss | integer | >>>>>9 | Line |
7 | run_nr | integer | >>>>>>>>9 | Run number |
8 | seqnr_payfmt | integer | >>>>>>>>9 | Seq nr. |
9 | order_nr | integer | ->>>>>>>>9 | Order number |
10 | debcrd | int64 | >>>>>>>>>9 | Debtor/Creditor |
11 | entry_nr_type | integer | >>>>>9 | Entry type |
12 | entry_nr | int64 | >>>>>>>>>>>9 | Entry number |
Contents > fielpayf
fielrf - Link recurring entries to fina1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | journal_nr | integer | >>9 | | | ? | Journal | |
3 | entry_code | character | x(12) | | | ? | Code | |
4 | year | integer | 9999 | | | ? | Financial year | |
5 | period | integer | >>9 | | | ? | Period | |
6 | journal_nr_atrsh | integer | >>9 | | | ? | Journal | |
7 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | |
8 | linenr_atrss | integer | >>>>>9 | | | ? | Line | |
9 | euserid_cr | character | x(20) | | | | Created: User | stuser |
10 | date_cr | date | 99/99/9999 | | | | Created: Date | |
11 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
12 | source_cr | character | x(12) | | | | Source creation | |
13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
15 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
16 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fielrfix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | journal_nr | integer | >>9 | Journal |
3 | entry_code | character | x(12) | Code |
4 | year | integer | 9999 | Financial year |
5 | period | integer | >>9 | Period |
6 | journal_nr_atrsh | integer | >>9 | Journal |
7 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
8 | linenr_atrss | integer | >>>>>9 | Line |
fielrf2ix
1 | adm_nr | integer | >>>>>9 | Company |
2 | year | integer | 9999 | Financial year |
3 | period | integer | >>9 | Period |
4 | journal_nr_atrsh | integer | >>9 | Journal |
5 | seqnr_atrsh | integer | >>>>>>9 | Sequence number |
6 | linenr_atrss | integer | >>>>>9 | Line |
7 | journal_nr | integer | >>9 | Journal |
8 | entry_code | character | x(12) | Code |
Contents > fielrf
fihbsh - History: Bank statements1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_acc_nr | character | x(34) | | | ? | Bank account | |
3 | iso_cur_code | character | x(3) | | | ? | ISO currency | isocur |
4 | stat_number | int64 | >>>>>>>>>>>9 | | | ? | Statement number | |
5 | date | date | 99/99/9999 | | | | Bank statement: Date | |
6 | tot_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Total amount | |
7 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
10 | type_lc | character | x(8) | | | | | |
11 | source_lc | character | x(12) | | | | | |
12 | pay_format | integer | 9 | | | 1 | Payment format | |
13 | bnk_curr_code | character | x(3) | | | | Currency code of bank account number | |
14 | extra_curr_code | character | X(3) | | | | Currency | curren |
15 | extra_tot_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Extra total amount | |
16 | extra_descr | character | X(30) | | | | Extra description | |
17 | extra_exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Extra exchange rate | |
18 | documents | integer | >>>>>>>> | | | 0 | Documents | |
19 | id | character | X(36) | | | | ID | |
Indexes
fihbsh01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | ISO currency |
4 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
5 | date | date | 99/99/9999 | Bank statement: Date |
Contents > fihbsh
fihbsl - History: Bank statement (lines)1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | bank_acc_nr | character | x(34) | | | ? | Bank account | |
3 | iso_cur_code | character | x(3) | | | ? | ISO currency | isocur |
4 | stat_number | int64 | >>>>>>>>>>>9 | | | ? | Statement number | fihbsh |
5 | date | date | 99/99/9999 | | | | Bank statement: Date | |
6 | stat_line | integer | >>>>>9 | | | ? | Line number | |
7 | entry_date | date | 99/99/9999 | | | | Entry date | |
8 | curr_date | date | 99/99/9999 | | | | Currency date | |
9 | amt_def_cur | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount FC | |
10 | transaction_proprietary | character | x(35) | | | | Transaction code | |
11 | offset_account | character | x(34) | | | | Offset account | |
12 | name | character | X(60) | | | | Name | |
13 | address_1 | character | x(70) | | | | Address line 1 | |
14 | address_2 | character | x(70) | | | | Address line 2 | |
15 | address_3 | character | x(70) | | | | Address line 3 | |
16 | postal_code | character | x(8) | | | | Postal code | |
17 | city | character | X(60) | | | | City | |
18 | country | character | x(3) | | | | Country | countr |
19 | contact | character | X(60) | | | | Contact | |
20 | ref_debcrd | int64 | >>>>>>>>>9 | | | 0 | Debtor / Creditor | |
21 | ref_entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | |
22 | descr_0 | character | x(32) | | | | Description | |
23 | descr_1 | character | x(32) | | | | Description | |
24 | descr_2 | character | x(32) | | | | Description | |
25 | descr_3 | character | x(32) | | | | Description | |
26 | descr_4 | character | x(32) | | | | Description | |
27 | descr_5 | character | x(32) | | | | Description | |
28 | descr_6 | character | x(32) | | | | Description | |
29 | descr_7 | character | x(32) | | | | Description | |
30 | descr_8 | character | x(32) | | | | Description | |
31 | descr_9 | character | x(32) | | | | Description | |
32 | completed | logical | yes/no | | | no | Itemized | |
33 | rec_state | integer | ->>>>>>>>>9 | | | 0 | Line status | t_test: ebasts_status |
34 | struct_accounce | logical | yes/no | | | no | Structured reference | |
35 | actual_dc_ref | logical | yes/no | | | no | Deb/Cred Ref from statements | |
36 | actual_ent_ref | logical | yes/no | | | no | Entry ref from statement | |
37 | time_lc | integer | ->,>>>,>>9 | | | ? | Modified: Time | |
38 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
39 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
40 | iso_reason_code | character | x(4) | | | | ISO reason code | |
41 | source_lc | character | x(12) | | | | | |
42 | bnk_curr_code | character | x(3) | | | | Currency code of bank account number | |
43 | extra_curr_code | character | X(3) | | | | Extra currency | |
44 | extra_tot_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Extra total amount | |
45 | scenario_code | character | x(12) | | | | Scenario | scencode |
46 | extra_exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Extra exchange rate | |
47 | remittance_unstructured | character | X(140) | | | | Reference | |
48 | remittance_structured | character | X(140) | | | | Structured reference | |
49 | issuer_structured | character | X(35) | | | | Issuer (Structured) | |
50 | additional_entry_info | character | X(500) | | | | Additional entry information | |
51 | transaction_domain | character | X(4) | | | | Domain (Bank transaction) | |
52 | transaction_sub_family | character | X(4) | | | | Sub-family (Bank transaction) | |
53 | transaction_family | character | X(4) | | | | Family (Bank transaction) | |
54 | payment_id | character | X(35) | | | | Payment ID | |
55 | instruction_id | character | X(35) | | | | Instruction ID | |
56 | end_to_end_id | character | X(35) | | | | End-to-end ID | |
57 | mandate_ref | character | X(35) | | | | Mandate reference | |
58 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
fihbsl01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | bank_acc_nr | character | x(34) | Bank account |
3 | iso_cur_code | character | x(3) | ISO currency |
4 | stat_number | int64 | >>>>>>>>>>>9 | Statement number |
5 | date | date | 99/99/9999 | Bank statement: Date |
6 | stat_line | integer | >>>>>9 | Line number |
Contents > fihbsl
fihpayext - Payment extra data (Historic)1 | adm_nr | integer | >>>>>9 | | | ? | Company | |
2 | run_nr | integer | >>>>>>>>9 | | | ? | Run number | |
3 | seqnr_payfmt | integer | >>>>>>>>9 | | | ? | Seq nr. | |
4 | order_nr | integer | ->>>>>>>>9 | | | ? | Order number | |
5 | seqnr_payext | integer | >>>>>>>>9 | | | ? | Seq nr. | |
6 | ext_str_1 | character | X(40) | | | | Extra string 1 | |
7 | ext_str_2 | character | X(40) | | | | Extra string 2 | |
8 | ext_str_3 | character | X(40) | | | | Extra string 3 | |
9 | ext_int_1 | integer | >>>>>>>>>9 | | | | Extra integer 1 | |
10 | ext_int_2 | integer | >>>>>>>>>9 | | | | Extra integer 2 | |
11 | ext_int_3 | integer | >>>>>>>>>9 | | | | Extra integer 3 | |
12 | ext_date_1 | date | 99/99/9999 | | | | Extra date 1 | |
13 | ext_date_2 | date | 99/99/9999 | | | | Extra date 2 | |
14 | ext_date_3 | date | 99/99/9999 | | | | Extra date 3 | |
15 | ext_log_1 | logical | yes/no | | | | Extra logical 1 | |
16 | ext_log_2 | logical | yes/no | | | | Extra logical 2 | |
17 | ext_log_3 | logical | yes/no | | | | Extra logical 3 | |
18 | ext_dec_1 | decimal | ->>>>>>>>>>>>9.9999999999 | 10 | | | Extra decimal 1 | |
19 | ext_dec_2 | decimal | ->>>>>>>>>>>>9.9999999999 | 10 | | | Extra decimal 2 | |
20 | ext_dec_3 | decimal | ->>>>>>>>>>>>9.9999999999 | 10 | | | Extra decimal 3 | |
21 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
22 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
23 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
24 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
fihpayext01ix - primary - unique
1 | adm_nr | integer | >>>>>9 | Company |
2 | run_nr | integer | >>>>>>>>9 | Run number |
3 | seqnr_payfmt | integer | >>>>>>>>9 | Seq nr. |
4 | order_nr | integer | ->>>>>>>>9 | Order number |
5 | seqnr_payext | integer | >>>>>>>>9 | Seq nr. |
Contents > fihpayext
fihpayfmt - History: Payment formats1 | adm_nr | integer | >>>>>9 | | | ? | Company | admdat |
2 | run_nr | integer | >>>>>>>>9 | | | ? | Payment: Run number | fihpayrun |
3 | seqnr_payfmt | integer | >>>>>9 | | | ? | Sequence number: Payment format | |
4 | journal_nr | integer | >>9 | | | 0 | Journal number | journl |
5 | bank_acc_nr | character | x(34) | | | | Bank account (Journal) | |
6 | bnk_curr_code | character | x(3) | | | | Bank currency (Journal) | curren |
7 | bank_format | integer | >>>>>>>9 | | | 0 | Bank format | t_test: bank-format |
8 | nr_items | integer | ->>>>>>>9 | | | 0 | Number of outstanding items | |
9 | amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | |
| | |