How to write IGTAX record for store coupon
Hi ,
In our TLOG for store coupon we are having tax amount so while writing into RTLOG from TLOG whether we need to write single IGTAX record for that transaction or for each line item we need to write this store coupon tax.? Please help.
For example:
STORE_NO
TRAN_DATE
TX_NO
SEQ_NO
TYPE
DTL_TYPE
SKU
DEPARTMENT
QUAN
MST_PRICE
PROMOPRICE
SELL_PRICE
TAX1
TAX_AMT1
CPNSEQNUM
INY_PRORATEDDISCOUNT
778
20130714
8176
1
1
1
1582232
14
1
- 6.49
- 6.49
- 6.49
Y
- 0.576
0
- 1.01
778
20130714
8176
2
1
1
1177680
14
1
- 5.49
- 5.49
- 5.49
Y
- 0.4872
9
- 0.68
778
20130714
8176
3
1
1
1342274
44
1
- 11.99
- 11.99
- 11.99
Y
- 1.0641
0
- 1.88
778
20130714
8176
4
1
1
1429272
54
1
- 8.99
- 8.99
- 8.99
Y
- 0.7979
0
- 1.43
778
20130714
8176
5
1
1
1271717
95
1
1
1
1
N
0
0
0
778
20130714
8176
6
1
1
1271717
95
1
1
1
1
N
0
0
0
778
20130714
8176
9
1
1
1177680
14
1
- 5.49
-1.1
-1.1
N
0
2
0
778
20130714
8176
10
1
1
0
SC
1
0
-5
-5
-0.4438
0
0
778
20130714
8176
11
1
1
0
PS
1
0
0
0
0
0
0
778
20130714
8176
12
1
35
1582232
14
0
0
0
0
0
10
- 1.01
778
20130714
8176
13
1
35
1177680
14
0
0
0
0
0
10
- 0.68
778
20130714
8176
14
1
35
1342274
44
0
0
0
0
0
10
- 1.88
778
20130714
8176
15
1
35
1429272
54
0
0
0
0
0
10
- 1.43
The output looks like below
TITEM1582232
IDISC1582232 - SC1
IGTAX-0.576
TITEM1177680
IDISC1177680 - SC1
IDISC 1177680-Promo
IGTAX-0.4872
TITEM1342274
IDISC1342274 - SC1