file start stop invoice pay chronology zer sta sto inv pay start stop invoice pay
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
 
This page converts the chronology prefix of invoice folders and files into dates (in YYYY-MM-DD) format. The prefix is constructed from 4 ordered date elements. The 1st element represents the billing period's start date, the 2nd is the billing period's end date, the third is the invoice date, and the forth is the payment date. The code "+E" at any of these 4 positions signifies the unavailability of the date. All empty elements of the leading positions are omitted. The chronology prefix starts only from the first available non-empty date element. All the following positions must be shown, and empty positions marked by "+E". The last element (empty or not) represents always the payment date. The first available date element of the prefix is provided in yymmdd 6-digit format. Following elements are provided as positive or negative increments in days.

Chronology prefix is followed by other fields in the filenames separated by commas. The first field of the file is always the chronology. The second field is the 2-letter account code in charge of the invoice. The third field is the amount, .positive in case of an invoice and negative in case of a payment. The forth element is the balance of the open invoice (i.e. the remaining amount to pay). The fifth and sixth fields are the beneficiary and the reason. These filenames are used for invoices, payment orders, and folders representing open balances.
 
Converts dates to prefx (web page) [go]  
Converts dates to prefx (excel file) [xls]  
Converts prefix to dates (web page) [go]  
Converts prefix to dates (excel file) [xls]  
This web page's mirror #1 [go]  
This web page's mirror #2 [go]