data alignment in flat file

[Former Member]

Hi All,

Request yout o help for urgent help. I hava a multiple idoc to single file scenario

i have to produce the format like

DFT@IN@1234567890@INR@ 33540.00@@20060628@2000000110@@@@@@@@@@@@Khandelwal Metal Corporation@B-142,@Faridabad-121001@@01@12312312312@@SBIN0004071@STATE BANK OF INDIA@@@RTGS@@@@@2000000110@Run Id- CDRST , Run Date- 28062006@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@SBIN0004071XXXXX@@@@@@@@@@@@@Faridabad-121001@@@@@

INV@PO NUMBER. INV.REF. DOC. NUM INV.AMOUNT DED. NET.AMOUNT.

INV@ SDASA 2200000274 15000.000.00 15000.00.

INV@ SASAS 2200000275 4500.000.00 4500.00.

INV@ ABCDEF 2200000276 650.000.00 650.00.

INV@ SDSDSDS 2200000277 6500.000.00 6500.00.

INV@ ABCDERJFK 2200000278 6890.000.00 6890.00.

INV@Net amount payable 33540.00.

DFT@IN@1234567890@INR@ 33540.00@@20060628@2000000110@@@@@@@@@@@@Khandelwal Metal Corporation@B-142,@Faridabad-121001@@01@12312312312@@SBIN0004071@STATE BANK OF INDIA@@@RTGS@@@@@2000000110@Run Id- CDRST , Run Date- 28062006@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@SBIN0004071XXXXX@@@@@@@@@@@@@Faridabad-121001@@@@@

INV@PO NUMBER. INV.REF. DOC. NUM INV.AMOUNT DED. NET.AMOUNT.

INV@ SDASA 2200000274 15000.000.00 15000.00.

INV@ SASAS 2200000275 4500.000.00 4500.00.

INV@ ABCDEF 2200000276 650.000.00 650.00.

INV@ SDSDSDS 2200000277 6500.000.00 6500.00.

INV@ ABCDERJFK 2200000278 6890.000.00 6890.00.

INV@Net amount payable 33540.00.

[Former Member]

Hi all,

I am sorry the question is not fully framed.

actually i required data is

DFT@IN@1234567890@INR@ 33540.00@@20060628@2000000110@@@@@@@@@@@@@@@Ksfsffsdfndelwal Metfsfsfsforporation@

INV@PO NUMBER. INV.REF. DOC. NUM INV.AMOUNT DED. NET.AMOUNT.

INV@ SDASA 2200000274 15000.000.00 15000.00.

INV@ SASAS 2200000275 4500.000.00 4500.00.

INV@ ABCDEF 2200000276 650.000.00 650.00.

INV@ SDSDSDS 2200000277 6500.000.00 6500.00.

INV@ ABCDERJFK 2200000278 6890.000.00 6890.00.

DFT@IN@1234567890@INR@ 33540.00@@20060628@2000000110@@@@@@@@@@@@Khasdfsdfsffsfelwal MetsfsffCorporation@

INV@PO NUMBER. INV.REF. DOC. NUM INV.AMOUNT DED. NET.AMOUNT.

INV@ SDASA 2200000274 15000.000.00 15000.00.

INV@ SASAS 2200000275 4500.000.00 4500.00.

INV@ ABCDEF 2200000276 650.000.00 650.00.

INV@ SDSDSDS 2200000277 6500.000.00 6500.00.

INV@ ABCDERJFK 2200000278 6890.000.00 6890.00.

But currently it is coming in flat file like

DFT@IN@1234567890@INR@ 33540.00@@20060628@2000000110@@@@@@@@@@@@@@@Ksfsffsdfndelwal Metfsfsfsforporation@

DFT@IN@1234567890@INR@ 33540.00@@20060628@2000000110@@@@@@@@@@@@Khasdfsdfsffsfelwal MetsfsffCorporation@

INV@PO NUMBER. INV.REF. DOC. NUM INV.AMOUNT DED. NET.AMOUNT.

INV@ SDASA 2200000274 15000.000.00 15000.00.

INV@ SASAS 2200000275 4500.000.00 4500.00.

INV@ ABCDEF 2200000276 650.000.00 650.00.

INV@ SDSDSDS 2200000277 6500.000.00 6500.00.

INV@ ABCDERJFK 2200000278 6890.000.00 6890.00.

INV@PO NUMBER. INV.REF. DOC. NUM INV.AMOUNT DED. NET.AMOUNT.

INV@ SDASA 2200000274 15000.000.00 15000.00.

INV@ SASAS 2200000275 4500.000.00 4500.00.

INV@ ABCDEF 2200000276 650.000.00 650.00.

INV@ SDSDSDS 2200000277 6500.000.00 6500.00.

INV@ ABCDERJFK 2200000278 6890.000.00 6890.00.

my data declaration is like

DTPaymentadvice -> Datatype name

PaymentAdvice -> element for payment details

invoicedetails -> element for invoice details

please let me know how to get this required output and let me know if any more details required

[Former Member]

hi,

I tried with all the possiblities but nothing is work. let me know if anyone have the same scenario.

Regards,

Dhill