[#4303] Filtrage sur cmpcode
[auf_coda_additions.git] / db / procedures / auf_p_Balance_VerificationAUF.sql
CommitLineData
8813ca10
EMS
1ÿþU\0S\0E\0 \0[\0c\0o\0d\0a\0-\0p\0r\0o\0d\0]\0
2\0G\0O\0
3\0
4\0D\0R\0O\0P\0 \0P\0R\0O\0C\0E\0D\0U\0R\0E\0 \0[\0d\0b\0o\0]\0.\0[\0a\0u\0f\0_\0p\0_\0B\0a\0l\0a\0n\0c\0e\0_\0V\0e\0r\0i\0f\0i\0c\0a\0t\0i\0o\0n\0A\0U\0F\0]\0
5\0G\0O\0
6\0
7\0S\0E\0T\0 \0A\0N\0S\0I\0_\0N\0U\0L\0L\0S\0 \0O\0N\0
8\0G\0O\0
9\0S\0E\0T\0 \0Q\0U\0O\0T\0E\0D\0_\0I\0D\0E\0N\0T\0I\0F\0I\0E\0R\0 \0O\0N\0
10\0G\0O\0
11\0-\0-\0 \0B\0a\0t\0c\0h\0 \0s\0u\0b\0m\0i\0t\0t\0e\0d\0 \0t\0h\0r\0o\0u\0g\0h\0 \0d\0e\0b\0u\0g\0g\0e\0r\0:\0 \0S\0Q\0L\0Q\0u\0e\0r\0y\01\0.\0s\0q\0l\0|\07\0|\00\0|\0C\0:\0\\0U\0s\0e\0r\0s\0\\0a\0d\0m\0i\0n\0_\0e\0m\0\\0A\0p\0p\0D\0a\0t\0a\0\\0L\0o\0c\0a\0l\0\\0T\0e\0m\0p\0\\02\0\\0~\0v\0s\08\0A\0B\0E\0.\0s\0q\0l\0
12\0
13\0-\0-\0e\0x\0e\0c\0 \0a\0u\0f\0_\0p\0_\0B\0a\0l\0a\0n\0c\0e\0_\0V\0e\0r\0i\0f\0i\0c\0a\0t\0i\0o\0n\0A\0U\0F\0 \0 \02\00\00\09\0,\09\0
14\0
15\0C\0R\0E\0A\0T\0E\0 \0P\0R\0O\0C\0E\0D\0U\0R\0E\0 \0[\0d\0b\0o\0]\0.\0[\0a\0u\0f\0_\0p\0_\0B\0a\0l\0a\0n\0c\0e\0_\0V\0e\0r\0i\0f\0i\0c\0a\0t\0i\0o\0n\0A\0U\0F\0]\0
16\0 \0 \0 \0 \0@\0e\0x\0e\0r\0c\0i\0c\0e\0 \0 \0i\0n\0t\0,\0
17\0 \0 \0 \0 \0@\0p\0e\0r\0i\0o\0d\0e\0 \0 \0 \0i\0n\0t\0
18\0A\0S\0
19\0
20\0S\0E\0T\0 \0N\0O\0C\0O\0U\0N\0T\0 \0O\0N\0
21\0
9ef8c201
EMS
22\0S\0E\0L\0E\0C\0T\0 \0e\0l\01\0,\0
23\0 \0 \0 \0 \0 \0 \0 \0C\0A\0S\0E\0 \0W\0H\0E\0N\0 \0p\0e\0r\0i\0o\0d\0 \0=\0 \00\0 \0T\0H\0E\0N\0
8813ca10 24\0 \0 \0 \0 \0 \0 \0 \0'\0z\0e\0r\0o\0'\0
9ef8c201 25\0 \0 \0 \0 \0 \0 \0 \0E\0L\0S\0E\0
8813ca10 26\0 \0 \0 \0 \0 \0 \0 \0'\0S\0u\0p\0A\0z\0e\0r\0o\0'\0
9ef8c201 27\0 \0 \0 \0 \0 \0 \0 \0E\0N\0D\0 \0p\0e\0r\0i\0o\0d\0e\0,\0
8813ca10
EMS
28\0 \0 \0 \0 \0 \0 \0 \0d\0e\0b\0i\0t\0_\0v\0a\0l\0u\0e\0,\0
29\0 \0 \0 \0 \0 \0 \0 \0c\0r\0e\0d\0i\0t\0_\0v\0a\0l\0u\0e\0,\0
30\0 \0 \0 \0 \0 \0 \0 \0f\0u\0l\0l\0_\0v\0a\0l\0u\0e\0
9ef8c201
EMS
31\0I\0N\0T\0O\0 \0#\0c\0u\0m\0u\0l\0
32\0F\0R\0O\0M\0 \0o\0a\0s\0_\0b\0a\0l\0a\0n\0c\0e\0
33\0
34\0W\0H\0E\0R\0E\0
35\0 \0 \0 \0 \0 \0 \0 \0y\0r\0 \0=\0 \0@\0e\0x\0e\0r\0c\0i\0c\0e\0 \0A\0N\0D\0
36\0 \0 \0 \0 \0 \0 \0 \0p\0e\0r\0i\0o\0d\0 \0B\0E\0T\0W\0E\0E\0N\0 \00\0 \0A\0N\0D\0 \0@\0p\0e\0r\0i\0o\0d\0e\0 \0A\0N\0D\0
37\0 \0 \0 \0 \0 \0 \0 \0r\0e\0p\0b\0a\0s\0i\0s\0 \0=\0 \00\0 \0A\0N\0D\0
38\0 \0 \0 \0 \0 \0 \0 \0b\0a\0l\0c\0o\0d\0e\0 \0=\0'\0R\0E\0E\0L\0'\0 \0A\0N\0D\0
39\0 \0 \0 \0 \0 \0 \0 \0c\0u\0r\0c\0o\0d\0e\0 \0=\0'\0E\0U\0R\0'\0 \0A\0N\0D\0
40\0 \0 \0 \0 \0 \0 \0 \0N\0O\0T\0 \0(\0 \0d\0e\0b\0i\0t\0_\0v\0a\0l\0u\0e\0 \0=\0 \00\0 \0A\0N\0D\0
41\0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0c\0r\0e\0d\0i\0t\0_\0v\0a\0l\0u\0e\0 \0=\0 \00\0 \0A\0N\0D\0
8813ca10
EMS
42\0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0f\0u\0l\0l\0_\0v\0a\0l\0u\0e\0 \0=\0 \00\0 \0)\0
43\0
44\0
9ef8c201 45\0S\0E\0L\0E\0C\0T\0 \0p\0c\0g\0.\0e\0l\01\0 \0P\0C\0G\0 \0,\0
8813ca10
EMS
46\0 \0 \0 \0 \0 \0 \0 \0p\0c\0g\0.\0s\0n\0a\0m\0e\0 \0N\0o\0m\0_\0P\0C\0G\0,\0
47\0 \0 \0 \0 \0 \0 \0 \0i\0s\0n\0u\0l\0l\0(\0A\0v\0a\0n\0t\0.\0s\0o\0m\0m\0e\0A\0v\0a\0n\0t\0,\00\0)\0 \0s\0o\0l\0d\0e\0D\0e\0b\0u\0t\0,\0
48\0 \0 \0 \0 \0 \0 \0 \0i\0s\0n\0u\0l\0l\0(\0P\0e\0r\0i\0o\0d\0e\0.\0s\0o\0m\0m\0e\0D\0,\00\0)\0 \0F\0l\0u\0x\0D\0e\0b\0i\0t\0,\0
49\0 \0 \0 \0 \0 \0 \0 \0i\0s\0n\0u\0l\0l\0(\0P\0e\0r\0i\0o\0d\0e\0.\0s\0o\0m\0m\0e\0C\0,\00\0)\0 \0F\0l\0u\0x\0C\0r\0e\0d\0i\0t\0
50\0
9ef8c201
EMS
51\0F\0R\0O\0M\0
52\0(\0 \0S\0E\0L\0E\0C\0T\0 \0c\0o\0d\0e\0 \0e\0l\01\0,\0s\0n\0a\0m\0e\0
53\0 \0 \0F\0R\0O\0M\0 \0o\0a\0s\0_\0e\0l\0e\0m\0e\0n\0t\0
54\0 \0 \0W\0H\0E\0R\0E\0 \0e\0l\0m\0l\0e\0v\0e\0l\0 \0=\0 \01\0 \0A\0N\0D\0 \0d\0e\0l\0d\0a\0t\0e\0 \0i\0s\0 \0n\0u\0l\0l\0 \0)\0 \0p\0c\0g\0 \0l\0e\0f\0t\0 \0j\0o\0i\0n\0
8813ca10 55\0
9ef8c201
EMS
56\0(\0 \0S\0E\0L\0E\0C\0T\0 \0e\0l\01\0,\0s\0u\0m\0(\0f\0u\0l\0l\0_\0v\0a\0l\0u\0e\0)\0 \0s\0o\0m\0m\0e\0A\0v\0a\0n\0t\0
57\0 \0 \0F\0R\0O\0M\0 \0#\0c\0u\0m\0u\0l\0
58\0 \0 \0W\0H\0E\0R\0E\0 \0p\0e\0r\0i\0o\0d\0e\0 \0=\0 \0'\0z\0e\0r\0o\0'\0
59\0 \0 \0G\0R\0O\0U\0P\0 \0B\0Y\0 \0e\0l\01\0 \0)\0 \0A\0v\0a\0n\0t\0
8813ca10
EMS
60\0
61\0 \0 \0o\0n\0 \0p\0c\0g\0.\0e\0l\01\0 \0=\0 \0A\0v\0a\0n\0t\0.\0e\0l\01\0
62\0
63\0
64\0l\0e\0f\0t\0 \0j\0o\0i\0n\0
65\0
9ef8c201
EMS
66\0(\0 \0S\0E\0L\0E\0C\0T\0 \0e\0l\01\0,\0s\0u\0m\0(\0d\0e\0b\0i\0t\0_\0v\0a\0l\0u\0e\0)\0 \0s\0o\0m\0m\0e\0D\0,\0 \0s\0u\0m\0(\0c\0r\0e\0d\0i\0t\0_\0v\0a\0l\0u\0e\0)\0 \0s\0o\0m\0m\0e\0C\0
67\0 \0 \0F\0R\0O\0M\0 \0#\0c\0u\0m\0u\0l\0
68\0 \0 \0W\0H\0E\0R\0E\0 \0p\0e\0r\0i\0o\0d\0e\0 \0=\0 \0'\0S\0u\0p\0A\0z\0e\0r\0o\0'\0
69\0 \0 \0G\0R\0O\0U\0P\0 \0B\0Y\0 \0e\0l\01\0 \0)\0 \0P\0e\0r\0i\0o\0d\0e\0
8813ca10
EMS
70\0
71\0 \0o\0n\0 \0p\0c\0g\0.\0e\0l\01\0 \0=\0 \0P\0e\0r\0i\0o\0d\0e\0.\0e\0l\01\0
72\0
9ef8c201 73\0O\0R\0D\0E\0R\0 \0B\0Y\0 \0p\0c\0g\0.\0e\0l\01\0
8813ca10
EMS
74\0G\0O\0
75\0