Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Select Target Data Format/Target Layout

...

  1. Create an Advance Positional advanced positional Target Data Layout

...

  1. Click on Next to create data mapping > Load Source & Target Schema

...

  • Let's create a variable using the following name: varTP_Code

  • The logic of the conditions: The logic examines the value of the UNB0201 element within the UNB segment of the EDIFACT INVOIC message. Depending on the specific value present in UNB0201, it assigns a corresponding output value:

    • 'O0013000023HELLA-KG-EDIP' corresponds to ['HELLA_EU']

    • 'O0013000023HELLA-KG-HER' corresponds to ['HELLA_EU_HER']

    • 'O0013000023HELLA-KG-BHTC' corresponds to ['HELLA_EU_BHTC']

    • 'O0013000023HELLA-KG-HIS' corresponds to ['HELLA_EU_HIS']

    • Any other value corresponds to ['ERROR']

Condition applied : "WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-EDIP' } VALUE=['HELLA_EU' ]
WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-HER' } VALUE=['HELLA_EU_HER' ]
WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-BHTC' } VALUE=[ 'HELLA_EU_BHTC']
WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-HIS' } VALUE=[ 'HELLA_EU_HIS']
OTHERWISE VALUE=['ERROR' ]"

...

  • Let's create a variable using the following name: varNAD_ST_0201

Condition applied: $Input_EDIFACT_D07A_INVOIC/EDIRoot/TS_INVOIC/Loop2_NAD/NAD[NAD01='ST']/NAD02/NAD0201"

The logic of the above condition :

  • The system directs its attention to the section of the message dedicated to storing address information.

  • Within this section, it specifically searches for the address type denoted as "ST", which signifies the ship-to address.

  • Subsequently, it extracts the identification code assigned to the ship-to party from this address segment.

...

  • Let's create a variable using the following name: varTp_loc

Condition applied: WHEN CONDITION{ $varNAD_ST_0201='1014'} VALUE=['SBI1014' ]
WHEN CONDITION{ $varNAD_ST_0201='1015'} VALUE=[ 'SBI1015']
WHEN CONDITION{ $varNAD_ST_0201='1000'} VALUE=['SBI1000' ]
WHEN CONDITION{ $varNAD_ST_0201='1025'} VALUE=[ 'SBI1025']
WHEN CONDITION{ $varNAD_ST_0201='1263'} VALUE=['SBI1263' ]
OTHERWISE VALUE=[ 'ERROR']

The Logic of the above condition :

  • Check the variable: It checks the value of a variable called $varNAD_ST_0201.

  • Assign specific values: Based on the value of $varNAD_ST_0201, it assigns a corresponding output:

    • If $varNAD_ST_0201 is '1014', the output is ['SBI1014'].

    • If $varNAD_ST_0201 is '1015', the output is ['SBI1015'].

    • If $varNAD_ST_0201 is '1000', the output is ['SBI1000'].

    • If $varNAD_ST_0201 is '1025', the output is ['SBI1025'].

    • If $varNAD_ST_0201 is '1263', the output is ['SBI1263'].

  • Default output: If the value of $varNAD_ST_0201 does not match any of the specified values, the output is ['ERROR'].

...

  • Let's create a variable using the following name: varLANtax_amt

Condition applied: round( $Input_EDIFACT_D07A_INVOIC/EDIRoot/TS_INVOIC/Loop26_LIN/Loop27_MOA/MOA/MOA01/MOA0102 * 0.19,2)

The logic of the above condition: The process involves extracting a particular monetary figure from an electronic invoice, computing 19% of that amount, and subsequently rounding the outcome to two decimal places.

...

  • Let's create a variable using the following name: varNAD_BY

Condition applied: $Input_EDIFACT_D07A_INVOIC/EDIRoot/TS_INVOIC/Loop2_NAD/NAD[NAD01='BY']/NAD02/NAD0201

The logic of the above condition: Putting it all together, the condition is seeking the initial sub-element of the second element (NAD0201 within NAD02) in the Name and Address (NAD) segment, which is designated as of the Buyer ('BY') in an electronic invoice document.

In more straightforward terms, it locates a particular address detail for the buyer in an electronic invoice.

...

  • Let's create a variable using the following name: varTP_BILL_LOC

Condition applied: WHEN CONDITION{ $varNAD_BY='317050'} VALUE=[ 'SBI1014']
WHEN CONDITION{ $varNAD_BY='317051'} VALUE=['SBI1015' ]
WHEN CONDITION{ $varNAD_BY='317052'} VALUE=['SBI1000' ]
WHEN CONDITION{ $varNAD_BY='317053'} VALUE=[ 'SBI1025']
WHEN CONDITION{ $varNAD_BY='317054'} VALUE=['SBI1263' ]
OTHERWISE VALUE=[ 'ERROR']

The logic of the above condition: In more straightforward terms, based on the value stored in $varNAD_BY, one of the designated values ('SBI1014', 'SBI1015', 'SBI1000', 'SBI1025', 'SBI1263') will be allocated. If $varNAD_BY does not correspond to any of these particular values, it will default to 'ERROR'. This configuration enables varied results depending on the value of $varNAD_BY.

...

  1. We implement the For Each operation at the top level on the destination side.

...

 Steps to Turn on the Transaction

After you have Saved saved and Exit Exited the Transaction transaction page. , You will be asked to Turn on the transaction

...

  • Navigate to the Dashboard to access execution details. The Status column will indicate the current status of the transaction.

  • Select the execution icon located under Action to delve into specific information about the transaction.

  • To gain insights into each step's execution details, click on the information icon corresponding to that particular step.

  • For additional transaction details, expand by clicking on the More arrow within the Action menu.

 

EDI Dashboard and EDI X12 EDIFACT Interchange logs

Logs provide runtime details about the inbound and outbound transactions.

...