Data dictionary atrss - entry lines - 7.20
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 | project_linknr | int64 | >>>>>>>>>9 | | | 0 | Project linknumber | 6 | seqnr_atrsh | integer | >>>>>>9 | | | ? | Sequence number | 7 | linenr_atrss | integer | >>>>>9 | | | ? | Line | 8 | linenr_atrss_user | integer | >>>>>9 | | | 0 | Line number (User) | 9 | date | date | 99/99/9999 | | | | Date | 10 | entry_nr_type | integer | >>>>>9 | | | 1 | Entry type | 11 | entry_nr | int64 | >>>>>>>>>>>9 | | | 0 | Entry number | 12 | entry_nr_col | int64 | >>>>>>>>>>>9 | | | 0 | Entry number totalled entries | 13 | acc_nr | character | x(12) | | | | Account | 14 | descr | character | X(60) | | | | Description | 15 | debtor | int64 | >>>>>>>>>9 | | | 0 | Debtor | 16 | creditor | int64 | >>>>>>>>>9 | | | 0 | Creditor | 17 | invoice_nr_type | integer | >>>>>9 | | | 1 | Invoice type | 18 | invoice_nr | int64 | >>>>>>>>>>>9 | | | 0 | Invoice number | 19 | due_date_invoice | date | 99/99/9999 | | | | Due date invoice | 20 | due_date_surch_1 | date | 99/99/9999 | | | | Due date PayCh/Disc 1 | 21 | due_date_surch_2 | date | 99/99/9999 | | | | Due date payment charge/discount | 22 | vat_code | character | x(3) | | | 0 | VAT code | 23 | amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount | 24 | vat_amt | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | VAT amount | 25 | vat_basis | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | VAT basis amount | 26 | curr_code | character | x(3) | | | | Currency | 27 | exch_rate | decimal | >>>>9.999999 | 6 | | 0 | Exchange rate | 28 | amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Currency amount | 29 | vat_amt_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Currency VAT amount | 30 | diff_code | integer | >>>>>9 | | | 1 | Difference code | 31 | asset_code | character | x(12) | | | | Asset | 32 | XXXarchitect_bytes | character | x(2) | | | | Architect bytes | 33 | vat_amt_atrsh_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount revenue | 34 | amt_atrsh_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount expenses | 35 | XXXproject_qty_revenue | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Number of revenues | 36 | XXXproject_qty_cost | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Number of expenses | 37 | XXXproject_posting | character | x(1) | | | | Project entry posted | 38 | XXXproject_cost_center | character | x(8) | | | | Cost center | 39 | ca_curr_code | character | x(3) | | | | IC Currency | 40 | cost_center | character | x(12) | | | | Cost center | 41 | cost_unit | character | x(12) | | | | Cost unit | 42 | qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | 43 | week_nr | integer | >9 | | | 0 | Week | 44 | pay_ref | character | X(32) | | | | Payment reference | 45 | pay_method | integer | >>>>>9 | | | 0 | Payment method | 46 | surch_disc | integer | >>>>>9 | | | 0 | Payment charge/discount | 47 | amt_credit_surch_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount PayCh/Disc 1 | 48 | amt_credit_surch_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount PayCh/Disc 2 | 49 | fin_yr_transit | integer | 9999 | | | 0 | Transit financial year | 50 | outst_item_created | logical | yes/no | | | no | Outstanding item created | 51 | rev_entry | logical | yes/no | | | no | Reversal entry | 52 | curr_code_extra | character | x(3) | | | | Extra currency | 53 | exch_rate_2 | decimal | >>>>9.999999 | 6 | | 0 | Exchange rate | 54 | exch_rate3 | decimal | >>>>9.999999 | 6 | | 0 | Exchange rate outstanding items | 55 | amt_curr_extra | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Extra currency amount | 56 | amt_outst_def_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Outstanding Amount DC | 57 | amt_outst_curr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Outstanding amount in currency | 58 | amt_cur_wo_code_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 1 | 59 | amt_cur_wo_code_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 2 | 60 | amt_cur_wo_code_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 3 | 61 | amt_cur_wo_code_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 4 | 62 | amt_cur_wo_code_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 5 | 63 | vat_rep_nr | character | x(2) | | | | VAT fiscal representative | 64 | del_acq | integer | >>>>>9 | | | 0 | Supply/acquisition | 65 | pay_condition | character | X(4) | | | | Payment condition | 66 | XXXprepayment | logical | yes/no | | | no | Prepayment | 67 | mcode1 | character | x(12) | | | | Mdim 1 | 68 | mcode2 | character | x(12) | | | | Mdim 2 | 69 | mcode3 | character | x(12) | | | | Mdim 3 | 70 | mcode4 | character | x(12) | | | | Mdim 4 | 71 | mcode5 | character | x(12) | | | | Mdim 5 | 72 | ca_acc_nr | character | x(12) | | | | Account | 73 | ca_cost_center | character | x(12) | | | | Cost center | 74 | ca_cost_unit | character | x(12) | | | | Cost unit | 75 | ca_qty | decimal | ->>>>>>>>>9.99 | 4 | | 0 | Quantity | 76 | source_lc | character | x(12) | | | | | 77 | time_lc | integer | ->,>>>,>>9 | | | ? | | 78 | date_lc | date | 99/99/9999 | | | | | 79 | euserid_lc | character | X(12) | | | | | 80 | type_lc | character | x(8) | | | | | 81 | commitment_nr | int64 | >>>>>>>>>>>9 | | | 0 | Commitment number | 82 | line_nr_lis | integer | >>>9 | | | 0 | Commitment line | 83 | x_flm_amt_costs | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount costs | 84 | x_flm_amt_corr | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount correction | 85 | XXXdelacq_code | integer | 99 | | | 0 | Delivery or acquisition | 86 | due_date_surch_3 | date | 99/99/9999 | | | | Due date PayCh/Disc 3 | 87 | due_date_surch_4 | date | 99/99/9999 | | | | Due date PayCh/Disc 4 | 88 | due_date_surch_5 | date | 99/99/9999 | | | | Due date PayCh/Disc 5 | 89 | amt_credit_surch_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount PayCh/Disc 3 | 90 | amt_credit_surch_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount PayCh/Disc 4 | 91 | amt_credit_surch_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount PayCh/Disc 5 | 92 | period_res | integer | >>9 | | | 0 | Period reserves | 93 | nr_periods_allocation | integer | >>>> | | | 0 | Allocation: Periods | 94 | start_year_allocation | integer | >>>> | | | 0 | Allocation: Start year | 95 | XXXdate_rec | date | 99/99/9999 | | | | Date of reconciliation | 96 | ca_amt_cur_wo_code_1 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 1 | 97 | ca_debtor | int64 | >>>>>>>>>9 | | | 0 | IC debtor | 98 | ca_amt_cur_wo_code_2 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 2 | 99 | ca_credit | int64 | >>>>>>>>>9 | | | 0 | IC creditor | 100 | ca_amt_cur_wo_code_3 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 3 | 101 | ca_invoice_nr | int64 | >>>>>>>>>>>9 | | | 0 | IC invoice number | 102 | ca_amt_cur_wo_code_4 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 4 | 103 | ca_invoice_nr_type | integer | >>>>>9 | | | 1 | IC invoice type | 104 | ca_amt_cur_wo_code_5 | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Amount WO code FC 5 | 105 | ca_diff_code | integer | >>>>>9 | | | 1 | Difference code |
Indexesatrssix - primary - unique1 | 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 |
atrss09ix1 | 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_user | integer | >>>>>9 | Line number (User) |
atrss2ix1 | adm_nr | integer | >>>>>9 | Company | 2 | acc_nr | character | x(12) | Account | 3 | fin_yr | integer | 9999 | Financial year | 4 | period | integer | >>9 | Period |
atrss3ix1 | adm_nr | integer | >>>>>9 | Company | 2 | debtor | int64 | >>>>>>>>>9 | Debtor | 3 | fin_yr | integer | 9999 | Financial year | 4 | period | integer | >>9 | Period |
atrss4ix1 | adm_nr | integer | >>>>>9 | Company | 2 | creditor | int64 | >>>>>>>>>9 | Creditor | 3 | fin_yr | integer | 9999 | Financial year | 4 | period | integer | >>9 | Period |
atrss5ix1 | adm_nr | integer | >>>>>9 | Company | 2 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment number | 3 | line_nr_lis | integer | >>>9 | Commitment line |
atrss6ix1 | 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 | commitment_nr | int64 | >>>>>>>>>>>9 | Commitment number | 7 | line_nr_lis | integer | >>>9 | Commitment line |
atrss7ix1 | adm_nr | integer | >>>>>9 | Company | 2 | debtor | int64 | >>>>>>>>>9 | Debtor | 3 | invoice_nr_type | integer | >>>>>9 | Invoice type | 4 | invoice_nr | int64 | >>>>>>>>>>>9 | Invoice number |
atrss8ix1 | adm_nr | integer | >>>>>9 | Company | 2 | creditor | int64 | >>>>>>>>>9 | Creditor | 3 | invoice_nr_type | integer | >>>>>9 | Invoice type | 4 | invoice_nr | int64 | >>>>>>>>>>>9 | Invoice number |
Contents > atrss
Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
26.936.150 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|