RE: VTB: Updated System Fields in Master Table and Event Master

7 views

Skip to first unread message

Praiwon Onmung

unread,

Apr 7, 2014, 6:29:33 AM4/7/14

to Sahapak Manopimok, Kamutpornthitaree Walachanat, csth...@googlegroups.com

พุด

พี่ขอ standard VTB ที่เรากำลัง dev กันอีกรอบนะ เนื่องจาก version เดิมมั่วมากและ ที่นี่ค่อนข้างสติ๊ก filed พวกนี้มาก

D_CREA_DATE, TRX_DT, C_USER_ID, D_RELE_DATE, D_RELE_BY, C_MODULE, C_CREA_BY

ถ้าเรา create แล้วค่ามันเป็นอะไร และถ้าเอารายการพวกนี้ไปทำต่อมันจะ update ขนาดไหน

- Master

- Event

--
Best Regards,

Praiwon Onmung
Support Director

China Systems (Thailand) Co., Ltd.
21/10 Soi Ruamrudee 1, Ploenchit Rd
Lumpini, Pathumwan, Bangkok 10330
Tel: (662) 650 7915
Fax: (662) 650 7914
Mobile: (6681) 551 9313

From: Praiwon Onmung [mailto:prai...@chinasystems.com]
Sent: Monday, April 07, 2014 4:15 PM
To: 'Sahapak Manopimok'; 'Kamutpornthitaree Walachanat'
Cc: 'Anchana Khunnangsue'
Subject: RE: VTB: Updated System Fields in Master Table and Event Master

พุดช่วยสรุปอีกทีได้ปะว่าเค้ายืนยันแบบไหนไอ้ field พวกนี้อะ

From: Sahapak Manopimok [mailto:sah...@chinasystems.com]
Sent: Wednesday, March 05, 2014 4:28 PM
To: Kamutpornthitaree Walachanat; Praiwon Onmung
Cc: Anchana Khunnangsue
Subject: Fwd: VTB: Updated System Fields in Master Table and Event Master

เรียนพี่เอ๊ะ พี่ส่วง

FWD เมลล์ที่ Lili ส่งมาเรื่อง C_MODULE, system fields.....

พุดจะเขียนตอบไปประมาณนี้นะคะ C_USER_ID ใช้ mapping report และ C_MODULE ใช้สำหรับอะไรดีคะ

ขอบคุณค่ะ

---------- Forwarded message ----------
From: Lili Chen <lili...@chinasystems.com>
Date: Wed, Mar 5, 2014 at 1:57 PM
Subject: Re: VTB: Updated System Fields in Master Table and Event Master
To: Alec Hui <ale...@chinasystems.com>
Cc: Sahapak Manopimok <sah...@chinasystems.com>

Dear Alec,

Would you please kindly explain why you need to use C_USER_ID field? It's advised to use the field C_MODULE,D_CREA_DATE,C_CREA_BY,C_RELE_BY in LEDGER table. The meaning of field C_CREA_BY and C_RELE_BY is more clearly that C_USER_ID field. And these field can be filled with right value now, please refer the attachment for detail.

If you still need to use C_USER_ID field, please response us. And please note that it may take much more time to fix this issue because it covers a broad.

Any problems, please contact us freely. Thanks!

Best Regards,

Lili

On Thu, Feb 27, 2014 at 9:55 AM, Lili Chen <lili...@chinasystems.com> wrote:

Dear Alec,

I have checked this issue in our test environment, the result is as below:

After confirm Register LC function, system inserts record into IMLC_MASTER table, but C_MODULE is null. C_USER_ID,D_CREA_DATE are with the right value.

For IMLC_LC_EVENT table,C_MODULE,C_USER_ID are null, D_CREA_DATE is with the right value.

Change another user to release, after release this transaction, no fields (C_MODULE,C_USER_ID,D_CREA_DATE) are changed.

And I have transferred this issue to engineer for further analysis.

Any update info, I will inform you asap.

Best Regards,

Lili

On Wed, Feb 26, 2014 at 3:53 PM, Alec Hui <ale...@chinasystems.com> wrote:

Hi Lili

Please check SD whether it can be fixed?

C_MODULE, can system update the value for each transaction?
For C_USER_ID, can system update the value in master table after released? because in IMLC already used this field to mapping

Best Regards

Alec

发件人: Sahapak Manopimok [mailto:sah...@chinasystems.com]
发送时间: Wednesday, February 26, 2014 3:49 PM
收件人: Alec Hui
抄送: Kamutpornthitaree Walachanat; Vachira Arunyakasem; Praiwon Onmung; Panupap Ayutaya
主题: Re: VTB: Updated System Fields in Master Table and Event Master

Hi Alec,

I can not re-create step which system do not update D_CREA_DATE as I show you. And I have questions as below.

C_MODULE, can system update the value for each transaction?
For C_USER_ID, can system update the value in master table after released? because in IMLC already used this field to mapping

Thank you

On Wed, Feb 26, 2014 at 10:43 AM, Sahapak Manopimok <sah...@chinasystems.com> wrote:

Hi Alec,

Please kindly to check, how the system fields can updated?. In attached file, there are the cases in EXLC for Advice and Transfer LC.

Thank you very much

--
Best Regards,

Sahapak Manopimok
Product Consultant
China Systems (Thailand) Co., Ltd. 21/10 Soi Ruamrudee 1, Ploenchit Rd
Lumpini, Pathumwan, Bangkok 10330
Tel No. 662 650 7915
Fax No. 662 650 7914

Reply all

Reply to author

Forward

0 new messages