File CustomerSurplusAsIncome, used execute current surpluses as income for specific customers
Name convention
CustomerSurplusAsIncome_<OwnerCode>_<YYYYMMDDHHMMSS>_<SeqNo>.CSV
| Names Component | Description |
|---|---|
| OwnerCode | The company number in PayEx ledger system |
| DateTime | The date and time that the file was created. Uses ISO 8601 format, YYYYMMDDhhmmss |
| SeqNo | Should follow an uninterupted number series, 00001 and so on. |
E.g. CustomerSurplusAsIncome_123_20210127084304_2
File content format
ReferenceId;CustomerNo;Amount
| Column | Name | Description |
|---|---|---|
| 1 | ReferenceId | Custom referenceid that will be attached to the "surplus as income" transaction |
| 2 | CustomerNo | CustomerNo of the customer to execute surplus as income |
| 3 | Amount | The total amount of the customers surplus to be changed as income, (must be total) |
Example
Download sample file
Input (sent to PayEx):