How to map journal fields and whats is the better process type

[Former Member]

/Journal/JournalSuspenseCostCentre NULL

/Journal/JournalBalancingCentre Lookup from Organisation ID

/Journal/JournalMultiCompany u2018Nu2019

/Journal/JournalBatchNumber NULL

/Journal/JournalNumTransactions Total number of /Journal/JournalLine transactions

/Journal/JournalBaseDRTotal Sum of /Journal/JournalLine/JournalLineBaseValue u2013 Debit Values only

/Journal/JournalBaseCRTotal Sum of /Journal/JournalLine/JournalLineBaseValue u2013 Credit Values only

How to map journal fields and whats is the better process type idoc/proxies?please let me know

Journal Line

Multiple journal lines per header:

Schema Element Data

/Journal/JournalLine/JournalLineCostCentre Bank account control Cost Centre

/Journal/JournalLine/JournalLineAccount Bank account control Account Code

/Journal/JournalLine/JournalLineMoneyTotal Transaction Line Amount

/Journal/JournalLine/JournalLineVolume NULL

/Journal/JournalLine/JournalLineDescription Payee Name

/Journal/JournalLine/JournalLineChequeBookReference NULL

/Journal/JournalLine/JournalLineMatchField Cheque Number

NB Contra accounting entries should be posted to:

Schema Element Data

/Journal/JournalLine/JournalLineCostCentre Bank account control Cost Centre

/Journal/JournalLine/JournalLineAccount Bank account control Account Code

/Journal/JournalLine/JournalLineMoneyTotal Transaction Line Amount * -1

/Journal/JournalLine/JournalLineDescription Payee Name

/Journal/JournalLine/JournalLineMatchField Cheque Number

/Journal/JournalPeriod Current General Ledger Period

/Journal/JournalYear Current General Ledger Year

[rajasekhar_reddy14 · Accepted solution]

Did functional team shared any mapping document how to build mapping logic.

[Former Member]

please could you explain me how to map these fields and what are functions i can use

[rajasekhar_reddy14]

It looks you are new to PI,

you have to develop scenario end to end, by creating source data type and target data type(if you have XSD's not required),then use Graphical mapping (message mapping) to map source and target structures.

Search in sdn for one end to end scenario you will understand easily

Regards,

Raj

[Former Member]

yes this is the mapping sheet they have shared and it contains these are the fields need to map