| # External Integration Transactions Now, the system is ready to receive financial integration transactions from an external source. One of the most obvious methods to import external transactions into the Financials integration transactions tables, is to make use of an exchange scheme, as was done for previous LN versions. The following sections list the requirements for the logged transactions. These database tables are involved: Integration transactions (tfgld482) Logged elements (tfgld481) Unmapped/unposted integration transactions (tfgld487) GL code by integration transaction (tfgld486), if GL codes are involved Integration transactions must be logged in pairs (in tfgld482): a credit transaction and an accompanying debit transaction. Both transactions will be stored in the same financial company, which is the financial company of the credit transaction (this is important for intercompany postings). Both transactions must be assigned the same GUID (see below). The transactions will refer to the same unmapped/unposted data in (tfgld487). Each integration transaction can have a set of related logged elements (tfgld481). If the integration transaction has a GL code attached, an additional row must be stored in (tfgld486). If a GL code is used, the mapping scheme will be bypassed in determining ledger account and dimensions, and the transactions will be posted to the ledger account and dimensions defined for the GL code. Integration transactions (tfgld482) This table contains the individual integration transactions. Note Related debit and credit transactions must have the same GUID assigned.
Field | Description | Format | Domain | Mandatory * | Comments
--- | --- | --- | --- | --- | ---
guid | globally unique identifier | str(22) | tcguid | Yes | must be the same for related debit and credit transactions; to be assigned using function uuid.generate$()
dbcr | debit/credit indicator | enum | tfgld.dbcr | Yes |
ocmp | source logistic company | int(3) | tcncmp | Yes | logistic company in which the business object resides; must be the same for related debit and credit transactions
idtc | integration document type | str(8) | tcidty | Yes | must be the same for related debit and credit transactions; refers to tfgld457.idtc
trdt | transaction date | utc date | tcdate | Yes | date on which, among others, the document date will be based; must be the same for related debit and credit transactions
tcmp | logistic company | int(3) | tcncmp | Yes | same as source logistic company (tfgld482.ocmp)
secd | sort element | str(12) | tfgld.elcd | No | soft reference to tfgld456.elcd; must only be filled if the sort element functionality is used
seva | sort element value | str(50) | tcelva | No | belongs to tfgld482.secd
rbon | business object | str(17) | tcbona | Yes | must be the same for related debit and credit transactions; refers to tfgld454.bona
rbid | business object ID | str(11) | tcboid | Yes | must be the same for related debit and credit transactions; the ID of the business object, for example, the purchase order number in case of a purchase order
rpon | sort position | long(8) | tcsopo | No | must be the same for related debit and credit transactions; used in indices for detailed sorting by business object (see indices tfgld482), among others, used in Integration Transactions (tfgld4582m000)
obre | business object reference | str(40) | tcborf | No | must be the same for related debit and credit transactions; extension of the business object ID, to specify more precisely what origin the transaction relates to; first part should be the same as tfgld482.rpon
buid | business object reference GUID | str(22) | tcguid | No | leave empty: not used externally
bpid | business partner | str(9) | tccom.bpid | No | soft reference to tccom100; business partner that should be logged with the transaction in the General Ledger
ttyp | transaction type | str(3) | tfgld.ttyp | No | leave empty; determined during posting
docn | document number | long(8) | tfgld.docn | No | leave empty; determined during posting
btno | batch number | long(6) | tfgld.btno | No | leave empty; determined during posting
lino | line number | long(8) | tfgld.lino | No | leave empty; determined during posting
sint | transaction status | enum | tfgld.ints | Yes | must be set to tfgld.ints.mapped if a GL code is involved, otherwise must be defaulted to tfgld.ints.logged
crdt | creation date | utc date | tcdate | Yes | must be the same for related debit and credit transactions; the date of the actual creation of the integration transaction
crus | user (creation) | str(16) | tfgld.user | Yes | user ID (logname$) of the user who logs the transaction; must be the same for related debit and credit transactions
usgr | financial user group | str(6) | tfgld.usgr | No | refers to tfgld435; to be retrieved from tfgld436 for tfgld482.crus; however, does not need to exist
pous | user (posting) | str(16) | tfgld.user | No | leave empty; determined during posting
podt | posting date | utc date | tcdate | No | leave empty; determined during posting
prin | printed | enum | tcyesno | Yes | value: tcyesno.no
glcu | GL code used | enum | tcyesno | Yes | value must be set to tcyesno.yes if a GL code is used, otherwise tcyesno.no
fcom | financial company | int(3) | tcncmp | Yes | financial company to whose General Ledger the transaction must be posted; can differ between the credit transaction and the debit transaction it belongs to; for the credit transaction, it must always be the financial company in which the integration transactions are logged (the physical financial company)
leac | ledger account | str(12) | tfgld.leac | No | must be empty if no GL code is used; otherwise, it must be filled by retrieval from tfgld475
dim1 | dimension 1 | str(6) | tfgld.dimx | No | see tfgld482.leac
dim2 | dimension 2 | str(6) | tfgld.dimx | No | see tfgld482.leac
dim3 | dimension 3 | str(6) | tfgld.dimx | No | see tfgld482.leac
dim4 | dimension 4 | str(6) | tfgld.dimx | No | see tfgld482.leac
dim5 | dimension 5 | str(6) | tfgld.dimx | No | see tfgld482.leac
amnt | transaction amount | double | tfgld.amnt | Yes | must be the same for related debit and credit transactions; must be properly rounded; zero can be a valid value
ccur | transaction currency code | str(3) | tcccur | Yes | must be the same for related debit and credit transactions; refers to tcmcs002
ratd | currency rate date | utc date | tcdate | Yes | date for which the currency rates towards the home currencies have been retrieved; probably equal to tfgld482.trdt
rtyp | currency rate type | str(3) | tcrtyp | Yes | rate type used in the home amounts calculation; will probably be equal to the (financial) company’s internal rate type (tcemm170.exeu)
rate | currency rates | double (array) | tcratc | Yes | rates towards the transaction’s financial company’s home currencies; can be retrieved using the standard tcemm.dll5000/5010 functions
ratf | currency rate factors | long(6) (array) | tcratf | Yes | rate factors towards the transaction’s financial company’s home currencies; can be retrieved using the standard tcemm.dll5000/5010 functions
eibc | express in base currency indicators | enum (array) | tcyesno | Yes | Express in Base Currency indicators towards the transaction’s financial company’s home currencies; can be retrieved using the standard tcemm.dll5000/5010 functions
amth | amounts in home currency | double (array) | tfgld.amnt | Yes | amounts in the transaction’s financial company’s home currencies; can be calculated using the standard tcemm.dll5000/5010 functions; must be properly rounded after calculation
cuni | the quantity’s unit | str(3) | tccuni | No | refers to tcmcs001; must be filled if a quantity is logged
nuni | quantity | double | tfgld.quan | No | belongs to tfgld482.cuni
fyer | financial year | int(4) | tfgld.year | Yes | see tfgld482.fprd
fprd | financial period | int(2) | tfgld.prod | Yes | must be filled, and must exist in tfgld005; can be determined based on tfgld482.trdt (transaction date and financial period should preferably be in line)
ryer | reporting year | int(4) | tfgld.year | No | mandatory if reporting periods are used; see tfgld482.fyer
rprd | reporting period | int(2) | tfgld.prod | No | mandatory if reporting periods are used; see tfgld482.fprd
tyer | tax year | int(4) | tfgld.year | Yes | see tfgld482.fyer
tprd | tax period | int(2) | tfgld.prod | Yes | see tfgld482.fprd
mscd | used mapping scheme code | str(6) | tfgld.mscd | No | leave empty; determined during mapping
msvs | used mapping scheme version | long(5) | tfgld.msvs | No | leave empty; determined during mapping
* For external data, this setting may be different from the table field’s property. Logged elements (tfgld481) This table contains the logged elements by integration transaction, which elements will be used for mapping of the integration transaction.
Field | Description | Format | Domain | Mandatory * | Comments
--- | --- | --- | --- | --- | ---
guid | globally unique identifier | str(22) | tcguid | Yes | soft reference to tfgld482.guid
dbcr | debit/credit indicator | enum | tfgld.dbcr | Yes | soft reference to tfgld482.dbcr
seqn | sequence number | int(4) | tcpono | Yes | sequence number to extend the primary key; initial 30 elements must be stored in row with sequence number 1, next 30 elements in row number 2, and so on.
elcd | element codes | str(12) (array) | tfgld.elcd | Yes | each element (softly) refers to tfgld456.elcd; elements with empty values do not need to be logged
elva | element values | str(50) | tcelva | Yes | belongs to tfgld481.elcd
* For external data, this setting may be different from the table field’s property. Unmapped/unposted integration transactions (tfgld487) This table contains the integration transactions pairs, and will be used during mapping and posting. This table is a parent table of tfgld482.
Field | Description | Format | Domain | Mandatory * | Comments
--- | --- | --- | --- | --- | ---
guid | globally unique identifier | str(22) | tcguid | Yes | = tfgld482.guid
sint | transaction status | enum | tfgld.ints | Yes | value: tfgld.ints.logged
ocmp | source logistic company | int(3) | tcncmp | Yes | = tfgld482.ocmp
fcom | credit financial company | int(3) | tcncmp | Yes | the credit transaction’s financial company
rbon | business object | str(17) | tcbona | Yes | = tfgld482.rbon
idtc | integration document type | str(8) | tcidty | Yes | = tfgld482.idtc
trdt | transaction date | utc date | tcdate | Yes | = tfgld482.trdt
usgr | financial user group | str(6) | tfgld.usgr | No | = tfgld482.usgr
crdt | creation date | utc date | tcdate | Yes | = tfgld482.crdt
* For external data, this setting may be different from the table field’s property. GL code by integration transaction (tfgld486) This table shows the GL code that was used in an integration transaction.
Field | Description | Format | Domain | Mandatory * | Comments
--- | --- | --- | --- | --- | ---
guid | globally unique identifier | str(22) | tcguid | Yes | = tfgld482.guid
dbcr | debit/credit indicator | enum | tfgld.dbcr | Yes | = tfgld482.dbcr
fcom | financial company | int(3) | tcncmp | Yes | = tfgld482.fcom; soft reference to tfgld475.fcmp
glco | GL code | str(50) | tcglco | Yes | soft reference to tfgld475.glcd
* For external data, this setting may be different from the table field’s property. |