Required Fields:
CustomerCode | BookCode | Rate | Qty
Optional:
Discount , BookRemark , CustomerRemarks , RefNo , CustomerPONO , Transport , ShipName , ShipAddress , SCHOOLNAME , TOLOCATION
Grouping Rule: Each unique CustomerCode + CustomerRemarks combination will create a separate Order.
| Excel Column |
Database Column |
Type |
| CustomerCode | CustomerCode | Required |
| BookCode | BookCode | Required |
| Rate | BookRate | Required |
| Qty | OrderQty | Required |
| Discount | DiscPer (%) | Optional |
| BookRemark | BookRemarks | Optional |
| CustomerRemarks | CustomerRemark | Optional |
| RefNo | CustRef | Optional |
| CustomerPONO | UDF2 | Optional |
| Transport | Transport | Optional |
| ShipName | UDF3 | Optional |
| ShipAddress | UDF4 | Optional |
| SCHOOLNAME | UDF7 | Optional |
| TOLOCATION | TO | Optional |
