其實我做緊嘅係adjustment
係每個ISIN要有3樣野要做
### Situation 1:
如果 Grand total > 0 (row 8 ?)
- PCEC(Column I): 302210, PCCO: A1311000, Account column: 1020, debit column: Grand Total
- 加多行row:
- PCEC: 921810,
- PCCO: 92100100
- account:8600,
- debit: grand total
- 再加多行row:
- PCEC: 922910,
- PCCO: 98900100
- account:8601,
- Credit: grand total
### Situation 2:
如果Grand total < 0 (row 8 ?)
- PCEC(Column I): 302210, PCCO: A1311000, Account column: 1020, credit column: Grand Total
- 加多行row: PCEC: 922810, PCCO: 92200100, account:8700, credit: grand total
- 再加多行row: PCEC: 921910, PCCO: 98900200, account:8701, debit: grand total
### Situation 3:
如果Grand total = 0
- 咩都唔洗做
### Special case (如果PCCO Code係P1375000):
### Situation 1:
如果Grand total > 0 (missing example)
- PCEC(Column I): 302410, PCCO: P1375000, Account column: 2020, debit column: Grand Total
- 加多行row: PCEC: 921810, PCCO: 92100100, account:8600, debit: grand total
- 再加多行row: PCEC: 922910, PCCO: 98900100, account:8601, credit: grand total
### Situation 2:
如果Grand total < 0 (row 21)
- PCEC(Column I): 302410, PCCO: P1375000, Account column: 2020, credit column: Grand Total
- 加多行row: PCEC: 922810, PCCO: 92200100, account:8700, credit: grand total
- 再加多行row: PCEC: 921910, PCCO: 98900200, account:8701, debit: grand total
### Situation 3:
如果Grand total = 0
- 咩都唔洗做
